DB2 & IMS

DB2 10 introduces temporal table support in accordance with the SQL 2011 ANSI/ISO standard and is the first commercial database to implement temporal table support as specified by the standard. Other commercial databases have their own version of temporal table implementation; this limits application transparency and portability. The three types of temporal tables are:…

Read Full Article →

IBM’s Information Management System (IMS) has been an important part of the computing environment for more than 40 years, yet it’s still able to make use of the latest computing ideas and technology. The first “IMS READY” message appeared on an IBM 2740 terminal on Aug. 14, 1968, and the first mission of the IMS system was to inventory a massive Bill of Materials for the Saturn V rocket and Apollo space vehicle…

Read Full Article →

Has DB2 10 for z/OS been on your mind lately? Are you thinking it’s time to start putting together a DB2 10 migration plan? If yes, that’s great. However, if upgrading isn’t yet on your to-do list, why not? DB2 10 became Generally Available (GA) on Oct. 22, 2010. It’s definitely not new anymore. In fact, the number of licenses being shipped is higher than previous versions. DB2 10 is stable and customer reports have been extremely positive…

Read Full Article →

Why is a software upgrade that instantly saves you 5 to 10 percent delayed while you’re looking to reduce costs almost everywhere in your company? I’m talking about the fact that 75 percent of IBM DB2 customers haven’t yet taken advantage of the superior resource efficiency in DB2 10 for z/OS. To better comprehend why we allow this type of waste in our IT departments, we need to understand how we ended up where we are today…

Read Full Article →

DB2 temporal tables are an outstanding database automation feature that can replace significant amounts of application programming. This makes them a popular feature of DB2 10 for z/OS and DB2 10 for Linux, UNIX and Windows (LUW). There are some things you need to understand and prepare for before using temporal tables. However, once you have a better understanding of how time travel queries work, their uses and implications, you will be able to leverage them for your needs.  …

Read Full Article →

When your car engine needs tuning, it wheezes and sputters when you’re driving uphill, and lacks that “get up and go.” Once you get the engine tuned, you feel like you have a new car. It climbs hills with ease and you get better mileage. DB2 is like an automobile. When it needs tuning, it slows down as workloads increase, and it consumes more MIPS. But tune it up and DB2 takes increasing workloads in stride, performing well within the limits of your Service Level Agreements (SLAs)…

Read Full Article →

Years ago, when a million CICS transactions a day was a lot, the data went on tape because it was so “huge.” Today, 500 million DB2 transactions may be considered small and, in many installations, the jobs that post-process System Management Facility (SMF) data have become among the largest applications. With the rising cost of software to support the ever-burgeoning volume of data, it’s important to decide what to keep and process daily. The tests run and examples provided here were all conducted with MXG, but the same techniques could be applied to other software performing the same functions…

Read Full Article →