A fix is available
APAR status
Closed as program error.
Error description
APAR PH24367 - s0C4 abend in ARCH 13 Production Build with IMS map reduce - Can not generate IMS VT - IMS DBD xxx not found - Map xxxx specifies PSB name yyyy which is not found - IDF -30081, ERROR TCP/IP COMM ERROR DETECTED - INSERT after UNION inserts wrong values in seq file - S0C4 Abend at COSETCAC + X'08A6' when INNER JOIN is used in IMS SQL query - Better message issued for: DB2 Direct exhausted process At X'00000051_02D000C0'(0000015A) - DB2 SUBSYSTEM xxxx IS NOT INSTALLED - Resultset ordered incorrectly for Adabas SQL with ORDER BY - Returned corrupted values when accessing IMS DEDB variable- length segment with IMS Direct access method - Multiple DVM subsystems running under the same ID are unable connect to the same IMS subsystem - DVM Abending on IMS DBD - Comments in Studio when generating SQL are wrong, it is always DB2 - DVM - Get SQLFAIL - NOACTION - SYSTEM ABEND X'0C3' OCCURRED ON THE REMOTE SYSTEM AND IS BEING PROPAGATED TO THIS SYSTEM - SELECT COUNT() gives SRB SYSTEM ABEND X'0C3' AT sdevsqce/AVZSQLCN - The SQL IS NULL does NOT work when used in compound WHERE predicate - DB2-Direct only discovers first linear dataset of multi- dataset table - Unable to create virtual table from an IMS logically related virtual segment - DBD extract parser fails when ENCODING= specified on SEGM statements - Select with CASE returns incorrect precision - SELECT query sets Type to VARCHAR and leaves out trailing spaces - IMS HDAM Database cannot be accessed with IMS Direct Access method - IDF table creation error when Db2 Fields are Nullable
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: s0C4 abend in ARCH 13 Production Build * * with IMS map reduce * * * * Can not generate IMS VT - IMS DBD xxx * * not found * * * * Map xxxx specifies PSB name yyyy which * * is not found * * * * IDF -30081, ERROR TCP/IP COMM ERROR * * DETECTED * * * * INSERT after UNION inserts wrong * * values in seq file * * * * S0C4 Abend at COSETCAC + X'08A6' * * when INNER JOIN is used in IMS * * SQL query * * * * Better message issued for: DB2 * * Direct exhausted process * * At X'00000051_02D000C0'(0000015A) * * * * DB2 SUBSYSTEM xxxx IS NOT INSTALLED * * * * Resultset ordered incorrectly for * * Adabas SQL with ORDER BY * * * * Returned corrupted values when * * accessing IMS DEDB variable-length * * segment with IMS Direct access * * method. * * * * Multiple DVM subsystems running * * under the same ID are unable to * * connect to the same IMS subsystem * * * * DVM Abending on IMS DBD * * * * Comments in Studio when generating * * SQL are wrong - it is always DB2 * * * * DVM - Get SQLFAIL - NOACTION - * * SYSTEM ABEND X'0C3' OCCURRED ON THE * * REMOTE SYSTEM AND IS BEING * * PROPAGATED TO THIS SYSTEM * * * * SELECT COUNT() gives SRB SYSTEM * * ABEND X'0C3' AT sdevsqce/AVZSQLCN * * * * The SQL IS NULL does NOT work when * * used in compound WHERE predicate. * * * * DB2-Direct only discovers first * * linear dataset of multi-dataset * * table * * * * Unable to create virtual table * * from an IMS logically related * * virtual segment * * * * DBD extract parser fails when * * ENCODING= specified on SEGM * * statements * * * * Select with CASE returns * * incorrect precision * * * * SELECT query sets Type to * * VARCHAR and leaves out trailing * * spaces * * * * IMS HDAM Database cannot be * * accessed with IMS Direct Access * * method * * * * IDF table creation error when * * Db2 Fields are Nullable * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** s0C4 abend in ARCH 13 Production Build with IMS map reduce Can not generate IMS VT - IMS DBD xxx not found Map xxxx specifies PSB name yyyy which is not found IDF -30081, ERROR TCP/IP COMM ERROR DETECTED INSERT after UNION inserts wrong values in seq file S0C4 Abend at COSETCAC + X'08A6' when INNER JOIN is used in IMS SQL query Better message issued for: DB2 Direct exhausted process At X'00000051_02D000C0'(0000015A) DB2 SUBSYSTEM xxxx IS NOT INSTALLED Resultset ordered incorrectly for Adabas SQL with ORDER BY Returned corrupted values when accessing IMS DEDB variable-length segment with IMS Direct access method. Multiple DVM subsystems running under the same ID are unable to connect to the same IMS subsystem DVM Abending on IMS DBD Comments in Studio when generating SQL are wrong - it is always DB2 DVM - Get SQLFAIL - NOACTION - SYSTEM ABEND X'0C3' OCCURRED ON THE REMOTE SYSTEM AND IS BEING PROPAGATED TO THIS SYSTEM SELECT COUNT() gives SRB SYSTEM ABEND X'0C3' AT sdevsqce/AVZSQLCN The SQL IS NULL does NOT work when used in compound WHERE predicate. DB2-Direct only discovers first linear dataset of multi-dataset table Unable to create virtual table from an IMS logically related virtual segment DBD extract parser fails when ENCODING= specified on SEGM statements Select with CASE returns incorrect precision SELECT query sets Type to VARCHAR and leaves out trailing spaces IMS HDAM Database cannot be accessed with IMS Direct Access method IDF table creation error when Db2 Fields are Nullable
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH24367
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-04-13
Closed date
2020-05-13
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69477
Modules/Macros
HLV$E3CE HLV$E3CM HLV$E3LE HLV$E3LM HLV$E3SE HLV$E3SM HLV$E3TE HLV$E3TM HLV$U3C0 HLV$U3L0 HLV$U3S0 HLV$U3T0 HLVCCNFU HLVCDRCK HLVCDSRL HLVCMQIO HLVCOTFU HLVCPROC HLVCRDBD HLVCRDFU HLVCRVAI HLVMFREF HLVMREFB HLVO2DSA HLVOBRSQ HLVODF9D HLVODF9N HLVODFAD HLVODFAN HLVODFBD HLVODFBN HLVODFCD HLVODFCN HLVODFDD HLVODFDN HLVOFSQL HLVOIMSR HLVOLI9D HLVOLI9N HLVOLIAD HLVOLIAN HLVOLIBD HLVOLIBN HLVOLICD HLVOLICN HLVOLIDD HLVOLIDN HLVOPRUT 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 UI69477
UP20/05/16 P F005
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"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021