DSXchange

Welcome aboard! :D

Under what user ID do your DataStage jobs run? Check that this user has all required permissions.

A good way to find out is to run a job that contains ExecTCL as a before-job (or after-job) subroutine, it really doesn't matter. In the Input Values field specify the command SH -c id (this will work on Windows because you have MKS installed). The user ID is the first part of the report, the remainder contains group memberships.

Also, how are you mapping the drives? Are they "statically mapped", meaning the drives are mapped no matter who is logged on to the box? Even if you log on to the DS server box as the same account that jobs run under, the mapped drives may not be available when the jobs run, if the drives aren't statically mapped.

Know what I mean?

One way to know if the drives are "available" to DataStage is to create a job with a sequential file as input and try to select a file from the mapped drive. If you can't see the mapped drive from Designer, jobs won't see it when they run.