Skip to Content
avatar image
Former Member

Connect to DB2 in dbacockpit via saprouter?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Oct 10, 2013 at 03:52 AM

    Hi David ,

    Please check SAP Note No. 1265134

    DBA Cockpit: Connecting a remote database

    BR

    A tul  

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2013 at 07:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2013 at 01:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Apr 22, 2014 at 10:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2015 at 11:32 AM

    anything new? we would know it too

    Add comment
    10|10000 characters needed characters exceeded

    • 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.