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.

Table 1. Deprecated functions in Db2 11
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:
  • 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. —
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:
  • 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. —
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