Warehouse Proxy Agent (WPA) logs contain the "Error 219" message and the Warehouse Proxy workspace in the TEP client displays "CTX_JavaError" messages.
Example of information in WPA log:
(5058CA36.0026-3F:khdxdaex.cpp,622,"processExport") Error 219 happened
in endProcessSample for originnode Primary:hostname1:NT and object
NT_Logical_Disk (table WTLOGCLDSK appl KNT)
The data being exported is in a format that does not match the data definition for the column within the database table.
Diagnosing the problem
Using the tablename in the WPA log, confirm the data definition for the columns of the table using the DB2 DESCRIBE command. Focusing on the columns where the "Data Type" is "INTEGER" and the "Column Name" ends with "_64".
Resolving the problem
The DB2 ALTER command can be used to alter the "Data Type" for the offending columns. The DB2 ALTER command should be run by the DB2 Administrator.
DB2> alter table "NT_LOGICAL_DISK" alter column "File_Control_Bytes/Sec_64" set data type BIGINT;