Share: |

Guest post by Mike Jones, Technical Marketing Manager


Here are some more reasons to migrate to DB2 10.


Plan stability, introduced as maintenance to DB2 9, is part of the DB2 10 base code. Plan stability makes it safer to rebind static packages after a DB2 upgrade. If performance degrades after a REBIND, you can switch back to the previous access path by running REBIND again with the SWITCH parameter.

SQL enhancements. The days of applications and data living solely on the mainframe are coming to and end. IBM recognizes this fact, and they delivered enhancements in DB2 10 that make it easier to port applications from other platforms and database management systems to DB2 for z/OS. Enhancements include faster native SQL procedure language (SQL PL), implicit casting, and more flexibility in the number of digits for fractions of seconds, timestamps with time zones, moving sums, and moving averages.

Support for DB2 V8 is ending. Moving to DB2 V8 was a daunting task for many IT organizations because V8 was so different from any previous versions of DB2. According to informal polls we have conducted, about one third of DB2 users are still on V8 and will move directly to DB2 10. Some are moving specifically because support for V8 is scheduled to end in April 2011. Whatever the reason for the migration, users will see significant benefits from DB2 10.

Temporal tables. DB2 10 supports system time (where DB2 maintains the beginning and ending timestamps for a row and business time (where you maintain the timestamps). This is especially useful when you need to know the state of the data at a certain time. For example, if you had a car accident last week but did not report it until this week, your insurance company would need to know what policy you had at the time of the accident. While they can find that information now through complex application programming, temporal tables will make it much easier. The insurance company can use business time to determine what policy you had at the time of accident.

Performance improvements. When was the last time your manager told you that performance could slip? Chances are, you are being told to improve performance. And it’s easy to do with DB2 10. IBM says that most users can see 5-10% performance improvement out-of-the box and up to 20% for specific workloads. DB2 10 reduces CPU usage with better memory access and shorter processor times, adds more memory, and exploits z/OS enhancements. For optimal performance, you will need to REBIND.


Let us know why you are migrating to DB2 10.


The postings in this blog are my own and don't necessarily represent BMC's opinion or position.
Share: |

Guest post by Mike Jones, Technical Marketing Manager


Chances are, you have heard a lot about DB2 10 over the past few weeks. You may have heard about the performance improvements and new features like temporal tables. But DB2 10 offers much more. Here are five reasons for you to migrate:


  • Improvements to the catalog. Links in the catalog and directory were removed in DB2 10 to reduce lock contention. Improved lock avoidance holds locks for less time, preventing data writers from blocking data readers. The result? Improved concurrency.


  • Virtual storage restraint relief. DB2 10 removes virtual storage constraints of individual DB2 subsystems and moves most memory to 64-bit. Benefit: better scalability and simplified administration.


  • Hash tables. Some high-volume online applications need to access a single row through a fully qualified primary key. The only way to guarantee this access has been through an index, and indexes require overhead because DB2 must open several pages in the index and table. DB2 10 introduces hash access, which enables access to a single row through a single page. Hash accessed-enabled tables take more disk space than traditional tables and they may be more expensive for multiple row access, but they are more efficient than indexes for applications that need single row access.


  • Security and auditing. DB2 10 offers better granularity for managing security. You can manage table access at the column and row levels. You can create multiple audit policies.


  • Online schema evolution. Beginning with DB2 V8, IBM has allowed you to alter database structures dynamically. In DB2 10, you can alter the table space type and convert older table spaces to universal table spaces (UTSs). UTSs can simplify space management and improve availability and productivity.


What are your reasons for migrating to DB2 10? Let us know.


The postings in this blog are my own and don't necessarily represent BMC's opinion or position.
Jonathan Adams

I want my money!

Posted by Jonathan Adams Nov 12, 2010
Share: |

Guest post by Danielle Scherer, Solutions Marketing Manager

Online banking has changed the way we deal with personal finances. With online banking, we can pay bills and not use a stamp, transfer money between accounts, and check account balances 24 X 7. But what did the bank have to do to create the online banking application? Chances are, the bank added some non-mainframe components that communicate with legacy DB2 or IMS databases through middleware.  How complex is that application – how many hops does the application take to get from your PC to the mainframe database and back? What happens when you have to wait 5-10 seconds for a response?

This is your money, and you want to know that it’s there. After all, if your bank consistently prevents you from seeing your account information because of scheduled maintenance or if it takes several seconds for you to get a response, you may just switch banks.

It’s important for IT organizations like the bank to maintain application performance and availability. Composite applications like online banking often have an owner who is responsible for ensuring the overall quality of service delivered by the composite application and owners who are responsible for each of the individual application components.

When problems occur, the composite application owner must work with associated application component owners and infrastructure technology administrators to quickly determine what’s causing the problem and then fixing it. Because of the complexity of composite applications, this presents a challenge. To find the cause of the problem, the bank could convene a war room where everyone points a finger and someone else. Or the bank could look at the application and transaction holistically with intelligent software and find the problem quickly.

Integrated, intelligent software permits a unified, enterprise-wide approach for managing composite applications. The ideal solution provides a console that gives composite application owners, mainframe application owners, and middleware administrators a broad view of all application components and their relationships. They can view the performance of applications as transactions traverse through the middleware.

The benefits are significant. A unified approach eliminates wasteful and cumbersome “all hands on deck” exercises in addressing problems, permitting more efficient and faster problem resolution. Consequently, the IT staff can maintain agreed on performance and availability levels in composite enterprise applications and reduce costs at the same time.

When you use composite applications like online banking, you don’t really care why something is broken or where it is. All you want is results. IT organizations care passionately about why and where problems occur. And they can find and resolve those problems quickly with intelligent solutions.

The postings in this blog are my own and don't necessarily represent BMC's opinion or position.
Jonathan Adams


Posted by Jonathan Adams Nov 3, 2010
Share: |

Chances are, you have taken a commercial flight at least once in your life. I take several each year to visit customers around the world.


Virtually all commercial flight prices include a tariff. The Airline Tariff Publishing Company (ATPCO) is the airfare data provider for more than 460 airlines worldwide, representing 97 percent of scheduled commercial air travel. ATPCO acts as a broker, consolidating fares and rules from participating airlines and making them available to global distribution systems, as well as to other computer reservation systems and entities that use the data to issue tickets. In addition, ATPCO supports travel agencies, airlines, cargo carriers, governments and industry organizations with fare information.


By using some smart software ATPCO manages mainframe DB2 databases more efficiently than before. They estimate that DBA productivity increased by 60 percent with the new software.


Check out this story. And next time you make an airline reservation, remember that smart software is making the process faster and more secure.

Filter Blog

By date:
By tag:
It's amazing what I.T. was meant to be.