A fix is available
APAR status
Closed as new function.
Error description
CQD February Release 2020 - DB2 Direct Segmented page not found error - UDTF not honoring non-decimal to zero conversion - 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 - SMF70 Sub Type 2 - changes to field SMF70LGO to have valid offset GMT to local time - DVM Abending on IMS DBD - SMF70 Sub Type 1 - changes to field SMF70LGO to have valid offset GMT to local time - The SQL "EXISTS" Operator does NOT work when used in "OR" condition of "WHERE" predicate - DB2 Direct Read against DB2 table may leave ENQs held - Comments in Studio when generating SQL are wrong - it is always DB2 - Db2 Federation CREATE NICKNAME results in ABEND in DVM server - IMS connections dropped, cannot recycle DVM - SQLENGDATEFMT=EUR causes a problem with ADABAS DATE & timestamp - UDTF fails to disconnect when DB2 FETCH FIRST n ROWS used in SQL - SQLCODE -206 error using correlation name in a Virtual View created from a DB2 Virtual table - Fail to create DVM virtual table with IMS DBD contain TYPE=SEQ - IMS HDAM Database cannot be accessed with IMS Direct Access method - Unsupported field type PIC S9(7)V99 COMP should be treated as SQL Decimal - IDF table creation error when Db2 Fields are Nullable - INSERT NULL and UPDATE with CURRENT_TIMESTAMP for column types TIMESTAMP, DATE and TIME not working - DVM parser fails with SSPTR in DBD - SELECT casting to DAYS/INTEGER fails with "Timestamp string contains invalid delimiters" - SQL INSERT to IMS child segments fails using DBCTL access - Increase IMSDIRECTBUFFERSIZE (MRBU) size
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users * **************************************************************** * PROBLEM DESCRIPTION: DB2 Direct Segmented page not found * * error * * * * UDTF not honoring non-decimal to zero * * conversion * * * * 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 * * * * SMF70 Sub Type 2 - changes to field * * SMF70LGO to have valid offset GMT to * * local time * * * * DVM Abending on IMS DBD * * * * SMF70 Sub Type 1 - changes to field * * SMF70LGO to have valid offset GMT to * * local time * * * * The SQL "EXISTS" Operator does NOT * * work when used in "OR" condition * * of "WHERE" predicate. * * * * DB2 Direct Read against DB2 table may * * leave ENQs held. * * * * Comments in Studio when generating SQL * * are wrong - it is always DB2 * * * * Db2 Federation CREATE NICKNAME results * * in ABEND in DVM server * * * * IMS connections dropped, cannot recycle * * DVM * * * * SQLENGDATEFMT=EUR causes a problem with * * ADABAS DATE & timestamp * * * * UDTF fails to disconnect when DB2 * * FETCH FIRST n ROWS used in SQL * * * * SQLCODE -206 error using correlation * * name in a Virtual View created from * * a DB2 Virtual table * * * * Fail to create DVM virtual table with * * IMS DBD contain TYPE=SEQ * * * * IMS HDAM Database cannot be accessed * * with IMS Direct Access method * * * * Unsupported field type PIC S9(7)V99 * * COMP should be treated as SQL Decimal * * * * IDF table creation error when Db2 * * Fields are Nullable * * * * INSERT NULL and UPDATE with * * CURRENT_TIMESTAMP for columns types * * TIMESTAMP, DATE and TIME not working * * DVM parser fails with SSPTR in DBD * * * * SELECT casting to DAYS/INTEGER fails * * with "Timestamp string contains * * invalid delimiters" * * * * SQL INSERT to IMS child segments fails * * using DBCTL access * * * * Increase IMSDIRECTBUFFERSIZE (MRBU) * * size * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** DB2 Direct Segmented page not found error UDTF not honoring non-decimal to zero conversion 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 SMF70 Sub Type 2 - changes to field SMF70LGO to have valid offset GMT to local time DVM Abending on IMS DBD SMF70 Sub Type 1 - changes to field SMF70LGO to have valid offset GMT to local time The SQL "EXISTS" Operator does NOT work when used in "OR" condition of "WHERE" predicate. DB2 Direct Read against DB2 table may leave ENQs held. Comments in Studio when generating SQL are wrong - it is always DB2 Db2 Federation CREATE NICKNAME results in ABEND in DVM server IMS connections dropped, cannot recycle DVM SQLENGDATEFMT=EUR causes a problem with ADABAS DATE & timestamp UDTF fails to disconnect when DB2 FETCH FIRST n ROWS used in SQL SQLCODE -206 error using correlation name in a Virtual View created from a DB2 Virtual table Fail to create DVM virtual table with IMS DBD contain TYPE=SEQ IMS HDAM Database cannot be accessed with IMS Direct Access method Unsupported field type PIC S9(7)V99 COMP should be treated as SQL Decimal IDF table creation error when Db2 Fields are Nullable INSERT NULL and UPDATE with CURRENT_TIMESTAMP for columns types TIMESTAMP, DATE and TIME not working DVM parser fails with SSPTR in DBD SELECT casting to DAYS/INTEGER fails with "Timestamp string contains invalid delimiters" SQL INSERT to IMS child segments fails using DBCTL access Increase IMSDIRECTBUFFERSIZE (MRBU) size
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH21003
Reported component name
QMF DATA SERVIC
Reported component ID
566872103
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2020-01-14
Closed date
2020-04-02
Last modified date
2020-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI68790
Modules/Macros
CQD$461E CQD$461M CQD$462E CQD$462M CQD$K610 CQD$K611 CQD$K612 CQD$K613 CQD$K614 CQD$K615 CQD$K616 CQD$K617 CQD$K620 CQD$K621 CQD$K622 CQD$K623 CQD$K624 CQDCBRUP CQDCDRCK CQDCPROC CQDCRDBD CQDCSQMM CQDCVPPT CQDO2DSA CQDOBRSQ CQDOBRTV CQDODT9N CQDODTAN CQDODTBN CQDODTCN CQDOIMSR CQDOINAS CQDOIO31 CQDOLI9D CQDOLI9N CQDOLIAD CQDOLIAN CQDOLIBD CQDOLIBN CQDOLICD CQDOLICN CQDOPPA CQDOPRUT CQDPB CQDSQ29D CQDSQ29N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN CQDSQ2CD CQDSQ2CN CQDSQL9D CQDSQL9N CQDSQLAD CQDSQLAN CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN
Fix information
Fixed component name
QMF DATA SERVIC
Fixed component ID
566872103
Applicable component levels
RC10 PSY UI68790
UP20/04/09 P F004
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 May 2020