This is an old revision of the document!

DB2

Connection to db, choosing schema and doing queries:

 su - db2instance_user_id
 db2 connect to tsmdb1
 db2 set schema tsmdb1 
 db2 "select * from tsmdb1.mms_drives" 
 db2 "select * from tsmdb1.drivest"

Drop Database afer Installationproblems/Errors:

Login as the Instance user. If needed CD to your db2 instance directory.

/opt/tivoli/tsm/db2/instance/
do:
db2start
db2 drop db tsmdb1

Do db2ilist to get a list of all the current instance names db2ilist db2stop

Change to the root user ID to do the next command (CD back to the instance directory– Example: /opt/tivoli/tsm/db2/instance/) :

db2idrop <instance name>
"db2idrop tsm1"

Delete all files located in the instance directory. Example:

/tsm1/<instance_name>
/tsm1/tsmdb001
/tsm1/tsmlog
/tsm1/tsmarchlog
/tsm1/tsmlogmirror
/tsm1/tsmarchlogfailover

TSM Instance down.

Paket läuft noch, db prozesse laufen noch, dsmserv killed

db2fodc -hang

DB2 Extend

extend dbpsace $dir Space is not available to TSM until:

db2 connect to tsmdb1
db2 set schema tsmdb1

db2 alter tablespace SYSCATSPACE rebalance
db2 alter tablespace USERSPACE1 rebalance
db2 alter tablespace LARGESPACE1 rebalance
db2 alter tablespace LARGEIDXSPACE1 rebalance 
db2 alter tablespace IDXSPACE1 rebalance
db2 alter tablespace SYSTOOLSPACE rebalance

db2 ALTER TABLESPACE USERSPACE1 LOWER HIGH WATER MARK
db2 ALTER TABLESPACE IDXSPACE1 LOWER HIGH WATER MARK
db2 ALTER TABLESPACE LARGESPACE1 LOWER HIGH WATER MARK
db2 ALTER TABLESPACE LARGEIDXSPACE1 LOWER HIGH WATER MARK

db2 ALTER TABLESPACE USERSPACE1 REDUCE MAX
db2 ALTER TABLESPACE IDXSPACE1 REDUCE MAX
db2 ALTER TABLESPACE LARGESPACE1 REDUCE MAX
db2 ALTER TABLESPACE LARGEIDXSPACE1 REDUCE MAX