DSXchange

Most of the following are for UNIX installations/upgrades. Some are for NT/2000 as well, but items such as ODBC connections and /tmp directory items, to name a few, are UNIX only. - Backup ALL your projects, just incase something disasterous happens like loss of power or somebody stopping the instal...

Hi, I have raed the Technichal Bulletin supplied with DS 5.1 and have also read the readme file. I was wondering if there is anything I should be aware of other than this when upgrading to DS 5.1 from DS 4.1. Regards Damien Kavney Technical Consultant Dialog Pty Ltd Contact Details (DNR) MIS Applica...

Why couldnt you let DataStage generate your SQL for you, then change to User Defined SQL and add the SET TRANSACTION as the first statemet? -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Monday, April 15, 2002 2:51 PM To: datastage-users@oliver.com Subject: RE: Defining...

Regu, I dont have the answer to your problem, but it seems to me to be a reasonable thing to do. What version of DataStage (precisely) are you using? There is some variation between versions in how they handle Oracle transactions. I think it would be worthwhile pushing Ascential for an answer on thi...

try something like this Status = DSGetJobInfo(yourjobhandle, DSJ.JOBSTATUS) If Status 1 Then *RESET job for CONTINUED RUNNING Result = DSGetJobInfo (hJob9,DSJ.JOBSTATUS) Call DSLogWarn("JOB STATUS: " :Result,"YourBatchName") hJob9 = DSAttachJob("DssJob8Final", DSJ.ERRFATAL) ErrCode = DSRunJob(hJob9,...

We have a condition in which if a field within a record is invalid then the whole file is rejected instead of that bad record. I need the groups help to figure out a clean solution to stop the job. I have written a routine called StopJob which basically does the following: - logs error message into ...

thanks, this looks like what I need > -----Original Message----- > From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] > Sent: Friday, April 12, 2002 8:02 PM > To: datastage-users@oliver.com > Cc: datastage-users@oliver.com > Subject: Re: troubleshooting control job > > > > I suspect your control rout...

Hi Regu, I am not the big Oracle Guru you are looking for, so I want to give you some tips Ive seen in many DataWareHouse projects, how your problems were solved there. Transaction with Rollback and Commit are good in non-DWH-environments because you have to have clean transactions and you have a lo...

Guys, I have a job that inserts rows into an Oracle table using the ORAOCI8 stage. I am trying to do the insert in one transaction and need to set the rollback segment to be a one of our larger ones to cater for the large number of rows. Ive tried to do this in the Before SQL part of the OCI stage b...

We are planning to upgrade our DataStage 4.0 to DataStage 4.2. Its just a DataStage version upgrade, OS would remain on HP-UX. I need to know the following: - How long roughly would it take? What should be the timeframe like? - Is there any references that I can read or web documents I can read/down...

I suspect your control routine uses DSWaitForJob to await completion of jobs under control. Another technique is to use an "active wait", where the controlling job spins (sleeping most of the time), periodically checking the status of the job under control. For example: Loop JobStatus = DSGetJobInfo...

DataStage processes fall into two major classes; connect client users, and running jobs. Running jobs should also have a status of Running in the Directors status view (though this is not 100% accurate in the ancient release you are using). When jobs run (in release 4.0), they will start one or more...

Chris, that was very useful information: fyi ..... more ds_start.bat REM Regenerate and restart DataStage server engine pushd C:AscentialDataStageEngine binuvregen popd net start unirpc net start dsengine net start dstelnet Thank you - Rob -----Original Message----- From: chris.thornton@ascentialsof...

Hi Rob, I dont have 5.1 on my machine at the moment, but on NT, these can be found in the files ds_start.bat & ds_stop.bat in a project directory. Regards - Chris Thornton -----Original Message----- From: Robert Takkunen [mailto:rtakkunen@idsgrp.com] Sent: 12 April 2002 15:16 To: datastage-users@oli...

Does anyone know what the service names are for DataStage 5.1 and above that can be used with the command line "net start" command? Since Ascential started renaming services to be DataStage specific, I dont think all the service names below still work. DataStage Engine Resource Service = net start ?...