DSXchange

Pretty sure you don't want to enter entry into VOC.

You may be looking for CLEAR.LOCKS that clears all your users locks. Be careful with it though!!!

LIST.LOCKS should list the locks.

The Database is Db2udb 8.x. Is there any flash back option in Db2? If we go for the option of having a date column or Etl_id column (suggested by Nick bond) to identify the records for a particular run and delete them if the job aborts in the middle, Is it a good idea to perform a delete operation ...

I would go with vincent's FAQ solution. No point mkaing forcing data into sequential mode just to get a sequence number.

With index rebuild the indexes should be ok after the job completes successfully.

As Craig said this won't be the case if the index rebuild failed. Is the job completing successfully?

Can yoy povide a description of what you job consists of? Which stages? Files? Databases? Before job routines?

But after reading one msg it does not go back by it self and wait for the next msg.

You sure?

A very useful routine for you to write is one that allows you to call sql from it. Then you can simply use this routine as derivation to a user variable in sequence running sql like select count(*) from myTable where mycondition and use the result from this in the sequence to decide which path to ta...

Just add a parameter to your job like pDelimiter and in teh sequential stage, in the Delimiter part add #pDelimiter# If all these datamarts want the same data just with a different delimiter these is no need to run the job with all the logic in many times. Run the job once creating on of the file, t...

In theory there is no limit to the number of changes to a table you can flashback, but for this to be possible Oracle needs to write a log of all the changes to the rollback segment, so there is a space issue. As long as your DBA can increase the parameters enough you will be ok. Off the top of my h...

for stagevar2 set the derivation to

Can you see a process for the job running? You need to work out if the job is actually running, i.e. has a process or whether the process has died and it is a problem with the way director is reporting the status of the job.

To change your code page, go to

Control Panel - Regional and Language Settings - Advanced

There is a section to load code pages. make sure you have 1256 laoded.

I guess there is a difference between the two client machines.

A couple of things to add then. When you have this problem of dates being null and you wish to use them in routines or stage variables, it can be usefull if you have a 'special date' that is outside of the domain of your data, i.e. 9999-12-31, which you can use set null dates to using NullToValue(in...

Are you using a stage variable for the derivation of your timestamp anywhere along the way? At no point can you set a stage variable to null, there was a bug in 7.5.1 I think that allowed a job to be compiled with SetNull() in a stage variable. this was fixed by lot sof tha available patches. I seem...

Not as far as I know but if you test it and find it does it would be interesting to know.

I would approach this by using the Count function to find out how many of the strings there are. If you want the last one use.