Interested to Buy Any Domain ? << Click Here >> for more details...
what are extents?
- 5 Answers
- 16676 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Is there any advantage to denormalizing DB2 tables?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
How to resolve -504 sql code in DB2?
Who uses db2?
How to test SQL -911 error while developing COB-DB2 program
Why do we bind in db2?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
How do you stop a db2 database in linux?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
wht happens if we close cursor with cursor with hold option?
COBOL 
