Hi,

I executed the below statement for get tablespace informations. But, I am getting an error.



db2 "select tablespace_id,substr(tablespace_name,1,20),total_p ages,used_pages,free_pages from table (snapshot_tbs_cfg('',-1)) as snapshot_tbs order by total_pages desc fetch first 20 rows only"

SQL1042C An unexpected system error occurred. SQLSTATE=58004

Please help me in resolving this problem.

Regards,
Santhosh

ensure that the system time and date is correctly set, and make sure
your system has enough memory and swapping/paging space
available.
Resubmit the current command.
If the error continues, stop the database manager and restart
it.
check more by typing (clp)
C:\Program Files\IBM\SQLLIB\BIN>db2 ? SQL1042C

Rahul Singh