/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be

[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

[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

[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

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

[abbhi]

I found this entry in /etc/passwd

db2adm370: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/

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

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

[electajay]

you can use db2 api stage if the catalogging is done.

[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