table partition related dictionary for DB2 iSeries(AS400)



IBM's flagship relational database management system

table partition related dictionary for DB2 iSeries(AS400)

Postby jangkeunna » Thu Sep 27, 2018 10:04 am

Hi!

I wander what is the dictionary containing table partitioning information like partition key, partitioning type, partittion range, etc. Actually what i want is creating partitioning clause of CREATE TABLE statement from dictionary.
DB2 for zOS have dictionary like syscat.datapartitions, syscat.datapartitionexpression but for DB2 for iSeries, theres no schema syscat.

How can I get partitioning information?
jangkeunna
 
Posts: 2
Joined: Thu Sep 27, 2018 9:49 am
Has thanked: 0 time
Been thanked: 0 time

Re: table partition related dictionary for DB2 iSeries(AS400)

 

Re: table partition related dictionary for DB2 iSeries(AS400

Postby jangkeunna » Thu Sep 27, 2018 10:42 am

My DB2 version is 7.2.
Does my version support partitioning?
jangkeunna
 
Posts: 2
Joined: Thu Sep 27, 2018 9:49 am
Has thanked: 0 time
Been thanked: 0 time

Re: table partition related dictionary for DB2 iSeries(AS400

Postby NicC » Thu Sep 27, 2018 2:13 pm

Does my version support partitioning?

Look in your manual.

Also, this is a mainframe forum so you might be better off asking on a dedicated iSerues/AS400 forum.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2941
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 134 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post