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 stogroup?
How is deadlock resolved?
What is the role of the data page in the db2 database?
Which component is used to execute the sql statements?
Highlight all the advantages that are attached to a package.
Can we delete records from view?
How do you stop a db2 database in linux?
What is host variable?
What is netezza database?
What is difference between alias and synonym in db2?
What does a deadlock mean in DB2?
How many types of page locks can be held in db2?
what is utility for parm lib
What is a system catalog table in db2?
Comment whether the cursor is closed during commit or not.