Partitioned and Segmented tablespace



IBM's flagship relational database management system

Partitioned and Segmented tablespace

Postby clunghi » Thu Jun 30, 2011 2:04 pm

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.
clunghi
 
Posts: 3
Joined: Fri May 29, 2009 4:11 am
Has thanked: 0 time
Been thanked: 0 time

Re: Partitioned and Segmented tablespace

 

Re: Partitioned and Segmented tablespace

Postby dick scherrer » Fri Jul 01, 2011 12:10 am

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
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Partitioned and Segmented tablespace

Postby clunghi » Sat Jul 02, 2011 3:14 am

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.
clunghi
 
Posts: 3
Joined: Fri May 29, 2009 4:11 am
Has thanked: 0 time
Been thanked: 0 time

Re: Partitioned and Segmented tablespace

Postby BillyBoyo » Sat Jul 02, 2011 3:55 am

Have a look to see if your vesion supports "Universal table spaces".
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post