Topic
  • No replies
jb_genier
jb_genier
1 Post

Pinned topic Alter a tablespace to Universal table spaces.

‏2013-05-23T07:59:46Z |

Hello,

I want to use the clone feature (I use DB2 v9.1), so I'm trying to alter a tablespace because it isn't an Universal table spaces (UTS). But I have a sqlcode -644.

This is the create of my tablespace (and inside there are 1 table and 1 index) 

CREATE TABLESPACE SVVV      
       IN DCTSTMAQ          
       USING STOGROUP GFRA105
             PRIQTY        40
             SECQTY        40
             ERASE         NO
       PCTFREE  10          
       FREEPAGE 0           
       BUFFERPOOL BP0       
       LOCKSIZE ANY         
       SEGSIZE       64     
       CLOSE NO;

This is the alter : ALTER TABLESPACE  DCTSTMAQ.SVVV  MAXPARTITIONS 1;

If some one can help me, it would be nice.

JB Genier. 

Updated on 2013-05-24T07:19:29Z at 2013-05-24T07:19:29Z by jb_genier