DSXchange

Can I have a stage variable whose derivation returns a dynamic array? If so, how do I access the individual values of this array for subsequent derivations on the output links? I tried using stagevarname<n> with no luck.

We are currently in the process of trying to "lock down" access to our production environment, but in the meantime there is more than one user who has access to schedule jobs there. I have run into an issue where a re-scheduled job has failed because the job's reject (flat) file was origin...

Despite the documentation, I went ahead and tested the Operator role again just in case the filter had any effect. Unfortunately, it works exactly as documented. When I log into the Director as an Operator there are no visible jobs and toggling that particular checkbox in the filter has no effect......

Craig, thanks for your reply. I'm sorry to say that I'm pretty certain that protected projects and VC are not a match right now (7.0). I tested VC promoting to them and the complile operation always failed. Ascential Support stated that this was the correct behavior. If you cannot use VC to promote ...

We're new users to DataStage, basically getting started on version 7. I would like to make use of VC and protected projects and/or roles, but I keep running into little issues that foul up my plans. The first hurdle is that protected projects don't seem to allow VC to compile the promoted projects. ...

We are planning on moving DS from one Unix server to another. DS is installed on the original server in a volume that resides on our SAN. Everything is contained within (incl Oracle client stuff) with the exception of things such as /.dshome, user-related stuff, cron-related stuff, etc. If the new s...

I would like to use the OCI9 stage with either the Update/Insert or Insert/Update action, but the insert statement will require the use of a sequence, which I typically handle via user-defined SQL.

Is there a way to do this? I can't seem to figure it out. Thanks!

Thanks Ray. What then is the best way to handle this on a production server that potentially has jobs running all the time? (We tend to use DS for a lot of frequent but small data integration batches between applications. Some of these occur around the clock.) Should we schedule jobs to avoid starti...

What will DataStage do when dsadm executes uv -admin -stop (or it is executed as part of a system shutdown) when there are running jobs? The documentation seems kind of vague on this and I'd like to know for when we need to shutdown the server for maintenance. Any insight would be greatly appreciated.

I'd like to produce a file daily that includes information such as object name, object type and last modified date for all the jobs, job sequences, shared containers, routines and transforms in our production project(s). (The purpose of this is to provide an audit mechanism so someone can see that s...

Thanks Miguel, but since it wasn't a "hung up" running process, there were no resources to clean up in Director. I didn't try the Clear Status File option in Director. I don't know if this would work or not. There has to be a better way than rebooting the engine or killing processes, doesn...

How do I close an orphaned connection to the DS server? I have a user who was using Designer over VPN when they lost their connection. (Or maybe they just disconnected w/o properly closing the jobs and client...[;)]) Now their job is locked. I can see their connection via netstat and I can also see ...

Ken,

Are you saying there's no need for server file system backups? Or that you should do those AND a client-based, automated export process?

KH

There was a recent post inquiring about a UNIX (server-side) DS export utility, which doesn't seem to exist. I think the person who posted the question was thinking along the same lines that I was for a backup strategy. That it would be nice to export all the projects to the file system and then bac...

We intend to use DataStage for integrating data between OLTP applications. Many of the target tables are in Oracle and have primary keys that are typically populated (by the OLTP application) using a sequence (sequence_name.nextval). Is there a way to get the ORAOCI9 stage to do this with a user-def...