DSXchange

I am trying out this code it is giving me error at a function GetJobNumber do i need to define this function or have to include library for that regards Sudhir APHOIT/CA$H Datawarehouse Team (65) 423-7449 ---------------------------------------- Message History --------------------------------------...

Sudhir, In my references to the &PH& directory, I wasnt suggesting that there is a problem here that needs addressing, but rather, that these work files might contain a clue as to what is wrong with your job that keeps hanging. Are you able to tell from Unix if the hanging job is using CPU (...

CLEAR.FILE DATA &PH& is good maintenance practice, and will positively impact on performance, but will have no impact on locking/hanging processes. &PH& contains the output logs for each phantom (background) process. Each job runs as a background process (executing the DSD.RUN progra...

Replied off line. In summary, I didnt have one lying around. Structures of the status records are taught in the Advanced DataStage class, so someone attending this class may end up saving David some work! Dont forget also that the MetaStage product (version 2.0 out real soon!) automatically captures...

This is a topic for an orphaned message.

Job Hangs As David pointed out, you can get more information about the actual status of each active stage in a job by using the Monitor. Choosing "show links" can provide more information. Double clicking on any line in the Monitor view will reveal the process ID associated with that activ...

In this case will CLEAR.FILE DATA &PH& help if i do it on regular basis does it have any impact on jobs please clarify thanks and regards Sudhir APHOIT/CA$H Datawarehouse Team (65) 423-7449 ---------------------------------------- Message History ---------------------------------------- From...

A far more efficient way would be to construct a BASIC subroutine to dump the log, and run this either from within a Job Control routine or from within a before-job subroutine. A secondary benefit is that the output can be exactly as you desire. Such a technique is taught on the "Programming wi...

Thanks, Ray. Ive been meaning to write one of these for a long time, just hadnt gotten that far down my list yet. Now the job is half done for me already. :-) I was also contemplating decoding the stage finished messages as well so I can track over time how long the jobs take, when they start and fi...

Sudhir To be of any help, we are going to need more information. What version of DataStage are you using? Can you supply the message from the log file for the lock? In the case of the hang, what does a monitor of the job show? What kind of server are you running on? -----Original Message----- From: ...

I have two types of problem in datastage job hangs and job locked Some times the job hangs with out any reason. Some times the the job control job hangs because the called job has got exclusive lock (cannot get exclusive access to job ). what could be the possible solution for this? thanks and regar...

Hi We are dumping the datastage log by following command from unix. dsjob -logsum ntpspro MMCustAcctMA01 >> Summary.log dsjob -logdetail ntpspro MMCustAcctMA01 event >> Detail.log This unix command is working fine but the problem is that it is creating a lot of uv processes while executing this comm...

David asked why we would convert to 3.6 and not 4.0. A fair question. It was recommended by the Help Desk at Informix that we take this approach. The reason is training. Release 3.5 modified the transformer stage a bit, and 4.0 has more features as well. In order to ease folks in, we were advised to...

I have just experienced a very difficult few days attempting to license a MetaBroker Plugin. Informix resolved the issue yesterday. If you experience a similar problem you might refer them to problem issue number 976884. Robert F. Woods 303 306-2355 Voice Strategy 7 Corporation 14881 Quorum Dr. Suit...

done that many, many times Mark Griffin AMP Sr. Application Developer Data Warehouse Systems CIGNA Healthcare Two College Park Drive, 454 Hooksett, NH 03106 Phone: 603-430-7610 603-268-7239 Fax: 603-268-7909 email: griffimk@hlthsrc.com >>> ray.wurlod@informix.com 08/08 9:05 PM >>> They had a "c...