470,586 Members | 1,651 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

How to find partitioning key of a table


I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

Jan 30 '06 #1
2 8459
jorge wrote:
I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

SYSCAT.COLUMNS.PARTKEYSEQ

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 30 '06 #2
Raj
I try the db2look to extract DDL and view the partitioning key ...
Serge Rielau wrote:
jorge wrote:
I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

SYSCAT.COLUMNS.PARTKEYSEQ

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab


Feb 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mike Charney | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.