PK67901: KCICTALR EXCEEDS MAXIMUM )SEL LEVEL OF 8, KD261SW1 RECORD-76

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• KCICTALR EXCEEDS MAXIMUM )SEL LEVEL OF 8, KD261SW1 RECORD-76
  
   KCICTALR ***************************************
  KCICTALR FATAL ERROR DETECTED, RC = 20
  KCICTALR FUNCTION: FTINCL KD261SJ5
  KCICTALR )SEL error
  KCICTALR Exceeds maximum )SEL level of 8, KD261SW1 record-76
  KCICTALR ***************************************
  KD261CB2 ***************************************
  KD261CB2 FATAL ERROR DETECTED, RC = 24
  KD261CB2 FUNCTION: UNKNOWN
  KD261CB2 ***************************************
  KCICSTMC ***************************************
  KCICSTMC FATAL ERROR DETECTED, RC = 24
  KCICSTMC FUNCTION: UNKNOWN
  KCICSTMC ***************************************
  
  
  Nested )SELECTs was not supported in z/OS 1.4 environment.
  

Local fix

• Please backup your rhilev.TKANCUS(KD261SW1) skel. and replace
  those lines below.
  
  From:
  000063 )SEL &D2PWSTGG ﾪ= &Z
  000064   GRANT USE OF STOGROUP &D2PWSTGG TO DB2PM;
  000065   COMMIT;
  000066 )SEL &D2PWBUFP ﾪ= &Z
  000067   GRANT USE OF BUFFERPOOL &D2PWBUFP TO DB2PM;
  000068 )SEL &D2PWOBUF ﾪ= &Z
  000069   GRANT USE OF BUFFERPOOL &D2PWOBUF TO DB2PM;
  000070 )SEL &D2PWCBUF ﾪ= &Z
  000071   GRANT USE OF BUFFERPOOL &D2PWCBUF TO DB2PM;
  000072 )SEL &D2PWROTG ﾪ= &Z
  000073   GRANT USE OF BUFFERPOOL &D2PWROTG TO DB2PM;
  000074 )SEL &D2PWACCP ﾪ= &Z
  000075   GRANT USE OF BUFFERPOOL &D2PWACCP TO DB2PM;
  000076 )SEL &D2PWIXBP ﾪ= &Z
  000077   GRANT USE OF BUFFERPOOL &D2PWIXBP TO DB2PM;
  000078 )ENDSEL
  000079 )ENDSEL
  000080 )ENDSEL
  000081 )ENDSEL
  000082 )ENDSEL
  000083 )ENDSEL
  000084 )ENDSEL
  000085 )SEL &D2PWOLBP ﾪ= &Z
  000086   GRANT USE OF BUFFERPOOL &D2PWOLBP TO DB2PM;
  000087 )SEL &D2PWQRYP ﾪ= &Z
  000088   GRANT USE OF BUFFERPOOL &D2PWQRYP TO DB2PM;
  000089 )ENDSEL
  000090 )ENDSEL
  000091    COMMIT;
  
  To:
  000063 )SEL &D2PWSTGG ﾪ= &Z
  000064   GRANT USE OF STOGROUP &D2PWSTGG TO DB2PM;
  000065   COMMIT;
  000066 )ENDSEL
  000067 )SEL &D2PWSTGG ﾪ= &Z && &D2PWBUFP ﾪ= &Z
  000068   GRANT USE OF BUFFERPOOL &D2PWBUFP TO DB2PM;
  000069 )ENDSEL
  000070 )SEL &D2PWSTGG ﾪ= &Z && &D2PWOBUF ﾪ= &Z
  000071   GRANT USE OF BUFFERPOOL &D2PWOBUF TO DB2PM;
  000072 )ENDSEL
  000073 )SEL &D2PWSTGG ﾪ= &Z && &D2PWCBUF ﾪ= &Z
  000074   GRANT USE OF BUFFERPOOL &D2PWCBUF TO DB2PM;
  000075 )ENDSEL
  000076 )SEL &D2PWSTGG ﾪ= &Z && &D2PWROTG ﾪ= &Z
  000077   GRANT USE OF BUFFERPOOL &D2PWROTG TO DB2PM;
  000078 )ENDSEL
  000079 )SEL &D2PWSTGG ﾪ= &Z && &D2PWACCP ﾪ= &Z
  000080   GRANT USE OF BUFFERPOOL &D2PWACCP TO DB2PM;
  000081 )ENDSEL
  000082 )SEL &D2PWSTGG ﾪ= &Z && &D2PWIXBP ﾪ= &Z
  000083   GRANT USE OF BUFFERPOOL &D2PWIXBP TO DB2PM;
  000084 )ENDSEL
  000085 )SEL &D2PWOLBP ﾪ= &Z
  000086   GRANT USE OF BUFFERPOOL &D2PWOLBP TO DB2PM;
  000087 )ENDSEL
  000088 )SEL &D2PWQRYP ﾪ= &Z
  000089   GRANT USE OF BUFFERPOOL &D2PWQRYP TO DB2PM;
  000090 )ENDSEL
  000091 )SEL &D2PWSTGG ﾪ= &Z | &D2PWOLBP ﾪ= &Z | &D2PWQRYP ﾪ= &Z
  000092    COMMIT;
  000093 )ENDSEL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   ICAT                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Exceeded the maximum level of        *
  *                       imbedded SEL statements in z/OS 1.4    *
  *                                                              *
  *                      2. Cloning of DB2 subsystem parameters  *
  *                      does not work.                          *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Exceeded the maximum level of
   imbedded SEL statements in z/OS 1.4
  
  2. Cloning of DB2 subsystem parameters
  does not work.
  
  PROBLEM CONCLUSION:
  1. Reduce the number of imbedded SEL statements.
  2. Fix cloning function.
  

Problem conclusion

• 1. Reduce the number of imbedded SEL statements.
  2. Fix cloning function.
  
  KEYWORDS : Z/OS1.4 ICAT
  

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:

  UK38879

Modules/Macros

• KD261CB1 KD261PW  KD261SW1
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK38879

     UP08/08/15 P F808

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.