Unix shell script run SQL scripts in parallel

Question

How do I setup this KornShell (ksh) script to run SQL scripts 2,3 in parallel after tst1.sql is done then run tst4.sql after 2,3 are complete? Is this possible?

#/usr/bin/ksh
#SET ENVIRONMENT ORACLE

sqlplus user1/pw @/home/scripts/tst1.sql
sqlplus user1/pw @/home/scripts/tst2.sql
sqlplus user1/pw @/home/scripts/tst3.sql
sqlplus user1/pw @/home/scripts/tst4.sql
exit 0

fabien · Accepted Answer · 2013-08-13 05:25:23Z

3

The first command should run synchronously...

If you start the two last commands as background processes (add & at the end of the command), they will run in parallel.

Do you want the script to wait for the two last processes to be complete before leaving?

Something like this should work:

  sqlplus user1/pw @/home/scripts/tst1.sql
  sqlplus user1/pw @/home/scripts/tst2.sql &
  pid2=$!
  sqlplus user1/pw @/home/scripts/tst3.sql &
  pid3=$!
  # pseudo-code:
  # while (`ps -p"$pid2,$pid3" | wc -l` != "1");
  sqlplus user1/pw @/home/scripts/tst4.sql

edited Aug 13, 2013 at 5:25

answered Aug 13, 2013 at 4:37

fabien

1,5591 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

jdamae Over a year ago

Yes. I want to wait. I also want to add another tst4.sql to run after 2,3 are complete. Is that possible?

fabien Over a year ago

Why don't you just concat tst2.sql and tst3.sql into some file (tmp.sql) that you would execute sync after tst1.sql and tst4.sql? Unless these files are very big (Gb), that is the easiest solution you'll have...

jdamae Over a year ago

Can you please elaborate on how to use sync? No files are very small.

fabien Over a year ago

I meant synchronously. When you run 'sqlplus user1/pw @/home/scripts/tst1.sql', the script doesn't move to the next line before that process is complete... Why are you trying to run tst2 and tst3 in parallel? ... Do you really want 2 concurrent processes hitting the db?

jdamae Over a year ago

need to run 2,3 in parallel to finish job faster then once that's complete, run last sql.

|

Collectives™ on Stack Overflow

Unix shell script run SQL scripts in parallel

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related