[Solved]Need connection to DB2 database...

[DWB]

kindly suggest me as soon as possible...

[Darek]

You need DB2 client on your PC and the database in your local catalog.

[DWB]

i have DB2 client on local system but am not able connect. i have no idea about database in local catalog. please explain me how to connect using DB2 client.

[Darek]

Do you have any support for DB2 at your site? Like a DB2 Admin.

[DWB]

Hi

actually i dont have much idea about DB2, COGNOS Frame Work manager and COGNOS Reportnet..
i have DB2 client, COGNOS Frame work manager installed in my system and COGNOS Reportnet, DB2 are installed on server.
i need to connect to DB2 to publish a package and generate reports..
i can connect to COGNOS Reportnet, which is installed on server from my system..

please put more light on this....

thanks in advance...

[sir_jeroen]

Can the server on which ReportNet is installed connect to the DB2 database?
This because ReportNet connects to your Database even when you a running FrameWork Manager on your pc (client).
Maybe you have to install the DB2 client on your ReportNet server.
Do you have any tool installed on your server with which you can try to connect to the DB2?
You can try it with QueryTools which you can download at http://gpoulose.home.att.net/

[DWB]

Hi
DB2 and Reportnet server are on the same system and Reportnet server is able to connect to DB2...and we installed Frame work manager on server and tried to import metadata but unable to connect to DB2...

please let me know how to connect to DB2 from Framework manager...

[sir_jeroen]

And are you able to query that DB2 Database?
Try it using the Query Tool and try to do it without an ODBC connection but with a native data provider.

If you look in <crn-location>\bin\cogdmd2.ini you see all DB2 databases which are supported by native protocols.

In some cases ReportNet isn't able to import tables/ views/ etc. from the database.
But what if you manually create a Database Query Subject like Select * from TableA
Does this work? If so, you can manually import all the tables you need.

[Darek]

Keep in mind that FM will look in local DB2 catalogs to get connected to the database.

[DWB]

Hi,

querying is possible from Reportnet by connecting to DB2 but unable to connect from Framework manager..

Reportnet, Framework manager and DB2 are installed onm server itself...

can i know the format of connection string for DB2, which Framework manager supports to connect to DB2?

please put more light on this....

Thanks

[sir_jeroen]

I don't know if this is of some help for you put you can take a look at:
http://www.connectionstrings.com/

What error do you get when you try to connect. As Darek stated above: have you tried specifying the schema / catalog in your database connection in Framework manager?

[sir_jeroen]

Catalog = DatabaseName
Schema = Database owner

You can enter this manually under: DataSources in Framework manager

[sir_jeroen]

Can you let us know what the status is of this topic?

[DWB]

Hi

Now i can connect to DB2 from framework manager and publish packages..
DB2, Reportnet and Framework manager are installed on server itself. After installing Reportnet, configuration about content manager and datasource is done on server and then we installed framework manager.

If we want to publish package from our client machine, we have to configure Reportnet on server before installing Framework manager on our client machine.

Thanks for all and thanks for all your efforts...