docs:tips_n_tricks:ibm:db2.html
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
docs:tips_n_tricks:ibm:db2.html [18.05.2010 15:52 CEST] – peter | docs:tips_n_tricks:ibm:db2.html [19.05.2010 10:55 CEST] (current) – peter | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== DB2 ====== | ====== DB2 ====== | ||
- | To drop an instance do (as root): | + | ===== Get Information ===== |
- | + | ==== config settings ==== | |
- | <db2 install dir>/ | + | |
To read settings for one instance: | To read settings for one instance: | ||
Line 12: | Line 11: | ||
db2 get db cfg for <db2 instance> | 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> | ||
To read global settings: | To read global settings: | ||
Line 17: | Line 21: | ||
<db2 install dir>/ | <db2 install dir>/ | ||
+ | ==== Tablespace Parameters ==== | ||
+ | |||
+ | db2 connect to <db2 database> | ||
+ | db2 " | ||
+ | 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>/ | ||
docs/tips_n_tricks/ibm/db2.html.1274190722.txt.gz · Last modified: 18.05.2010 15:52 CEST by peter