Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Suppose I have a program which uses a dynamic SQL and it
has been performing well till now. Off late, I find that
the performance has deteriorated. What happened?

Question Posted / guest


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off la..

Answer / s

Check if it is a DB2 problem or not. If its a DB2 problem ,
It depends !!!
Check the access path and see if there is a problem.
RUNSTATS may be necessary to update the statistics if the
data characteristics has been changed.
OR
Check for locking problems
OR
Check for failed messages

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is sqlca’s maximum length?

0 Answers  

What is the picture clause of the null indicator variable?

6 Answers  

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

what is cursor stability?

2 Answers   IBM,

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

List some fields from sqlca?

0 Answers  

What are iseries servers?

0 Answers  

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

How will fetch last 5 rows from table in db2

6 Answers  

how will you retrieve first record in table

1 Answers   UST,

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

For more DB2 Interview Questions Click Here
Categories