Answer Posted / guest

DEFINE ALTERNATEINDEX. Important paramters are RELATE where
you specify the base cluster name, KEYS,
RECORDSIZE,SHAREOPTIONS,UNIQUEKEY(or NONUNIQUEKEY), DATA(ds
name for the data component), INDEX(ds name for the index
component). Then DEFINE PATH. Important paramters are NAME
(ds name for the path), PATHENTRY (ds name of the alternate
index name), UPDATE(or NOUPDATE) which specifies whether an
alt index is updated when a update to the base cluster takes
place. Then BLDINDEX. Parameters are INDATASET(ds name of
base cluster), OUTDATASET(ds name of AIX).

what do you mean by recovery and speed parameters in define cluster command?

1025

---

Tell me how many alternate indexes you can have on a dataset?

1044

---

What is the use of lds (linear data set)?

963

---

explain how many ways you can load data in a vsam cluster?

975

---

What is a lds (linear data set) and what is it used for?

947

---

Explain the function of the relative record data set?

884

---

On which dataset you can have alt index?

865

---

Is it slower if you access a record through alt index as compared to primary index?

976

---

can you specify some the distinctive features of a ksds, key sequenced dataset?

980

---

what are the codes returned by the ams (access method services) command during the execution in vsam?

1223

---

what is the probability of a complete system distortion under high end low performing multiprocessor job?

2406

---

what is meant by dirty read in vsam?

1300

---

write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...

2689

---

Discuss record management in vsam?

905

---

What is the main function of key sequenced data set in vsam?

908

---