Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: SECADM

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

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

SECADM musing

Published February 9th, 2011 - by

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 server. The production database DB2SEC had been created by the user DB2INST1 in the instance DB2INST1. The restore on the test Continue Reading