DQWFINIT DQW 03 DB ERROR RC=08, ADDITDQWDQWK108

Products

• Datacom

Issue/Introduction

Dataquery batch job DQWFINIT on the DQW fails with DB ERROR RC=08, ADDITDQWDQWK108.

 //STEP040 EXEC PGM=DQWFINIT,REGION=4096K                 
 //STEPLIB  DD ...
 //DDSNAP   DD SYSOUT=Z                                   
 //SYSOUT   DD SYSOUT=*                                   
 //SYSPRINT DD SYSOUT=*                                   
 //SYSIN    DD *                                          
 DQW 03                                                   
 /*                                                       
 //*                                                      

                    *                                CA Datacom/DB                                 *
                                    General Utility                               *      Version: 15.1
                    *               COPYRIGHT (C) 1990-2015 CA.   ALL RIGHTS RESERVED.             *
                    ********************************************************************************

                    CONTROL CARD(S)
                    .........1.........2.........3.........4.........5.........6.........7.........8
                       INIT  AREA=DQW,DBID=003

                    FUNCTION=INIT
                       AREA=DQW
                       DBID=00003

DB ERROR RC=08, ADDITDQWDQWK108 

 

Environment

z/OS 

Dataquery 15.1 

Cause

The DQW area is incorrectly defined with the AREA Attribute DYNAMIC-EXTEND on.

MUF log shows the dynamic extend messages :

20.11.09 STC07560  DB01705I - DYNAMIC EXTEND START DQW003 TRK 11,000 hlq.mufname.DB003DQW EXCP
20.11.09 STC07560  DB01709I - EXTEND SIZE DQW003 TRK 750 - AREA FULL  - DATADICT CYL 50

DBUTLTY CXX report shows this for the DQW: 
CHANGE MASTER KEY    - NO                                    TOTAL TRACKS  -    11,000          DYNAMIC EXTEND -    YES
DUPLICATE MASTER KEY - NO                                   PERCENT FULL  -       100          DYN.EXT.CYLS   -     50
RECOVER  - YES   ENCRYPTION - NONE                          DEVICE TYPE  - 3390                SECONDARY CYLS -     33

Resolution

To change the DYNAMIC-EXTEND attribute to No , run DDUPDATE using 

//SYSIN     DD  *
-USR DATACOM-INSTALL,NEWUSER 
-UPD AREA,DATAQUERY-DQW(PROD) 
1000 ALTER 
1500 DYNAMIC-EXTEND,N 
/*

Additional Information

The DQW area should not be defined with dynamic extend. 
This is mentioned in the documentation, see section Creating and Maintaining Data Areas, under heading Dynamically Extending an Area:

Some areas must be set to be not dynamically extendible. For SQL users, the TTM area which is normally in database 17 may not be extendible. For Dataquery users, the DQW table may not be extendible.

Also under section AREA Attribute-Types

DYNAMIC-EXTEND

Restrictions
Do not code a Y, T, or C on the TTM-AREA area (for SQL) or the DQW area (for Dataquery). Some user areas may also be designed in a way in which DYNAMIC-EXTEND is not desirable. If an area has tables where an application program does ADDITs or INSERTs until the table area is full and then manipulates the records added, that area should not be extendible.