You still have to factor in allowances for nulls, varying length columns,
user defined types, LOBs and the like. Try the best-fit pagesize algorithm
from my website: http://www.sustainablesoftware.net/free_downloads.htm ;
this includes a fully commented calculation of row length.
Regards
Alex Levy
Sustainable Software Ltd.
________




"Kaushal Anand "
<db2udbdba-ezmlms
hield-x51967464.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
29/08/2006 11:15
Subject
RE: Row size in DB2










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





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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