PK10611: ALC ON TABLE THAT CONTAINS A GENERATED ALWAYS COLUMN CAN RESULT IN MSGIEFC452I JOB NOT RUN - JCL ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool an ALC line command run against a
  table that contains a GENERATED ALWAYS column can fail with a
  JCL error. Error messages appear similar to the following:
  .
  IEFC019I MISPLACED ENDIF STATEMENT
  IEFC018I UNEXPECTED END OF JCL
  IEFC018I UNEXPECTED END OF JCL
  .
  Additional symptoms: Combine job steps no ... iefc452i
  msgiefc019i msgiefc018i ST6SQ
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 ADB2GEN  to  ALC a table with an identity    *
  *                 column with  GENERATED  ALWAYS on DB2 V8,    *
  *                 are affected.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALC on TABLE that contains a GENERATED  *
  *                      ALWAYS column can result in MSGIEFC452I *
  *                      JOB NOT RUN - JCL ERROR                 *
  *                      .*                                      *
  *                      When ALC JCL was created with separate  *
  *                      jobs  for each step an extra ENDIF was  *
  *                      generated in the LASTSQL step.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• In  DB2 Administration Tool an ALC line command run against a
  table that contains a GENERATED ALWAYS column could fail with
  a JCL error. The problem has now been fixed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADB27SQ1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK08048

     UP05/10/28 P F510

• R710 PSY UK08049

     UP05/10/28 P F510

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.