All tablespaces are state 0.  Including syscat  :

=> db2 list tablespaces show detail | grep State
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000
State                                = 0x0000

On Feb 1, 3:43 am, vijay...@gmail.com wrote:

Weird - a pragmatic method to test it would be:

Just pick by random a table from each tablespace and do a "select *
with fetch first 1 rows only". If all selects work well then db2 cfg
lies - if not you'll know which tablespace has a problem. You can
generate the necessary select with a sql query like this:
with temp1 as
(SELECT max(rtrim(tabschema) concat '.' concat rtrim(TABNAME)) as
TABNAME,TBSPACEID
    FROM SYSCAT.TABLES where tbspaceid > 0
    group by tbspaceid)
select 'SELECT * FROM ' concat tabname concat ' FETCH FIRST 1 ROWS
ONLY;' as SELECT_STMT from temp1

This method will not cover tablespaces where only indexes are stored
in. In this case you will need to modify the selects in such a way
that an index access will happen

HTH
Joachim