Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are extents?

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


Please Help Members By Posting Answers For Below Questions

What is db2 stogroup?

1223


How is deadlock resolved?

1207


What is the role of the data page in the db2 database?

1084


Which component is used to execute the sql statements?

1147


Highlight all the advantages that are attached to a package.

1170


Can we delete records from view?

1023


How do you stop a db2 database in linux?

1060


What is host variable?

1113


What is netezza database?

1082


What is difference between alias and synonym in db2?

1200


What does a deadlock mean in DB2?

1221


How many types of page locks can be held in db2?

1091


what is utility for parm lib

2423


What is a system catalog table in db2?

1246


Comment whether the cursor is closed during commit or not.

1171