DSXchange

Hi Guys, Please help me on below issue, not able to connect to db2 through datastage. main_program: Fatal Error: Could not connect to datasource?? (-1; rpraveen; mwwqa; [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Not authorized to access database %s1.) : Resource bundle corresponding to mess...

Hi Guys,

Please reply how to execute the script i.e. syntax.

Hi Buddy,

I tried the same script in mine production environment and it work fine for me.
But I didn't remembered how I executed that script.
I didn't remember from which user-id I executed the script and in what way , the only thing I know I have to supply the suite admin id and password.

Yeah Buddy,

It is in ASBServer/bin dir

Hi Guys,

Please reply what will be the impact if will run the cleanupabondedlock.sh script from Unix command line.

Prasson,

As previous mentioned it is not showing any active session related to the user.
And user is not able right now.

Ray,

I came to know about the cleanabondedlocks.sh, if I will run this script what will be the impact.
Please reply with your valuable suggestion.

Hi Prasson,

I am not aware of the metadata repository username and password.
Apart then that is there any way to do that.

Hi All, Am facing strange issue , whenever am trying to open the job in designer window it is giving me error message job is locked by the user. However when I tried to see the resource lock through the director client there is no resource lock. After that I tried with the Administrator client , by ...

Thanks for your valuable suggestion.

Thanks , Prasoon.
One more doubt, through which user-id should I run this script , the one which I used to run the datastage job or any of the user-id will be Ok.

much Thanks to Ray, Jwiles and Prasoon for your helps.
Yeah It is working for me , but I got one point if will use this concept for password , it will decipher my password in the datastage log and it will be visible to each and everyone

Hi Prasson,

Is there any way we can dynamically update the parameter value.
Suppose if i'm running the job from command line , then how can I achieve the same.

Hi Ray, I tried with the parameter value file, However I'm running the job by default it is showing (As-predefined) , everytime I have to select the value file name, Is there any way I can make that value file default. Or How I can achieve the same through the Shell script. Please reply with your va...

Hi All,

I have a query , I want to make the changes at the parametset of the datastage through unix .
Is it possible to achieve the same through the unix.

Thanks for your reply.
My datastage version is 8.1.1.
But my main point is that
the licensing of the datastage designer client impact the compilation of the job.