Page 1 of 1

DB2 storage space

PostPosted: Sat Feb 18, 2017 5:43 pm
by senthamizh
Hi ,

In want to know how to Calculate the size of one Table or one Schema

I searched in google but i am getting queries using SYSCAT.% tables to get the information.But i dont have this tables access.In our shop we are having sysIMB.SYS% tables.

can some know how to get the information using SYSIBM.SYS% tables.

Thanks,
Sen

Re: DB2 storage space

PostPosted: Tue Feb 21, 2017 12:27 pm
by pranav283
TS,

You won't be able to query SYSCAT tables because they are DB2 LUW specific tables and not for DB2 for z/OS.