Deprecated function in Db2 12
Certain features and capabilities that Db2 12 for z/OS® supports are deprecated, meaning that their use is discouraged. Although they remain supported except as noted below in Db2 12, support is likely to be removed eventually.
Avoid creating new dependencies that rely on deprecated features and capabilities, and develop plans to remove any dependencies on them.
| Deprecated function | Recommended alternative | Support removed |
|---|---|---|
| AUTHCACH subsystem parameter | Use the default value. | Db2 13 |
| 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. | — |
| CMTSTAT subsystem parameter | Set the CMTSTAT value to INACTIVE. Although, the ACTIVE setting can sometimes provide limited CPU performance advantages, they are generally outweighed by increased use of other system resources and the lack of scalability for distributed application workloads. For the recommended alternatives to the ACTIVE setting, see Enabling KEEPDYNAMIC refresh for DBATs and Enabling high-performance DBATs. | — |
| COPY utility CHANGELIMIT option | Use the DSNACCOX stored procedure to determine if the object needs to be copied. | — |
| CHECK_FASTREPLICATION subsystem parameter | Use the default value REQUIRED. | — |
| DDF_COMPATIBILITY subsystem parameter | Use the default value NULL. | Db2 13 |
| DEPLOY option of the BIND PACKAGE command | Deploy native SQL procedures and compiled SQL scalar functions to multiple environments by issuing the same CREATE or ALTER statements separately in each Db2 environment. | — |
| 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. | — |
| 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. | — |
| 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. | — |
| DSVCI subsystem parameter | Use the default value YES. | Db2 13 |
| EXTRAREQ subsystem parameter | Use the default value 100. | Db2 13 |
| EXTRASERV subsystem parameter | Use the default value 100. | Db2 13 |
| 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 or higher. For more information, see Fast index traversal. | 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. |
| HONOR_KEEPDICTIONARY subsystem parameter | Use the default value NO. | Db2 13 |
| IMMEDWRI subsystem parameter | Use the default value NO. | Db2 13 |
| 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. | — |
| MATERIALIZE_NODET_SQLTUDF subsystem parameter | Set MATERIALIZE_NODET_SQLTUDF to YES. Later Db2 releases always use the behavior of this setting. | — |
| MAXARCH subsystem parameter | Use the default value 10000. | Db2 13 |
| MAXTYPE1 subsystem parameter | Use the default value 100. | Db2 13 |
| NEWFUN SQL processing option | Use SQLLEVEL. NEWFUN is ignored if SQLLEVEL is specified. | — |
| ODBC 2.0 function | See Deprecated ODBC functions. | — |
| OPT1ROWBLOCKSORT subsystem parameter | Use the default value DISABLE. | Db2 13 |
| PARA_EFF subsystem parameter | Use the default value 50. | Db2 13 |
| PassTickets for RACF-protected user IDs. | Use client certificate authentication. | — |
| PLANMGMTSCOPE subsystem parameter | Use the default value STATIC. | Db2 13 |
| PREVENT_NEW_IXCTRL_PART subsystem parameter | Use the default value YES. | — |
| REORG INDEX utility LEAFDISTLIMIT 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 UNLOAD ONLY option | Use the UNLOAD utility. | — |
| REORG TABLESPACE utility UNLOAD PAUSE option | Use the UNLOAD utility FORMAT INTERNAL option. | — |
| RESYNC subsystem parameter | Use the default value 2. | Db2 13 |
| RBALRSN_CONVERSION keyword of the LOAD, REORG, and REBUILD INDEX utilities |
Starting in Db2 12 with APAR PH26317, utilities that specify RBALRSN_CONVERSION(BASIC) always fail. If the target object is in the 6-byte page format, utilities also fail if they specify RBALRSN_CONVERSION(NONE) |
Db2 12 |
| REPAIR VERSIONS utility | Use the REPAIR CATALOG utility. | — |
| SNA communication methods, including the VTAM interface | Use TCP/IP communication only. You can disable SNA communication by specifying a value in the DB2 TCP/IP IPNAME field on panel DSNTIPR. | — |
| 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. | — |
| SUBQ_MIDX subsystem parameter | Use the default value ENABLE. | Db2 13 |
| 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. FL 504 In Db2 12, Packages bound with APPLCOMPAT( V12R1M504) or higher cannot create objects of the following types:
You cannot create new simple table spaces in any supported Db2 release. |
— |
| TRACSTR subsystem parameter | Use the default value NO. | Db2 13 |