PH38355: MISSING SQL TEXT FOR SQL TYPE "CLOSE ALLOC CURSOR" EVENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Missing SQL text for sql type "CLOSE ALLOC CURSOR" events
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Security Guardium S-TAP for     *
  *                 Db2 on z/OS                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Missing SQL text for sql type "CLOSE    *
  *                      ALLOC CURSOR" events                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Missing SQL text for sql type "CLOSE ALLOC CURSOR" events.
  

Problem conclusion

• Some OPEN CURSOR events may be reported in the Guardium
  appliance as "DB2_COMMAND UNKNOWN UNKNOWN" The original event is
  an OPEN CURSOR. The cause of the problem is the SQL Text was not
  being captured for the OPEN CURSOR. The missing SQL Text is now
  being captured and the event is now being reported correctly in
  the Guardium appliance.
  

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:

Modules/Macros

• ADH#BCMZ ADH#INIZ ADHBFILT ADHEDML1 ADHGEDML ADHGUARZ ADHMFILT
  ADHMINIZ ADHMKMSG
  

Fix information

• Fixed component name

  SEC GUAR STAP D

• Fixed component ID

  5655STP00

Applicable component levels

• RA13 PSY UI76188

     UP21/07/10 P F107

• RB30 PSY UI76189

     UP21/07/10 P F107

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.