Deprecated function in Db2 12

Certain 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 function, and develop plans to remove any dependencies on such function.

Table 1. Deprecated functions in Db2 12
Deprecated function Recommended alternative Support removed
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:
  • LOAD REPLACE with the ROWFORMAT RRF option, or LOAD REPLACE without the ROWFORMAT option. The ROWFORMAT option is deprecated and will be removed eventually.
  • REORG TABLESPACE with the ROWFORMAT RRF option, or REORG TABLESPACE without the ROWFORMAT option. The ROWFORMAT option is deprecated and will be removed eventually.
BIND PLAN command MEMBER option Use BIND PACKAGE commands to bind DBRMs into packages explicitly.
COPY utility CHANGELIMIT option Use the DSNACCOX stored procedure to determine if the object needs to be copied.
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.
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.
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.
NEWFUN SQL processing option Use SQLLEVEL. NEWFUN is ignored if SQLLEVEL is specified.
ODBC 2.0 function See Deprecated ODBC functions.
PassTickets for RACF-protected user IDs. Use client certificate authentication.
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 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.
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.
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 APPLCOPMAT( V12R1M504) or higher cannot create objects of the following types:
  • New partitioned (non-UTS) table spaces
  • New segmented (non-UTS) table spaces
  • New tables in existing segmented (non-UTS) table spaces
  • New tables in existing simple table spaces

You cannot create new simple table spaces in any supported Db2 release.

TEMP database Db2 uses the work file database instead.
V10R1 application compatibility. Rebind at application compatibility level V11R1 or higher.