V4.1.39 - connect_cdc_sqdata

Db2/z Log Capture (SQDDB2C):
- Fix high CPU and slow startup when scanning for metadata changes during capture task initialization on low-activity system.
  Note: This requires the same Db2 table described in the Db2/z Troubleshooting section Db2/z Log Buffer Delays so it may already exist in your environment:
```
CREATE TABLE SQDATA.CHURNING
(
COMMENT VARCHAR(128) NOT NULL
)I
N SQDATADC.SQDCHURN
DATA CAPTURE CHANGES;
COMMIT;
```
Display Capture Latency alerts
- When --high-threshold and --low-threshold are specified for the Db2 Log Capture either at runtime using SQDPARMS DD or using sqdconf modify.
```
SQDZ005W Latency for capture ( 274 sec.) is high
SQDZ006I Latency for capture is back to normal
```
IMS TM, IMS Log and VSAM Captures:
- Display Capture Latency alerts when --high-threshold and --low-threshold are specified for the CDCzLog Publisher either at runtime using SQDPARMS DD or using sqdconf modify.
```
SQDZ005W Latency for capture ( 274 sec.) is high
SQDZ006I Latency for capture is back to normal
```

Db2/z Log Capture and CDCzLog Publisher:

Add sqdconf tune command to enable/disable dynamic ACK (Acknowledgment) latency (the ACK receive time minus the commit time) trace.

00001523 92.06 [CDCSTORE | ZLOGC] :ack:dcb060d805e6d13a commit:dcb060d546581402 latency:2881 ms
(cdc:////engine1)
00001524 92.06 [CDCSTORE | ZLOGC] :ack:dcb060d805e70a38 commit:dcb060d546a9f402 latency:2880 ms
(cdc:////engine1)
00001525 92.06 [CDCSTORE | ZLOGC] :ack:dcb060d805e74456 commit:dcb060d546f84402 latency:2879 ms
(cdc:////engine1)

z/OS ISPF Panels:
- Fix dialog errors caused by EBCDIC code page differences.
- Fix dialog error in DSNREXX return code handling.

z/OS diagnostic logs:

Option, specified in DD SQDLOGL to display either the system Storeclock in Miliseconds or a human readable timestamp in DD SQDLOG:

OPTIONS=TIME the system Storeclock in Miliseconds
3882279447104 [ MSGS] :SQDDB2C 4.1.39-dev (zOS-370) ccsid:1047 - 0x21
3882279447104 [ MSGS] :Build-id:a93d3e38230049d11ebb7c229360042d7b098407
3882279447106 [ NET] :net_init_module
3882279447108 [ MESSAGE] :overload proc for type 0x20a0003(AGENT_MESSAGE_T_PING)
3882279447108 [ CNVFT] :cnvft_init_module <-- 0x0
3882279447109 [ MESSAGE] :overload proc for type 0x2020002(CDCCONF_MESSAGE_T_ACTION)

OPTIONS=TS
2023-01-09.14.33.14.748758 [ MSGS] :SQDDB2C 4.1.39-rel (zOS-370) ccsid:1047 - 0x21
2023-01-09.14.33.14.749565 [ MSGS] :Build-id:a93d3e38230049d11ebb7c229360042d7b098407
2023-01-09.14.33.14.751236 [ NET] :net_init_module
2023-01-09.14.33.14.753076 [ MESSAGE] :overload proc for type 0x20a0003(AGENT_MESSAGE_T_PING)
2023-01-09.14.33.14.753076 [ CNVFT] :cnvft_init_module <-- 0x0
2023-01-09.14.33.14.753202 [ MESSAGE] :overload proc for type 0x2020002(CDCCONF_MESSAGE_T_ACTION)

Apply Engine (SQDENG):
- Tolerate FPINDEX keyword on parse of IMS DBD statement.
- Fix SQData Apply Engine termination delay.
Replicator Engine (SQDRPL):
- Add IGNORE NOMAPPING option in replicator script and allow an IGNORE response from the mappings exit. Supported for Db2z to Kafka in Avro and JSON format and IMS RAWCDC in Distributor Mode.
z/OS All Components:
- Change signal handler on z/OS to avoid an ABEND when the ESTAE exit is not initialized.

V4.1.39 - connect_cdc_sqdata - Latest

Connect CDC (SQData) Release Notes