Category: Recovery

5

Backup Compression Consideration – DB2 COMPRESS vs. GZIP

We interrupt your regular programming for a quick announcement. If you have been reading DB2commerce.com for a while you know I am an occasional guest writer on this technical blog. I’ve worked this year on expanding my comfort zone with regular articles here, a developerWorks article to be posted next week, and I have entered as a competitor on the...

5

IDUG NA 2013 Brain Dump

Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes. This year, I’m going to try to make it a bit more organized. It...

7

Parameter Wednesday: DB CFG UTIL_HEAP_SZ

DB2 Version This Was Written For 9.7 Parameter Name UTIL_HEAP_SZ Where This Parameter Lives DB CFG How To Check Value > db2 get db cfg for sample |grep UTIL_HEAP_SZ Utilities heap size (4KB) (UTIL_HEAP_SZ) = 70982 OR > db2 “select name, substr(value,1,12) value, substr(deferred_value,1,12) deferred_value from sysibmadm.dbcfg where name=’util_heap_sz’ with ur” NAME VALUE DEFERRED_VALUE ——————————– ———— ————– util_heap_sz 70982 70982...

8

DB2 Commands: db2relocatedb

I’m pretty proficient with a redirected restore. As a first or second year DBA, I remember being afraid of their voodoo, but I even at one point wrote a redirected restore script (on DB2 7 or 8) that would do a redirected restore of a PeopleSoft database with hundreds of containers, changing the paths in a predictable way on a...