PQ99461: SYSADMIN UPD JOBLISTS FAILS DUE TO ENQUEUE ON CUSTOMER IDLTABL DATASET DURING MULTIPLE UPDATES FOR CSID GROUPS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AFTER APPLYING ANY DBCS PTFS AND ATTEMPTING TO RUN THE
  IDLUPDJL REXX UTILITY PGM THROUGH THE SYSTEM ADMINISTRATION
  PANEL TO UPDATE THE JOBLIST TABLES FOR MULTIPLE CSID
  MEMBERS IN THE IDLTABL DATASET, THE USER'S TSO SESSION
  WENT INTO A WAIT AS A RESULT OF AN ENQUEUE ISSUED PREVIOUSLY
  AGAINST A MEMBER BEING EDITED A SECOND TIME. THE PREVIOUS
  ENQUEUE WAS NOT RELEASED.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DATABASE CONTROL SUITE R3.10 USERS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: THE SYSTEM ADMINISTRATION OPTION TO     *
  *                      UPDATE THE TABLE DATA SET AFTER SMPE    *
  *                      MAINTENANCE CAUSES AN ENQUEUE ON THE    *
  *                      JOBLIST TABLES IF RUN TWICE ON THE      *
  *                      SAME CSID.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  THE ENQUEUE PROBLEM OCCURRED AS A RESULT OF RUNNING THE UPDATE
  JOBLIST UTILITY AGAINST THE SAME IDLTABL DATASET CSID MEMBER A
  SECOND TIME. THE ENQUEUE ON THE IDLTABL FROM THE FIRST UPDATE
  PROCESS WAS STILL OUTSTANDING THUS A WAIT CONDITION WAS CREATED.
  

Problem conclusion

• THE ENQUEUE PROBLEM HAS BEEN RESOLVED BY ISSUING A TBCLOSE FOR
  EACH JOBLIST TABLE IN THE SELECTED CSID.
  
  ADDITIONAL CORRECTIONS MADE WITHIN THIS APAR.
  1.  CORRECT JOBLIST COMPARES WITHIN NEW REXX LOGIC TO TRIGGER
      CCF COMMANDS WITH DATABASE REORG JCL JOBSTREAMS.
  2.  CHANGE THE 'LIST.DBDSGRP ALL' DBRC COMMAND TO
      'LIST.DBDSGRP GRPNAME(NAME)' WHEN SELECTED FROM THE
      MAINTAIN RECON PANEL, OPTION 3, DBRC COMMANDS SELECTABLE
      BY DBDSGRPS.
  3.  ADD AN ERROR MESSAGE TO THE DBCS STARTUP PROCESS TO
      INDICATE A DISPLAY FAILURE OF THE COPYRIGHT/INITIALIZATION
      PANEL.
  4.  CORRECT ERROR IN FAST PATH REORG JCL FOR WORK DATASET NAME.
  5.  ENHANCE THE MAINTAIN RECON FIND COMMAND CAPABILITIES WITHIN
      DBDSGRP DISPLAYS.
  6.  ENHANCE 'E' COMMAND FOR DBDSGRP DISPLAY INTERFACES WITH FIND
      COMMAND PROCESSING TO PERFORM A SEARCH WITHIN THAT
      SUB-LIST DISPLAY.
  

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:

  UK00309

Modules/Macros

• IDLC000  IDLC0001 IDLGNJCC IDLIJOB1 IDLRCDB9
  IDLRDISP IDLRI148 IDLRLIDB IDLRLOG2 IDLRMAIN IDLRMAI0 IDLUPDJL
  IDLZZ10
  

Fix information

• Fixed component name

  IMS DB CNTL SUI

• Fixed component ID

  5655F7600

Applicable component levels

• R310 PSY UK00309

     UP05/02/08 P F502

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.