Db2 for zOS V12 introduces a new UNLOAD authority permission for tables. This is “beside” the good-old-fashioned classic table authority permissions for SELECTAUTH, INSERTAUTH, DELETEAUTH, UPDATEAUTH, etc. etc. This UNLOAD authority controls the ability to use the UNLOAD utility on the...
Db2 SQL for the DBA - Using Modern SQL for DBA Tasks Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity. ...
Deprecated Objects and APPLCOMPAT DBA's are notoriously conservative when it comes to migrating data to new types of objects. Our theme seems to be "if it ain't broke, don't fix it!" IBM has decided to encourage those of us on DB2 for z/OS to migrate our data to Universal Table Spaces (UTS)...
Calculates how full and how close to maximum capacity a partition is. This is for DB2/z. Updated to use NPAGES instead of NACTIVE.
TSMAX.txt
Beginning with your migration to Db2 12 for z/OS, you will be embarking on a new journey called continuous delivery. This new way of delivering new features into IBM program products such as Db2 for z/OS will change the migration process and the way you deal with applications going forward....
Temporal Support of Db2 for z/OS – Part III Temporal RI By Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Background and Motivation What is referential integrity (RI)? Referential integrity (RI) is the state in which all values of all foreign keys are...
Temporal Support of Db2 for z/OS – Part I Temporal Auditing Enhancements in Db2 12 Continuous Delivery Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Abstract This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS...
Temporal Support of Db2 for z/OS – Part II Temporal Logical Transaction Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Temporal Logical Transaction Background and Motivation Transactions are omnipresent in today’s database systems, providing data integrity...
I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. Most of this time has been in support of various application teams as they build systems that use Db2 as their data store. During that time, I’ve collected a lot of knowledge that makes my job easier and...
1 Comment - no search term matches found in comments.
With the ever increasing number of features and functions being added to Db2 for z/OS it’s easy to overlook the finer points of some of those features. Take in point the “Profile Tables”. You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set...