View previous topic :: View next topic
|
Author |
Message |
harithaganna
New User
Joined: 03 Jun 2008 Posts: 14 Location: chennai
|
|
|
|
Hi all,
I need to find out the partion name, number of partitions and partition range for a table/View?
Could anyone help me how to get these information?
Thanks in advance,
Haritha |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Haritha,
There are various way to get it:
1. By using DB2 admin tool if you ahve access to?
2. By DDL for the table if its TAble partition or by index def if Index partition.
3. You can get it by querying on SYSIBM.SYSTABLEPART & SYSIBM.SYSTABLES |
|
Back to top |
|
|
harithaganna
New User
Joined: 03 Jun 2008 Posts: 14 Location: chennai
|
|
|
|
Hi,
I cant use the solution 1 and 2 as I dont have the required authurization.
I looked into SYSIBM.SYSTABLES, in that the column PARTKEYCOLUMN specifies the number of cols which the table is partitioned.
Then in SYSTABLEPART, I could find the Index infor and number of partitions only.
I need to specifically find what is the partition name and range for a table?
It will be better if you can provide some more details? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
for tablepartitioned tables :
Code: |
select partition, limitkey from sysibm.systablepart p
where dbname = ? and tsname = ? |
for indexpartitioned
Code: |
select partition, limitkey from sysibm.sysindexpart i
where ixcreator = ? and ixname = ? |
|
|
Back to top |
|
|
harithaganna
New User
Joined: 03 Jun 2008 Posts: 14 Location: chennai
|
|
|
|
Thanks a lot
I got th einfo what I wanted |
|
Back to top |
|
|
|