Hi Gurus,
Am getting following error.
UDA-QOS-0006 Error
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[IBM][CLI Driver][DB2/AIX64] SQL1585N A system temporary table space
with sufficient page size does not exist. SQLSTATE=54048..
can any help me to fix this issue???
thanks in adv.
This looks more like a DB2 thing than a Cognos issue. Your DBA should more about these type of messages..
[size=1.166em]Hi,Diagnosing the problem
[/size]Netezza DB supports WITH clause from v6. In Cognos, whether to throw WITH clause to Netezza DB is determined, based on the following definition in <cognos_root>\bin\cogdmod.ini.
---[size=inherit]
[Exceptions Clauses DATABASE:NETEZZASQL]
With="with "
[Exceptions Clauses DATABASE:NETEZZASQL VERSION:05.00]
With=
[Exceptions Clauses DATABASE:NETEZZASQL VERSION:04.00]
With=
[Exceptions Clauses DATABASE:NETEZZASQL VERSION:04.05]
With=
[Exceptions Clauses DATABASE:NETEZZASQL VERSION:04.06]
With=
[Exceptions Clauses DATABASE:NETEZZASQL VERSION:03]
With=
[/size][/color]---
Note: Based on this default definition, Cognos does not throw WITH clause to versions (05.00.x, 04.00.x, 04.05.x, 04.06.x, 03.x). In other words, Cognos throws WITH clause to Netezza DB 5.2[/size][size=1.166em]Resolving the problem
[/size][/color]You can use one of 2 methods (Method 1 & Method 2) below if you need system wide solution.
[/color][size=inherit]Method 1:[/size]
Make backup for cogdmod.ini first and edit content of cogdmod.ini as below.
[/color][/color]<Before>
[size=inherit][Exceptions Clauses DATABASE:NETEZZASQL VERSION:05.00]
With=[/size][/color]
[/size][/color]<After>
[size=inherit][Exceptions Clauses DATABASE:NETEZZASQL VERSION:05]
With=[/size][/color][/color][size=inherit]Method 2:[/size]
Make backup for cogdmod.ini first and add a new definition as below.
[/color][/color][size=inherit][Exceptions Clauses DATABASE:NETEZZASQL VERSION:05.02]
With=[/size][/color][size=1.166em]