SQL queries to IBM Tivoli Data Warehouse fail because of invalid column name

When you are writing a Structured Query Language (SQL) query against IBM® Tivoli® Data Warehouse (without using the Tivoli Enterprise Portal) where your database manager is DB2® or Oracle, the query sometimes fails, indicating that the column name is invalid.

The cause of this problem might be that your column name is greater than 30 characters in length, and DB2 and Oracle do not support column names greater than 30 characters.

The Warehouse Proxy Agent creates the table with the abbreviated column names. These abbreviations are shown in the WAREHOUSEID database table.

Additionally, column names that seem to meet the fewer than 30 characters rule might also fail when the Summarization and Pruning Agent is used because this agent adds a four-character prefix to the column name (for example, AVG_).

To avoid this problem, revise your SQL queries to match the abbreviated column names in the WAREHOUSEID table.