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 Enabling default application compatibility with function level 500 or higher.
Tip: Set all Db2 data sharing members to the same value.
Acceptable values: Start of changefunction-level, V11R1, V10R1End of change
Default: Start of changeV11R1 or V10R1, as specified in the CLIST migration input member of the Db2 subsystem or first member of the data sharing group; V12R1M500 for installationEnd of change
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 changeVvvRrMmmmEnd of change
Start of change

Compatibility with the behavior of the identified Db2 function level. For example, V12R1M510 specifies compatibility with the highest available Db2 12 function level. The equivalent function level or higher must be activated.

Start of changeFor the new capabilities that become available in each application compatibility level, see: 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
End of change
Start of changeV12R1End of change
Start of changeCompatibility with the behavior of Db2 12 function level 500. This value has the same result as specifying V12R1M500.End of change
V11R1
Compatibility with the behavior of Db2 11 new-function mode. After migration to Db2 12, this value has the same result as specifying V12R1M100. For more information, see V11R1 application compatibility level
V10R1
Compatibility with the behavior of DB2® 10 new-function mode. For more information, see V10R1 application compatibility level.
Start of change

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.

End of change