Shell Programming and Scripting

Hi All,

We have three shell script batch, which extract data from three different systems(oracle, db2, db2/400).

By running each shell script batch, the data is extracted from respective systems. while the batch is running, job date, system_name, start_date and end_date will be inserted into a common staging database for each shell script batch.

we are facing some technical problem while executing the three shell scripts parallelly. we use data stage ETL tool to run the three shell script batch in parallel.

while running parallel, the three rows should be inserted into staging database table for respective source system. but one or two rows only getting inserted into staging table. some times Shell script gets failed while executing the sql script(which insert the above mentioned data to staging table) within the batch. even there is no dependency between the three shell scripts

If we run the batch one after other, we are not facing any issues.

i m very much thankful, if i could get a solution from this forum.

thankz & regards
Anwar

my reply may not be that useful, just a pointer to ur problem.

since all the 3 scripts are inserting into a common table, there is possibility that the insertion is being failed due to implicit locking of table while inserting a row.
Have you checked for the return status of the insertion, that would have been a great pointer to proceed with.

If the problem has been downsized due to locking of table simultaneously and insertion failing due to that, then increase the lock time wait period.

hope this helps.