Archive for May, 2010


DB2 9 and 10 for z/OS Beta Program Begins…..

May 24, 2010

Hi again. For this month , I’m going to tell you about the wonders of database DB2 10 , the most recent database produced by IBM. DB2 has been on the database market for so many years , and it had it own market and customer. For us in Malaysia , many organization including the goverment had implemented database DB2 in their system. For DB2 10 , its specifically means for the z/os operating system. Here I include the excerpt from the Data Management Magazine from IBM that I received this month..Hope you all will enjoy….!

New version designed for improved performance, scalability, and cost savings

Building on the formidable capabilities of IBM DB2 9 for z/OS and the IBM System z platform, the next version of DB2 for z/OS has moved one step closer to release. Beginning in March, IBM made DB2 10 for z/OS available to selected organizations in a closed beta program. The new version includes features that can improve performance, increase the resiliency of business-critical data, and accelerate application and warehouse deployment.

Internal testing at IBM indicates that customers may realize significant out-of-the-box CPU savings with DB2 10, depending on the type of workload. Additional savings and higher performance can be achieved by taking advantage of features including hash access, index include columns, in-line large objects, parallel index updates, faster single-row retrieval, in-memory work files, index list prefetch, and a 1 MB page size for System z10 buffer pools.

The new version of DB2 can also support up to 10 times as many users per data-sharing group member than was possible with previous versions of DB2. Depending on the configuration and situation, this can mean that fewer data-sharing members are needed, greatly increasing the number of users that can be supported on reduced memory and CPU resources.

Maintaining the resiliency of business-critical information is another area of emphasis in this release. More data access, data management, and data definition functions can be handled concurrently, reducing overall downtime. Schema evolution, or data definition on demand, enables developers and DBAs to change the structure of the database in certain ways without requiring DB2 to come down—and fewer planned outages result in higher availability. DB2 10 also has several features aimed at enhancing security and simplifying regulatory compliance, including data masking, more granular administrative privileges, and new audit capabilities.

Enhancements for rapid application and warehouse deployment to support business growth round out the feature set for DB2 10, including support for temporal or versioned data, which facilitates a more automated process for rolling old data into archives over time. A number of SQL enhancements make the DB2 10 SQL implementation more consistent with other members of the DB2 family and make it easier to adapt SQL applications originally written for other database platforms. Examples include a 64-bit ODBC driver, Currently Committed locking, implicit casting or loose typing, time stamp with time zone, and moving sum and average.

DB2 10 also features enhancements to DB2 pureXML that focus on improving performance and usability of XML data applications. These include schema validation in the engine, a binary XML exchange format, multiversioning, easy update of subparts of XML documents, stored procedures, user-defined functions and triggers, and XML index matching with date/time stamp.

Query Management Facility (QMF), the DB2 query and reporting facility, also contains many updates for DB2 10, including more than 140 new analytical functions and support for HTML, PDF, and Flash report output.

Migration to DB2 10 is supported from both DB2 9 and from DB2 for z/OS V8.


OpenSuse 11.0 and SUSE Linux Enterprise Server….

May 11, 2010

Well , the topic for today is mainly about openSUSE 11.0. I actually take this topic according to the book that I had borrowed from the National Library. It’s kindda interesting topic , though , it covers the basic installation of openSUSE , partition , filesystem , booting , networking, Yast , network services , printing and so much more. Well , for a start , here is my experience using openSUSE . Hope you all enjoy it…..

Installation: Image-based Deployment and Sleek

The openSuSE site has a nice installation guide with screenshots and it doesn’t make sense for me to go through the same thing again. But two things are special in openSuSE 11.0 that are worth mention. The first is that they have a gorgeous installation GUI, the best looking installation for any operating system ever!! Its easy to install and intuitive. The second the use of image deployment for the installation of GNOME. This really speeds up the installation if you are just using the basic GNOME-based setup. I generally prefer KDE, but for the test I installed the GNOME and it was fast… really really fast! I was shown the GNOME desktop with all the preferred software installed in straight 15 minutes. That’s faster than any other distro that I’ve ever installed. It was an amazing experience to see such a fast installation!

Like previous version, openSuSE 11.0 comes with a variety of useful non-opensource software like flashplayer, java 1.6.0_u6, fonts, Adobe reader 8, etc. Along with these I also installed Jdk6 update 10 (the awesome new Java Plugin), Mono, Netbeans 6.1, GlassFish for my OpenMRS performance test… KDE 4.0 is also there as a separate choice of GUI when installing along with KDE 3.5.9, GNOME 2.22. Since I have never been able to stably run KDE 4.0 and have always switched back to KDE 3.5, I thought I’d try KDE 4.0 in openSUSE 11.0

I was pleasantly surprised that KDE 4.0 “just worked”. I had my first KDE 4.0 crash after 1.5 hrs of use whereas earlier it was before 20 min that the SigEnv or Segmentation Fault would throw up. I still didn’t want any crashes and hence I’m back to using KDE 3.5.9. But KDE 4 is really coming good!

As soon as I finished installing, everyone at home wanted me to record the Euro 2008 matches and soon I needed VLC to be installed. I went to and clicked on the SuSE link… and I was greeted with a 1-Click Install button.

This was one of the really awesome openSUSE things that was first brought in openSUSE 10.3 and has been improved in openSuSE 11.0. I clicked on it and the installation was finished really quickly.

Improved Installation with YaST

