Scenario: Qlik Replicate is using a DB2 Z/OS Source Endpoint. During an IPL, tasks fail while connecting to the DB2 instance in the Data Sharing Group.
The errors in the log are:
00124988: 2024-06-20T12:11:18 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020101 (replicationtask.c:3519) 00124988: 2024-06-20T12:11:18 [TASK_MANAGER ]W: Task 'ECS_GRP2_LS_IC0A_ECS_03' encountered a fatal error (repository.c:6064) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: Reading IFI packet encountered a fatal error upon UDTF execution. Aborting... [1020101] (db2z_ifi_api.c:405)our prod Logstream and Aurora tasks encountered multiple errors failing with DB2 communication error. Attaching the required logs and diagnostic package. Some of the tasks were able to recover, but two tasks tried to recover and finally errored out. When we tried to resume with resume option they threw an error and were able to resume with locally stored checkpoint option.:: this is what the error looks on simple resume: 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: R4DB2: Instance state has been recreated (r4z2util.c:1294 [20014] (db2z_ifi_api.c:995) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]I: IFI306 Skew is 3927874278216977 micro seconds (db2z_endpoint_util.c:510) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]I: IFI306 is initialized with buffer size of 262144 bytes (db2z_ifi_cdc.c:113) 00124988: 2024-06-20T12:11:18 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020101 (replicationtask.c:3519) 00124988: 2024-06-20T12:11:18 [TASK_MANAGER ]W: Task 'ECS_GRP2_LS_IC0A_ECS_03' encountered a fatal error (repository.c:6064) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: Reading IFI packet encountered a fatal error upon UDTF execution. Aborting... [1020101] (db2z_ifi_api.c:405) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: db2z_capture_start: Error connecting to IFI306 [1020101] (db2z_endpoint_capture.c:3109) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: Error executing command [1020101] (streamcomponent.c:2052) 00125214: 2024-06-20T12:11:18 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_cadm_db2_DDFIC0A_0523 [1020101] (subtask.c:1431) 00125214: 2024-06-20T12:11:18 [SOURCE_CAPTURE ]E: Stream component 'st_0_cadm_db2_DDFIC0A_0523' terminated [1020101] (subtask.c:1602)
Resolution
A DB2 configuration parameter (enableAcr) can be added to the db2dsdriver.cfg configuration file, which maintains the connection to DB2 during an IPL when the instance is in a Data Sharing Group.
For more information about enableAcr, see Element in the <acr> section of the db2dsdriver configuration file (Source: IBM.com).
Specifies whether automatic client reroute is in effect. The default is true. If the server accessed is Db2 for z/OS, the enableAcr parameter should be enabled only when the enableWLB parameter is in effect.
Cause
Environment
