Answer Posted / mehdee
- Extents in DB2 is about either Table Space or Index Space
going further than the PRIQTY assigned, into SECQTY
assigned when we did the create, and it slows downe the
access to these tables. So when EXTENTs is more than 1,
then we need to do DB2 ALTER and increase the PRIQTY on
STOGROUP for that Table Space of Index Space.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is db2 purescale?
B37 abend during spufi?
How do I add a column to a table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is package in db2 mainframe?
How can you find out the # of rows updated after an update statement?
How to view db2 table structure?
How does a cursor work?
What are the uses of db2 optimizer?
How do I import a csv file into db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is cloudant database?
What is a trigger in the db2 database?
What is explain in db2?
What are the benefits of using the db2 database?