PI43628: SQLCODEN4743 AFTER DB2 11 NFM APPLCOMPAT VALUE = V10R1 IS USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS may issue SQLCODEN4743 SQLCODE
  -4743 after DB2 11 for z/OS mode NF and APPLCOMPAT value = V10R1
  in ZPARM or in SYSIBM.SYSPACKAGE column.
  .
  DSNT408I SQLCODE = -4743, ERROR:  ATTEMPT TO USE A FUNCTION WHEN
  THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS
  LEVEL
  

Local fix

• Add APPLCOMPAT option with value V11R1 to the packages in
  ADBBIND job manually and submit it.
  Additional Information:
  Fix for AOC 11.2 is APAR PI48724 / PTF UI32239.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The zPARM APPLCOMPAT(V11R1) parameter   *
  *                      is not generated in the BIND package    *
  *                      statements from the bind jobs when      *
  *                      using DB2 11 New Function Mode          *
  *                      (NFM), which may result in a            *
  *                      SQLCODE=-4743 / SQLCODEN4743            *
  *                      when running a Work Statement List      *
  *                      (WSL) if zPARM APPLCOMPAT is set to     *
  *                      V10R1:                                  *
  *                                                              *
  *                      DSNT408I SQLCODE = -4743, ERROR:        *
  *                      ATTEMPT TO USE A FUNCTION WHEN          *
  *                      THE APPLICATION COMPATIBILITY           *
  *                      SETTING IS SET FOR A PREVIOUS LEVEL     *
  *                      DSNT418I SQLSTATE   = 56038             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The zPARM APPLCOMPAT(V11R1) parameter is not generated in the
  BIND package statements from the bind jobs when using DB2 11
  New Function Mode (NFM), which may result in a SQLCODE=-4743 /
  SQLCODEN4743 when running a Work Statement List (WSL) if zPARM
  APPLCOMPAT is set to V10R1.
  

Problem conclusion

• The APPLCOMPAT(V11R1) parameter is added into the bind package
  statements if DB2 11 NFM is used.
  

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:

  UI30634

Modules/Macros

•    ADBBIND  ADBCFGBD ADBCUST  ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI30634

     UP15/08/29 P F508

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.