1
Download Up and Running with DB2 on Linux
Transcript
gemini: db2 get snapshot for ... completed ok db2inst1@mensa:/> db2 get snapshot for all on itsodb global | grep "Lock list" Lock list memory in use (Bytes) = 9280 In 6.2.2, “Manual table maintenance” on page 280, we used the GET SNAPSHOT command from the DB2 command line (CLP) to monitor the inplace table reorganization. You can also capture a snapshot from administrative views, SQL table functions, or by using the snapshot monitor APIs in a C or C++ application. There are several snapshot administrative views available for you to query the snapshot information. Example 7-22 shows the list. Example 7-22 Snapshot™ administrative views db2inst1@mensa:/ db2 "select substr(tabschema,1,10) tabschema, substr(tabname,1,30) tabname from syscat.tables where tabname like 'SNAP%'" TABSCHEMA ---------SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM SYSIBMADM 410 TABNAME -----------------------------SNAPAGENT SNAPAGENT_MEMORY_POOL SNAPAPPL SNAPAPPL_INFO SNAPBP SNAPBP_PART SNAPCONTAINER SNAPDB SNAPDBM SNAPDBM_MEMORY_POOL SNAPDB_MEMORY_POOL SNAPDETAILLOG SNAPDYN_SQL SNAPFCM SNAPFCM_PART SNAPHADR SNAPLOCK SNAPLOCKWAIT SNAPSTMT SNAPSTORAGE_PATHS SNAPSUBSECTION SNAPSWITCHES SNAPTAB SNAPTAB_REORG SNAPTBSP SNAPTBSP_PART SNAPTBSP_QUIESCER Up and Running with DB2 on Linux
