CQM and Logon Page from Framework Manage - DB2 Connection (Urgent Need)

[gosoccer]

Hi guys,
Good evening, :) :)

When my Model is using CQM, I'm getting a standard Logon page displayed as a part of Testing the Datasource.
DQM doesn't prompt the same Logon Screen. Only the CQM does when the model is set to Compatble Mode of the Query Mode.

Our system admin is saying "The issue you are having might be an attribute to how your db2 client is setup."
Does anyone know what to check if the db2 clientsetup? or any document that explains what needs to be
done at the machine that is utilized for the Framework Manager?

Thanks in advance for your time.
:) :)

[gosoccer]

I'm running Framework Manager in a MS Windows Machine. Thx a lot

[bdbits]

When you are using CQM, you are using a 32-bit Windows client.
When you are using DQM, you are using JDBC.

So the configuration is going to be different. I am not all that familiar with DB2. You should probably talk to your DBA, explaining you are using JDBC and how to configure that.

[gosoccer]

Yeah! you right. Although the Windows OS is a 64 Bit, I checked and the DB2 Driver Client is a 32 bit client so FM should
be fine with that. There seems to be a configuration that is missing as a part of the DB2 Client to connect to this Remote DB.
We normally connect to this DB using our VPN. It seems the database but it raises the Login/Password  screen. 

Thank you

[gosoccer]

ok, getting further. The logon/password screen is not raised but I'm getting the following. PLS see attached.
QE-DEF-0285 - Logon Failed
QE-DEF-0325 - Unable to logon to at least one database during multi-database
RQP-DEF-0068
UDA-SQL-0107

Thanks again for your time

[MFGF]

Yeah! you right. Although the Windows OS is a 64 Bit, I checked and the DB2 Driver Client is a 32 bit client so FM should
be fine with that. There seems to be a configuration that is missing as a part of the DB2 Client to connect to this Remote DB.
We normally connect to this DB using our VPN. It seems the database but it raises the Login/Password  screen. 

Thank you

When you use the DB2 Client to attach to a remote database, Cognos (and or FM) is talking to the DB2 client locally (ie on the same machine). Unless the database is also on the same machine, you're going to need to tell the local client where to find it. You do this by creating a connection to the remote server, then by defining the database you want to connect to. These are some basic instructions I follow (as a DB2 novice):

To connect to a remote DB2 database using CLI you will need to tell the local server about the remote server using the Command Line Processor. This can be found under the DB2 entry on the start menu on your local machine - DB2 Command Window – Administrator.

Firstly you need to use the CATALOG NODE command.  In this example, Power8 will be the thing you reference going forward to identify the remote server, remote is the server name or IP address and server is the port number:

db2 catalog tcpip4 node Power8 remote 10.200.30.167 server 50000

Next you need to tell the local server about the remote database using a CATALOG DATABASE command.  SAMPLE is the name of the database and Power8 is the node defined above and will be the name of the database when you create the connection in Cognos Administration:

db2 catalog database SAMPLE at node Power8

To test the connection, use the CONNECT TO command.  In this example, you provide the username and you will be prompted for the password:

db2 connect to SAMPLE user <username>

To reverse the process, you need to use the UNCATALOG commands as in the examples below.

db2 uncatalog database SAMPLE
db2 uncatalog node Power8


Cheers!

MF.

[gosoccer]

Thank you so much! I followed through the process you mentioned to get it working. YEAHAHAHAH

Yes, I finally got it working but from my PC. From within my Oracle VM (MS Windows 2012), I'm still getting an error but
a different error. But at this point, I'm just going after using the FM on my PC to connect.

In addition, if you got the message saying can not decrypt when Testing the Datasource, I had to do the following to redo some of the encryption FM Model utilizes.

You normally will have to locate your ~installed location/configuration and delete the csk/signkeypair/encryption keys. Open cogconfig again and Save to regenerate keys.

Thank you again. :) :) :)