Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Nottingham, UK
    Posts
    12

    Unhappy Unanswered: Inconsistant cost+execution

    I have a reasonably simple query being submitted as part of a cobol program, which is failing to return any results and is being tracked at costing 200000 timerons and timesout after about 5 minutes of doing nothing but row reads.

    When i take this query into a query tool it runs in a split second and analyses a cost of about 75. By the way the table has about 260000 rows on it.

    Cannot understand why its running differently for each situation.

    Stats are totally up to date too.

    Thanks for any advice

    Jamie
    Last edited by wallisj; 08-12-03 at 09:18.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Inconsistant cost+execution

    Is the query in the cobol program parametrized ?

    If so, you will see a difference, but a difernce this large is amazing

    I'll suggest you to contact IBM Support ..

    Cheers
    Sathyaram


    Originally posted by wallisj
    I have a reasonably simple query being submitted as part of a cobol program, which is failing to return any results and is being tracked at costing 200000 timerons and timesout after about 5 minutes of doing nothing but row reads.

    When i take this query into a query tool it runs in a split second and analyses a cost of about 75. By the way the table has about 260000 rows on it.

    Cannot understand why its running differently for each situation.

    Stats are totally up to date too.

    Thanks for any advice

    Jamie
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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