Connection Problem of Xmeta Database on Datastage

Question

I have a problem about connection of the db2 connector to metadata repository database (XMETA- inside datastage- not remote). I can connect to XMETA database on terminal with db2inst1 user. But I can not connect with DB2 Connector Stage with the db2inst1 user.

I gave this error;

"SQL1013N The database alias name or database name "XMETA" could not be found. SQLSTATE=42705"

Is there any suggestion about this situation?

Thank you in advance.

score 0 · Answer 1 · answered Nov 16 '18 at 06:25

0

I suggest to catalog the database as a remote one even though it is on the local system. For Db2 this could be done by running a catalog tcpip node command and a catalog database. You might have to use a different DB Alias to differentiate the two entries in the system database directory.

answered Nov 16 '18 at 06:25

MichaelTiefenbacher

3,805
2
11
17

But I can connect to database with the same user on terminal. If it is not be catalog, how can I connect to this database same user on terminal? – Hülya Bahçebaşı Nov 16 '18 at 07:02
Have you tried it? For a local connection Db2 is not waiting for a password and therefore you as db2inst1 are able to connect through the command line. Give it a try it might solve your problem – MichaelTiefenbacher Nov 16 '18 at 11:44
Thank you Michael. I will try to catalog. – Hülya Bahçebaşı Nov 18 '18 at 12:31

Connection Problem of Xmeta Database on Datastage

1 Answers1