Page 1 of 1

table partition related dictionary for DB2 iSeries(AS400)

PostPosted: Thu Sep 27, 2018 10:04 am
by jangkeunna
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?

Re: table partition related dictionary for DB2 iSeries(AS400

PostPosted: Thu Sep 27, 2018 10:42 am
by jangkeunna
My DB2 version is 7.2.
Does my version support partitioning?

Re: table partition related dictionary for DB2 iSeries(AS400

PostPosted: Thu Sep 27, 2018 2:13 pm
by NicC
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.