PI16183: A STATIC SQL STATEMENT SHOULD BE IN THE OUTPUT OF AN IFI READS OF IFCID401 BUT IT IS NOT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A static statement should be in the output of IFCID 401, but it
  is not. This static statement is in the SMF data.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 IFI READS users.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: IFCID 401 may not be returned on an IFI *
  *                      READS call.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The IFCID 401 record contains information about static
  applications in the EDM pool. Sometimes the READS of
  IFCID 401 does not return information about all
  static applications in the EDM pool.
  

Problem conclusion

• An error in internal logic can cause DB2 to not return
  information about all static applications that are in the EDM
  pool. The logic has been corrected.
  

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:

  UI18350 UI18352

Modules/Macros

• DSNGEPLC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI18350

     UP14/06/11 P F406

• RB10 PSY UI18352

     UP14/06/11 P F406

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.