Getting below error when one of the user is trying to run a report from cognos:
CNC-ASV-0025 Agent Condition invalid: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "prepare". [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048
however I have an 32K pagesize temp tablespace.
When I run the query seperately through commandeditor it is giving the result. Am I missing anything?
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be