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?

Answers were Sorted based on User's Feedback



what are extents?..

Answer / harish

EXTENTS ARE CONTIGIOUS MEMORY ALLOCATIONS

FOR SEQUENTIAL 16 EXTENTS ARE POSSIBLE AND FOR VSAM 123
EXTENS ARE POSSIBLE..........

pls let me know if ANY OTHER ANSWERS.

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

Is This Answer Correct ?    5 Yes 2 No

what are extents?..

Answer / harish

extents are contigous memory locations

Is This Answer Correct ?    3 Yes 3 No

what are extents?..

Answer / shailendra

extent means not a continious memory allocation.
its means the number of gap between the memory allocation
is possible when data is going to store.
if the extent is full then just run the jcl
with

space=(cyl or blk,(primary,secondary,directory,3),rlse)

it will increase the no extent by 3*16
previously it was 1*16.

Is This Answer Correct ?    1 Yes 1 No

what are extents?..

Answer / prashanth yp

An extent is a contiguous area of storage in a computer file
system, reserved for a file. When a process requires
starting to write to a file, file-system management software
allocates a whole extent. When writing to the file again,
possibly after doing other write operations, the data
continues where the previous write left off. This reduces or
eliminates file fragmentation and possibly file scattering
too.(VISIT WWW.COOLINDIA.WEBS.COM FOR MORE)

Is This Answer Correct ?    0 Yes 0 No

what are extents?..

Answer / 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

More DB2 Interview Questions

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  


What does the CHECK Utility do ?

1 Answers  


what is SPUFI ?

2 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


how to take the back up of the DB2 table.

7 Answers  


What is the maximum size of a char data type in db2?

0 Answers  


For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


What is a storage group (stogroup)?

0 Answers  


What is alias in db2?

0 Answers  


Categories