Answer Posted / 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.

What is reorg?

1245

---

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 ?...

4373

---

What is check constraint. Explain with example.

1163

---

What is host variable?

1113

---

What is the maximum size of varchar data type in db2?

1178

---

Explain packages.

1173

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3011

---

Explain about rct.

1132

---

What is runstats db2?

1082

---

Can one database have multiple instances?

1097

---

What is the difference between nvl and coalesce?

1110

---

what is diffrence b/w file-aid tool and file-aid utility???

4963

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1147

---

Why select is not preferred in embedded sql programs?

1353

---

What's The Percentage Free Space ?

1285

---