PH40261: PROVIDE ENHANCED DETAILS IN MESSAGES AND STATUS DISPLAY OF IBM INTEGRATED SYNCHRONIZATION LOG READER TASKS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Usability enhancement for IBM Integrated Synchronization log
  reader tasks started by IBM Db2 Analytics Accelerator with IBM
  or IBM Db2 for z/OS Data Gate.
  
  Additional keywords: IDAAV7R5/K DATAGATE/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who use either                     *
  * IBM Db2 Analytics Accelerator with IBM                       *
  * Integrated Synchronization or IBM Db2 for                    *
  * z/OS Data Gate.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Command -DISPLAY STATS(LOGREADERTASKS)                       *
  * does not provide a group wide view of                        *
  * active log reading tasks.                                    *
  * Messages issued by log reading tasks                         *
  * for IBM Integrated Synchronization do                        *
  * not contain a reference to the                               *
  * accelerator or Data Gate instance for                        *
  * which the log reading task was                               *
  * started.                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The -DISPLAY STATS(LOGREADERTASKS) command is enhanced to
  provide additional detail for each active task and to run the
  command on all active members of a data sharing group.
  All log reading task related messages MSGDSN090I, MSGDSNI091I,
  MSGDSNI092I, MSGDSNT788I are enhanced to show additional
  details about the task and connected accelerator or Data Gate
  instance.
  Additional keywords: IDAAV7R5/K DATAGATE/K
  

Problem conclusion

Temporary fix

Comments

• The PTF for this APAR provides the following usability
  enhancements for IBM Integrated Synchronization users:
  Output for the -DISPLAY STATS(LOGREADERTASKS) command now
  shows the correlation id of each log reading task and the
  identifier of the connected IBM Db2 Analytics Accelerator or
  IBM Db2 Data Gate instance on a second line for each task.
  The -DISPLAY STATS(LOGREADERTASKS) command can now be issued
  to all members in a data sharing group at the same time by
  using the SCOPE(GROUP) keyword:
     -DIS STATS(LRT) SCOPE(GROUP)
  SCOPE(GROUP) causes the command to run on all active members
  of the data sharing group. If any member of the data sharing
  group does not have the PTF for APAR PH40261 installed and
  activated, that member will return message:
  DSN9001I -ssid KEYWORD 'SCOPE' IS INVALID
  Messages DSNI090I, DSNI091I, DSNI092I, and DSNT788I are
  enhanced to show new fields LOCATION and CORR-ID. The
  LOCATION field shows the identifier of the IBM Db2 Analytics
  Accelerator or the IBM Db2 Data Gate instance that is
  associated with the log reading task. If no identifier is
  available due to an error, the remote IP address will be
  shown instead. The CORR-ID field shows the correlation id of
  the log reading system thread which can be helpful to
  identify possible deadlock or lock timeout issues.
  

APAR Information

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

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

  UI77365

Modules/Macros

• DSNFIDIR DSNFTDIR DSNILGRT DSNLJMCF DSN9SCNA DSNILGWD DSNLJMLR
  DSNFCDIR DSNTDSTE DSNTDSTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI77365

     UP21/10/06 P F110

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.