Connection Problem of Xmeta Database on Datastage
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.
etl datastage
add a comment |
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.
etl datastage
add a comment |
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.
etl datastage
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.
etl datastage
etl datastage
asked Nov 15 '18 at 20:27
Hülya BahçebaşıHülya Bahçebaşı
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
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 7: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
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53327409%2fconnection-problem-of-xmeta-database-on-datastage%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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 7: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
add a comment |
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.
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 7: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
add a comment |
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.
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 6:25
MichaelTiefenbacherMichaelTiefenbacher
2,2742714
2,2742714
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 7: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
add a comment |
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 7: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
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 7:02
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 7: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
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
Thank you Michael. I will try to catalog.
– Hülya Bahçebaşı
Nov 18 '18 at 12:31
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53327409%2fconnection-problem-of-xmeta-database-on-datastage%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown