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