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?

see what it is doing.

What kind of stored procedure? SQL? C/Java? We need more details.

I think Cougar8000 nailed it in any case.

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...

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.

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.

If you are using Static SQL Statements in your SP, the associated packages have to be rebound after a RUNSTATS.

HTH

Sathyaran

Just wondering. How often are you running runstats and why?

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