DSXchange

RAI ROUSES wrote:Did the clear status of the job, in the log it appears the message that is done the clear to the RT FILE, but the job continues in the state "running".

Odd, another 8.x quirk it seems.

Perhaps:

viewtopic.php?t=124610

There's the question - are you trying to abort if the threshold was crossed after the job ran or the moment the threshold is exceeded?

Sounds like you are trying to use a Parallel function in a Server BASIC routine... no can do, if that's the case.

You've got bad XML. As noted, it should look like this:

<color><blue></color>

Ask whomever supplied / generated it to correct the problem.

A search for "did not finish OK" would show that this question has been asked and answered alot, most recently here.

So... your problem is resolved? If so, can you mark it as such using the button at the top of the screen, please?

I am sure that botlneck in writing to seq file . I am get about 3500 rows/sec. What makes you so sure? No, there's no "trick" and I sincerely doubt the "bottleneck" is your sequential write speed unless you are writing to some crap disks or the underlying filesystem is very busy...

You'll need to provide more details about your jobs and issue. Is the abort happening in one of the "sub sequences" or the "main" sequence?

1. You tell us, is your problem resolved? :? If so, you should do two things - post the resolution and mark the problem as Resolved using the green button at the top of the screen. 2. Ideally, by looking at the thread subject - it should either be marked 'resolved' or 'workaround', otherwise a 'work...

rachit82 wrote:However i just wanted to confirm from you and others that If there is a possibility that there could be data loss without any warning in such cases.

That's going to have to come from someone else, one of the many DB2 gurus here. Hopefully they'll chime in when they get a chance.

No, my experience is all with Oracle for the last several years, with Progress and Informix before that. I've got no idea about any quirks that DB2 may bring to the table or how they line up with Oracle. For example, in Oracle an update or delete that affects zero records is considered successful wh...

Ok, then why not give the various 'Seq' functions a try? As Ray noted, OpenSeq opens / creates a sequential file, Seek can be used to position the pointer to the end to begin appending to any existing records, followed by WriteSeq and lastly CloseSeq which do exactly what you'd think they do. Pick o...

I assume it is a memory leak issue, one that simply causes your PC to run out of the process memory it needs to load the icon images. I've seen this in older versions, it would start showing the icons as generic "plug-in" icons, like an electrical wall plug. Is that what a "build op&q...

I monitored the Job through the Director and the Scheduling tool. There were absolutely no warnings. When i said monitor, I asked you to see the no. of records extracted from source and loaded to target. Right click the job in Director and select monitor. Then you can see the details. If there is a...