• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

Connecting DB2 from the unix script

Hi,
    We are using informatica tool.in that we running the script in the pre session.
In pre session we are connecting to the database,
"connect to $DB_NAME user $USER using $PWD"
the exit status of the prev command is 255.and also its not connecting to the database.even its not showing any error.But while checking the error status it is 255

But if i run the script in the unix its workking and connecting tothe database also
What will be problem and what it means that error code 255
-Pari.

0
pari205
Asked:
pari205
1 Solution
 
ajmcgarryCommented:
If you are running the command as above, directly in the Pre-Session, are you considering the Environment Variables.

The command "connect to $DB_NAME user $USER using $PWD" run in Unix with your profile and your Environment Variables is different to the same command run in the Informatica "dtm" process with different Environment Variables.

Try the command hardcoded in the Pre Session with the database, user and password. Or better...... instead of running the commands in the Pre-Session, run a shell script file so you can source the proper parameters. This would also provide more flexibility.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now