DB2 - tax factory connectivity issue

[Former Member]

Friends,

Have anyone come across this issue with tax factory ?

We have Db2 server on one node and SAP is running on other node.

We configured tf80server.csh with following enviroment variable

setenv DB2INSTANCE

setenv DB2DBDFT

setenv DATABASE

setenv DB2USER

setenv PASSWD

when we run tax factory test sfotwar from R3, it is "system failure" error and then in the error.txt we have the following

ConnectToDataSource...failed

Error String -> 7777 - [IBM][CLI Driver] SQL1531N The database alias "XXX" could not be found in the db2dsdriver.cfg configuration file.

SAP is working fine.

I am not sure how to configure tf80server.csh file in order to connect to the database which is running on other node.

This issue is only on HA system ( DB and SAP are running on different nodes). We have other systems where SAP AND DB2 running on same systems and with the above tf80server.csh file it works fine.

Any suggestion or help to fix this issue ?

Thanks!

[Former Member]

DB2 instance needs be installed on both the nodes.

[Former Member]

Upgrading TaxFactory from 8.0 to 9.0. Following SAP Note 1469858 to load BSI Machine Key with tf90lic cmd in tf90lic.csh and Got the similar problem

ConnectToDataSource() failed: 7777 - [IBM][CLI Driver] SQL1531N The database alias "SID" could not be found in the db2dsdriver.cfg configuration file.

Tried to use db2dsdcfgfill -i <instance-name> to populate db2dsdriver.cfg but got

SQL3901N A non-severe system error occurred. Reason code "22".

Our DB is running with DB2 v9.7.0.3. Found a document saying db2dsdrvie.cfg is no longer for 9.7 with fixpack3.

Anybody could help???!!

[Former Member]

Hi,

Have you tried SAP note 1564507 (DB6: SQL1531N alias "<DBNAME>" not found in db2dsdriver.cfg)?

You may need to maintain db2cli.ini instead of db2dsdriver.cfg. Please confirm if your db2cli.ini has a correct entry for your database.

Regards,

Masako