Product Documentation
Abstract
The following text explains event log messages that might be reported by IBM InfoSphere Data Replication for z/OS 10.2.1 (CDC) when continuous incremental updates are enabled. It also contains recommendations on how to respond to these messages.
Content
These messages can occur if CDC propagates incremental updates to an accelerator. The messages as such are documented in the CDC collection of the IBM Knowledge Center. However, you will not find appropriate responses there because on its own, the CDC product is not concerned with accelerator issues.
The following table summarizes all 30 messages and suggests appropriate responses or interpretations.
| Event | Message | Interpretation / solution |
| CHC0748I | CHC0748I Table name in subscription subscription has been set to the EXTERNAL REFRESH state by subscription subscription | The accelerator-shadow table with the name name is currently being loaded or reloaded. See the IBM DB2 Analytics Accelerator: User's Guide for a description of the states that an accelerator-shadow table goes through during a load operation if continuous incremental updates are enabled. No action required. |
| CHC0749I | CHC0749I Table name in subscription subscription has been set to the SPILLING state by subscription subscription | |
| CHC0750I | CHC0750I Table name in subscription subscription has been set to the DRAINING state by subscription subscription | |
| CHC0950W | CHC0950W Signal signaltime could not be retrieved. The signal will be ignored. | An operation on a table that is enabled for incremental updates failed. For example, a reload might have ended unfinished.
|
| CHC0951E | CHC0951E Signal signaltime contains an unrecognized signal type type | Contact IBM support. |
| CHC0952E | CHC0952E Signal signaltime contains an unrecognized signal subtype subtype | |
| CHC0953E | CHC0953E Signal signaltime contains an unrecognized new table state state | |
| CHC0954E | CHC0954E Signal signaltime contains an incorrect number of parameters. number parameters were expected | |
| CHC0955E | CHC0955E Signal signaltime parameter parameter is invalid | |
| CHC0956E | CHC0956E Signal signaltime reports a missing end-of-quote character from the parameter value | |
| CHC0957E | CHC0957E Signal signaltime contains invalid data after parameter parameter | |
| CHC0958E | CHC0958E Signal signaltime specifies a table named name which is not part of subscription subscription | An operation on the name table has been skipped because the same operation failed before.
|
| CHC0959E | Signal signaltime cannot be processed. Table name is in an incorrect state. | |
| CHC0960W | CHC0960W Table name has encountered an error during an external refresh; The table will be set to idle | The accelerator-shadow table name was loading or reloading when incremental updates were stopped. Therefore, the table has been suspended from the incremental update process.
|
| CHC0961E | CHC0961E Signal signaltime specifies a table named name which does not exist | An operation on the name table could not be completed because the table was not found. This happens, for example, if a table has been removed from DB2 despite pending incremental updates for that table. Check whether the table was removed from DB2. If not, repeat the following steps on the accelerator. That is:
|
| CHC0962E | CHC0962E Signal signaltime cannot be processed since a new screen table cannot be created | This message indicates that an incremental update operation on a table failed due to an internal error.
|
| CHC0963W | CHC0963W IFI Filtering is no longer in use for this subscription | During the enablement of a table for incremental updates, IFI filtering stopped working. A possible consequence is that the CPU utilization increases significantly.
|
| CHC0964E | CHC0964E Signal signaltime cannot be processed. Table name is already processing a signal | Contact IBM support. |
| CHC0965E | CHC0965E Signal signaltime failed. The target failed to process the signal | An incremental update operation on a table failed.
|
| CHC0966E | CHC0966E Signal signaltime failed. Table name cannot be found in subscription subscription | An incremental update operation on a table was omitted, presumably because a previous incremental update operation failed.
|
| CHC0967E | CHC0967E Signal signaltime failed. Table name cannot be dropped from subscription subscription | Incremental updates could not be disabled for a table.
|
| CHC0968E | CHC0968E Signal signaltime failed. Table name cannot be added to subscription subscription | Incremental updates could not be enabled for a particular table.
|
| CHC0969W | CHC0969W Signal subtype with input signal has been in state state since timestamp | This is a hint that unused CDC metadata will be deleted soon. No action required. |
| CHC0970I | CHC0970I Table name has been added to subscription subscription by signal signaltime | This message confirms the successful enablement of incremental updates for a particular table. No action required. |
| CHC0971I | CHC0971I Table name has been dropped from subscription subscription by signal signaltime | This message confirms the successful disablement of incremental updates for a particular table. No action required. |
| CHC0972I | CHC0972I External load abandoned for table name due to initiation of a new external load | This message reports that incremental update processing for a table has been ended prematurely because a load or reload of the accelerator-shadow table has been requested. This is the expected behavior, not a malfunctioning. No action required. |
| CHC0973W | CHC0973W Subscription is presently stalled due to being in state state waiting for a response from remote partner | This message reports that incremental update processing has been paused for all tables in a particular DB2 subsystem because the workload on the accelerator is too high. If this message is just temporary or does not occur repeatedly, no action is required. If the message occurs repeatedly over a longer period of time:
|
| CHC1434W | CHC1434W Table name is not configured in subscription subscription. Requested operation will be ignored | If this message is reported repeatedly, contact IBM support. If it is a one-time incident, it can be ignored. |
| CHC9640W | CHC9640W Signalled request subtype has been cancelled by ending of subscription subscription | An incremental update operation was in progress when the entire incremental update process was stopped. Hence the operation has been aborted.
|
| CHC9641W | CHC9641W Table name in subscription subscription has been set to IDLE due to signalled request subtype being cancelled by ending of subscription | An incremental update operation was in progress for a particular table when the entire incremental update process was stopped. Hence the table has been suspended from the process.
|
[{"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"4.1.0;5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
08 August 2018
UID
swg27047505