FM Data Validation error

[srinu_anu2007]

Hi,

When iam validating the tables iam getting the below error in FM and i don't see any issues with DB. Can some one help me and i have gone through the some of the links but couldn't found solution related to DB2

Env Details:
OS:AIX
Db:DB2
Cognos FM10.2.2

This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

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:
ISAMPRDB

UDA-SQL-0031 Unable to access the "ISAMPRDB" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

Thanks,

[MFGF]

Hi,

When iam validating the tables iam getting the below error in FM and i don't see any issues with DB. Can some one help me and i have gone through the some of the links but couldn't found solution related to DB2

Env Details:
OS:AIX
Db:DB2
Cognos FM10.2.2

This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

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:
ISAMPRDB

UDA-SQL-0031 Unable to access the "ISAMPRDB" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

Thanks,

Hi,

This tells me you have a problem with the DB2 CLI definition on the machine you are running FM from. My guess is that the Cognos BI server has this connection defined properly, but you are running FM from another machine that does not have the DB2 database defined in the local DB2 client. You can't be running FM from your BI server, since this is an AIX machine and FM does not run on AIX. So, things to check in order:

1. Do you have the DB2 client installed on your FM machine?
2. If so, have you created a local DB2 alias on your FM machine that points to the database?
3. If yes to both of these, have you installed the 64-bit DB2 client libraries by mistake? Cognos can use only the 32-bit client libraries.

Cheers!

MF.

[srinu_anu2007]

Thanks MF.

I have uninstalled DB2 and Fm and again installed both of them, re-pointed DB to cognos and started working.

Thanks,