Tuesday, January 7, 2025

Db2 13 Function Level 506: a Nice Multi-Row Insert Enhancement

›
Recently (via f unction level 506 , which came out in October 2024), Db2 13 for z/OS got a multi-row INSERT enhancement that surprised me. W...
2 comments:
Tuesday, December 17, 2024

Db2 13 for z/OS: Granular Control of Security Requirements for Client-Server Applications

›
The Db2 profile tables - SYSIBM.DSN_PROFILE_TABLE and SYSIBM.DSN_PROFILE_ATTRIBUTES - have long been very useful in managing a Db2 for z/OS ...
Friday, November 22, 2024

Db2 13 for z/OS: Partition-Level Locking for Insert into a PBG Table Space

›
Db2 13 for z/OS delivered an enhancement to reduce the likelihood that an insert targeting a table in a partition-by-growth (PBG) table spac...
Monday, October 28, 2024

Db2 for z/OS: Avoiding Splitting Headaches (the Index Page Kind)

›
This blog entry is about a Db2 for z/OS-internal process that has long been a headache-inducer for DBAs, and about some Db2 13 enhancements ...
Wednesday, September 25, 2024

Migrating to Db2 13 for z/OS: What About Non-Universal Table Spaces?

›
I recently communicated with a Db2 for z/OS system administrator who had some concerns about non-universal table spaces in the context of hi...
2 comments:
Friday, August 23, 2024

After Migrating to a New Version of Db2 for z/OS, Rebind All Your Plans and Packages

›
At this writing, a lot of Db2 for z/OS-using organizations are actively engaged in migrating to Db2 13 from Db2 12, and plenty of sites have...
7 comments:
Tuesday, July 30, 2024

Db2 for z/OS: What Makes for a Balanced Mainframe Configuration?

›
What I'm writing about today is something I've been talking about for years, thought often in a somewhat indirect way. It has to do ...