I met the same problem today. After I did the following setting, it works!
1. set the user dsadm and it's group's id all the same on all cluster;
2. not only set home directory .rhosts but also set /etc/hosts with all cluster info;
Wish it help :D
Search found 2 matches
- Tue Dec 20, 2005 1:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to setup DataStage for MPP system
- Replies: 14
- Views: 13669
- Wed May 25, 2005 10:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: user defined sql
- Replies: 6
- Views: 2612
user defined sql
I have a user-defined sql in Oracle Stage, which works fine in parallel job but failed in server job. UPDATE test_table SET IS_EXPIRED = 'Y' WHERE (COL_ID in (666, 667) ) error message in server job is: ORA-01722: invalid number Does anyone know why it won't work in server job? Thanks in advance!