Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2005
    Posts
    73

    Angry Unanswered: Stored Procedure Slow...

    UDB V8.2
    OS AIX, Solaris

    I am verynew to UDB .One of the stored procedrue is running very slow...
    where can i start to improve the performance..

    any ideas?

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    see what it is doing.

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    What kind of stored procedure? SQL? C/Java? We need more details.

    I think Cougar8000 nailed it in any case.
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Mar 2005
    Posts
    73
    Its sql stored procedure...

    It is using a cursor...open , close curstor statements and handler statements and a couple of insert statements...
    I have checked the tables too ..they have got all the necessary indexes.

    It was running fine till a couple of days agao.....offlate it is running slow..
    Runstats are running regularly too...

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Are you able to run some of the statements outside of the procedure? See if they're slow first, could just be a statement that needs tuning.
    --
    Jonathan Petruk
    DB2 Database Consultant

  6. #6
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    What changed in the last couple of days? Have you try running an explaine on the SQL?

    Plus, You need to see what the system is doing as a whole. What was added to the box, what other processing is done now.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are using Static SQL Statements in your SP, the associated packages have to be rebound after a RUNSTATS.

    HTH

    Sathyaran

  8. #8
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by dba_udb
    Runstats are running regularly too...
    Just wondering. How often are you running runstats and why?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  9. #9
    Join Date
    Feb 2005
    Posts
    6

    single partioned DB or multi-partitioned?

    Are u running it on a single partioned DB or on a multi-partitioned one?

Posting Permissions

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