Hi All,

I am getting this error when trying to execute the following command on
Linux.

db2 "SELECT substr(TABLESPACE_NAME,1, 18) as
TABLESPACE_NAME,((USED_PAGES * 100) / TOTAL_PAGES) as PERC_USED FROM
table (snapshot_tbs_CFG(cast(null as varchar(20)), -2 )) as x ORDER by
PERC_USED desc".

This query gives the correct results on SUN Solaris.

Anybody has idea about this, plz share..

Thanks,

Jayaprakash.

DB2 & UDB email list listserv db2-l LazyDBA home page