Troubleshooting
Problem
After converting the tables to column based, the following error may occur using the db2batch tool on certain queries involving column-organized tables. ** CLI error in fetching next query result row: (-1667): [IBM][CLI Driver][DB2/LINUXX8664] SQL1667N The operation failed because the operation is not supported with the type of the specified table. Specified table: "CTRLM.ROLLUP_CONTROL_M_EXEC". Table type: "ORGANIZE BY COLUMN". Operation: "WITH RR". SQLSTATE=42858 Note: The same query runs sucessfully if it is manually executed: i.e using db2 -tvf sql_file
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21960416