DSXchange

You could give your users Developer rights to a project that is protected, and when you promote jobs into the project (with Version Control), make sure the Read Only option set (yes, you could also go in and muck the readonly flag directly if you like that approach). The main thing in this scheme is...

Arun, You may have run into a system limit, like memory. Log in with the user id used to start the job, and execute the ulimit command to see what limits have been set for that user. Then, monitor the process to see if it runs into any of those limits. Even if they are unlimited, check memory utiliz...

What are your settings for the following uvconfig parameters: RLTABSIZE GLTABSIZE MAXRLOCK We had a similar problem a while back and basically the job startup would time out due to constraints on the message queues. We were instructed to try the following: RLTABSIZE 150 GLTABSIZE 150 MAXRLOCK 149 Yo...

Thanks for the response. Yes, in our process, include dependent components should always be checked as well, and it wasn't in this case. That's why I was surprised when I realized that we had made this mistake, yet the jobs ran fine anyway. Hence the reason for my confusion - whether it is a test jo...

I am noticing some interesting behavior as part of our Version Control usage. On promotion, we set the flags to compile objects and mark them read-only. If a dependent object is missing, it would seem that the job would not be able to compile and we would see that in the compilation report. Instead,...

I have a question that I am sure the DataStage gurus can answer, but I was not able to find in prior posts - Where does DataStage keep the metadata for the creation parameters for a hash file? For example, I want to be able to look up the type, modulo and separation for a hash file - how can this be...

SQL Server can be read via ODBC once you have configured ODBC correctly to access it from your DataStage server. If you are on UNIX or want to have a consistent way to access Excel and have the Java pack you can use POI (http://jakarta.apache.org/poi/) to access the files directly.

Stan

Kim, - or you could just send me Ken's code and bill me for it. Except we already have it (couldn't resist [:)]). Yes, I am aware of this - the code is great, very robust and very well-tested. In general, though (and not being a long-time DataStage developer), I would prefer to move more of the func...

Also depends on what you call (or want to call) an Exception . . . If your definition is the same as the one used to trigger a DataStage Exception stage, then great. By my definition, though, I wouldn't want to continue a sequence if I ran into something that would trigger the Exception stage, so I ...

Craig - Thanks for your post, and all of your other helpful posts to this forum, for that matter. Your assumption of the definition for intiative is correct - we have been using that to differentiate what we might normally be called a project from a DataStage project to avoid confusion. We are not e...

Everything I have read here and elsewhere mentions the use of the VERSION project for the Version Control repository. How does one manage the objects when performing migrations in multiple initiatives? Seems to me that after a few batches for each initiative have been performed it would be difficult...

I too have been the beneficiary of Ray's knowledge and his willingness to share it with the public, and am extremely grateful. I lurked here often and picked up a wealth of knowledge from his posts, and in particular from his complete and detailed descriptions of how to address problems or what Data...

Ray - as usual, great response! Thanks so much for your help.

I have a job which should have terminated but has not. It was a test job to wait a long time for a file to show up. It should have waited for three days, and in the log that is exactly what it said it would do. The three days are long up, however, and according to the log the stage has not completed...