Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find table record length

Status
Not open for further replies.

AIXDB2DBA

MIS
Jan 24, 2005
9
US
The results in the following query do not reflect the same record length displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generates record length for every table?

select tabname,sum(length)
from syscat.columns
where tabschema = '<schema-name>'
group by tabname
 
This query you're using calculates only the length of the data in a table. The whole length is propably more since each column has to be separated somehow from each other.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top