Important DB2 commands

-DISPLAY UTIL(*) --> Displays any object which is placed in utility mode due to abnormal completion of any utilitity job.

-TERM UTIL(*) --> Terminates the utility and resets the utility mode.

-STA DATABASE(DBNAME) SPACENAM(TSNAME) ACCESS(RW) - ->
Starts the TS in Read/Write mode.

-STO DATABASE(DBNAME) SPACENAM(*) --> Stops all the TS in the Database.

-DIS DB(DBNAME) SPACENAM(TSNAME) LOCKS/CLAIMERS LIMIT(*) -->
Displays list of TS which are held/locked by the users and the corresponding USERID.

-DIS GROUP --> Displays information about the DB2 subsystem (which mode the
DB2 is in, name of the subsystem,Active/Inactive,current version of the DB2 )

-DIS DB(DBNAME) SPACENAM(TSNAME) RESTRICT --> Displays TS and IX which are in utility pending status (COPY,RECOVERY,REORG pending,..etc)

-DIS DB(DBNAME) SPACENAM(TSNAME) RESTRICT LIMIT(*) --> Displays all
information without any space restriction. LIMIT(100) displays 100 rows of information.
Default is 50.