Interested to Buy Any Domain ? << Click Here >> for more details...
what are extents?
- 5 Answers
- 16667 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 |
What is syscat in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a bind in db2?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is the connection string to connect to the DB2 Database ?
Explain what are the various isolation levels possible?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is bind in db2?
What can the Locate option of the Repair Utility accomplish?
How to fetch the last row from the table in SQL (db2)?
What is concurrency in db2?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
COBOL 
