Thursday, January 22, 2009

Getting db snapshot

Getting db snapshot
=====================
db2 "get snapshot for db on IBSDB"> dbsnapshot.out

Getting dbm snapshot
=====================
db2 "get snapshot for dbm" > dbmsnapshot.out

Getting dynamic SQL snapshot
===========================
db2 "get snapshot for dynamic sql on IBSDB" > dynamicsql.out

Getting application snapshot
============================
db2 "get snapshot for applications on IBSDB" > applications.out

Getting lock snapshot
====================
db2 "get snapshot for locks on IBSDB" > locks.out

Kill application that lock db
===============================
force application(lock_id)