A fix is available
APAR status
Closed as program error.
Error description
DB2 PLAN_TABLE created by FM/DB2 V13 option 4.5.C (EXPLAIN utility - clist FMN2PSX2) has missing columns; SCAN_DIRECTION and EXPANSION_REASO - added by DB2 V11 PER_STMT_ID - added by DB2 V12
Local fix
Create PLAN_TABLE manually
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 * * component. * **************************************************************** * PROBLEM DESCRIPTION: In File Manager DB2 component, the * * Explain utilities create tables without * * certain columns added at DB2 versions * * 11 and 12. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The table definitions for PLAN_TABLE, DSN_STATEMNT_TABLE and DSN_FUNCTION_TABLE have not been updated for DB2 version 11 and 12.
Problem conclusion
File Manager DB2 component has been updated so that all columns appropriate for DB2 versions 8-12 will be included when the explain utility is used to create the following user tables: 1. PLAN_TABLE 2. DSN_FUNCTION_TABLE 3. DSN_STATEMNT_TABLE
Temporary fix
Comments
APAR Information
APAR number
PI89650
Reported component name
FILE MANAGER Z/
Reported component ID
5655Q1200
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-01
Closed date
2018-03-05
Last modified date
2020-03-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN0AMS FMN0BKG FMN0LVL FMN0LVLJ FMN0LVLK FMN0MASK FMN0MSG FMN0PR2 FMN0PRT FMN0SAF FMN0SETP FMN0WILD FMN1ABXT FMN1AGNS FMN1BDT FMN1BREX FMN1BSSA FMN1DBD FMN1DBI FMN1DBIB FMN1DBRI FMN1DDD FMN1DDDC FMN1DDSS FMN1DIR FMN1DLI FMN1ECMD FMN1EDIF FMN1EGHL FMN1ETOS FMN1FIND FMN1GSEG FMN1HIER FMN1IC FMN1ICR FMN1IE FMN1IEB FMN1IEBO FMN1II FMN1IL FMN1ILB FMN1IMSI FMN1INIT FMN1IPR FMN1IPRO FMN1ISPF FMN1ISRT FMN1ISS FMN1IT FMN1IV FMN1IX FMN1IXB FMN1IXR FMN1KEY FMN1LOCL FMN1LVL FMN1MAIN FMN1NOXP FMN1OBJS FMN1OCCN FMN1PCBS FMN1POSN FMN1PSB FMN1RALL FMN1RASG FMN1RMDT FMN1RSGT FMN1SECI FMN1SSID FMN1SSTA FMN1SXX FMN1TERM FMN1TREX FMN1VLDB FMN1VLDO FMN1VLDT FMN1XDBD FMN1XDBT FMN1XDDA FMN1XDDS FMN1XPCB FMN1XPCN FMN1XPOS FMN2A2IO FMN2ABUF FMN2ABXT FMN2ACNM FMN2AD32 FMN2AJSQ FMN2ASQD FMN2ATXT FMN2AUDI FMN2BCNL FMN2BCTQ FMN2BDBQ FMN2BNCL FMN2BONM FMN2BSQL FMN2BUCL FMN2BUTQ FMN2BWHC FMN2C2IO FMN2CATQ FMN2CD2V FMN2CF2B FMN2CGM2 FMN2CHKI FMN2CKCN FMN2CNVR FMN2CPYB FMN2CSQI FMN2CTM1 FMN2CTM2 FMN2CTMP FMN2CTQ2 FMN2D2C FMN2D2E FMN2D2EC FMN2D2EE FMN2D2EG FMN2D2EI FMN2D2EL FMN2D2ES FMN2D2EX FMN2D2G FMN2D2I8 FMN2D2IO FMN2D2JO FMN2D2L FMN2D2LG FMN2D2LI FMN2D2LS FMN2D2SP FMN2DATA FMN2DBC FMN2DBI FMN2DBJ FMN2DBO FMN2DBOL FMN2DBP FMN2DBV FMN2DBX FMN2DBY FMN2DCIO FMN2DCMD FMN2DCRE FMN2DENP FMN2DENU FMN2DIUS FMN2DJPN FMN2DKOR FMN2EDSP FMN2EDT1 FMN2EOBN FMN2ERR FMN2ERRK FMN2ETRC FMN2EXML FMN2EXSY FMN2FDCN FMN2FE4B FMN2FMT FMN2FSQC FMN2FTJV FMN2FTPC FMN2FXNM FMN2GISQ FMN2GV20 FMN2GV21 FMN2GV22 FMN2HLI FMN2IDTB FMN2INTE FMN2INTJ FMN2INTP FMN2INTS FMN2IPSU FMN2ISPF FMN2ISQ FMN2ISQG FMN2ISQI FMN2ISQS FMN2ITSV FMN2IVSU FMN2LBRS FMN2LBSV FMN2LCCP FMN2LIBS FMN2LOCL FMN2LVL FMN2LVLJ FMN2LVLK FMN2MAIN FMN2MENU FMN2MISC FMN2MJPN FMN2MKOR FMN2NFMC FMN2OPTL FMN2PCOP FMN2PD2E FMN2PDBP FMN2PEO1 FMN2PEO2 FMN2PEO3 FMN2PEO4 FMN2PEO5 FMN2PEO6 FMN2PEO7 FMN2PEO8 FMN2PFMS FMN2POAC FMN2POPT FMN2PPO1 FMN2PRVP FMN2PSX2 FMN2PUOP FMN2PXO1 FMN2PXO2 FMN2PXO3 FMN2PXOA FMN2PXOB FMN2RALI FMN2RD45 FMN2RMDT FMN2RMQ FMN2RMR FMN2RMR2 FMN2RMUT FMN2SADA FMN2SAGF FMN2SAPR FMN2SBPR FMN2SCON FMN2SCRE FMN2SCST FMN2SEDX FMN2SELS FMN2SENX FMN2SERR FMN2SHLB FMN2SHSQ FMN2SIDM FMN2SNTX FMN2SNXP
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655Q1200
Applicable component levels
RD10 PSY UI54261
UP18/03/08 P F803
RD11 PSY UI54262
UP18/03/08 P F803
RD12 PSY UI54264
UP18/03/08 P F803
RD13 PSY UI54265
UP18/03/08 P F803
RD14 PSY UI54267
UP18/03/08 P F803
RD16 PSY UI54268
UP18/03/08 P F803
RD1A PSY UI54263
UP18/03/08 P F803
RD1B PSY UI54266
UP18/03/08 P F803
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
24 March 2020