How about using syscat.columns!! You should ensure that you're
statistics are up-to-date on that table. Run runstats otherwise.

-- [] optional
select sum(length) from syscat.columns where tabname='tablename' [and
tabschema='yourschema']

This will give the size in bytes.

Regards,

Anand.

-----Original Message-----
From: Alex Choice
[mailto:db2udbdba-ezmlmshield-x71487143.[Email address protected]
Sent: Thursday, August 17, 2006 2:23 AM
To: LazyDBA Discussion
Subject: Row size in DB2



Does anybody have a script to calculate the row size in DB2?

Alex Choice
Account Executive
Database-Brothers, Inc.
512-249-2324 x 117
512-249-9324 (Fax)
alex.[Email address protected]
<http://www.database-brothers.com/> www.database-brothers.com





---------------------------------------------------------------------
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