Wednesday, September 30, 2020

Db2 for z/OS Character Columns: Thoughts on CHAR versus VARCHAR

›
Recently, I received from a Db2 for z/OS DBA a question: for a table column that will hold character string values, are there any recommenda...
2 comments:
Friday, August 28, 2020

Db2 12 for z/OS RPN Table Spaces: New Possibilities for Range-Partitioned Tables

›
Sometimes, I assume that I've blogged about some Db2 for z/OS-related topic when in fact I have not. RPN table spaces is one such topic....
39 comments:
Friday, July 31, 2020

A Case Study - Db2 for z/OS High-Performance DBATs

›
Over the years, I have posted several entries to this blog that have covered various aspects of Db2 for z/OS high-performance DBATs (example...
4 comments:
Monday, June 29, 2020

The Various Aspects of Db2 for z/OS Data Encryption

›
Just last week, a person on the Db2 for z/OS team at an organization asked me for some guidance regarding data encryption in a Db2 context. ...
11 comments:
Thursday, May 28, 2020

Db2 12 for z/OS Buffer Pools - Recommendations for PGSTEAL, PGFIX and FRAMESIZE

›
Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking for my take on a Db2 12 buffer po...
5 comments:
Wednesday, April 29, 2020

Clearing the Air Regarding Db2 12 for z/OS and "Deprecated Objects"

›
On a number of occasions over the past several months, I have seen that there is some misunderstanding in the Db2 for z/OS community regardi...
Monday, March 30, 2020

Db2 for z/OS Online LOAD REPLACE - Minimizing Impact on Transactions

›
A couple of years ago, IBM introduced an important enhancement for the Db2 for z/OS LOAD utility, via the fix for an APAR (the APARs are PI6...
167 comments: