Differences

This shows you the differences between two versions of the page.

--- docs:tips_n_tricks:ibm:db2.html [28.04.2010 16:44 CEST] – Page moved from docs:tips_n_tricks:db2.html to docs:tips_n_tricks:ibm:db2.html peter
+++ docs:tips_n_tricks:ibm:db2.html [19.05.2010 10:55 CEST] – peter
@@ Line 1: / Line 1: @@
 ====== DB2 ======
-To drop an instance do (as root):
+===== Get Information =====
+==== config settings ====
-  <db2 install dir>/instance/db2idrop <instance>
 To read settings for one instance:
   <db2 install dir>/adm/db2set -i <instance>
+and (as instance owner):
+  db2 get db cfg for <db2 instance>
+or (as instance owner, retrieving more details):
+  db2 connect to <db2 database>
+  db2 get db cfg for <db2 instance> show detail
 To read global settings:
@@ Line 13: / Line 21: @@
   <db2 install dir>/adm/db2set -g
+==== Get Tablespace Parameters ====
+  db2 connect to <db2 database>
+  db2 "select tbspace, overhead, transferrate from syscat.tablespaces"
+  db2 get snapshot for tablespaces on <db2 database>
+==== List connected applications ====
+  db2 list applications show detail
+===== Maintenance =====
+To drop an instance do (as root):
+  <db2 install dir>/instance/db2idrop <instance>