IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Issue While Recovering a Tablespace


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 172
Location: India

PostPosted: Tue Aug 07, 2018 2:54 am
Reply with quote

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
View user's profile Send private message
Terry Yin

New User


Joined: 19 Sep 2018
Posts: 4
Location: China

PostPosted: Wed Sep 19, 2018 5:12 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2572
Location: NYC,USA

PostPosted: Fri Sep 21, 2018 7:27 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Senior Moderator


Joined: 14 Mar 2007
Posts: 10714
Location: italy

PostPosted: Fri Sep 21, 2018 8:04 pm
Reply with quote

after one month the problem should have already been solved icon_cool.gif
Back to top
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 172
Location: India

PostPosted: Mon Oct 15, 2018 1:03 am
Reply with quote

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 icon_biggrin.gif

Thanks,
Sati
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 tablespace space limitation DB2 3
This topic is locked: you cannot edit posts or make replies. issue with Syntax error SYNCSORT 2
No new posts Issue while fetching a column(Nullabl... DB2 18
No new posts Issue while reading a file in browse ... TSO/ISPF 7
No new posts Issue in SFTP a file All Other Mainframe Topics 1
Search our Forums:

Back to Top