Deprecated function in Db2 12
Certain features and capabilities that Db2 12 for z/OS supports are deprecated, which means that their use is not recommended. Although Db2 12 currently supports these capabilities, they might be removed eventually.
Tip: Avoid creating new dependencies that rely on deprecated features and capabilities, and develop plans to remove any dependencies on them. A deprecated feature is supported by Db2, but its use is no longer recommended, and it might become obsolete.
| 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, and use the NOT DETERMINISTIC and DETERMINISTIC attributes to control whether Db2 materializes or merges specific user-defined SQL table functions. | — |
| 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 |
| Receiving RACF PassTickets for authentication of RACF protected user IDs 1 |
Use one of the following alternatives to authenticate RACF protected user IDs:
|
— |
| 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 REPORTONLY 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 REPORTONLY, INDREFLIMIT, and OFFPOSLIMIT options | Use the DSNACCOX stored procedure to determine whether the object needs to be reorganized. | — |
| 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:
|
Use partition-by-growth (PBG UTS) or partition-by-range (PBR UTS) table spaces instead.FL 504 Applications that run at application compatibility level V12R1M504 or higher cannot create the following objects:
New simple table spaces cannot be created in any supported Db2 release. |
— |
| TRACSTR subsystem parameter | Use the default value NO. | Db2 13 |
Notes:
- Receiving RACF PassTickets for authentication of RACF protected user IDs is deprecated. This deprecation does not apply to RACF PassTickets in general or any other use for them in Db2 for z/OS.