IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Altering MAXPARTITIONS


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Jimy Carol

New User


Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Wed Jun 05, 2013 5:59 pm
Reply with quote

Hello ,

I am migrating a Table from one SSID to another SSID , the Table space in target has too many partitions (PBG) which is leading some problem ( Actually its merger operation ) . The probable solution is to make MAXPARTITIONS of target equal to source TS .
How could I make target Tablespace MAXPARTITIONS same as of source , without explicitly specifying the source table space MAXPARTITIONS.
is there anything like LIKE command which can alter the attribute MAXPARTITIONS of target making it excatly same as of source .

Appreciate for any pointers !

Regards
Carol
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1018
Location: India

PostPosted: Thu Jun 06, 2013 4:48 pm
Reply with quote

Hi Carol,

Below is the statement to alter the maxpartitions of the tablespace,
Code:
ALTER TABLESPACE               
  Sushanth.TESTPBG
    MAXPARTITIONS 4           
;                             

You can query the source subsystem, table sysibm.systablepace column MAXPARTITIONS and generate an SQL and run that SQL in the TARGET. Like below ,
Code:
SELECT 'ALTER TABLESPACE '||strip(DBNAME)||'.'||strip(NAME)||' MAXPARTITIONS '||MAXPARTITIONS||' ; '
from sysibm.systablespace
Where dbname like 'A%'
;

the sql is Not Tested

Thanks,
Sushanth
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10696
Location: italy

PostPosted: Thu Jun 06, 2013 5:44 pm
Reply with quote

Quote:
I am migrating a Table from one SSID to another SSID ,


even if foggy
the terminology seems to imply transferring data between different DB2 subsystems.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Altering output file attributes All Other Mainframe Topics 5
No new posts SORT altering seq in non sorted colum... DFSORT/ICETOOL 3
No new posts Altering the management class of a GD... JCL & VSAM 9
No new posts Altering COBOL Load Module Signature ... COBOL Programming 5
No new posts Altering RACF group in batch or thru ... TSO/ISPF 14

Back to Top