administration (3)

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert pagesets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit. Read the full story.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.


Read the full story in the Db2 for z/OS News from the Lab blog:
http://ibm.biz/BdzPr4


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews

Read more…

Fast index traversal is one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal. To benefit from fast index traversal, data access must use a random pattern. However, SELECT, INSERT, DELETE and UPDATE statements, and in fact any operation that requires traversal of an index, can benefit from fast index traversal. 

Db2 12 can use fast index traversal for many cases starting in function level 100 and full support begins in function level 500. For the whole story, see Fast index traversal - a Db2 12 greatest hit with John Campbell.


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @Db2World and @DB2zLabNews

Read more…