DB Connect using the external DB DB2

[Former Member]

Hi ,

We are trying to create a DB connect to external DB DB2 . As per the SAP note  523622 we have installed DB2 CLI driver and DBSL patch to the System. created a logical system  in BD54 and after that trying to create db connect using the tcode rsa1 when we are saving and coming back and back

it is giving error can not access source system db2admin.

Please let me know if i  have to perform any other steps to come out from this issue.

Thanks,

Pradeep Kumar

[divyanshu_srivastava3]

Hi Kumar,

What is your DB2 system release and FP level ?

What about DBSL and CLI driver - your source and target OS?

Refer

1267189 - DBA Cockpit: DB2 for LUW as Remote Database

1265134 - DBA Cockpit: Connecting a remote database

Regards,

[Reagan]

Could you supply the DCON details please?

Also call Tx RSA1 and select the source system and provide the connection parameters maintained there.

What is the output when you do a "Check" for the DB Connect entry?

Cheers

RB

[Former Member]

Hi Reagan,

Thanks for your response.

i am attaching the DBCON detail here. i have created two connection inside this table.

there is no entry in db connect due to above error.

Regards

Pradeep.

[Reagan]

Hello Pradeep

Are you sure that the schema name is DB2ADMIN?

DB6_DB_SCHEMA=DB2ADMIN

What about the user used? Is that a valid user?

Cheers

RB

[Former Member]

Hi RB,

Schema name is correct. same Schema and user id  configuration is working on other system.

i am new  for db2 so i dont have clear idea about this, as per note 523622 i have installed db2 client and DBSL patch. after that i have created dbconnect  under the source system but it is giving error and not creating. Shall i need to perform any other steps to create a db connect.

Please share the steps which is require to connect external DB2 for db connect.

Regards,

Pradeep

[Reagan]

Hello Pradeep

Could you call Tx Se38 and run the report ADBC_TEST_CONNECTION and check if you are able to see the connection there and test it?

If yes could you supply the error log. Where did you install the client software? I mean the directory.

Cheers

RB

[Sriram2009]

Hi Pradeep

1.  You can check the error message in SM21 log. Could you share the error message in detail?

2.  Could you check this SCN link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae5...

BR

SS

[Former Member]

Hi Sriram,

Thanks for your reply.

SM21 log says connect to the database with source system failed.

and after saving source system it is saving but when coming back to the previous screen it giving the below error.

i have to gone through this PDF .one thing i have missed in my procedure one steps has skipped .

this step is skipping in my system. kindly please let me know m i missing any steps.Due to this some step are skipping.

Regards,

Pradeep

[Sriram2009]

Hi Pradeep

Yes, it may be, better you can recreate the connection once again. 

BR

SS

[Former Member]

Hi Sriram,

Facing the same problem during creation of  new connection.

any idea how to overcome from this.

Regards,

Pradeep

[manumohandas82]

Hi Pradeep ,

Are you able to connect from the OS level  of the source to the target ( DB6 db)

Please check SAP Note 200164   .

Please send a screenshot of your TXN DBCO

Thanks ,

Manu