User Tools

Site Tools


db2

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.1376906068.txt.gz · Last modified: 2021/04/24 07:38 (external edit)