Answer / sagar kajale

aix is used to access records of vsam ksds in order other than ksds files primary key or we can say base key. the ds over which aix exists is called a base cluster.
aix are ksds and has their own data and index component.

advantages:
can be updated automatically.
reduces data redundancy.
can be defined for both ksds and esds.
can have duplicates.

Disadvantages:
complex update logic.
performance degradation.

What are the common vsam error conditions and codes?

0 Answers  

---

Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.?

1 Answers  

---

What is an alternate index?

1 Answers  

---

Explain the meaning and syntax for the START command. ?

4 Answers   IBM,

---

what is difference between repro and export? if any one know this plz tell me

7 Answers   Cap Gemini,

---

what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.

4 Answers   Target,

---

what is meant by s0c-07 system abend codes?

0 Answers   IBM,

---

Describe the uses of ams?

0 Answers  

---

to use the rewrite command, how should the vsam file be opened?

0 Answers   IBM,

---

By looking into the Jcl can we identify the dataset is VSAM?

5 Answers   Cognizant, Keane India Ltd,

---

What is a ci split? What is a ca split?

0 Answers  

---

Hi, I want to create alternate index on VSAM file.my file structure is ex: RoomID pic x(7) R000001 Floor pic a((6) First RoomNo pic x(2) FA1 Occupied(yes/no) pic a(3) Yes Occupied Batch pic x(10). Maths i want to create alternate index on floor,roomno fields.can i create alternate index on both the fields.and tell me how to create.

1 Answers  

---