Hi all,
I am executing the following query to find out if the tablespaces have enough pages. This query works on all the servers except for one. The error is SQL1042C An unexpected system error occurred. SQLSTATE=58004
Query:
select count(*) from table(snapshot_tbs_cfg('',0)) as x where cast((cast(used_pages as double)/cast(usable_pages as double))*100 as integer) > 80 and usable_pages!=0 and tablespace_type=0

Does anyone experienced this error before?

"DB2 v8.1.1.96", "FixPak "10".
OS : AIX 5.1.0.0



Thanks all..