DSXchange

Affected to? To quote The Princess Bride: You keep using that word. I do not think it means what you think it means. Could you please clarify what exactly you mean by 'affected to' in this context? :? sorry, my mother tongue is french and not english. well, in mean, in the sequential stage, I defin...

Well, my logic is the following I take one or more files in input and I sort them by date. I remove duplicate by taking the more recent line. So, I have 2 lines with the same key in the 090309 and in the 090311, but the line in the 090309 is affected to the 090311, so my remove duplicate becomes wro...

I have a strange problem when reading files in sequential stage. I read 3 files 090309.sdi,090310.sdi and 090311.sdi with pattern file option. I use the option file name column to associate each line with the corresponding file. But, some lines in the 090309.sdi are affected to the 090311.sdi file. ...

"Do no Check point run" mean that the job will be execute if the sequencer is re run. for exemple, the following scenario : JOB SEQUENCE Job1 (Do not Checkpoint Run) -> Finish OK Job2 (Checkpoint) -> Finish OK Job3 (Checkpoint) -> Finish Abort If you restart the sequence : Job1 will be exe...

You can define the environment variable $APT_PM_SHOW_PIDS to true. In the log, you will see the PID of the process.

you can use a lookup. Force a reference with one line in the principal flux. And if there is not line from the reference 'Abort'

Here is your answer.

viewtopic.php?t=117884&highlight=StringToTimestamp

well, if your job SEQ_Accnt_summary is a JobControl, perhaps there is a problem in your code.

Anyway, If it says 'NOT RUNNING', i see two possibilities :

- you are trying to execute a job witch is is not defined as 'Allow Multiple instance'
- you are trying to execute a job witch doesn't exist.

You are using instances for your jobs. perhaps there is a problem in your instanciation.

Sainath.Srinivasan wrote:The format must not be dependant on the version.

well, as it is write in the Help "Date, Time, and Timestamp functions that take a format string (e.g. timetostring(time, stringformat)) need specific formats."
It seems that the day and the month must be on 2 digits.

not very elegant but still works

StringToTimestamp(Right('0':Field(DSLink8.Eff_date,'/',1),2):'/':Right('0':Field(DSLink8.Eff_date,'/',2),2):'/':Field(DSLink8.Eff_date,'/',3) :' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss")

try
StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss")

Have you test your 8 jobs running sequentially with the option $APT_DISABLE_COMBINATION set to false ? and is it ok ?

If you think it's a CPU issue, I advice you to monitor CPU usage and look for an over-use of CPU.
If you don't have such tool, use NMON.

When you delete in the table, there is an exclusive lock on the table, and you can't execute another delete statement on the same table, even if the set of records are differents. If you partitionned the table you should execute your delete statement in parallel. You could also create a specific del...

chulett wrote:You're deleting 30M out of how many total rows? May be more efficient to rebuild the table with just what you want to keep if the percentage is high enough. ...

Well, the table contains 400M of rows and the most of the rows are real update (80%) insert (20%).