/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Moderators: chulett, rschirm, roy
/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
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
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
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
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
A Kumar
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/
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/
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.
Wondering if you've done all the setup / configuration steps needed for DB2 access.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
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
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
regards
Michael
Michael