Page 1 of 1
/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Posted: Tue Apr 07, 2015 12:35 pm
by abbhi
Hello,
I am attempting to write to a DB2 stage and receiving the following error. Below is information to help assess the situation and hopefully resolve the issue.
Below is the error i am receiving.
/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be readable by all users!
This is a new job i have created and when i checked /app/DB2Client/DB2V97/sqllib i dont find the file db2nodes.cfg.
Do i need to create the file?
Please help to resolve the issue.
Thanks,
Abhishek
Re: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist an
Posted: Tue Apr 07, 2015 1:31 pm
by electajay
once you login to the DB2 server with the instance owner id.
cd <Enter>
cd sqllib <Enter>
pwd
ls -ltr db2nodes.cfg
-r--r--r-- 1 db2xdmet db2xdmet 16 Apr 24 2013 db2nodes.cfg
if you cat that the file you will see the hostname.
either you need to source the Path and include DB2 profile in your profile.
Thanks
Ajay
Posted: Tue Apr 07, 2015 1:37 pm
by abbhi
Hi Ajay,
I don't see the file on my datastage server in the specified path ?
Do you need to contact db2 admin related to this.?
The db2 is installed on our datasatge server itself.
Thanks,
Abhishek
Posted: Tue Apr 07, 2015 1:42 pm
by electajay
So you have the db2 repository (xmeta) installed on the same server?
then cat /etc/passwd and see the db2 id and login with that id and see if you can find or else you can update the path
echo $PATH
env
send me the command output.
Posted: Tue Apr 07, 2015 2:49 pm
by abbhi
I found this entry in /etc/passwd
db2adm
370:370::/app/DB2Client/DB2V97:/bin/sh
we don't have access to login through db2adm id.
output of echo $path
/app/IBM/InformationServer/Server/PXEngine/bin:/app/IBM/InformationServer/Server/PXEngine/osh_wrappers:/app/IBM/InformationServer/Server/DSEngine/bin:
/app/IBM/InformationServer/Server/DSEngine/DSComponents/bin:/app/oracle/product/11.2.0/client_1/bin:/app/DB2Client/DB2V97/sqllib/bin:/opt/teradata/client/13.10/tbuild/bin:
/usr/bin::/usr/local/bin:/usr/X11/bin:/usr/openwin/bin::/opt/mqm/bin:/usr/sbin:/app/IBM/
Posted: Tue Apr 07, 2015 3:15 pm
by chulett
I'm curious... I see that this job is new but is this also the first time you've attempted to connect to this DB2 instance? Any DB2 instance? Or do all others work fine and the problem is just with this one job?
Wondering if you've done all the setup / configuration steps needed for DB2 access.
Posted: Tue Apr 07, 2015 3:52 pm
by abbhi
yes this is a new job and the only difference in this and other job is that this is one writing to db2 and other arr reading from db2.
Should i try this job using db2 api stage instead of enterprise stage or if you can suggest some other alternative ?
All db2 setup has been done correctly on the server.
Posted: Thu Apr 09, 2015 11:26 am
by electajay
you can use db2 api stage if the catalogging is done.
Posted: Mon Apr 13, 2015 12:36 pm
by MT
Hi Abhishek,
why are you not using the DB2 Connector - relly recommended when using DS8 as described!
The db2nodes.cfg is only available in partitioned DB2 databases - so yes it might be a good idea to ask your Db2 admin. But again if you use the Db2 Connector you do not have to worry about the dbnodes.cfg....
The DB2 API stage and DB2 EE stage are outdated do not build something new with old stages!
If you want some hints join my websession on Friday
www.db2nightshow.com
best regards
Michael
370:370::/app/DB2Client/DB2V97:/bin/sh