Hi All, Can you pls tell me how to 3

[gbag]

Hi All,
Can you pls tell me how to find row length [row size] for a DB2 table.
Thanks
G

 

[Crox]

Does the programming language help you with LENGTH OF or can you read it in the listing?

 

[tzamora]

select SUM(XX.LENGTH)
FROM SYSIBM.SYSCOLUMNS XX
where XX.tbcreator = 'DBAADMIN'
AND XX.tbname = 'YOUR_TABLE_NAME'

http://programmer-by-the-hour.com

 

[kasavazala]

sum(length) is correct only if the columns in the table don;t include a char or varchar.

So, if you have a char or varchar columns,

select sum(length) from syscat.columns where tabname="tablename" and tabschema="tableschema" and typename not in ('CHARACTER','VARCHAR')

this is your first sum.

then take each column that is a char or varchar and do

select avg(length(rtrim(column))) from tablename

these will be your second sum.

Add these two to get rowsize.

Hope this helps.

 

[pkganapathi]

HI,

Another option is to use a tool like BMC Catalog Manager and do a DESCRIBE or (select S) against that table. There is a field to show the total length of the table.

-PK.Ganapathy
DB2 DBA
TCS

I.T.Analyst
Tata Consultancy Services

 

[hnkadmn]

Hi

If you have Platinum tool, then go to Rc/query and give the table name you get the length.

Hari
TCS

 

[samiksaha]

Hello all,

The SYSIBM.SYSCOLUMNS contains the coloums mentioned below:

NAME: Name of the coloum
TBNAME: Name of the Table
TBCREATOR:
COLNO:
COLTYPE:
LENGTH: You need to chk it

So if you give a simple select * on the SYSIBM.SYSCOLUMNS
with the TBNAME you will get the col name and the length of it irrespective of the col type.

Hope it helps.

regards.
Samik.