DSXchange

Thanks a lot Ray, It worked. :D

I am marking this thread as resolved and closing it.

Hi, I am executing the below command in execute command activity.The output from the command is 4 expr `date +%Y` - 2007 and passing the output of this command to start loop activity. i want the loop to be executed the number of times the output from above command. But i am getting the below error. ...

Check this link ...

https://www-304.ibm.com/support/docview ... wg21454584

I found out that my libpath was not setup correctly for AIX...

You need three joins for three files

One is left outer , one is right outer and one is equijoin...

All our DEV and QA servers are configured the same way from the infrastructure perspective. Same systems, same CPUs, Memory, same network switches, same disks, same SANs etc. So whenever we encounter a difference in performance between one environment and another, in our case, most of the time the p...

I had the 'root' go and chmod -R 775 everything in the bad project directory and that fixed the issue.

Now bchusr can login and compile/run/add jobs in the bad project directory.

Still don't know how the permissions got messed up.

Marking the thread as resolved. Thanks everybody for your time.

I have created a new project and everything is working just fine in it. I imported the DSX into this new project while logged in as "dsadm" and then i logged in as "bchusr" and am able to do everything that i was not able to do in the old project. So the testing team is happily w...

Should i chmod -R 775 the entire project directory ? Could something have changed at the websphere layer ?

By the way - Love the quote in your signature

chulette i dugged and dugged and could find nothing wrong ...which is why i am here seeking guidance from the all knowing gods of Datastage like you and Ray :-) I have looked at the file permissions in project directory. They are all at 775 as they should be ... Where else should i look ? All this u...

Paul - no. Not protected and all files are intact. As i mentioned in my first post, i can access everything just fine if i use the admin user id of dsadm.

group is dsadm (gid = 15) $DSHOME/bin and objects in it are owned by dsadm:dsadm I imported the DSX into the nonworking project as dsadm and bulk compiled them with dsadm. So all the objects under the project directory are also owned by dsadm:dsadm. However i have similar setup in all other places a...

hello paul

i did create the project that is not working in a different path.

but the second test project i created is also in the same different path and it is working fine with bchusr.

Hi Ray Thanks for coming to my rescue. The permissions on the project directory were rwxrwxr_x. Both dsadm and bchusr accounts are member of the same groups. I changed it to rwxrwxrwx just the same. The permissions on the DSEngine directory are the same - drwxrwxr-x 37 dsadm dsadm 8192 May 16 02:44 ...

People who fix a problem by themselves and then fail to tell the community how they fixed it do not understand the concept behind community at all. There should be some way to ex-communicate them ...

thanks Ray