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