Hello,
I'm new to cognos, i installed Cognos 8 BI Starter Edition, i already create the sample database in DB2, now i would like to create a model in FM. But i just cant, when i ty to create the model, i click new project, new db, with name sample, type db2 and DB2 database name: 'sample', but i dont know what to put on DB2 'connect string:' neither in 'Collation sequence:' .Can anybody explain me?I tried a conection string db2 standart but allways gives me an error Report server not responding, when i try to create a model with databases pre-defined like great_outdoors_sale or great_outdoors_warehouse but gives me an error immediatelly
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
great_outdoors_sales
UDA-SQL-0031 Unable to access the "great_outdoors_sales" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
[IBM][CLI Driver] SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
???
so..i'm stucked!can anybody help?Thanks in advance
Did you install DB2 client software to create a native connection to the DB2 instance/database?
In DB2 terms connecting to an instance is an attach. From the error message it looks like db2 cannot resolve which database to acces.
Check this out:
http://www.cognoise.com/community/index.php?topic=5506.0