KB20529: 'Performance of this complex query may be sub-optimal' and ‘Unknown error: SQLCODE -968’ error messages occur when executing a report in MicroStrategy Developer 9.4.1 and 10.x.

SYMPTOM:
When executing a report in Strategy Developer 9.4.1 and 10.x against an IBM DB2 Warehouse, the following error occurs:

Your request could not be processed due to a server error. Please try again. If the problem persists, contact the server Administrator.
(QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Performance of this complex query may be sub-optimal. Reason code: 1 Unknown error: SQLCODE -968Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 2318, Error Code= -2147212544.)

 

It should be noted that the above error contains two parts:
 

(QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Performance of this complex query may be sub-optimal. Reason code: 1

 

and
 

Unknown error: SQLCODE -968Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 2318, Error Code= -2147212544.)

 

The first error is a warning message and is not a cause for query cancellation. It usually appears in conjunction with a second error. Here, the SQLCODE -968 error caused the query to cancel execution.
 
CAUSE:
SQLCODE -968, or SQL0968C can be described as the following:
 

"The file system is full.
Explanation:
One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container.
The statement cannot be processed.
User Response:
Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required.
On unix-based systems, this disk full condition may be due to exceeding the maximum file size allowed for the current userid. Use the chuser command to update fsize. A reboot may be necessary.
This disk full condition may be caused when containers are of varying sizes. If there is sufficient space in the file system, drop the table space and recreate it with containers of equal size.
sqlcode: -968
sqlstate: 57011 "

 

More information can be found at the following link:
 
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql0900.htm
 
ACTION:
Strategy advises bringing in the Database Administrator to review the error. In previous cases increasing the temp space available in the warehouse resolved the error.