Hi all,
I use DB2 v7.2 on AIX.
Our tablespaces are SMS. I want to calculate the size off the
tables. For example the table sysibm.systables has the
following files:
-rw------- 1 apldba dba 110592 Jan 16 10:21 SQL00002.DAT
-rw------- 1 apldba dba 61440 Jan 16 10:14 SQL00002.INX
-rw------- 1 apldba dba 2094080 Jan 16 15:24 SQL00002.LB
-rw------- 1 apldba dba 8192 Jan 16 15:11 SQL00002.LBA
The size for the DAT file is calculated as follows:
syscat.systables.fpages * syscat.tablespaces.pagesize = 27 * 4096 =
110592
I also want to calculate the size for the INX file, but information
for the number of pages is missing in syscat.sysindexes.
I know that there are 6 indexes:
IBM00 nleaf=3 nlevels=2
IBM21 nleaf=1 nlevels=1
IBM22 nleaf=1 nlevels=1
IBM23 nleaf=1 nlevels=1
IBM78 nleaf=4 nlevels=2
IBM137 nleaf=1 nlevels=1
But how to calculate this into 61440 ??
Alse there are some BLOB columns defined, how do I calculate them
into 2094080 and 8192 ??
Note there are 319 rows currently in the table sysibm.systables.
Regards
Raoul A. Joemman
*****************************************************************
This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only.
If you are not the addressee, you are notified that no part of
the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail
or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the
sender immediately by return e-mail, and delete this message.
Martinair Holland N.V., its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any
delay in receipt.
*****************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
