Where could I find a table record lenght in the SYSIBM 1

[AIXDB2DBA]

Where could I find a table record lenght in the SYSIBM in catalogs? I look into systables and is no there.

 

[ifxtechie]

I don't think that you can get the record length from syscat views. But you can get it by using
select sum(length) from syscat.columns where tabschema='<SOME_SCHEMA>' and tabname='<SOME_TABLE>'


Hope this helps

 

[AIXDB2DBA]

How could I do it for all table with a query?

 

[rbod]

--for all tables
select tabname,sum(length)
from syscat.columns
where tabschema = '<schema-name>'
group by tabname

 

[AIXDB2DBA]

The results in the following query do not reflet the same record lenght displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generate record lenght for every table?

select tabname,sum(length)
from syscat.columns
where tabschema = '<schema-name>'
group by tabname