During initialization, the DB2 ECCR tried to get information for determining the schema version for the specified table by reading the tablespace data set or partition data set that contains the table. However, the DSSIZE information was not available. This problem occurs because the columns in the PowerExchange capture directory tables for the supported schema version contain default values instead of the correct values from the DB2 catalog. The DB2 ECCR issues this warning message to indicate that it might encounter problems in capturing log data for the table.
This problem can occur only if you are using DB2 Version 9.1 or later.
The message text includes the fully-qualified table name, the name of the data set that the ECCR was processing, and the type of information that was not available.
Processing continues. The DB2 ECCR continues to capture changes for the table, even though some schema version information might be unavailable. If the ECCR reads log records for the table with an older schema version, the ECCR might not interpret that log data correctly. In this case, the ECCR issues message PWXEDM177456E or PWXEDM177460E and reacts in one of the following ways, depending on the setting in the EC PERMIL statement in the REPL2OPT DD data set:
If the EC PERMIL value is 0 or has been exceeded, the ECCR abends.
If the EC PERMIL value has not be exceeded, the ECCR discards the log records.
Normally, if you reorganize the tablespace or partitions after making a schema change that increments the schema version, no rows in the table should be recorded with an older schema version.
If the DB2 ECCR encounters errors when capturing data for this table, follow the instructions in message PWXEDM177456E or PWXEDM177460E.
To prevent this problem from occurring in the future, use the sample SQL in the FIXTCAPC, FIXTCAPS and FIXTCAPT members of the PowerExchange SAMPLIB library to update the columns in the PowerExchange capture directory tables with the correct values from the DB2 catalog.
If this message persists after the SQL updates to the capture directory tables have been done, contact Informatica Global Customer Support.
