Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2 9.7

Top 10 DB2 LUW 9.7 Fixpack “Pearls”

Published August 20th, 2012 - by

  Iqbal Goralwalla, Principal Consultant at Triton Consulting, was again invited to present on the DB2Night Show webinar. A staggering 100% of the audience who watched said they learned something from Iqbal’s presentation on the subject of DB2 LUW 9.7 Fixpack "Pearls". We share these pearls of wisdom with you below, on the new commands and features Continue Reading

New Podcast! Inside SECADM

Published February 14th, 2012 - by

In the latest podcast we chat to Iqbal Goralwalla and Sathyaram Sannasi about SECADM. Take a look at Iqbal’s article below. I had fun with the new SECADM authority introduced in DB2 9.7 recently. I wanted to restore a database on a test server from a backup of the production database taken on a production Continue Reading

A Fresh Look at Setting Session Isolation Level

Published October 12th, 2011 - by

The isolation level determines how data accessed by one application is isolated from the other. In other words, the degree to which rows accessed by an application is available to another.   A description of the isolations level can be found here – http://ibm.co/qLofSg   It is important to note that the isolation level is Continue Reading

Sathy’s SECADM Secrets

Published April 4th, 2011 - by

In the recent post – SECADM Musings, Iqbal discussed the RESTORE scenario in 9.7 where the privileges will be ‘lost’ when restoring the database to a different instance and a work around for the situation. There are other ways to tackle the same issue and here are two of them.   a) Consider that a Continue Reading

Next Page »