Answer Posted / s
It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Is db2 free?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the role of data manager in the db2 database?
What is a plan and package in db2?
What is a db2 package?
What is the picture clause of null indicator variable?
What are iseries servers?
What is commit in db2?
What is the maximum length of sqlca?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is iseries database?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Give a brief description of db2 isolation levels?
What is role in db2?