Re: Multi-tasking to reduce time

Is there a k in the file spec in the input file for each of these
programs?    Since you are processing all records, there is probably no
reason to process them in any special order.

I have seen this simple step give improvements of 40% and more in programs
processing large files.

> I have following scenario.
>
> Control program reads through a control file (control file has list of
> transactions to be processed) and calls programs as below:
> CREATE_TRAN_INFO -> this program writes record in CREATE_TRAN_INFO phy.
> file per transaction
> CREATE_CASH_INFO -> this program writes record in CREATE_CASH_INFO phy.
> file per transaction
> CREATE_COLLAERAL_INFO -> this program writes record in
> CREATE_COLLAERAL_INFO phy. file per transaction
> (Lets call these as work programs)
> If all work programs run successfully, control program flags transaction
> as processed and commits.
>
> This is taking about 20 min. to process around 40,000 transactions. I need
> to reduce this by 40% to meet SLA specified. Can I get some ideas on how
> best can this be achieved.
>
> I could think of creating IN and OUT data queues for each work program.
> Take them out (from inline call) to a separate job that runs in batch.
> Control program feeds these programs through IN data queue and picks the
> processed part from OUT and also writes to the respective phy. file.
> I am of the opinion that there would be too many dynamic calls to QSNDDTAQ
> and QRCVDTAQ, not sure if the objective would be achieved.
> Just for note, all work programs can run independently at the same time.
>
> Any help is greatly appreciated.
>
> Best rgds.,
> Srikanth D