View previous topic :: View next topic
|
Author |
Message |
Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
|