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

Confession of the Month

From IBM Data Management Magazine

Published May 19th, 2010 - by

Distributed DBA: Changes to the Cursor Stability Isolation Level  Interesting article from Roger Sanders about the Currently Committed semantics introduced in DB2 9.7, and shows how these semantics provide faster data access and increased data concurrency for SQL statements running under the CS isolation level. Click here to view

DB2 LUW Security – DB2 Whisperings

Published January 27th, 2010 - by

DB2 Configuration Parameters – What They Whisper About Security Behind Your Back.   An article by Rebecca Bond.   I’ve always wondered what DB2 would say about security IF it could talk.  Maybe the conversation would be something like this…..   DBM DISCOVER:  “So, today she set me to DISABLE.   I know…I know…it’s for my Continue Reading

DB2 Gets More Bite With COBRA

Published January 20th, 2010 - by

IBM has been making huge technical strides with their flagship database, DB2, over the past few years. As expected, the recent launch of DB2 9.7 has not failed to impress, incorporating even more improvements. Click here to download the white paper. DB2 9.7, also known as the COBRA release, has made up significant ground on Continue Reading