Answer Posted / s

1.Unload the DB
2.Delete/Define Database Datasets (if space allocation
needs to be changed make necessary changes)
3.Change the DBD to calculate how many RAPS is needed.
RAPS is the number of DB records that can be stored in a
Block, say 8KB Blocksize. Say you have 1000 byte records
and 16,000 records 8*1024/1000= 8. Relative Block Number
(RBN) is the number of blocks in the Root addressable area
= 16000/8 = 2000. Add some % to these blocks as free space,
say 2500.
Make changes to DBD. RMNAME(DFSHDC40,8,2500)
4.Reload DB with new DBD.
5.Use other utilities to rebuild logical relationships and
secondary indices.
6.Image Copy the DB.

What is acbgen process?

1165

---

What are the processing modes available in ims db?

1063

---

What information does a psb contain?

1082

---

What is mpp mode?

1117

---

Define psb?

1063

---

What is dl/i?

1112

---

What is an ims database?

1113

---

Explain psbgen process?

1169

---

Explain the maximum number of fields allowed per segment and what is the maximum number of fields per database?

1042

---

What is the maximum number of pcbs allowed in a psb?

950

---

Explain the maximum of key fields and search fields allowed in a segment?

3189

---

Explain the maximum number of segment types allowed for a single database?

2241

---

What is batch dl/i mode?

3337

---

What are the advantages and disadvantages of a hierarchical database?

1123

---

how do you bind the cobol with db2

2774

---