Hi,
I am running DataStage 8.1 and am getting the following error:
The file `/home/dsadm/remote_db2config/maxinst/sqllib/db2nodes.cfg' must exist and be readable by all users!
I made the following verifications:
1. The file `/home/dsadm/remote_db2config/maxinst/sqllib/db2nodes.cfg' DOES EXIST, and has read permissions for everyone.
2. Similar jobs running DB2EE with same configuration run without errors.
3. I have set the env. variable APT_DB2INSTANCE_HOME to the value /home/dsadm/remote_db2config/maxinst, which is the same as in other jobs (Jobs running OK)
4. The log shows the error mentioned above, and beneath it, another error: Message: DLY_high_redemption_alarm,14: The runLocally() of the operator failed.
EXPERTS, PLEASE ANSWER.
Thanks,
--Raj
db2nodes.cfg must exist and be readable by all users!
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: db2nodes.cfg must exist and be readable by all users!
Hi ,
Is this error a 'compile time error' or a 'run time error' ?
Regards
Sreeni
Is this error a 'compile time error' or a 'run time error' ?
Regards
Sreeni
tfrajk wrote:Hi,
I am running DataStage 8.1 and am getting the following error:
The file `/home/dsadm/remote_db2config/maxinst/sqllib/db2nodes.cfg' must exist and be readable by all users!
I made the following verifications:
1. The file `/home/dsadm/remote_db2config/maxinst/sqllib/db2nodes.cfg' DOES EXIST, and has read permissions for everyone.
2. Similar jobs running DB2EE with same configuration run without errors.
3. I have set the env. variable APT_DB2INSTANCE_HOME to the value /home/dsadm/remote_db2config/maxinst, which is the same as in other jobs (Jobs running OK)
4. The log shows the error mentioned above, and beneath it, another error: Message: DLY_high_redemption_alarm,14: The runLocally() of the operator failed.
EXPERTS, PLEASE ANSWER.
Thanks,
--Raj
This is a run time error.
IBM gave a work around for this problem.
It appears that this is a bug and will perhaps be patched up in the future.
The work around is to create an EMPTY "db2nodes.cfg" files on the remote DB2 servers in the same directory location as it exists on the datastage server. The file need not contain anything, it can be EMPTY. Just touch the file.
This will resolve the errors, and the job continues execution.
IBM gave a work around for this problem.
It appears that this is a bug and will perhaps be patched up in the future.
The work around is to create an EMPTY "db2nodes.cfg" files on the remote DB2 servers in the same directory location as it exists on the datastage server. The file need not contain anything, it can be EMPTY. Just touch the file.
This will resolve the errors, and the job continues execution.
krs