DSXchange

Yes, We are running a custom Batch Automation process created by a Ascential consultant. -----Original Message----- From: J. Schatz JMS Data Management Inc [mailto:johnshot@bellatlantic.net] Sent: Monday, January 13, 2003 2:10 PM To: datastage-users@oliver.com Subject: Re: Corruption of 5.2r1 DataSt...

Hi Ramsey, > We had a potentially similar problem a number of times in 5.1 on NT 4.0 Ascential support suggested we backup the DriveLetter:AscentialDataStageEngine and then restore it if the problem occurred again. They said if it did not fix the problem, it would help them further in problem determ...

We have experienced a similar situation with MetaStage 6.0 repository running on Window 2000. And suggestion we received from the Ascential is to upgrade to 6.1 as 6.1 is available and supposed to be more stable. Thanks...Kamal -----Original Message----- From: Shawn Ramsey [mailto:SRamsey@starbucks....

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) so we have been forced to build a new repository and import the data. My questions ar...

To execute a command which will show its output in your job log: In the before job window, choose ExecSH and place your command: (Syntax shown for AIX) Use semi-colons to seperate commands... This example counts rows in a file. -----path to your file or shell script----- cd /appl/datastage/projects/...

In Director go to the View pull down and turn off Show Categories. You now get all of the jobs listed. Then click on the Status column once or twice until your jobs are actively sorting by status. This will bubble all running jobs to the top, the only status higher priority is Aborted. Good luck! -K...

Denzil, use the Director. disable in Menu "View" the show categories in the second block. Click in the list on status once or twice and all running jobs are on the head of this list. Wolfgang > -----Original Message----- > From: Denzil Sander [mailto:DenzilS@mxgroup.co.za] > Sent: Monday, January 13...

hi all A lot of our jobs are spread over different categories within a project. Is there a job/routine/anything we can write that only displays running jobs? In other words, I dont want to bounce around between categories looking at which jobs are running - i want to view only running jobs, or only ...

Hi Craig_Hulett/Kenneth Bland, Thanks for your responce. Could you please guide me, what I need to do exactly now to run shell script from data stage job. Could you please send me in more detail steps, so I can fallow them. Actually, I am pretty new to UNIX. Thanks Ramesh Craig_Hulett@rsausa.com wro...

Hi, We are trying to make use of an external versioning tool (Rational Clearcase), and would like to make a "check-in/check-out" solution. As it looks we can only export at full project using the dscmdexport.exe command. Is it possible to export a single job, sharedcontainer, routine... from a comma...

Hi, Im sorry replaying so late.. I think you are getting this error because of the position of the key value. You use :1 in the where clause.. verify the position of your key field (VEND_CDE). Hope this will help you.. even if I think someone else has already helped you! Riccardo ----- Original Mess...

We migrated from ibm to solaris 8. It basically boiled down to: Export jobs/project from ibm server Install solaris datastage on sun server Set up $DSHOME/DSEngine/uvodbc.config and $DSHOME/DSEngine/odbc.ini files Import projects Test connections in jobs It will be useful to use the same names for y...

Hi All,

Does anybody having experienced of DataStage server migration in
Sun solaris8, mount point by point. Is that any thing we have to take
care on it?

Thank you.

B.Regards,
tathoong

Instead of doing something in the log, which is also possible with the filter in View, you should do something in your job. If it is a a text truncate in your DataStage-Job to the size of the target table. If it is a number round it. That is better and more secure and your job will even run faster. ...

hi all

Is there a way you can suppress warnings in the log entry for a job? The
problem I have is that many rows are being truncated in the job, and the
warnings are coming out like mad.

thanks

denzil