Use this code

DB2 commands : TERM, START, STOP, DIS

- DIS or -Display : Display a status of tablespace (ie READ-WRITE / COPY-PENDING / CHECK-PENDING / READ ONLY)

-DIS  DATABASE(dbname) SPACENAM(tbspace)

more on Display Database

Stop / Start a tablespace / indexspace:

-STOP  DATABASE(dbname) SPACENAM(tbspace)
-START  DATABASE(dbname) SPACENAM(tbspace) ACCESS(FORCE)

Start: publib.boulder.ibm.com/../bjncstdb999243.htm

Stop: publib.boulder.ibm.com/../bjncstod999243.htm
How to find a table’s Database name and tablespace name?

SELECT DBNAME, TSNAME FROM
SYSIBM.SYSTABLES WHERE NAME = [table name]
 AND OWNER = [qualifier] ;

SELECT DBNAME, TSNAME FROM
SYSIBM.SYSTABLES WHERE NAME = 'SYSDUMMY1' AND
OWNER = 'SYSIBM';

Terminating a BMC (or any DB2) utility:
issue the Terminate Utility command:
-TER UTILITY([util id])
TERM: publib.boulder.ibm.com/../ctermu.htm

Related Posts

• DIRECT YES and DIRECT NO options in BMC unload plus
• Logical Operators in DB2
• Embedded DB2 SQL in Easytrieve
• Using MAXASSIGNEDVAL from SYSIBM.SYSSEQUENCES (IBM DB2 for Z OS)
• Creating (Declaring), Inserting data into DB2 temporary tables
• Using IKJEFT01 for Binding a normal batch DB2 program
• Using IKJEFT01 for running a normal batch DB2 program
• Running DSNTIAUL using IKJEFT01 for batch unload
• Running DSNTEP2 / DSNTEP4 using IKJEFT01 for batch SQL(DB2) processing