That’s when I realized the most important update to openSuSE 11.0 which is the improved speed of YaST. No other distro has such an easy administration tool where nearly everything can be administered. And in openSuSE 11.0 everything in the YaST module just works. RPM installation is fast and adding community repositories is easy. I am a big fan of apt-get in Ubuntu, but openSUSE 11.0 software installation is just as easy now…


You can’t miss the ease of use and the sleek looks that openSuSE 11.0 brings to the desktop. Its the perfect distro for a new user coming to linux. For the old pros, openSUSE 11.0 is fast and brings in ease of administration and software installation. Novell support is pretty good for big organizations that can buy a boxed product from them. Xen is my favorite for virtualization and it has good integration and management in YaST. But the strength and momentum of openSUSE is definitely in the desktop space. Earlier, openSuSE lacked the community backing that Ubuntu has generated in a short timespan, but with new initiatives and better responses at openSuSE forums, the openSuSE community and grown leaps and bounds. openSuSE 11.0 has grown from strength to strength and is one of the best ways to give competition to Windows on the desktop!


Introducing Microsoft Exchange Server 2007 SP1….

May 6, 2010

Well…what the heck…For this month onwards , I’m going to concentrate on Microsoft product and platform. This is because i want to specialized more on Microsoft based product. Microsoft product and platform is widely used nowadays in this world compare to Linux based. As my experience as a Windows Administrator at Emerio Corp (M) Sdn Bhd , I would like to share my experience administering Microsoft product at my workplace at HP (Hewlett Packard) headquarterd at Damansara Height (HP Tower)….


Service Pack 1 (SP1) reinstates a lot of the functionality that Microsoft left out in order to get Exchange Server 2007 out of the door last year.

The good

  • Support for Windows Server 2008
  • Standby Continuous Replication (SCR)
  • Management tools left out of EMC have been reinstated
  • Enhanced OWA client
  • Improved mobile support

The bad

  • Requires 64-bit processors and operating system
  • Careful planning needed before upgrading large deployments

When it released Exchange Server 2007 at the beginning of last year, Microsoft admitted to dropping a number of the expected features in order to meet its deadline. Some of these were new to the 2007 product, but others were already available in Exchange Server 2003, causing more than a little concern among customers looking to upgrade. It comes as no surprise, therefore, to find many of these features reinstated in Service Pack 1 (SP1) in a clear attempt to finally deliver the product that Microsoft originally promised.

Along with the usual performance enhancements and bug fixes, one of the new features is, naturally, support for Windows Server 2008, with SP1 required if you want to host Exchange Server 2007 on that platform. Otherwise you’ll need Windows Server 2003 with the SP2 update applied to run Exchange Server 2007 SP1. As before, the latest implementation is designed for 64-environments, although it can be deployed on 32-bit servers for unsupported testing and evaluation purposes.

Another much-anticipated new feature is something called Standby Continuous Replication (SCR). The original product introduced the ability to replicate Exchange data between two servers in a cluster; SCR extends that by adding the ability to replicate data to a standby system ready to be activated in the event of a disaster. It’s not quite seamless failover, but if that’s what you’re after Exchange can also make use of the enhanced clustering facilities provided in Windows Server 2008, enabling servers to be clustered across different, geographically disperse, subnets. Microsoft’s new server OS, due for full release at the end of February, also enables Exchange to be supported on IPv6 networks.

The technology behind the existing local and cluster continuous replication options is extended in Exchange 2007 SP1 to take backups to a separate standby server (Standby Continuous Replication, or SCR).

Elsewhere, a lot of fuss was made at the launch over the ability to manage Exchange Server 2007 from the command line, and to script common tasks using Windows PowerShell. This went down well with large organisations that manage distributed Exchange setups, but was less popular with smaller companies, many of which were disappointed to find that tools they had come to rely on were left out of the GUI.

Exchange Server 2007 SP1 fills in a lot of those gaps. For example, POP3/IMAP4 server settings can now be configured from the Exchange Management Console (EMC) just as before. Public folders can, similarly, be managed from the EMC again, along with user Send As permissions. With the original release, these options all had to be configured via the Exchange Management Shell (EMS), requiring programming skills that are not normally available in smaller companies. The Move Mailbox tool has also been enhanced in this release to allow import and export to personal folders.

The Outlook Web Access (OWA) Premium client in Exchange Server 2007 SP1 is yet another component to benefit from the return of lost functionality. This includes the ability to manage personal distribution lists from a browser, create and maintain custom rules, recover deleted items and select a monthly calendar view — all of which were dropped when Exchange 2007 was first launched. Support for S/MIME is similarly reinstated, but only when using IE 7.0; the list of attachments that can be converted to HTML in a message (WebReady Document Viewing) is also extended to include more of the Office 2007 formats.

The Exchange Server 2007 SP1 update can be downloaded free of charge. At 840MB it’s not small, but it can be used to install a fresh copy of Exchange as well as upgrade existing code. We found it straightforward to apply and would recommend anyone already on the new platform or installing Exchange for the first time to get hold of it. Upgrading from an earlier version of Exchange, however, can be problematic, and the support forums are full of customers who have experienced problems.

Careful planning and testing is, therefore, advisable even with this new and improved implementation. It’s also still very much an enterprise solution, and there’s no news yet about a small-business version of Exchange Server 2007.

Till next article….Happy hacking and Support Microsoft Product!!!……