TSM uses DB2 Enterprise Edition as its backend database
DB2 Utilities and commands are sometimes useful and necessary for setup,performance,and troubleshooting.
As a rule, do not alter,modify, add-to,or delete the fields,tables, indices, or containers that are created by TSM in the DB2 database.
. Use TSM native tools if possible
. Treat the database as read-only
. Use the constructs that are provided through TSM and documented in official TSM documentation or support technotes.
TSM DB2 instance User ID, Startup, and Command Line
TSM and DB2 instance
.Everything required to run DB2 and/or TSM
.One-to-One relationship between DB2 instances and TSM instances
.You can have more than one instance per system
TSM and DB2 instance user ID
. Has SYSADM authority on the TSM database (superuser)
. Starts and stops the database
. Has authority to run all DB2 commands and access any data in the TSM database
db2start and db2stop
. Used to start and stop the database
. Done automatically, unless the instance service control is used to stop the database
. Warning: Use TSM to start and stop the database; as a rule, don't use DB2 directly
TSM DB2 Command Window
. DB2 Command Window (Windows)
. Initializes the DB2 command line environment
. DB2 OS Commands
. db2start, db2top, db2level
. db2 get instance
. db2set -all
. db2 connect to TSMDB1
. DB2 Command Line Processor
. db2
. db2 "select * from syscat.tables"
. db2 "select * from syscat.columns"
TSM commands:
q sess
q sys
select * from tables
halt
quit