Connect to DB2 in dbacockpit via saprouter?

[Former Member]

I am trying to connect to DB2 databases to the dbacockpit in solution manager. The challenge is the databases are on numerous remote networks. We have SAP Routers on each network which we use for RFC connections allowing the managed systems to be connected to our solution manager.

I have searched and found methods to connect remote MAX DB and Oracle databases to solution manager dbacockpit but nothing for DB2.

Please advise if there is a method to achieve this, we are using Solution Manager 7.1 SP08.

[AtulKumarJain · Accepted solution]

Hi David ,

Please check SAP Note No. 1265134

DBA Cockpit: Connecting a remote database

BR

A tul  

[Former Member]

anything new? we would know it too

[Former Member]

Hi Dieter

MaxDB can connect via the SAProuter, however since DB2 is outside the SAP stable of products it is not really supported by this architecture that I am aware of. Perhaps someone from the SAP DB2 integration team can comment on this.

[Former Member]

Hi David,

Could you connect to a remote Database successfully using SAP Router. If yes, can you please let me know how?

Thank you.

Best Regards,

Shilpa

[Former Member]

Steps that we took:

Call transaction SOLMAN_SETUP > Select Managed System Configuration > Select Managed System with DB2 Database and Click the Configure System button> Go to step 5 Enter System Parameters> Mark Setup DBACockpit / DB extractors.

Specified the following for the database connection:

Database host = /H/<SAPROUTER HOST>/S/3299/H/<SAPROUTER HOST>/S/3299/H/<DB Host>

Database Name = <SID>

Port = <Listening Port of DB>

Database  User = DB2<SID>

Password = *******

Then we get the below error.

  Database connection <SID>: SQL error 1336- SQL 1336N The remote host “/H/<SAPROUTER HOST>/S/3299/H/<SAPROUTER HOST>/S/3299/H/<DB Host>” was not found. SQLSTATE=08001

[maria_shen]

Hello David,

For the above specific error, it is recommended to create a SAP ticket for further help on the setup.

Thanks and kind regards

Maria

[maria_shen]

Hello David,

Below document may help.

http://scn.sap.com/docs/DOC-43039Connect to DB2 in dbacockpit via saprouter?

Monitoring IBM DB2 for Linux, UNIX, and Windows in SAP System Landscapes Using SAP Solution Manager 7.1

(Chapter 3: SAP Solution Manager Setup: Setup of Managed Systems)

Kind regards

Maria

[Former Member]

Hi Maria

Thanks but document assumes the machines are on the same network or at least the solution manager or DB2 client can see the DB2 server. If we establish a VPN to  the client this works, but we have multiple clients so  establishing a VPN is not a viable solution, besides the network confusion caused by this. We are using the SAP Router and Web dispatcher to get past most of those issues.

MaxDB allows you to use a router string as the hostname for  the database server. Oracle allows for RFC connections. when we try this on DB2 connection we get this:

Steps that we took:

Call transaction SOLMAN_SETUP > Select Managed System Configuration > Select Managed System with DB2 Database and Click the Configure System button> Go to step 5 Enter System Parameters> Mark Setup DBACockpit / DB extractors.

Specified the following for the database connection:

Database host = /H/<SAPROUTER HOST>/S/3299/H/<SAPROUTER HOST>/S/3299/H/<DB Host>

Database Name = <SID>

Port = <Listening Port of DB>

Database  User = DB2<SID>

Password = *******

Then we get the below error.

  Database connection <SID>: SQL error 1336- SQL 1336N The remote host “/H/<SAPROUTER HOST>/S/3299/H/<SAPROUTER HOST>/S/3299/H/<DB Host>” was not found. SQLSTATE=08001