A fix is available
APAR status
Closed as program error.
Error description
DVM October/November 2021 1.1.0.101 Release - REMARKS column added for ADABAS Subtable is changed to URL from SUBTABLE - Table Name - DB2 VT creation fails - Unable to create IAM data sources - ISSUE ON OFFSET LENGTH - ADABAS TABLE SELECT- FROM DEV_CLEARANCE_FILE_D0002788 LIMIT 150 - CREATE COUNT FIELD - PE/MU FIELD VALUE '1' - SMF Map for Record Type 83 Sub Type 2 doesn't retrieve data. - SQL Engine support - UDTF Select count(* - always returns 0 rows - LOGSTREAM VT timestamp range comparisons using LS_TIMESTAMP failing - Common Table Expression - Other Data sources- VSAM - CAST fails from Decimal to character in VSAM database - Update AVZCTRON/AVZCTROF CMD rules to include all the latest Trace Parms - IMS-Direct MDA discovery does not work for fastpath databases. - update count not returned in sqlerrd3 when sqlcode is zero - Insert with Select UNION is inserting partial set of records, not the expected resultset. - DVMZ-I-64:DVM - Support Virtual Table with db2 Table on an AS400 server. - UCS-2 blank padding incorrect in DRDA-AR - CLONE - Security vulnerability in module OPINBR detected when wrong INMEM resource was coded in AZKS IN00 - ADABAS virtual table is not allowing insert or updates when th VT contains a redefined field - Getting " Invalid conversion from string to number" exception using value +2.00000000000000E-001
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: REMARKS column added for ADABAS * * Subtable is changed to URL from * * SUBTABLE - Table Name * * DB2 VT creation fails * * Unable to create IAM data sources * * ISSUE ON OFFSET LENGTH - ADABAS TABLE * * SELECT * * * FROM DEV_CLEARANCE_FILE_D0002788 * * LIMIT 150 * * CREATE COUNT FIELD - PE/MU FIELD * * VALUE '1' * * SMF Map for Record Type 83 Sub * * Type 2 doesn't retrieve data. * * SQL Engine support * * UDTF Select count(* - always * * returns 0 rows) * * LOGSTREAM VT timestamp range * * comparisons using LS_TIMESTAMP failing * * Common Table Expression - * * Other Data sources- VSAM * * CAST fails from Decimal to * * character in VSAM database * * Update AVZCTRON/AVZCTROF * * CMD rules to include all * * the latest Trace Parms * * IMS-Direct MDA discovery * * does not work for fastpath * * databases * * Update count not returned in * * sqlerrd3 when sqlcode is zero * * Insert with Select UNION is * * inserting partial set of * * records, not the expected * * resultset. * * DVMZ-I-64:DVM - Can DVM * * create Virtual Table with db2 * * Table on an as400 server? * * UCS-2 blank padding incorrect * * in DRDA-AR * * Security vulnerability in * * module OPINBR detected when * * wrong INMEM resource was coded * * in AZKS IN00 * * ADABAS virtual table is not * * allowing insert or updates * * when the VT contains a redefined * * field * * Getting " Invalid conversion from * * string to number" * * exception using value * * +2.00000000000000E-001 * * Support for Comma as decimal delimiter * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** REMARKS column added for ADABAS Subtable is changed to URL from SUBTABLE - Table Name DB2 VT creation fails Unable to create IAM data sources ISSUE ON OFFSET LENGTH - ADABAS TABLE SELECT * FROM DEV_CLEARANCE_FILE_D0002788 LIMIT 150 CREATE COUNT FIELD - PE/MU FIELD VALUE '1' SMF Map for Record Type 83 Sub Type 2 doesn't retrieve data. SQL Engine support UDTF Select count(* - always returns 0 rows LOGSTREAM VT timestamp range comparisons using LS_TIMESTAMP failing Common Table Expression - Other Data sources- VSAM CAST fails from Decimal to character in VSAM database Update AVZCTRON/AVZCTROF CMD rules to include all the latest Trace Parms IMS-Direct MDA discovery does not work for fastpath databases. update count not returned in sqlerrd3 when sqlcode is zero Insert with Select UNION is inserting partial set of records, not the expected resultset. DVMZ-I-64:DVM - Can DVM create Virtual Table with db2 Table on an as400 server? UCS-2 blank padding incorrect in DRDA-AR Security vulnerability in module OPINBR detected when wrong INMEM resource was coded in AZKS IN00 ADABAS virtual table is not allowing insert or updates when the VT contains a redefined field Getting " Invalid conversion from string to number" exception using value +2.00000000000000E-001 Support for Comma as decimal delimiter
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH40835
Reported component name
DATA VIRT MGR Z
Reported component ID
5698DVM00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-09-22
Closed date
2022-01-26
Last modified date
2022-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
AVZ$532E AVZ$532M AVZCBDBK AVZCBKRW AVZCCM64 AVZCCRDC AVZCCUBI AVZCCUBU AVZCD2CL AVZCDBIF AVZCDCCB AVZCDSEY AVZCFAPI AVZCFIRQ AVZCFR64 AVZCGTCM AVZCIDCL AVZCIMCL AVZCISCL AVZCPREV AVZCPRHL AVZCRDBD AVZCSQCM AVZCSQOP AVZCSVCL AVZCTGOP AVZCTROF AVZCTRON AVZDRATH AVZEISER AVZMFMIG AVZO319D AVZO319N AVZO31AD AVZO31AN AVZO31BD AVZO31BN AVZO31CD AVZO31CN AVZO31DD AVZO31DN AVZO649D AVZO649N AVZO64AD AVZO64AN AVZO64BD AVZO64BN AVZO64CD AVZO64CN AVZO64DD AVZO64DN AVZOAOPR AVZOAUCK AVZOBJ AVZOBRIM AVZOBRSQ AVZOCKLM AVZOCXA0 AVZOCXIN AVZODARU AVZODBTP AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZODT9N AVZODTAN AVZODTBN AVZODTCN AVZODTDN AVZOFIST AVZOFSQL AVZOHOPA AVZOINAS AVZOINBR AVZOINCM AVZOINSM AVZOINSQ AVZOINXM AVZOMAIN AVZOPPA AVZOPPT AVZOPST AVZOSVTP AVZOTBEV AVZOTBRU AVZPB AVZPRIMP AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN AVZSQ2BD AVZSQ2BN AVZSQ2CD AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLAD AVZSQLAN AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN AVZSQLDD AVZSQLDN
Fix information
Fixed component name
DATA VIRT MGR Z
Fixed component ID
5698DVM00
Applicable component levels
R110 PSY UI78836
UP22/02/01 P F201
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"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"110"}]
Document Information
Modified date:
02 February 2022