Anybody has idea about this error..

Jayaprakash.
> -----Original Message-----
> From: Bandaru, Jayaprakash
> Sent: Friday, January 28, 2005 5:11 PM
> To: '[Email address protected]
> Subject: SQL1476N The current transaction was rolled back
> because of error "-801
>
> 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