MVSFORUMS.com

LEO · Posted: Wed Jul 19, 2006 4:53 pm Post subject: DB2 Partition Tables

Hi,

I would like to know if there is way to find out the PART VALUES that were used while creating partition index ?

I have access to platinum ? I could see that there are 100 partitions in the table. But I could not see any column that say Partitioning value.
ex: Part 1 - 1 to 2000
part 2 - 2001 t0 4000 etc

I do not have access to DDLs that were used. Is there a way to find out this ?

Please advise

Thanks

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

If you have access DB2 catalog table, check the table SYSIBM.SYSINDEXPART
column LIMITKEY contain this information

LEO · Posted: Fri Jul 21, 2006 1:31 pm Post subject:

Thanks alot

coolman · Posted: Wed Jul 26, 2006 3:31 pm Post subject:

Videlord,

Who determines this LIMITKEY? or depending on the number of partitions, does DB2 determine itself and when you do a REORG, I suppose this LIMITKEY would change. Correct?
________
vaporizer wholesale

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

The values in LIMITKEY stem from the CREATE INDEX DDL; that means, that the person creating the object is responsible for the partitioning design.

A REORG does not reballance the contents of the partition.

regards
Christian

coolman · Posted: Thu Jul 27, 2006 10:16 am Post subject:

If that's the case, you create a partition on a tbsp and then lots of updates/inserts happens on this tbsp. Then there's a possibility that one partition might become really huge when compared to the other. So, in this case do you drop the index and create it ?
________
vaporizer shop