DSXchange

Have you tried using your reporting assistant (located in Manager)? Alternatively, the usage analysis? Vincent, Brad wrote: >Im running DataStage 5.2 on an NT Server. We have several jobs and a few >routines which use sequential stages. The pathname for these files is >usually something like: >D:Pro...

Hi Tim, Oh, yes. I agree. Weve been using parms for years for everything except sequential file pathnames. That was due to problems we had with it when we were still back on DataStage Release 3.1.1. Since thats now behind us (yea!), and works fine in DS 5.2, were now ready to enter the 21st century....

Well, we have checked it out here and (unfortunately) the peoples with the purse-strings are all singing the "aint got no money for more software" blues. So right now, I am the Parameter Manager. Good thing its not really that big of a deal... typically its only needed when the batch that controls t...

Then check out Parameter Manager (m) so that you can manage your parameters "globally". Disclaimer: I am not employed by Tools4DataStage and do not receive any reward for mentioning their products. ----- Original Message ----- From: Craig_Hulett@rsausa.com Date: Mon, 13 Jan 2003 14:38:28 -0700 To: S...

Are you using any routines to write to this repository? Shawn Ramsey wrote: >All, > > >We have experienced at least 4-5 incidents of the corruption of our >DataStage repository over the last 9 months. All I have gotten from >support is to rebuild the indexes using DS.TOOLS (which has never >worked) ...

----------------------------------------------------------------------------------------------- Have you seen our website?.... m CAUTION: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you...

Brad, As a future development "Best Practice", anything that can change when you migrate from one environment to another should be replace with a Parameter. Typical Parameters are: Root Directory DSN Logins Passwords If you want the dirty way to do mass updates to pathnames, there is one way that I ...

Actually V0S0 is a stage record, rather than a container record, but that doesnt take anything away from Kens analysis that something, probably space, has caused a problem with the DS_JOBOBJECTS hashed file. ----- Original Message ----- From: Kenneth Bland Date: Mon, 13 Jan 2003 12:30:50 -0800 (PST)...

Cant really help you with the string search dilemma, but goodness... this is why Job Parameters exist and why they should really be your bestest buddy. You should really consider working parameters into your job for the environment or whatever you want to call Prod, Test, etc. they can then be subst...

Export all the Jobs/Ruotines/Transforms via DataStage Manager, and search the resulting dsx file using NotePad or an editor of your choice. Thanks, Lester F. Callif / Centennial, Co -----Original Message----- From: Vincent, Brad To: DataStage Mailing List Sent: 1/13/2003 4:05 PM Subject: string sear...

Im running DataStage 5.2 on an NT Server. We have several jobs and a few routines which use sequential stages. The pathname for these files is usually something like: D:Proddatareadymaininput.txt or D:Testdatareadyspecial.txt etc. As you can see, the first part of the pathname after the drive letter...

Your job, #1597, does not have its initial container record. All jobs have this record, so it looks like you have a job that was not able to save all of its pieces. This job is most likely irretrievably damaged. Youre going to have to go back to your version control and get another copy of this job,...

The error that I received this time was: Record J1597V0S0 in file DS_JOBOBJECTS does not exist -----Original Message----- From: Glenn Herbert [mailto:glenn.herbert@ascentialsoftware.com] Sent: Monday, January 13, 2003 11:43 AM To: datastage-users@oliver.com Subject: RE: Corruption of 5.2r1 DataStage...

Is there any indication as to the nature of the corruption? Error logs, etc., that might show where the corruption is occurring? At 02:20 PM 01/13/2003, you wrote: >Yes, > >We are running a custom Batch Automation process created by a Ascential >consultant. > >-----Original Message----- >From: J. Sc...

Starbucks is discovering one of my recommended best practices. DataStage allows users to create hash file in the default project. The hash file also has the capability to use an explicit directory path for locating the hash file. This allows you to map hash files into a foreign directory from the Da...