How to find partitioning key of a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jorge - 30 Jan 2006 01:04 GMT

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

Reply to this Message

Serge Rielau - 30 Jan 2006 01:43 GMT

> I have just started working with DB2 Data Partition Feature.. Given a
> table
[quoted text clipped - 4 lines]
> Thanks,
> Jorge

SYSCAT.COLUMNS.PARTKEYSEQ

Cheers
Serge

Signature

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

Reply to this Message

Raj - 08 Feb 2006 21:35 GMT

I try the db2look to extract DDL and view the partitioning key ...

> > I have just started working with DB2 Data Partition Feature.. Given a
> > table
[quoted text clipped - 15 lines]
> DB2 UDB for Linux, Unix, Windows
> IBM Toronto Lab

Reply to this Message