Author Topic: URGENT- NEED HELP Unable to connect to DB2 using framework manager  (Read 1504 times)

Offline addicted2cognos

  • Full Member
  • ***
  • Posts: 13
  • Forum Citizenship: +0/-0
The datasource we created is able to test successfully, but when i import metadata from FW mgr, try to connect to that datasource it gives me this error:

QE-DEF-0177 An error occurred while performing operation 'sqlOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "sqlOpen".
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
[IBM][CLI Driver][AS] SQL0805N Package "NULLID .SYSSH200" was not found. SQLSTATE=51002

Please Help

Offline cognosengine

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +0/-0
Catalog your database by running DB2 scripts on your local machine and ask your DB2 Administrator to give the scripts and also read /select previleges on the schema

Offline lalithabmk

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Try to check if Datasource is working on the machine that Framework Mgr is loaded.