Why do we need reorg in db2?
- 1 Answers
- 1070 Views
- I also Faced
- E-Mail Answers
Answer / Jaiveer Singh
Reorganization (REORG) in DB2 is used to optimize the performance of a database table by rearranging its data and updating statistics. It helps to reduce storage space, improve read/write speed, and maintain data integrity.
| Is This Answer Correct ? | 0 Yes | 0 No |
Give the name of some fields form sqlca.
is it possible to get -811 error when you use cursors. why?
What is a DB2 bind?
What is dpf in db2?
What is a db2 schema?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
How will you return the number of records in table?
How can you find out the # of rows updated after an update statement?
COBOL 
