Search

1 to 10 of 16
Sort by

Blog Entry
New V12 functionality - UNLOAD authority! Why? What is the point?

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...

Brian Laube's profile image

Blog Entry
Db2 SQL for the DBA

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. ...

Brian Laube's profile image

Blog Entry
Deprecated Objects and APPLCOMPAT

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)...

Jim Dee's profile image


Blog Entry
Db2 12 Migration and Continuous Delivery

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....

David Simpson's profile image



Blog Entry
Temporal Support of Db2 for z/OS – Part II

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...

Xiaohong Fu's profile image

Blog Entry
Simple DBA Tools for the Db2 DBA

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...


Blog Entry
Are you making the most of your Profile Tables for Db2 z/OS?

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...