You probably need more activity on the system. There is a zero value
somewhere.





"Bandaru
Jayaprakash "
<db2udbdba-ezmlms To
hield-x51821838.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

01/28/2005 10:17 Subject
AM RE: SQL1476N The current
transaction was rolled back because
of error "-801











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.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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