PI68019: IF THE ACCESS DATABASE MODE(OPEN) COMMAND FAILS FOR A SPECIFIC PARTITION, THE RETURN CODE IS EITHER ZERO OR TWELVE.

APAR status

• Closed as program error.

Error description

• The return code cannot be use reliable to determine the success
  or failure of an ACCESS DATABASE MODE(OPEN) command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 Version 12 administrators, executing the ACCESS DATABASE *
  * command.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The ACCESS DATABASE command uses parallelism to access       *
  * multiple partitions of an object. If the access operation    *
  * (i.e. OPEN) fails for a subset of the partitions, the        *
  * corresponding return code might not be picked up correctly   *
  * and the command responds with a non - deterministic return   *
  * code, sometimes even zero. This might prevent automation     *
  * from detecting that the access operation failed for a subset *
  * of partitions.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The ACCESS DATABASE command doesn't produce deterministic return
  codes if the access operation (i.e. OPEN) failed for a subset of
  partitions.
  

Problem conclusion

• The fix improves the synchronization of the ACCESS DATABASE
  command with the parallel executed tasks to ensure that the
  return codes are correctly handled.
  

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:

  UI42801

Modules/Macros

• DSNILSTS DSNTSTRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels