View previous topic :: View next topic
|
Author |
Message |
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
if the table is using partisioned table space. if there are 3 parts.
how to know that what type of data is stored in part1, part2 & part3. i mean the schema/condition to store in a particular part. |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Data is stored by partioning key (data seperation key), you can query SYSIBM.SYSTABLEPART table to view partioning key.
Example:
Code: |
SELECT PARTITION, LIMITKEY
FROM SYSIBM.SYSINDEXPART
WHERE IXNAME = 'give clustering index'
ORDER BY PARTITION;
|
LIMITKEY is max value partition will have for example if result is:
Code: |
PARTITION LIMITKEY
--------- ----------
1 00340330
2 01000000
3 01664166
|
Partition 1 is anything less than 00340330
Partition 2 will have values Greater than 00340330 and Less than equal to 01000000 and so on. |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Correction! Partition 1 is anything less than equal to 00340330 |
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
Thank you.
but i am getting junk values in limit key column
index is a date filed.
[/img] |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Probably index name is not correct, you can find clustering index name by using following:
Code: |
SELECT NAME "IXNAME", TBNAME, CLUSTERING
FROM SYSIBM.SYSINDEXES
WHERE TBNAME = 'table name'
AND CLUSTERING = 'Y'
|
|
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
Thank you.
i got the limit key from systablepart. it is showing normally like 2001-01-01. but in indexpart is is showing junk values. this because the field is date field. it may encrypt and keep in index.
thanks for your help. |
|
Back to top |
|
|
|