OA28794: Z/OS TEMS FAILS AFTER QUERY TO O4SRV.TACTSTSC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RKANDATV members KIBATR and KIBCAT each contain entries for
  O4SRV.TACTSTSC but ICAT does not create a data set for QA1CACTS.
  
  The result is that a query to the O4SRV.TACTSTSC table causes
  the TEMS to shut itself down.
  
  Recreation steps:
  
  1. Create RKANSQLU member SHUTTEST containing
  
   SELECT     ACTIVITYID,
              ACTIVITYTP,
              ENDCODE   ,
              LCLTMSTMP ,
              ORIGINKEY ,
              POLICYNAME,
              POLICYNODE,
              RECORDVER ,
              RESERVED  ,
              RESULTS
     FROM O4SRV.TACTSTSC;
  
  2. Run the SQL
  
     F temsname,CTDS START SPUFIL SHUTTEST
  
     RKLVLOG shows:
  
     KLVVS001 OPEN FAILED FOR VSAM ACB: R15(8) ACBERFLG(00000080)
     KLVOP023 SHUTDOWN STARTED BY *MASTER* AT SYS-CONS
  
  Approver: Mike Stevens
  

Local fix

• None available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All TEMS users.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running queries against the             *
  *                      O4SRV.TACTSTSC table causes the TEMS to *
  *                      shut itself down on z/OS.               *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  The shut down happens because the table is no longer created
  and stale entries for the table remain in the KIB.CAT and
  KIB.ATR files. TEMS shuts itself down if a query is run
  against a table that is defined in KIB.CAT and KIB.ATR but
  that table does not exist.
  

Problem conclusion

• References to O4SRV.TACTSTSC were removed from the TEMS.
  

Temporary fix

Comments

APAR Information

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

  OA26307

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

Modules/Macros

• KIBATR   KIBCAT   KMSIOBJ
  

Fix information

• Fixed component name

  MGMT SERVER DS

• Fixed component ID

  5608A2800

Applicable component levels

• R620 PSY UA47229

     UP09/05/27 P F905

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.