Function that Db2 11 no longer supports
If you are migrating to Db2 11 from Db2 10, be aware of function that is no longer supported.
The following function is not supported in Db2 11.
Password protection for active log and archive log data sets
In Db2 11, password protection for active log and archive log data sets is no longer supported.
Previous NEWFUN values
In Db2 11, DSNHDECP no longer supports values of NEWFUN=V8 or NEWFUN=V9.
Some supplied routines
The following supplied routines are removed in Db2 11 and are unavailable to callers after migration to conversion mode. A report is added to the DSNTIJPM premigration job to detect occurrences of these routines on an existing subsystem or data sharing group, and to specify that these routines are not available in Db2 11.
- SYSPROC.DSNAEXP
- AMI-based Db2 MQ functions
- DB2MQ1C.GETCOL
- DB2MQ1C.MQPUBLISH
- DB2MQ1C.MQREAD
- DB2MQ1C.MQREADALL
- DB2MQ1C.MQREADALLCLOB
- DB2MQ1C.MQREADCLOB
- DB2MQ1C.MQRECEIVE
- DB2MQ1C.MQRECEIVEALL
- DB2MQ1C.MQRECEIVEALLCLOB
- DB2MQ1C.MQRECEIVECLOB
- DB2MQ1C.MQSEND
- DB2MQ1C.MQSUBSCRIBE
- DB2MQ1C.MQUNSUBSCRIBE
- DB2MQ2C.GETCOL
- DB2MQ2C.MQPUBLISH
- DB2MQ2C.MQREAD
- DB2MQ2C.MQREADALL
- DB2MQ2C.MQREADALLCLOB
- DB2MQ2C.MQREADCLOB
- DB2MQ2C.MQRECEIVE
- DB2MQ2C.MQRECEIVEALL
- DB2MQ2C.MQRECEIVEALLCLOB
- DB2MQ2C.MQRECEIVECLOB
- DB2MQ2C.MQSEND
- DB2MQ2C.MQSUBSCRIBE
- DB2MQ2C.MQUNSUBSCRIBE
- DB2MQ1N.GETCOL
- DB2MQ1N.MQPUBLISH
- DB2MQ1N.MQREAD
- DB2MQ1N.MQREADALL
- DB2MQ1N.MQREADALLCLOB
- DB2MQ1N.MQREADCLOB
- DB2MQ1N.MQRECEIVE
- DB2MQ1N.MQRECEIVEALL
- DB2MQ1N.MQRECEIVEALLCLOB
- DB2MQ1N.MQRECEIVECLOB
- DB2MQ1N.MQSEND
- DB2MQ1N.MQSUBSCRIBE
- DB2MQ1N.MQUNSUBSCRIBE
- DB2MQ2N.GETCOL
- DB2MQ2N.MQPUBLISH
- DB2MQ2N.MQREAD
- DB2MQ2N.MQREADALL
- DB2MQ2N.MQREADALLCLOB
- DB2MQ2N.MQREADCLOB
- DB2MQ2N.MQRECEIVE
- DB2MQ2N.MQRECEIVEALL
- DB2MQ2N.MQRECEIVEALLCLOB
- DB2MQ2N.MQRECEIVECLOB
- DB2MQ2N.MQSEND
- DB2MQ2N.MQSUBSCRIBE
- DB2MQ2N.MQUNSUBSCRIBE
Some subsystem parameters
The following subsystem parameters are removed in Db2 11:
- ASSIST
- COORDNTR
- DISABSCL
- DISALLOW_DEFAULT_COLLID
- MSVGP
- MSVGP2
- OJPERFEH
- OPTIOPIN
- OPTIOWGT
- OPTIXIO
- PGRNGSCR
- PTCDIO
- RETVLCFK
- SEQCACH
- SEQPRES
- SMSDCFL
- SMSDCIX
- STATCLUS
An application programming default value
The following application programming default value is removed in Db2 11:
- CHARSET
BIND PACKAGE options ENABLE and DISABLE (REMOTE) REMOTE (location-name,…,<luname>,…)
In Db2 11, you cannot use the BIND PACKAGE options ENABLE and DISABLE (REMOTE) REMOTE (location-name,…,<luname>,…) to enable or disable specific remote connections. You can use the ENABLE(REMOTE) or DISABLE(REMOTE) options to enable or disable all remote connections.
Sysplex query parallelism
In Db2 11, Sysplex query parallelism is no longer supported. Packages that used Sysplex query parallelism in releases before Db2 11 use CPU parallelism in Db2 11.
DSN1CHKR utility
In Db2 11, the DSN1CHKR utility is no longer supported. The DSN1810I and DSN1816I messages are issued when the DSN1CHKR utility is invoked.