table partition related dictionary for DB2 iSeries(AS400)

IBM's flagship relational database management system
Post Reply Previous topicNext topic
jangkeunna
Posts: 2
Joined: Thu Sep 27, 2018 9:49 am
Skillset: DB2
Referer: googling

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?
Top
jangkeunna
Posts: 2
Joined: Thu Sep 27, 2018 9:49 am
Skillset: DB2
Referer: googling

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?
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”