db07105i dynamic extend start failed rc 07 (36)
Article ID: 100225
Updated On:
Products
Datacom
DATACOM - AD
Issue/Introduction
We just started getting the following messages in three of our Datacom regions:
DACA:DB01705I - DYNAMIC EXTEND START A06004 TRK 330
DACA.A06004 IEC030I B37-04,IFG0554A,DACA,DACA,A06004,53B4,DACT01, 676 DACA.A06004
DACA: DB01702I - DYNAMIC EXTEND OF AREA A06004 HAS FAILED
DACA:DB01102E - UNEXPECTED 07(036) RETURN CODE ON A06 TABLE FOR ADDIT REQUEST DACA:DB01103I - ACCOUNTING FOR A06 TABLE DISABLED DACA: DB01107W - 00068 ACCOUNTING ENTRIES LOST FOR TABLE A06 DUE TO FAILURE
I found the files were at 16 extents and 100% full - can i simply copy the files to larger files and then swap them in when the regions are down? Or do i need to do some kind of a INIT or FORMAT of the files? I don't know Datacom at all..
I found in the error manual what the message means - so i just need help in how i go about fixing the issue. Thanks.
DACA:DB01705I - DYNAMIC EXTEND START A06004 TRK 330
DACA.A06004 IEC030I B37-04,IFG0554A,DACA,DACA,A06004,53B4,DACT01, 676 DACA.A06004
DACA: DB01702I - DYNAMIC EXTEND OF AREA A06004 HAS FAILED
DACA:DB01102E - UNEXPECTED 07(036) RETURN CODE ON A06 TABLE FOR ADDIT REQUEST DACA:DB01103I - ACCOUNTING FOR A06 TABLE DISABLED DACA: DB01107W - 00068 ACCOUNTING ENTRIES LOST FOR TABLE A06 DUE TO FAILURE
I found the files were at 16 extents and 100% full - can i simply copy the files to larger files and then swap them in when the regions are down? Or do i need to do some kind of a INIT or FORMAT of the files? I don't know Datacom at all..
I found in the error manual what the message means - so i just need help in how i go about fixing the issue. Thanks.
Environment
z/os, CA Datacom/DB 14.0 and higher.
Cause
The fact, that files involved were at 16 extents and 100% full, is preventing any dynamic extend facility to take place.
DBUTLTY using following SYSIN will not work:
//SYSIN DD *
COMM OPTION=CONSOLE,OPTION2='DYNAMIC_EXTEND 004,A06,111,TRK'
/*
DBUTLTY using following SYSIN will not work:
//SYSIN DD *
COMM OPTION=CONSOLE,OPTION2='DYNAMIC_EXTEND 004,A06,111,TRK'
/*
Resolution
The only possibility here is to:
0- Shut down the Multi-User via EOJ.
1- ALLOCATE a larger AREA using same data set name using ISPF or other meaning.
2- INIT the AREA using DBUTLTY (see below).
3- LOAD FORMAT=NONE the AREA using DBUTLTY (see below).
4- Restart the Multi-User.
DBUTLTY job would look like:
/DBUT EXEC PGM=DBUTLTY,REGION=0M
//DDSNAP DD SYSOUT=*
//SNAPER DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSPUNCH DD DUMMY
//A06004 DD DSN=yourdsn.A06004,DISP=SHR
//SYSIN DD *
INIT AREA=A06,DBID=004
LOAD AREA=A06,DBID=004,FORMAT=NONE
/*
0- Shut down the Multi-User via EOJ.
1- ALLOCATE a larger AREA using same data set name using ISPF or other meaning.
2- INIT the AREA using DBUTLTY (see below).
3- LOAD FORMAT=NONE the AREA using DBUTLTY (see below).
4- Restart the Multi-User.
DBUTLTY job would look like:
/DBUT EXEC PGM=DBUTLTY,REGION=0M
//DDSNAP DD SYSOUT=*
//SNAPER DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSPUNCH DD DUMMY
//A06004 DD DSN=yourdsn.A06004,DISP=SHR
//SYSIN DD *
INIT AREA=A06,DBID=004
LOAD AREA=A06,DBID=004,FORMAT=NONE
/*
Additional Information
In case the file has not fully use the 16 extents, you may still use the DBUTLTY mentioned above.
see following article 000040185
https://ca--c.na60.visual.force.com/apex/CustomKnowledgeEdit?articleId=ka00c000000y6wxAAA
Title: Can I manually extend my CA Datacom database area to a new size while the database is in use?
see following article 000040185
https://ca--c.na60.visual.force.com/apex/CustomKnowledgeEdit?articleId=ka00c000000y6wxAAA
Title: Can I manually extend my CA Datacom database area to a new size while the database is in use?
Feedback
Yes
No
Powered by
