Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 14117 Views
- I also Faced
- E-Mail Answers
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 |
How can we retrieve the total number of records in RPG & CLLE?
How to find last record before record through SQLRPGLE?
What is a Database Request Module(DBRM)?
What is the physical storage length of timestamp data type?
How do you retrieve the data from a nullable column?
why we go for SPUFI for creating tables or for sql queries?
What is ibm db2 database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to execute stored procedure in db2 command editor?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What information is contained in a SYSCOPY entry?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
COBOL 
