Shell Programming and Scripting

db2 list tablespaces 

            Tablespaces for Current Database

 Tablespace ID                        = 0
 Name                                 = SYSCATSPACE
 State                                = 0x0000
   
 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 State                                = 0x0000

Tablespace ID    Name                       State
            0        SYSCATSPACE            0x0000
            1        TEMPSPACE1              0x0000

db2 list tablespaces | \
awk -F '[[:space:]]*=[[:space:]]* ' '
BEGIN            { print "Tablespace_ID Name State"; }
/^Tablespace ID/ { id    = $2 ; next }
/^Name/          { name  = $2 ; next }
/^State/         { print id, name, $2 }
'

SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE ORDER BY DBNAME,NAME

or 

SELECT TBSPACE FROM SYSIBM.SYSTABLES WHERE NAME = 'table_name' AND CREATOR='schema_name';