Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mehdee
About the above question. We create INDEX when we create a
DB2 table, but Leaf pages are created by DB2 as this DB2
table being accessed and it keeps going on. That is why
DBADM use the SYSIBM.SYSINDEXES table and check on the
column LEAFDIST to see for example if it is greater than
500, then they run the REORG job then RUSTATS to bring down
the Leaf pages distribution to less then 500 to improve
access performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I optimize a query in db2?
What is the difference between bind and rebind in db2?
Why do we bind in db2?
Discuss about db2 bind?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's The Error Code For Unique Index Voilation?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Is db2 a mainframe database?
Mention the different locking levels that are available in db2.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
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?
What is release/acquire in bind?
What is an instance database?
What is alias in db2?
