User Tools

Site Tools


docs:tips_n_tricks:ibm:db2.html

This is an old revision of the document!


DB2

Get config settings

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:

<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>

Maintenance

To drop an instance do (as root):

<db2 install dir>/instance/db2idrop <instance>
docs/tips_n_tricks/ibm/db2.html.1274259103.txt.gz · Last modified: 19.05.2010 10:51 CEST by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki