Failure to create tables in the warehouse

The problem: You might encounter errors in the Warehouse Proxy agent logs similar to the following example:

4B94AF42.0026-8:khdxrpcr.cpp,513,"run") Tivoli Export Server Ready 
for Operations
(4B94AFEE.0000-A:khdxjdbc.cpp,2330,"SQL_Tables") Calling SQLTables 
using owner <ITMUSER> tablename <WRT_SubTransaction_Instance>
(4B94AFEE.0001-A:khdxjdbc.cpp,3980,"processJavaException") 
Exception message: execDirect Error :
...
+4B94AFEE.0003 Caused by: com.ibm.db2.jcc.c.SqlException: 
DB2 SQL error: SQLCODE: -286, SQLSTATE: 42727, SQLERRMC: 8192;ITMUSER

The solution: The user that is configured for the warehouse proxy agent to access the database needs to be granted access to an 8K tablespace. The following example shows how to do this for DB2:

1. Connect to the database with a user that has admin authority, using the following command:

   # db2 connect to warehous user <admin user name> using <password>

2. Find the name of the 8k tablespace, using the following command:

   # db2 list tablespaces show detail  

   In this case the 8k tablespace is ITMREG8k:

   Tablespace ID        = 3
    Name                = ITMREG8K
    Type                = System managed space
    ... 
    Page size (bytes)   = 8192

3. Grant permissions for ITMUSER using the following command:

   # db2 GRANT USE OF TABLESPACE <tablespace name> TO ITMUSER

4. Restart the Warehouse Proxy agent and the Summarization and Pruning agent. The tables should be created during the next export operation.