Parallel invocation of SQL script from shell

Question

I am using below logic to execute an SQL in parallel

PID_LIST="start" while [ "$PID_LIST" ] do

$count =0
if [ "z$PID_LIST" = "zstart" ]
then
PID_LIST=""
fi

for PID in $PID_LIST
do
    # echo "Checkpid $PID"
    if kill -0 $PID >/dev/null 2>&1
    then
    PID_LIST_TMP="$PID_LIST_TMP $PID"
    $count =`expr $count  + 1`
    fi
done
PID_LIST=$PID_LIST_TMP

if [ $more_re_to_process -eq "Y" ]
then
while [ $count -le $MAX_INSTANCE ]
do

    #prepare input for sql

    invoke SQL script sql1 with prepared one >LOG_$count
    PID_LIST = PID_LIST="$PID_LIST $!"

done
fi; done

In this example whenever any sql process finishes I am creating a new one. But the problem is that I end up creating a new log. I want that whenever I create a new SQL session it uses the the LOG file of process which is finished (if any).

Could someone tell How Can I do this?

Armali · Accepted Answer · 2016-08-18 08:57:57Z

1

Provided that the shell handles arrays, you could store the PIDs as elements in an array and clear only the element if a process finishes, so that the indexes of the other processes remain the same; then in a loop for invoking new processes scan for cleared elements; with the array index $count, >LOG_$count uses the the LOG file of process which is finished.

answered Aug 18, 2016 at 8:57

Armali

19.6k15 gold badges64 silver badges184 bronze badges

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

Collectives™ on Stack Overflow

Parallel invocation of SQL script from shell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related