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...
3 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 ...
Wednesday, June 26, 2024

Db2 for z/OS: Getting From Function Level 500 to 510 in a Db2 12 Environment

›
It's pretty well known that getting the activated function level of a Db2 12 for z/OS system to V12R1M510 is required prior to migrating...
5 comments:
Thursday, May 30, 2024

Db2 for z/OS: Really Big Buffer Pools are Great, but Don't Stop There

›
  Back in 2018, I reviewed an organization's production Db2 for z/OS environment, and saw at that time the largest z/OS LPAR real storag...
10 comments:
Monday, April 29, 2024

Db2 13 for z/OS: Utility Execution History

›
  A few months ago, I got this question from a Db2 for z/OS DBA: "Is there a way we can check to see if the UNLOAD utility has been exe...
15 comments: