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 with ur in db2?
What is cursor with hold option in db2?
What is a storage group (stogroup)?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a db2 tablespace?
How do I add a column to an existing table in db2?
What action db2 takes when a program aborts in the middle of a transaction?
Mention the definition of cobol in varchar field.
What happens in bind step in a db2 program?
What is db2 instance?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is db2 stogroup?
What are the different types of base tables?
What does sqlcabc has?
What are the various data types available in db2?