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.