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
Explain packages.
List out the data types available.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Explain the function done by data manager?
How to take backup of table in db2?
Name the various locking levels available?
Is it possible using max on a char column?
What is cascading rollback?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the use of db2 optimizer?
How do you pull up a query which was previously saved in qmf?
Outputs of explain are with matchcols = 0. What does this signify?
Mention data types used in db2 ?
What is the physical storage length of date data type?
What is the difference between cursor stability and repeatable read isolation levels?
