What does the REORG Utility do?
Answers were Sorted based on User's Feedback
Answer / guest
REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.
Is This Answer Correct ? | 23 Yes | 5 No |
Answer / harsha
Reorg is done when
1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode
Is This Answer Correct ? | 6 Yes | 2 No |
What is with ur in db2?
How do you insert a record with a nullable column?
What is difference between alias and synonym in db2?
What is the difference between oracle and db2?
What is CHECK PENDING ?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is the database descriptor?
How do you define a correlated name?
Describe what a storage group(STOGROUP) is?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
What is meant by repeatable read?
What is a lock?