LOADPLUS for DB2: SQLCODE=-4743. BMC50653E PACKAGE AMU1310 .AMUECAT IS NOT USEABLE.

Knowledge Article

LOADPLUS for DB2: SQLCODE=-4743. BMC50653E PACKAGE AMU1310 .AMUECAT IS NOT USEABLE.
LOADPLUS Dynamic Bind fails with an SQLCODE=-4743 ATTEMPT TO USE NEW FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL due to an incompatible Db2 ZPARM APPLCOMPAT level.
LOADPLUS for DB2
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 7. PROCESSED BIND RETURN CODE<8>
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8. DSNX200I -ssid BIND SQL ERROR
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      USING sysadm AUTHORITY
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      PLAN=(NOT APPLICABLE)
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      DBRM=AMUECAT
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      STATEMENT=5757
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      SQLCODE=-4743
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      SQLSTATE=56038
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      TOKENS=
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      CSECT NAME=DSNHSM2V
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      RDS CODE=37
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8. DSNT233I -ssid UNSUCCESSFUL BIND FOR
 BMC50652I DYNAMIC BIND API HAS RETURNED RC = 8, REAS = 8.      PACKAGE = DSNB.AMU1310.AMUECAT.(AMU_1310_BQU5182)
 BMC50654I BIND OF PACKAGE AMU1310 .AMUECAT COMPLETED UNSUCCESSFULLY
 BMC50653E PACKAGE AMU1310 .AMUECAT IS NOT USEABLE. IF IT HAS BEEN BOUND SUCCESSFULLY, CHECK BIND OF PLAN AMU1310 
 BMC50013I UTILITY EXECUTION TERMINATING, RETURN CODE = 8

This is caused by the Db2 ZPARM APPLCOMPAT level and occurs when the APPLCOMPAT in the DSNZPARM does not support a function being used. This can occur because LOADPLUS for Db2 uses (BMC) Dynamic Binds for all of its packages, and the APPLCOMAT will default to the value of the ZPARM APPLCOMPAT that existed at the time the packages were bound. Dynamic Bind does not currently support (and there are no plans to change this) overriding the APPLCOMPAT level. 
This can occur when using an old APPLCOMPAT level (e.g. V10R1) with a newer version of Db2 (V12R1M500).
If this occurs, BMC recommends the following procedure to correct the issue: 
 
1)  Change the DSNZPARM APPLCOMAT for the Db2 subsystem to an appropriate level (or higher) for the SQL that is being executed. 
2)  Free all of the packages for LOADPLUS for Db2.
3)  Run the IVP or LOADPLUS job again. LOADPLUS for Db2 will dynamically bind the packages using the APPLCOMPAT from DSNZPARM. 
4)  Set DSNZPARM back to the previous level. 
LOADPLUS for DB2
LOADPLUS for DB2
Attachment(s):