DSXchange

The jobs will abort if you specify "Abort after NN warnings" in the properties of "Run Job" in Director. The default is set to 50 IIRC. This is not a bug. Regards, Anthony Corrente. --- Dirk Moolman wrote: > I logged a case with Tech Support for this - cant figure it out. > > I add the line "DISABLE...

I logged a case with Tech Support for this - cant figure it out. I add the line "DISABLE_INFO=YES" to the rbodbc32.ini file, and all jobs are fine accept one. When I remove this line, all jobs abort with too many warnings being displayed. The funny thing is that the warnings arent errors, just messa...

Hi all, I have a requirement to read data present in thousands of RTF docs to a database. The data in formatted in the files, such that one record is structured over 1 page. I wonder if i can read it through datastage. Needless to say, I cannot open each file and save it as a sequential file. I trie...

The reason I specifically mentioned NT is I believe that the way NT handles attempts to access locked files causes excessive delays to the job close down when there are a lot of jobs running with lots of active stages. In my early DataStage days, when running a dozen or so short jobs at the same tim...

Unix also has a &PH& directory - just dont know if it will have the same affect. Tech Support e-mailed me a procedure the other day on how to clean up this directory in Unix. I quote the e-mail: "As per our phone conversation, these are the instructions to clear the &PH& directory: 1) Open DS Admini...

Thank you Jack, I appreciate the reply. I will have a look at this. Have a nice day Dirk -----Original Message----- From: Jack Luchjenbroers [mailto:jack@luchjenbroers.com] Sent: Wednesday, November 07, 2001 6:32 PM To: datastage-users@oliver.com Subject: Re: NT ? Dirk, There is a file .uvconfig (wh...

How do you measure the 10-12 seconds? Much of the "delay" between the finish of the final active stage and the finish of the job is involved in closing things - either files or connections to databases. Close is an expensive operation, since it has to update the date/time accessed (and, possibly, da...

Dirk, You have just installed the NT version of Datastage. Then Job Done. There is not a lot left to do short of Installing Connectivity & ODBC to your data sources. Jack ----- Original Message ----- From: "Dirk Moolman" To: "Datastage List" Sent: Tuesday, November 06, 2001 2:37 AM Subject: NT ? > H...

Cleaning up the &PH& directory can help (if you are on NT, anyway). -----Original Message----- From: Peter Oates [mailto:Peter.Oates@macquarie.com] Sent: Wednesday, November 07, 2001 2:05 PM To: datastage-users@oliver.com Subject: Inter-job delays There seems to be a constant delay of 10-12 secs whi...

There seems to be a constant delay of 10-12 secs while a DS job closes.
The actual job itself takes only 5 secs. This can add up when you have a large number of DS jobs in a workflow.

Is there any way of reducing this delay ?

Peter

Yeah, Jack, the correct procedure to change tuneables is: 0. take backup copies of uvconfig and .uvconfig (dunno about keeping them in bin folder though) 1. edit the uvconfig file as required 2. run bin/uvregen (replaces .uvregen unless errors) 3. bounce UniVerse (DataStage engine) (stop and start s...

DONT TOUCH THE .uvconfig FILE !!! (shouting intentional) The file uvconfig contains engine configuration parameters. When these are changed, a new image of the shared memory segment is created via the uvregen command. This image is stored in the .uvconfig file, which is loaded when the engine is sta...

Hi Nazek, Thanks. Solved the problem by placing umask=002 in the .profile file and changing the mode for the existing files. We havent kept the umask=002 in the dsenv file. If we place so, can we gain any advantage over keeping in the .profile file! Thanks, -Radha > -----Original Message----- > From...

Thanks a lot David, well check if other processes occur to the Oracle error. In any case the DataStage version is 4.1.1 and the OCI version is ORAOCI8i 2.3 Regards Patrizia ----- Original Message ----- From: "David Barham" To: Sent: Tuesday, November 06, 2001 1:57 PM Subject: RE: DataStage Fatal err...

Something else that makes me wonder - normally when I get an error on an update or an insert, there is only one update / insert statement and 1 record (result set) in the error. In the case below I get 2 records in the error. OPLoadCustomer.Load_Customer.Customer_update: DSD.BCIPut call to SQLExecut...