Answer / Reetika Yadav

To handle a deadlock (-911) error in a DB2 program, you can use one of the following strategies:
1. Implement locking procedures to avoid deadlock situations.
2. Use the DEADLOCK TREATMENT option in DB2 to specify how the system should react when a deadlock occurs.
3. Catch the error using a try-catch block, and implement a recovery plan within the catch block.

Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!

1 Answers  

---

If a ceo wants to see all employees of the company from an online screen. How will be the design of the map from the developer point of view?

1 Answers  

---

Explain delete-connected tables?

1 Answers  

---

suppose oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset?

1 Answers   IBM,

---

How do you pass pointer PL/1 main procedure to sub procedure?

1 Answers   IBM,

---

My program has an array defined to have 10 items. Due to a bug, I find that even if the program access the 11th item in this array, the program does not abend. What is wrong with it?

1 Answers  

---

by using xpeditor if we want to debug the subpgm, how can you code in x-ped for mai-pgm n sub-pgm ?

1 Answers  

---

Can you define a gdg?

1 Answers  

---

What is mainframe testing?

1 Answers  

---

Define the necessity of run stats among the environment test?

1 Answers  

---

How many bytes does a s9(7) comp-3 field occupy ?

1 Answers  

---

Explain index cardinality?

1 Answers  

---