DSXchange

Hi David 1. We are using DataStage 3.6. 2. Yes multiple jobs run in parallel 3. No we are not using a multi processor server Thanks & Regards Avinash Tadwalkar ---------------------------------------- Message History ---------------------------------------- From: David.Barham@anglocoal.com.au on...

You are in luck. I believe the Informix basically have the hanging problem cracked. Questions... What version of DataStage? Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel stages?) Do you use a multi processor server? Depending on your answers (ie is it the usual hanging p...

Hi,

We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.

Is there anyone who knows solution for this.

Regards
Avinash

There are two restrictions. By default, the maximum number of columns is 400. The maximum number of bytes in a row in the result set is 8192. You may be encountering this limit. The good news is that these are not hard limits. Add the following lines to the bottom of the uvodbc.config file in your p...

Hong, We have tables with significantly more than 90 columns. (I wont reveal how many, it is too embarrassing.) However, these tables are updated using the ORAOCI8 stage. I dont believe we have attempted this with ODBC stages. I guess this probably does not help. David Barham Information Technology ...

I have a job which uses a view that returns 90 columns in the resultset (we have our reasons). This resultset is then used to populate a table. When I run this job, it aborts with the following: Program "DSD.BCIOpenW": Line 437, Array index out of bounds. Attempting to Cleanup after ABORT ...

DataStage imposes no limit on the number of jobs. (Actually this is not true - there is, by default, a limit of 2GB on the size of the DS_JOBS table, which maps job names to job numbers, so the limit is just short of 2GB worth of job names. Doubt that youll hit this one! If you do, we can resize the...

This is a topic for an orphaned message.

I need to subscribe the Sybase DBA mail list, anyone also on that list and know the email adress? Thanks in advance ThomasCook LTD IT Sydney ********************************************************************** NOTICE: This message contains information intended only for the use of addressee named a...

Dont know how you thought you unsubscribed. Here are the instructions. Instructions for unsubscribing from the Informix-DataStage Discussion List To leave the list, send an empty email message to informix-datastage-unsubscribe@oliver.com The Mail List Manager program will send you a message asking y...

Bob, I would be interested to know if you receive this message. If you do, please acknowledge it. This message is being sent to the list only. I cannot see why anyone would bother to send a message direct to you rather than (or as well as) the list. -----Original Message----- From: Bob Modrich [SMTP...

To Mark & Mark: Thanks for the feedback on VPN access. I also heard from Informix/Ardent Support that as long as I had the client DataStage software on my dial-in laptop, were fine. Phew! We just get it workin with dial-in and they (our Security dept) go and change it on us. ;-) Brad Vincent Com...

Alas, I do not have access to source. In any case, DSD.RUN is one program that is likely to change at every release. We would need to know the exact release number, then offer Glenn or someone a virtual beer (or similar) to dig it out. Not all components of a job compile to individual components, so...

This is a topic for an orphaned message.

I have been using an ISDN line to work remotely for several years and when we started using DataStage a year and a half ago there were no problems at all, just like sitting at my desk in the office. Now I am using a dial in setup which is a little slower just until we get the VPN set up. P.S. I neve...