DB2 & IMS

Many IT organizations are planning their move to DB2 10 because the benefits are quite compelling. While DB2 10 has features that can benefit most customers, all customers are interested in the reduction of CPU this version delivers. The reduction can be substantial (some organizations have seen up to 20 percent) and will enable users to run more business transactions without having to upgrade their systems. Other enhancements include increased availability, concurrency, reduced catalog contention, virtual storage relief, and temporal data. These new features are available in different DB2 10 modes; this means that for some of the features you will get the benefits in Conversion Mode (the new name for Compatibility Mode). For other features, you will have to wait until the switch to New Function Mode. Depending on the complexity of your DB2 environment, this could mean you’re a year or more away from being able to use some of the DB2 10 features…

Read Full Article →

You’ve probably heard a lot about IBM’s pureXML feature of DB2 and seen some examples of data stored and retrieved from XML columns. pureXML is the native XML storage and retrieval feature of DB2 that lets an XML document be stored in a format the database engine can manipulate. The ability to store XML natively in DB2 is vital, and DB2 is feature-rich in managing and manipulating XML. From a business perspective, however, there are several choices that need to be made when managing XML data with DB2. Which choice you make depends on your objectives, the perceived costs, the personnel and skills available, and the amount of time dedicated to establishing and maintaining the database housing the data…

Read Full Article →

While new IMS database development is scarce, existing IMS databases continue to grow. Databases, like many things in life, tend to get bigger over time. If you have Web-enabled legacy IMS databases, you’ve probably seen significant growth in them. Traditional, full-function databases are limited to 4GB (VSAM) or 8GB (OSAM). Once you reach those size limits, you have a few options:…

Read Full Article →

IMS High Availability Large Databases (HALDBs) offer many advantages, including virtually unlimited space and the promise of near-continuous availability. HALDBs give you an opportunity to review existing IMS database reorganization strategies because you can reorganize one or more partitions while the other partitions are still online and available for processing. This article reviews database maintenance best practices for HALDBs and is geared toward an audience already familiar with the concepts of HALDB…

Read Full Article →