Division by zero. When I run:

select substr(TABLESPACE_NAME,1, 18) as tablespace_name, total_pages from
table (snapshot_tbs_CFG(cast(null as varchar(20)), -2 )) as x

I get

TABLESPACE_NAME TOTAL_PAGES
------------------ --------------------
SYSCATSPACE 0
TEMPSPACE1 0
USERSPACE1 0
TEMPSPACE2 0

Your query divides by TOTAL_PAGES.

I have SMS tablespaces.

-----Original Message-----
From: Bandaru Jayaprakash
[mailto:db2udbdba-ezmlmshield-x33334146.[Email address protected]
Sent: Friday, January 28, 2005 3:41 AM
To: LazyDBA Discussion
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