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 db2 400?
How do I change the column size in db2?
What do you mean by storage group (stogroup)?
What is the advantage in De-normalizing tables in DB2?
what is the sqlcode -501
What is a dbrm in db2?
How do you stop a db2 database in linux?
What is the role of data manager in the db2 database?
What does sqlcabc has?
Define buffer pool.
When the like statement is used?
How can deadlocks be resolved?
What is the difference between spufi and qmf?
Explain how can you do the explain of a dynamic sql statement?
What action db2 takes when a program aborts in the middle of a transaction?
