Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2008
    Posts
    45

    Unanswered: nohup db2 -tvf issue

    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

  2. #2
    Join Date
    Apr 2008
    Posts
    51
    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?
    db2topgun.com

  3. #3
    Join Date
    Jan 2008
    Posts
    45

    Hi SuperKuper

    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

  4. #4
    Join Date
    Apr 2008
    Posts
    51
    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
    db2topgun.com

  5. #5
    Join Date
    Jan 2008
    Posts
    45
    I opened a PMR today but no reply from the folks yet..Please let me know if you find any info abt that..Thanks

  6. #6
    Join Date
    Apr 2008
    Posts
    51
    PMR 49632 180 000 .... lets see if they realize that these are duplicates
    db2topgun.com

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you try it without the comments (// and following text on the line)?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Apr 2008
    Posts
    51
    Yes, I did. Never use //. It hangs consistently.
    db2topgun.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •