View previous topic :: View next topic
|
Author |
Message |
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi There,
Hope you are doing well.
I am getting following error while running RECOVER TABLESPACE
Code: |
BMC40407S UNABLE TO EXTEND DATASET dataset name
BMC96300S EXECUTION SUBTASK 1 TERMINATED WITH SYSTEM ABEND CODE X'0C4' |
When I verified memory allocations of the underlying dataset of the tablespace or tablespace partition, it is reaching 251 extents but it got 1 primary and 1 secondary allocation only.
Is there a way to alter and allocate more primary/secondary allocations for an underlying datasets of a tablespace.
Can someone help me in this regard. |
|
Back to top |
|
|
Terry Yin
New User
Joined: 19 Sep 2018 Posts: 4 Location: China
|
|
|
|
From the two rows log only I couldn't figure out exact root cause. But if you want to resize your tablespace you can use below statement. Do check if your tablespace already in UTS structure.
ALTER TABLESPACE database_name.tablespace_name PRIQTY integer;
ALTER TABLESPACE database_name.tablespace_name SECQTY integer;
also considering to change DSSIZE, SEGSIZE and add PARTITION according to your actual scenarios. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Did you check the BMC Manuals for any fix or have you contacted anyone else at your site than just the forum? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
after one month the problem should have already been solved |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi All,
Thanks for your kind suggestions and sorry for the late update.
Actually, TABLESPACE was created with PRIQTY and SECQTY values as -1 which allows DB2 to increase the primary or secondary allocations dynamically when data grows but somehow it was not happening to my tablespace.
I have dropped and recreated the tablespace. Now, DB2 is able to manage the primary and secondary allocations efficiently.
Not sure about reason why it was not happening earlier and happening after recreation
Thanks,
Sati |
|
Back to top |
|
|
|