I have created Environment variables like DSN,UserID,Pwd at Project Level in UserDefined variables.
My job is parallel job, when i try to pass those enviroment variables as parameters to the parallel job, job is aborting saying that Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 server '#$DEV_SRC_DB_SERVER#'.
But when i give actual value without parameters, the job is working fine.
what could be the reason ?
Job Aborted
Moderators: chulett, rschirm, roy
</a>When i remove #, it is giving the error Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 server '$DEV_SRC_DB_SERVER'.
do i need to create these Environement varaibles in Parallel Environment in Enviroment Variables button of DS Administrator for a particular project when i try to pass these parameters in parallel job ?
The heirarchy of Navigator is like this in Enviroment variables in DS Admin tool.
General
-->customize
Parallel
--> OperatorSpecific
-->compiler
UserDefined
Even i tried in Parallel --> OperatorSpecific, but i could not able to create a variable as it is not creating a record to add a new enviroment variable except in UserDefined Enviroment.
has anybody encountered this kind of problem ?
do i need to create these Environement varaibles in Parallel Environment in Enviroment Variables button of DS Administrator for a particular project when i try to pass these parameters in parallel job ?
The heirarchy of Navigator is like this in Enviroment variables in DS Admin tool.
General
-->customize
Parallel
--> OperatorSpecific
-->compiler
UserDefined
Even i tried in Parallel --> OperatorSpecific, but i could not able to create a variable as it is not creating a record to add a new enviroment variable except in UserDefined Enviroment.
has anybody encountered this kind of problem ?
some more info i am updating here.
when i press view data of DB2_UDB_API Stage have parameters as environment variables for DSN , UserID, Password, it is connecting to database and displaying the records properly.
But, when i try to run the job, it is giving the error
Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 server '$DEV_SRC_DB_SERVER'
i am just wondering why this is happening at runtime
when i press view data of DB2_UDB_API Stage have parameters as environment variables for DSN , UserID, Password, it is connecting to database and displaying the records properly.
But, when i try to run the job, it is giving the error
Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 server '$DEV_SRC_DB_SERVER'
i am just wondering why this is happening at runtime
How are you running this job? Using dsjob ?
Looks like that perticular parameter is not setting at runtime. Look in the director job log for environment variable settings of that job. see what your variables are set to at runtime?or else only that variable is not set and other variables are set......
you can declare shell variables (user defined environment variable names) in your script and assign values to it and export them before dsjob command. Thats how you set your env variables in script.
If you are running using dsjob in shell script, you need few things:
1.Source dsenv file to your script
2. use -local option in dsjob command
3. you need to be in the project directory to run dsjob with -local(if you set the bin path and cd to projects directory, should be fine)
Hope this will help....
Kris~
Looks like that perticular parameter is not setting at runtime. Look in the director job log for environment variable settings of that job. see what your variables are set to at runtime?or else only that variable is not set and other variables are set......
you can declare shell variables (user defined environment variable names) in your script and assign values to it and export them before dsjob command. Thats how you set your env variables in script.
If you are running using dsjob in shell script, you need few things:
1.Source dsenv file to your script
2. use -local option in dsjob command
3. you need to be in the project directory to run dsjob with -local(if you set the bin path and cd to projects directory, should be fine)
Hope this will help....
Kris~