What is reorg and runstats in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is the result of open cursor statement?
What is pagespace?
My SQL is not performing well. Describe how will you fine tune it?
What is the use of predicate?
Define declaration generator (dclgen).
What is meant by concurrency?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
How will you delete duplicate records from a table?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
When do you specify the isolation level?
Give a brief description of db2 isolation levels?
What are the 2 sqlcodes that are returned?