APPL COMPAT LEVEL field (APPLCOMPAT subsystem parameter)

The APPLCOMPAT subsystem parameter specifies the default value to use when the APPLCOMPAT bind option is not specified in a BIND command, or the APPLCOMPAT value is not specified or stored in the Db2 catalog for a REBIND command. Its value does not prevent specific applications from running at higher application compatibility levels.

Tip: Do not raise the default application compatibility level of the Db2 subsystem immediately after migrating or activating a new function level. Instead, wait until applications have been verified to work correctly at the higher function level, and any incompatibilities have been resolved. For details, see Specifying the default application compatibility level.
Tip: Set all Db2 data sharing members to the same value.
Acceptable values: function-level, function-level, V10R1
Default:
  • Installation: V13R1M501
  • z/OSMF migration: V13R1M501
  • Migration: value specified in the CLIST migration input member of the Db2 subsystem or first member of the data sharing group;
Update: option 5 on panel DSNTIPB
DSNZPxxx: DSN6SPRM.APPLCOMPAT

The following values can be used to specify the default APPLCOMPAT bind option value for package binds and rebinds:

Start of changeV13R1M5nnEnd of change
Start of changeCompatibility with the behavior of the identified Db2 13 function level. For example, V13R1M508 specifies compatibility with the highest available Db2 13 function level. The equivalent function level or higher must be activated.

Start of changeFor information about the new capabilities that become available in each application compatibility level, see V13R1Mnnn application compatibility levels.End of change

End of change
V12R1M5nn

Compatibility with the behavior of the identified Db2 12 function level.

Start of changeFor information about the new capabilities that become available in each application compatibility level, see V12R1Mnnn application compatibility levels.End of change

Tip: Start of changeExtra program preparation steps might be required to increase the application compatibility level for applications that use data server clients or drivers to access Db2 for z/OS®. For more information, see Setting application compatibility levels for data server clients and drivers.End of change
V12R1
Compatibility with the behavior of Db2 12 function level 500. This value has the same result as specifying V12R1M500.
V11R1
Compatibility with the behavior of Db2 11 new-function mode.
V10R1
Compatibility with the behavior of DB2® 10 new-function mode. For more information, see V10R1 application compatibility level.

z/OSMF migration

The APPL COMPAT LEVEL field value is always selected as a z/OSMF variable. The setting indicates the target application compatibility level for Db2 after the migration process completes.