A fix is available
APAR status
Closed as program error.
Error description
-DB2 SUBSYSTEM xxxx IS NOT INSTALLED -RHB DVM PoC - Missing Data from array elements - all elements take the value of the first element -Spaces in CICS connection and transaction name in import VSAM XML abends -DB2 & ADABAS default Date conversion when selected using SQLEnine -S0C4 Abend at COSETCAC + X'08A6' when INNER JOIN is used in IMS SQL query -DVM - Get SQLFAIL - NOACTION - SYSTEM ABEND X'0C3' OCCURRED ON THE REMOTE SYSTEM AND IS BEING PROPAGATED TO THIS SYSTEM -DVMZ-I-13: Ability for DVM subsystem started task ID use an alternative ID when connecting to other systems (DB2, IMS, JGate,etc.) -Need Virtual Table/Map support for ACF2 SMF records type 229 for additional sub types other than D and V -DB2-Direct only discovers first linear dataset of multi-dataset table -ACI Server are not deleting Enclaves Properly -IPLed due to High ESQA and ECSA usage -Length on the Stored procedure appears to be truncated -Support for Studio generated SAR files and restful service creation -Full scan of IMS DB occurs for 2 or more Record_IDs used in where predicates -CASE Statement fails with invalid packed data when trying to convert invalid data to NULL -Update parm IMSSUFFIX to AFIN=NO -Compression Exit with MapReduce being terminated early causing other Threads to abend -IMS DIRECT - 0C4 abends in VDB9/RS14 -SELECT statement on SMF data with Time filtering using BETWEEN with ORDER BY and JOIN ON gives error -SMF query returning 0c3 abend after Spark 2.3.3 upgrade -Virtual View with circular reference causes error - Unable to find the sqch block for prepare and high ZIIP usage -SMF 99 Column names are cut -SMF99 records - Subtypes are missing information -SMF type 99 table has columns that give errors in the calculations/conversion to seconds -PMR50298,070,724 - Wrong mapping in SMF Type 99 Subtype 2 -Virtual table failure from PL/I DCL -Increase number of direct children a IMS Segment can have (currently limited to 15) -ABEND ERROR X'000C3000' REASON X'00000003' during ZOOM IN in trace browse on small SQL event -Cannot UPDATE a segment that is just under the root and/or using a SUBSELECT key -SELECT from TABLE WHERE KEY=1 UNION with another SELECT WHERE KEY=2 fails -TOR/DOR using IDF for load balancing/routing capability -Abend S0C1 on SQL UPDATE to ADABAS using zCEE without RRS installed -Query of IMS Virtual Table with secondary index fails -Virtual Table IDMS Creation problem when Index has 14 fields -Studio Parser generates error when parsing copybook that contains ' (single quote) -PMR88902,L6Q,000 - DVM Crashes with a Join query and Union with Join query -VSAM OPEN FAILED (31) RC=X'00000008', ERROR FIELD=X'00 -Change security requirements for Db2-Direct and IMS Direct dataset access -IMS Update failure when using Secondary Index -Missing VAR fields from SMF_10101 and SMF_10101_QPAC -SMF80RST contains format YYYY-MM-DD-hh.mm.ss, but not always -Request for new SMF map for SMF30SIT and SMF30STD fields -ADABAS ORDER BY on a Date field returns result with incorrect order -New IDAA Loader VT needed for CDC SMF records -DVMZ-I-17: Allow configuration to specify hlq for MMAP and MFL datasets [Server changes] -Support for SMF Type 98 records -Correct SMFxxDAT field in all SMF record - Phase 1 -Map xxxx specifies PSB name yyyy which is not found -IDF -30081, ERROR TCP/IP COMM ERROR DETECTED -WHERE criteria not working on a view -The SQL IS NULL does NOT work when used in compound WHERE predicate -TOCHAR gives error "Invalid token TO_CHAR found preceding left parenthesis" when converting TIMESTAMP field to specified format. -Better message issued for: DB2 Direct exhausted process At X'00000051_02D000C0'(0000015A) -CONCAT returns error inside DATEFMT - Invalid token CONCAT found after left parenthesis -Support for SMF Type 28 Virtual Table -Initialize PAPLGRPN to spaces in IMS DBCTL PSB scheduling logic -Problem with IMS "Implicit Join"
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users * **************************************************************** * PROBLEM DESCRIPTION: Change security requirements for * * Db2-Direct and IMS Direct dataset * * access * * * * VSAM OPEN FAILED (31) RC=X'00000008', * * ERROR FIELD=X'00 * * * * PMR88902,L6Q,000 - DVM Crashes with * * a Join query and Union with Join * * query * * * * Virtual Table IDMS Creation problem * * when Index has 14 fields * * * * Query of IMS Virtual Table with * * secondary index fails * * * * TOR/DOR using IDF for load * * balancing/routing capability * * * * SELECT from TABLE WHERE KEY=1 UNION * * with another SELECT WHERE KEY=2 fails * * * * Cannot UPDATE a segment that is just * * under the root and/or using a * * SUBSELECT key * * * * ABEND ERROR X'000C3000' REASON * * X'00000003' during ZOOM IN in * * trace browse on small SQL event * * * * PMR50298,070,724 - Wrong mapping * * in SMF Type 99 Subtype 2 * * * * SMF type 99 table has columns that * * give errors in the calculations * * or conversion to seconds * * * * SMF99 records - Subtypes are * * missing information * * * * SMF 99 Column names are cut * * * * Virtual View with circular reference * * causes error - Unable to find the * * sqch block for prepare and high * * ZIIP usage * * * * SMF query returning 0c3 abend after * * Spark 2.3.3 upgrade * * * * SELECT statement on SMF data with Time * * filtering using BETWEEN with ORDER * * BY and JOIN ON gives error * * * * IMS DIRECT - 0C4 abends in VDB9/RS14 * * * * Compression Exit with MapReduce being * * terminated early causing other Threads * * to abend * * * * Update parm IMSSUFFIX to AFIN=NO * * * * CASE Statement fails with invalid * * packed data when trying to convert * * invalid data to NULL * * * * Full scan of IMS DB occurs for 2 or * * more Record_IDs used in where * * predicates * * * * Support for Studio generated SAR files * * and restful service creation * * * * Length on the Stored procedure appears * * to be truncated * * * * IPLed due to High ESQA and ECSA usage * * * * ACI Server are not deleting Enclaves * * Properly * * * * DB2-Direct only discovers first linear * * dataset of multi-dataset table * * * * S0C4 Abend at COSETCAC + X'08A6' when * * INNER JOIN is used in IMS SQL query * * * * DB2 & ADABAS default Date conversion * * when selected using SQLEnine * * * * TOCHAR gives error "Invalid token * * TO_CHAR found preceeding left * * parenthesis" when converting * * TIMESTAMP field to specified * * format. * * * * Spaces in CICS connection and * * transaction name in import * * VSAM XML abends * * * * RHB DVM PoC - Missing Data from array * * elements - all elements take the * * value of the first element * * * * Map xxxx specifies PSB name yyyy * * which is not found * * * * DB2 SUBSYSTEM xxxx IS NOT INSTALLED * * * * IMS Update failure when using * * Secondary Index * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** Change security requirements for Db2-Direct and IMS Direct dataset access VSAM OPEN FAILED (31) RC=X'00000008', ERROR FIELD=X'00 PMR88902,L6Q,000 - DVM Crashes with a Join query and Union with Join query Virtual Table IDMS Creation problem when Index has 14 fields Query of IMS Virtual Table with secondary index fails TOR/DOR using IDF for load balancing/routing capability SELECT from TABLE WHERE KEY=1 UNION with another SELECT WHERE KEY=2 fails Cannot UPDATE a segment that is just under the root and/or using a SUBSELECT key ABEND ERROR X'000C3000' REASON X'00000003' during ZOOM IN in trace browse on small SQL event PMR50298,070,724 - Wrong mapping in SMF Type 99 Subtype 2 SMF type 99 table has columns that give errors in the calculations/conversion to seconds SMF99 records - Subtypes are missing information SMF 99 Column names are cut Virtual View with circular reference causes error - Unable to find the sqch block for prepare and high ZIIP usage SMF query returning 0c3 abend after Spark 2.3.3 upgrade SELECT statement on SMF data with Time filtering using BETWEEN with ORDER BY and JOIN ON gives error IMS DIRECT - 0C4 abends in VDB9/RS14 Compression Exit with MapReduce being terminated early causing other Threads to abend Update parm IMSSUFFIX to AFIN=NO CASE Statement fails with invalid packed data when trying to convert invalid data to NULL Full scan of IMS DB occurs for 2 or more Record_IDs used in where predicates Support for Studio generated SAR files and restful service creation Length on the Stored procedure appears to be truncated IPLed due to High ESQA and ECSA usage ACI Server are not deleting Enclaves Properly DB2-Direct only discovers first linear dataset of multi-dataset table S0C4 Abend at COSETCAC + X'08A6' when INNER JOIN is used in IMS SQL query DB2 & ADABAS default Date conversion when selected using SQLEnine TOCHAR gives error "Invalid token TO_CHAR found preceeding left parenthesis" when converting TIMESTAMP field to specified format. Spaces in CICS connection and transaction name in import VSAM XML abends RHB DVM PoC - Missing Data from array elements - all elements take the value of the first element Map xxxx specifies PSB name yyyy which is not found DB2 SUBSYSTEM xxxx IS NOT INSTALLED IMS Update failure when using Secondary Index
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH25789
Reported component name
QMF DATA SERVIC
Reported component ID
566872103
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-26
Closed date
2020-08-03
Last modified date
2020-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70870
Modules/Macros
CQD$631E CQD$631M CQD$632E CQD$632M CQD$M310 CQD$M311 CQD$M312 CQD$M313 CQD$M314 CQD$M315 CQD$M316 CQD$M317 CQD$M318 CQD$M319 CQD$M31A CQD$M31B CQD$M31C CQD$M320 CQD$M321 CQD$M322 CQD$M323 CQD$M324 CQD$M325 CQD$M326 CQD$M327 CQD$M328 CQD$M329 CQD$M32A CQDCCAPR CQDCDRCK CQDCDSPS CQDCDSRL CQDCDSTZ CQDCINWK CQDCMSCG CQDCPROC CQDCRDBD CQDCSEAC CQDCSPTB CQDCSQOP CQDCSVCL CQDIDFRR CQDO2DSA CQDOBOFU CQDOBRID CQDOBRIM CQDOBRIS CQDOBRPR CQDOBRSQ CQDOBRSR CQDOBRTV CQDOCXRL CQDOCXRU CQDOCXSV CQDOHOPA CQDOINAS CQDOIO31 CQDOLI9D CQDOLI9N CQDOLIAD CQDOLIAN CQDOLIBD CQDOLIBN CQDOLICD CQDOLICN CQDOLIDD CQDOLIDN CQDOPPA CQDOSVTP CQDPB CQDSIN00 CQDSQ29D CQDSQ29N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN CQDSQ2CD CQDSQ2CN CQDSQ2DD CQDSQ2DN CQDSQL9D CQDSQL9N CQDSQLAD CQDSQLAN CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN CQDSQLDD CQDSQLDN HLVSIN00
Fix information
Fixed component name
QMF DATA SERVIC
Fixed component ID
566872103
Applicable component levels
RC10 PSY UI70870
UP20/08/05 P F008
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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS9UMF","label":"DB2 Query Management Facility"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
02 September 2020