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

Answer / harish

extents are contigous memory locations

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.

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)

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.

What is a Database Request Module(DBRM)?

4 Answers  

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

Explain what a plan is?

3 Answers   CTS,

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

Explain in detail about buffer manager and its functionalities?

0 Answers  

wht is d/f between union and joins ?

2 Answers  

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

When is the access path determined for dynamic SQL?

2 Answers  

Mention and explain the contention situations caused by locks?

1 Answers  

What is the self-referencing constraint?

2 Answers