During a migration, DB2 12 will automatically rebind any package bound in DB2 9 and earlier versions. The automatic rebind results in a new package, while the previous package copy is automatically discarded. However, to ensure plan stability, a BIND should be done manually, because auto rebind won't copy the original package to the previous one. So if a regression in access path occurs, the REBIND SWITCH option is not available.
Posted: February 16, 2017 |
One big change in DB2 12 is the new install SYSOPR authority. Using install SYSOPR instead of SYSADM allows systems programmers to install or migrate DB2 without having access to user objects and user data.
Posted: February 07, 2017 |
The REORG utility is one of the most important tools in the DBA toolbox. Traditionally, the REORG table space or index utility is used to reorganize the data to improve access performance as well as reclaim fragmented space.
Posted: January 31, 2017 |
In my career as a DBA, I’ve done a lot work working around table space size limits. Managing this involves resizing, rebalancing, adding partitions, and much more. With this perspective, I can assure you that the dramatically increased partition sizes allowed in DB2 12 are a big deal.
Posted: January 24, 2017 |
I don't need to tell you that a career working with DB2 for z/OS is never boring. DB2 for z/OS continues to evolve at an ever-increasing pace. To help you keep up with all these changes, IBM has delivered a new Redbook, "DB2 12 for z/OS Technical Overview."
Posted: January 17, 2017 |
I’ve previously written about RESTful services, noting how these services will enable data and applications running on DB2 for z/OS to become a strategic component of your enterprise API strategy.
Posted: January 10, 2017 |
I was recently reading the DB2 12 for z/OS What’s New guide. It's interesting comparing the features available in the initial Function Level M100 with what you can get when you activate Function Level M500.
Posted: January 03, 2017 |
When IBM decides to remove a function from DB2 for z/OS (or any DB2 offering), it's generally publicized in in the DB2 for z/OS announcement letter. See the DB2 12 for z/OS announcement letter, for instance.
Posted: December 20, 2016 |
I was recently asked about activating a trace that sends information about DB2 11 index cleanup threads to the IBM System Management Facility (SMF).
Posted: December 13, 2016 |
Following up on my recent posts on the latest version of IBM DB2 Analytics Accelerator for z/OS (DB2 Accelerator) as well as the new Accelerator cloud-centric solution, I wanted to step back a bit and discuss an IBM Redbook.
Posted: December 06, 2016 |