Deprecated function in Db2 11
Certain capabilities that Db2 11 for z/OS® supports are deprecated, meaning that their use is discouraged. Although they remain supported except as noted below in Db2 11, support is likely to be removed eventually.
Avoid creating new dependencies that rely on deprecated function, and develop plans to remove any dependencies on such function.
| Deprecated function | Recommended alternative | Support removed |
|---|---|---|
| 6-byte RBA and LRSN format for the BSDS | Convert the BSDS to use the extended 10-byte RBA and LRSN formats. The BSDS conversion must be completed before migration to Db2 12. | Db2 12 |
| ALCUNIT subsystem parameter | Set ALCUNIT to CYL. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| Basic row format table spaces | Use reordered row format. Starting in Db2 12, any table space that uses basic row format is automatically converted to reordered row format when you run one of the following utilities:
|
— |
| BIND PLAN command MEMBER option | Use BIND PACKAGE commands to bind DBRMs into packages explicitly. | — |
| CACHEDYN_FREELOCAL subsystem parameter | Set the value to 0. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| CACHE_DEP_TRACK_STOR_LIM subsystem parameter | Starting in Db2 12, storage is allocated from the SCB pool. | Db2 12 |
| COPY utility CHANGELIMIT option | Use the DSNACCOX stored procedure to determine if the object needs to be copied. | — |
| CATALOG (in DSN6ARVP) subsystem parameter | Set CATALOG (in DSN6ARVP) to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| CHECK_SETCHKP subsystem parameter | Set CHECK_SETCHKP to NO. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| COMPRESS_SPT01 subsystem parameter | Set COMPRESS_SPT01 to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| CONTSTOR subsystem parameter | Set CONTSTOR to NO. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| DB2SORT subsystem parameter | Set DB2SORT to ENABLE. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| DISALLOW_SEL_INTO_UNION subsystem parameter. | Modify applications to remove any use of UNION or UNION ALL as the outermost from-clause of a SELECT INTO statement. Then set DISALLOW_SEL_INTO_UNION to YES. | — |
| SYSPROC.DSNACCOR stored procedure | Use the SYSPROC.DSNACCOX stored procedure. | V12R1M504 |
| DSNRLMTxx table format from before Db2 11 | Use the current format for resource limit facility (RLF) tables. See Convert RLF tables to the current format. | — |
| DSNRLSTxx table format from before DB2® Version 8 | Use the current format for resource limit facility (RLF) tables. See Convert RLF tables to the current format. | Db2 12 |
| SYSPROC.DSNTBIND stored procedure | Use the SYSPROC.ADMIN_COMMAND_DSN stored procedure. | — |
| SYSPROC.DSNUTILS stored procedure | Use the SYSPROC.DSNUTILU stored procedure. | — |
| DSNTPSMP SQL procedure processor | The SQL procedure processor, DSNTPSMP, is one of several methods that you can use to create and prepare an external SQL procedure, which are also deprecated. | — |
| SYSPROC.DSNWZP | Use the SYSPROC.ADMIN_INFO_SYSPARM stored procedure. | — |
| EDMPOOL subsystem parameter | Starting in Db2 12, all EDM storage is above the bar. | Db2 12 |
| External SQL procedures | Use native SQL procedures, which are more fully supported, easier to maintain, and typically perform better that external SQL procedures. For more information, see Migrating an external SQL procedure to a native SQL procedure | — |
| Hash-organized tables | Alter tables to drop hash organization, and , create indexes to support fast index traversal in Db2 12. | Beginning in Db2 12 with application compatibility level V12R1M504, Db2 no longer supports creating hash-organized tables or altering tables to use hash-organization. Existing hash organized tables remain supported. However, that support is likely to be removed in the future. |
| IFCID 0366 | Use IFCID 0376. | Db2 12 |
| INDEX_IO_PARALLELISM subsystem parameter | Set INDEX_IO_PARALLELISM to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| LEMAX subsystem parameter | Starting in Db2 11, the LEMAX value is not used. | Db2 12 |
| LOAD utility IDENTITYOVERRIDE option | Use the OVERRIDE(IDENTITY) option. | — |
| LOAD utility PERIODOVERRIDE option | Use the OVERRIDE(SYSTEMPERIOD) option. | — |
| LOAD utility TRANSIDOVERRIDE option | Use the OVERRIDE(TRANSID) option. | — |
| LOBVALA subsystem parameter | Use the default value. Starting in Db2 12, the database manager automatically determines the amount of storage for processing LOB values. | Db2 12 |
| LOBVALS subsystem parameter | Use the default value. Starting in Db2 12, the database manager automatically determines the amount of storage for processing LOB values. | Db2 12 |
| MATERIALIZE_NODET_SQLTUDF subsystem parameter | Set MATERIALIZE_NODET_SQLTUDF to YES. Later Db2 releases always use the behavior of this setting. | — |
| MINSTOR subsystem parameter | Set MINSTOR to NO. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| NEWFUN dsnhdecp parameter | Use NEWFUN=Vnn instead of YES or NO
values. Starting in Db2 12, use SQLLEVEL. |
Db2 12 |
| NEWFUN SQL processing option | Use NEWFUN(nn) instead of YES or NO
values. Starting in Db2 12, use SQLLEVEL. NEWFUN is ignored if SQLLEVEL is specified. |
— |
| OBJECT_CREATE_FORMAT subsystem parameter. | Set this subsystem parameter value to NOBASIC before migrating to Db2 12. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| ODBC 2.0 function | See Deprecated ODBC functions. | — |
| REORG_IGNORE_FREESPACE subsystem parameter | Set REORG_IGNORE_FREESPACE to NO. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| REORG INDEX utility LAEFDISTLIMIT and REPORT only options | Use the DSNACCOX stored procedure to determine whether the object needs to be reorganized | — |
| REORG INDEX utility UNLOAD ONLY option | Use the UNLOAD utility. | — |
| REORG INDEX utility UNLOAD PAUSE option | Use the DIAGNOSE utility to stop the process. | — |
| REORG TABLESPACE utility UNLOAD EXTERNAL option | Use the UNLOAD utility. | — |
| REORG TABLESPACE utility INDREFLIMIT and REPORTONLY options | Use the DSNACCOX stored procedure to determine whether the object needs to be reorganized. | — |
| REORG TABLESPACE utility OFFPOSLIMIT and REPORTONLY options | Use the DSNACCOX stored procedure to determine whether the object needs to be reorganized. | — |
| REORG TABLESPACE utility PARALLEL option | Use the LISTPARTS option instead. | — |
| REORG TABLESPACE utility UNLOAD ONLY option | Use the UNLOAD utility. | — |
| REORG TABLESPACE utility UNLOAD PAUSE option | Use the UNLOAD utility FORMAT INTERNAL option. | — |
| RBALRSN_CONVERSION keyword of the LOAD, REORG, and REBUILD INDEX utilities |
Starting in Db2 12, utilities that specify RBALRSN_CONVERSION(BASIC) always fail. If the target objects is in the 6-byte page format, utilities that specify RBALRSN_CONVERSION(NONE) also fail. |
Db2 12 |
| REPAIR VERSIONS utility | Use the REPAIR CATALOG utility. | — |
| RRF subsystem parameter | Set RRF to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| SPT01_INLINE_LENGTH subsystem parameter | Set SPT01_INLINE_LENGTH to 32138.Later Db2 releases always use the behavior of this setting. | Db2 12 |
| DB2XML.SOAPHTTPC supplied user-defined function | Use the DB2XML.SOAPHTTPNC user-defined function. | — |
| DB2XML.SOAPHTTPV supplied user-defined function | Use the DB2XML.SOAPHTTPNV user-defined function. | — |
| SQWIDSC subsystem parameter | Set SQWIDSC to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| Synonyms | Use aliases when writing new SQL statements or creating portable applications. Aliases behave the same for the Db2 family of products. | — |
| SYSIBM.SYSROUTINES_OPTS catalog table | This catalog table supports the DSNTPSMP SQL procedure processor for creating and preparing external SQL procedures, which are also deprecated. | — |
| SYSIBM.SYSROUTINES_SRC catalog table | This catalog table supports the DSNTPSMP SQL procedure processor for creating and preparing external SQL procedures, which are also deprecated. | — |
| Non-UTS table spaces for base tables, including segmented (non-UTS), partitioned (non-UTS), and simple table spaces. | Use partition-by-growth or partition-by-range universal table spaces instead.
In Db2 12, Packages bound with APPLCOPMAT(
V12R1M504) or higher cannot create objects of the following types:
You cannot create new simple table spaces in any supported Db2 release. |
— |
| TEMP database | Db2 uses the work file database instead. | — |
| UTILITY_OBJECT_CONVERSION subsystem parameter | Set UTILITY_OBJECT_CONVERSION to EXTENDED before migrating to Db2 12. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| UTSORTAL subsystem parameter | Set UTSORTAL to YES. Later Db2 releases always use the behavior of this setting. | Db2 12 |
| XMLVALA subsystem parameter | Use the default value. In Db2 12, the database manager automatically determines the amount of storage for processing XML values. | Db2 12 |
| XMLVALS subsystem parameter | Use the default value. In Db2 12, the database manager automatically determines the amount of storage for processing XML values. | Db2 12 |