Interview Questions   Tutorials   Discussions   Programs   

DB2 - What are extents?

asked mar September 9, 2014 12:43 PM  

What are extents?


1 Answers

answered By Mswami   0  


An allocation of space, within a container of a table space, to a single database object. This allocation consists of multiple pages.

An extent is a contiguous area of storage in a computer file system, reserved for a file. When a process creates 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.

An extent-based file system (i.e., one that addresses storage via extents rather than in single blocks) need not require limiting each file to a single, contiguous extent.

   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -474
Number of Answers -1
Last updated
3 years and 3 months ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!