Hi friends,

I am kicking off two sql scripts at a time::

nohup db2 -tvf script1.sql &//contains RUNSTATS on tables for SAMPLE database

nohup db2 -tvf script2.sql &// contains a simple connect to database command


I was surprised to notice that script2.sql is waiting for script1.sql to finish...Any idea why there is no parallelism in execution here....FYI the OS i use is linux..Thanks

It is probably hanging somewhere in the operating system - not DB2. Lets capture output from both scripts and post here. Is there any response from DB2 to CONNECT in the second script?

Thanks for your reply..

Output of the first script...

RUNSTATS completed successfully...

RUNSTATS completed successfully...

It is still running and the second script was not even able to connect to database and waiting until the first one is done

I tried it myself and see what you mean. You can open a problem with IBM on this - it is clearly a bug. Or I will when I have time. Come to think of it, I have seen this before but never got around to getting them to fix it. Thanks for the reminder

I opened a PMR today but no reply from the folks yet..Please let me know if you find any info abt that..Thanks

PMR 49632 180 000 .... lets see if they realize that these are duplicates

Did you try it without the comments (// and following text on the line)?

Yes, I did. Never use //. It hangs consistently.