IBM Mainframe Forum

In DB2 V8, an index partitioned table space could also be segmented ?
Really I thought no. By looking at the SQL Reference SC18-7426-00, in the syntax schema, it appears that the NUMPARTS line is not compatible with the SEGSIZE ones.
But in the catalog I found few tablespace of unknown (for me) applications where both NUMPARTS and SEGSIZE are <> 0.
Therefore my model is crashing.
Could it depend from effect of any LARGE or LOB or DSSIZE clause ? (or not reorg-ed catalog ?)
Probably I need to study again.
Thanks for comments.

Hello,

Is there actually a question or problem here?

Therefore my model is crashing.

What does this mean?

Once more people understand the issue, more useful replies may be posted. . .

d

Sorry dick, I am unclear, now redo.
Question1: from a syntactical point of view, does the create tablespace statement (SQL DB2 v.8) accept both NUMPARTS n (PARTITIONS 1 etc. PARTITIONS n etc:) and SEGSIZE m ? If yes, where is the case documented ?
Question2: Is this query correct ?
SELECT PARTITION, SEGSIZE
FROM SYSIBM.SYSTABLEPART AS D, SYSIBM.SYSTABLESPACE AS E
WHERE ((D.TSNAME = E.NAME)
AND (D.PARTITION <>0)
AND (E.SEGSIZE <>0))
WITH UR;

If yes, I'm saying that by means of it I discovered that apparently partitioned and segmented table spaces do exist. For me it is a new concept.

Have a look to see if your vesion supports "Universal table spaces".