A fix is available
APAR status
Closed as new function.
Error description
ASNMON can not start if any of the columns in IBMSNAP_MONPARMS table is set to null.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- ASNMON user * * 2- Users running ASNMON in z and accessing * * LUW Capture tables * **************************************************************** * PROBLEM DESCRIPTION: 1- ASNMON can not start if any of the * * columns in IBMSNAP_MONPARMS table is * * set to null. * * 2- ASNMON in z gets SQL-Error -440 on * * ASN.IBMSNAP_CAPMON * **************************************************************** 1- The data type of columns in IBMSNAP_MONPARMS table are changed to nullable type. ASNMON can start successfully if any of the columns is set to null. 2- When using the asnmon for zos to monitor the db2luw instance, using CHAR9 function to access the DB2 LUW SYSIBM. SYSDUMMY1 table, the CHAR9 function is not supported on DB2 LUW, it caused that the code goes to the sqlError function, Then SQLCODE is -440, the SQLSTATE is 42884 error is occurred.
Problem conclusion
1- ASNMON can start successfully if any of the columns is set to null. 2- Removed CHAR9 from ASNMON for zos to monitor zos & luw instance with CONDITION_NAME QCAPTURE_STATUS Note: ASNCLP has been updated from v1158 s2401240821. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH58977
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-01-02
Closed date
2024-01-26
Last modified date
2024-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI95440 UI95441 UI95442 UI95443
Modules/Macros
ASN2BASE ASN2DBCN ASN2SQLZ ASN2ZOSC ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAMAN ASNAPPLY ASNAPRS ASNAWPN ASNCAP ASNCATM ASNCCMD ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNDBCON ASNMCMD ASNMON ASNMONIT ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP ASNQAROW ASNQASUB ASNQBRWZ ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQLODZ ASNQMFMT ASNQP2PA ASNQP2PI ASNQSPIL ASNQSQLZ ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF ASNTDSP ASNTRC ASNVSQL ASNZOSCN
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI95440
UP24/01/30 P F401
RB34 PSY UI95441
UP24/01/31 P F401
RB35 PSY UI95442
UP24/01/30 P F401
RB36 PSY UI95443
UP24/01/30 P F401
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":"BU029","label":"Software"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]
Document Information
Modified date:
01 February 2024