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.

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

how to resolve -811 error. give clear explination

4 Answers   IBM,

what is SPUFI ?

2 Answers  

what is difference between random and sequence file access

1 Answers   Syntel,

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

Update command

1 Answers  

Mention the downsides of page level lock.

0 Answers  

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,