A fix is available
APAR status
Closed as new function.
Error description
Subsystem parameter to enable index in-memory optimization (FTB) for non-unique indexes - DB2FTB/K
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users. * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR adds a new Db2 subsystem * * parameter in DSN6SPRM called * * FTB_NON_UNIQUE_INDEX that specifies * * whether fast index traversal for * * non-unique indexes is enabled. * **************************************************************** * RECOMMENDATION: * **************************************************************** This PTF adds a new Db2 subsystem parameter in DSN6SPRM called FTB_NON_UNIQUE_INDEX that specifies whether fast index traversal for non-unique indexes is enabled. Valid options are: - NO : Fast index traversal for non-unique indexes is disabled. ====> This is the default setting - YES : Fast index traversal for non-unique indexes is enabled.
Problem conclusion
Temporary fix
Comments
This PTF adds a new Db2 subsystem parameter in DSN6SPRM called FTB_NON_UNIQUE_INDEX that specifies whether fast index traversal for non-unique indexes is enabled. Valid options are: - NO : Fast index traversal for non-unique indexes is disabled. ====> This is the default setting - YES : Fast index traversal for non-unique indexes is enabled.
APAR Information
APAR number
PH30978
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-10-27
Closed date
2021-06-01
Last modified date
2022-09-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI75643
Modules/Macros
DSNTINMF DSNDQWPZ DSNTIP71 DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ DSNTINST DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNTIWIE DSNTIVIE DSN@XAZP DSN6SPRM DSNTXAZP DSNTIWPC DSNDSPRM DSN6SPRC DSNTIVMN DSNTIWMN DSNTIVAF DSNTIVIN DSNTIWMS DSNTIVMS DSNTIWAF DSNTIWIN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI75643
UP21/06/09 P F106
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 September 2022