How do I resolve the following error in the R18 or R19 Post Install Create job (ssid0001) in the EXECRBP2 step:
DSNT408I SQLCODE = -650, ERROR: THE ALTER STATEMENT CANNOT BE
EXECUTED, REASON 21
This occurs on:
ALTER TABLE PTI.PTMGB_APTABLE_0100
ALTER COLUMN AUTOREPAIR SET DEFAULT 'N' ;
As of April 29, 2016 the following PTF's are available:
The REASON states:
ALTER TABLE SET DEFAULT and DROP DEFAULT are not allowed for
tables in advisory REORG-pending (AREO) state.
1. Reorg the table.
2. Restart the Create job (ssid0001) as follows:
a. ADD ",RESTART=EXECRBP2" to the JOBCARD.
b. . DELETE or comment out the line
"// COND=(4,LT,EXECRBP1)," FROM THE EXECRBP2 STEP.
c. On the Batch processor control statements in EXECRBP2,
add .RESTART SYNC After the .OPTION line and before .CONNECT.
( The job will pick up at the SYNC point it left off at.)
d. Submit the job.