Job Failure

psybarite · Post by **psybarite** » Thu Oct 23, 2008 7:19 am

Hi

I have a job which reads from Unidata DB and loads to a DB2 table. This job has been running fine untill last week.

We have been getting the below error for past couple of days when the job fails. This job runs fine again when we run it manually after a couple of minutes.

The error message is

Unable to connect to server 39204 - UDT error
DSD.UDTOpen GCI $DS.UDTOpen error 24

There are other jobs in the main stream which pretty much do the same but run fine with out any issues. This is the only job tht fails.

Any help in debugging this would be appreciated.

Thanks

ArndW · Post by **ArndW** » Thu Oct 23, 2008 9:59 am

Is the UniData instance local to the DataStage server machine.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 23, 2008 3:27 pm

What changed last week? Clearly "nothing" is not the correct answer.

psybarite · Post by **psybarite** » Mon Oct 27, 2008 2:17 pm

Well actually nothing has really changed. We have not done any change both on source and target side. There are a bunch of other jobs which are also part of the same master seq and they run fine.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 27, 2008 2:23 pm

Are your UniData services (particular shared memory manager) running?

chulett · Post by **chulett** » Mon Oct 27, 2008 2:29 pm

Resource problem? Don't ask exactly what resource, just seems like a reasonable stretch to me as I found some mention of UniData and shared memory segments mentioning an errno=24.

Edited to add: Ray, aren't you supposed to be either in a lecture or out enjoying the sights and sounds of Sin City?