DSXchange

If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where tha ... unfortunately it is not triggered from the command line. but triggered using sequence. i...

chulett wrote:From what I can tell, yes. ...

Ok, thanks very much for your help

That is how you should do it, if that's not working you'll need to report it to your official support provider. What exact 8.x version are you running? ... I'm using Datastage version 8.1. So, just confirmation, what I had done has already been right and this problem is caused by the software, righ...

OK, "job run level" seems to mean Sequence job's Job Activity stage? You can't control it there, it should be inheriting the warning level of the parent / controlling job. ... Yup.. it means the sequence job's activity stage. hmm,then how to set warning level of the parent/controlling job...

Dear all, I had the same problem as what happened to Pierre post at this link I have set the warning limit to No Limit at director. But the strange thing is, when I run the job without sequence from director, it can run well and no warning limi.t But, when I run the job using sequence, it limits the...

The problem is resolved. The jobs were started by Job Controls. In fact, the limit was 50 warnings at job run level. Thanks to all for help. Pierre. Dear all, I had the same problem as what Pierre get. But I can't find how to set the limit warning at job run level. Can anyone help me? For your Info...

Another possibility to improve the load performace, but not using the DataStage, which we used on database other than Oracle. Have your Load files exported per partition. As others recommended drop the constraints & indexes on the table, this can happen at the same time when your load files are...

ArndW wrote:Does your job partition the data streams according to the DB partitioning scheme and load appropriately? ...

hmm, what do you mean by DB partitioning scheme? I'm sorry, because I'm new to datastage

Hi, is there any tips to speed up an extract and loading process in datastage using Oracle database as source /target? Is the load method at oracle Enterprise stage equals to SQLLoader? And is append method in Oracle Enterprise stage equals to append DML in Oracle? for your information, my table is...

Hi, is there any tips to speed up an extract and loading process in datastage using Oracle database as source /target? Is the load method at oracle Enterprise stage equals to SQLLoader? And is append method in Oracle Enterprise stage equals to append DML in Oracle? for your information, my table is ...

Best example would be in any existing checkpoint enabled job. Check the Job Control tab under Job Properties, the fully generated code will be there including all of the checkpointing logic. Basically, you are leaving "bread crumbs" to show where you've been and what the result of each st...

Please understand - you cannot make the built-in automatic check-pointing work the way you 'need' it to work, so you should put that from your mind. For the behaviour you say you want, you'll need to (in essence) build your own check-pointing system, one which may (or more likely may not) require t...

chulett wrote:But don't think you still need to Abort the Sequence to trigger the checkpoint restarting you no longer have. Abort it for other reasons, perhaps, but not that one.

hmm, does it mean that there is another way to trigger the checkpoint except by making a sequence finished with abort status?

So how to design the sequence as my objective before? As already noted. Your requirements preclude the use of the automatic checkpointing, hence the suggestion to disable those compiler options. You need to control the job flow using triggers, for example if you don't want an aborted job to stop th...

That is true. But, with explicit triggers and record-keeping, you can design sequences do to whatever you like. ... hmm,if a single job activity is aborted at a sequence, and I want to make a job sequence finish with aborted status after all other independent jobs finished, then I must use the help...