Interested to Buy Any Domain ? << Click Here >> for more details...
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 a db2 cursor?
What is the physical storage length of time data type?
How to access db2 tables in mainframe?
Explain various types of locks in db2?
What is a cursor in programming?
What is reorg?
How do I add a column to a table in db2?
What is node in db2?
What is db2 optimizer?
What is a dbrm in db2?
What is dbrm? When it will be created?
Which component is responsible for db2 startup and shutdown?
List down the data types in the db2 database.
How to connect to db2 database from windows command line?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
