DBXCLPS MESSAGE: SQE00204

Document ID : KB000024254
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Executing the Collapse entity id program 'DBXCLPS' may end with a CC=8 and the following error:

*
MESSAGE: SQE00204
***** AN SQL ERROR HAS OCCURRED. *****                    
DB2 MESSAGE: DSNT408I
SQLCODE:    ...204
ERROR:
repowner.COLLAPSE_RESTART IS AN UNDEFINED NAME
*
Where repowner is the repository schema specified in parm #6.

Solution:

Remove any spaces in the PARMFILE DD separating parameters.

For example, the following PARMFILE results in the above error:

...
//PARMFILE DD *
   Y       ; 1.  DEBUG  MODE
   1       ; 2.  STARTING ENT_ID
   240     ; 3.  THE NUMBER OF MINUTES THIS JOB SHOULD RUN
   100     ; 4.  THE NUMBER OF INSTANCES UPDATED BEFORE A COMMIT
   
   REPODB  ; 5.  THE NAME OF THE DATABASE TO CONTAIN THE
   
   OWNER   ; 6.  THE REPOSITORY SCHEMA
...

Remove the spaces after parms 4, 5, and 6 as follows:

...
//PARMFILE DD *
   Y       ; 1.  DEBUG  MODE
   1       ; 2.  STARTING ENT_ID
   240     ; 3.  THE NUMBER OF MINUTES THIS JOB SHOULD RUN
   100     ; 4.  THE NUMBER OF INSTANCES UPDATED BEFORE A COMMIT
   REPODB  ; 5.  THE NAME OF THE DATABASE TO CONTAIN THE
   OWNER   ; 6.  THE REPOSITORY SCHEMA
...