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 ran by the DB2 Administrator.
DB2> alter table "NT_LOGICAL_DISK" alter column "File_Control_Bytes/Sec_64" set data type BIGINT;
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.