A fix is available
APAR status
Closed as program error.
Error description
May 2020 Release. -Issue with MapReduce Filtering -SMF80RST contains format YYYY-MM-DD-hh.mm.ss, but not always -ADABAS ORDER BY on a Date field returns result with incorrect order -SMF data disappears when Select contains ADD ORDER BY -Spaces in CICS connection and transaction name in import VSAM XML abends -DB2 Direct Segmented page not found error -CONCAT returns error inside DATEFMT - Invalid token CONCAT found after left parenthesis -SQL Query fired against IMS Root segment abends with '0C'4 for IMS-DIRECT type -UDTF not honoring non-decimal to zero conversion -Initialize PAPLGRPN to spaces in IMS DBCTL PSB scheduling logic -SQLEngine Date and Time function DAYOFYEAR returns 0 -Problem with IMS "Implicit Join" -IMS query returns Incorrect output for sub select -ABEND 0C4 ACCESSING ADABAS WHEN USING SELECT IN -DB2 & ADABAS default Date conversion when selected using SQLEnine -SQL MAX function for ADABAS Date & Timestamp return Invalid ADABAS time found in result set column 1 -Ability for server subsystem started task ID use an alternative ID when connecting to other systems (DB2, IMS, JGate,etc.) -Length on the Stored procedure appears to be truncated -SELECT DISTINCT on a DB2 Virtual table that has RUNSTATS gives incorrect results -SQLENGDATEFMT=EUR causes a problem with ADABAS DATE & timestamp -MongoDB Port displaying negative values after server start-up -DRDARANGE Support for JGATE - Oracle and MSSQL -Cannot UPDATE a segment that is just under the root and/or using a SUBSELECT key -Abend S0C1 on SQL UPDATE to ADABAS using zCEE without RRS installed -Virtual Table IDMS Creation problem when Index has 14 fields
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: Issue with MapReduce Filtering * * * * SMF80RST contains format * * YYYY-MM-DD-hh.mm.ss * * but not always * * * * ADABAS ORDER BY on a Date * * field returns * * result with incorrect order * * * * SMF data disappears when * * Select contains * * ADD ORDER BY * * * * Spaces in CICS connection * * and transaction * * name in import VSAM XML * * abends * * * * DB2 Direct Segmented page * * not found * * error * * * * CONCAT returns error inside * * DATEFMT - Invalid token CONCAT * * found after left parenthesis * * * * SQL Query fired against IMS * * Root segment * * abends with '0C'4 for * * IMS-DIRECT type * * * * UDTF not honoring non-decimal * * to zero conversion * * * * Initialize PAPLGRPN to spaces * * in IMS DBCTL PSB scheduling * * logic * * * * SQLEngine Date and Time function * * DAYOFYEAR returns 0 * * * * Problem with IMS "Implicit Join" * * * * IMS query returns Incorrect output * * for sub select * * * * ABEND 0C4 ACCESSING ADABAS WHEN * * USING SELECT IN * * * * DB2 & ADABAS default Date conversion * * when selected using SQLEngine * * * * SQL MAX function for ADABAS * * Date & Timestamp return Invalid * * ADABAS time found in * * result set column 1 * * * * Ability for server subsystem * * started task ID use an * * alternative ID when connecting * * to other systems * * (DB2, IMS, JGate,etc.) * * * * Length on the Stored procedure * * appears to be truncated * * * * SELECT DISTINCT on a DB2 * * Virtual table that has RUNSTATS * * gives incorrect results * * * * SQLENGDATEFMT=EUR causes a * * problem with * * ADABAS DATE & timestamp * * * * MongoDB Port displaying * * negative values * * after server start-up * * * * DRDARANGE Support for JGATE * * - Oracle and MSSQL * * * * Cannot UPDATE a segment that * * is just under * * the root and/or using * * a SUBSELECT key * * * * Abend S0C1 on SQL UPDATE * * to ADABAS using * * zCEE without RRS installed * * * * Virtual Table IDMS Creation * * problem when * * Index has 14 fields * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** Issue with MapReduce Filtering SMF80RST contains format YYYY-MM-DD-hh.mm.ss, but not always ADABAS ORDER BY on a Date field returns result with incorrect order SMF data disappears when Select contains ADD ORDER BY Spaces in CICS connection and transaction name in import VSAM XML abends DB2 Direct Segmented page not found error CONCAT returns error inside DATEFMT - Invalid token CONCAT found after left parenthesis SQL Query fired against IMS Root segment abends with '0C'4 for IMS-DIRECT type UDTF not honoring non-decimal to zero conversion Initialize PAPLGRPN to spaces in IMS DBCTL PSB scheduling logic SQLEngine Date and Time function DAYOFYEAR returns 0 Problem with IMS "Implicit Join" IMS query returns Incorrect output for sub select ABEND 0C4 ACCESSING ADABAS WHEN USING SELECT IN DB2 & ADABAS default Date conversion when selected using SQLEnine SQL MAX function for ADABAS Date & Timestamp return Invalid ADABAS time found in result set column 1 Ability for server subsystem started task ID use an alternative ID when connecting to other systems (DB2, IMS, JGate,etc.) Length on the Stored procedure appears to be truncated SELECT DISTINCT on a DB2 Virtual table that has RUNSTATS gives incorrect results SQLENGDATEFMT=EUR causes a problem with ADABAS DATE & timestamp MongoDB Port displaying negative values after server start-up DRDARANGE Support for JGATE - Oracle and MSSQL Cannot UPDATE a segment that is just under the root and/or using a SUBSELECT key Abend S0C1 on SQL UPDATE to ADABAS using zCEE without RRS installed Virtual Table IDMS Creation problem when Index has 14 fields
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH25442
Reported component name
IDAA LOADER DAT
Reported component ID
5639OLE01
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-14
Closed date
2020-06-17
Last modified date
2020-07-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70104
Modules/Macros
HLV$500E HLV$500M HLVCCAPR HLVCDSPS HLVCDSTX HLVCDSTZ HLVCMSCG HLVCPROC HLVCSCHE HLVCSPTB HLVCSQOP HLVCTSRD HLVOBRSR HLVOINAS HLVOPAGN HLVOPMS HLVOSVTP HLVPB HLVSQ29D HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD HLVSQLDN
Fix information
Fixed component name
IDAA LOADER DAT
Fixed component ID
5639OLE01
Applicable component levels
R210 PSY UI70104
UP20/06/19 P F006
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021