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
How do you eliminate duplicate values in db2?
What is consistency token in db2?
What is data manager?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do I copy a table in db2?
Are views updateable?
What is load utility in db2?
what is the responsibility of the construction superintendent
What is query_cache_limit?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is null indicator in cobol db2?
What does db2 stand for?
Explain dclgen.
How does coalesce work?
What parameters are used to control the free space in DB2?
