Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Altering MAXPARTITIONS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Altering MAXPARTITIONS
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: 1013
Location: India

PostPosted: Thu Jun 06, 2013 4:48 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Jun 06, 2013 5:44 pm    Post subject: Reply to: Altering MAXPARTITIONS
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT altering seq in non sorted colum... Yvonne1980 DFSORT/ICETOOL 3 Thu Feb 24, 2011 7:52 pm
No new posts Altering the management class of a GD... Chase JCL & VSAM 9 Sun Jul 04, 2010 8:28 pm
No new posts Altering COBOL Load Module Signature ... Bill O'Boyle COBOL Programming 5 Wed Mar 17, 2010 9:06 pm
No new posts Altering RACF group in batch or thru ... vasanthz TSO/ISPF 14 Thu Oct 30, 2008 4:52 pm
No new posts algo for altering a table mailsaurabh.tripathi DB2 1 Tue Oct 07, 2008 11:00 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us