asked on

DB2 tablespaces: “partition-by-range” or “partition-by-growth”

During the upgrade from DB2 9 to DB2 10 on z/OS, the previous (now retired) DBA converted all tablespaces from "simple" to "universal". How can I determine if they are partition-by-range or partition-by-growth?

Using RC/Query in CA/Tools from Computer Associates, I was able to reverse-engineer the CREATE TABLESPACE statement, but it's not obvious from the code which type of tablespace this is.

CREATE TABLESPACE SNF101
       IN DNF1
       USING STOGROUP GNF2
           PRIQTY 48
           SECQTY 48
           ERASE NO
       BUFFERPOOL BP1
       CLOSE NO
       LOCKMAX SYSTEM
       SEGSIZE 4
       FREEPAGE 0
       PCTFREE 5
       GBPCACHE CHANGED
       DEFINE YES
       LOGGED
       TRACKMOD YES
       COMPRESS NO
       LOCKSIZE ANY
       MAXROWS 255
       CCSID EBCDIC
;

Open in new window

Given that CREATE TABLE statement, how can I determine if this is partition-by-range or partition-by-growth?

Thanks!

Dave

Kent Olsen

Hi Dave,

I'm not a Z/OS kinda guy, but I do have a long history with DB2/UDB. Curious about your question, I found this:

MAXPARTITIONS integer

Specifies that the table space is partition-by-growth. integer specifies the maximum number of partitions to which the table space can grow. integer must be in the range of 1 to 4096, depending on the value that is in effect for DSSIZE and the page size of the table space, and must not be less than the current maximum number of partitions for the table space.

That can be found in both the DB2 V9 and V10 Reference manuals. If MAXPARTITIONS is set, the table is partition-by-growth. If it is not set the table space is partition-by-range.

Good Luck,
Kent

ASKER CERTIFIED SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_2484401

ASKER

Thanks, gentlemen! That answered the question perfectly.