IBM MainFrame DB2 Interview Questions.
Mainframe professionals are invited to share the answers.
- Explain the difference between IN subselects and EXISTS subselect?
- What is performance tuning in DB2?
- Is there any advantage to demoralizing DB2 tables?
- What is difference between 911 and 913 error code in DB2?
- What do you mean by a thread in DB2?
- What do you mean by a DB2 bind?
- Explain difference between sys.cat and sys.ibm?
- How will you send data from a COBOL file to DB2 table?
- What do you mean by a DB2 plan?
- What is the index, describe various types of index?
- How many clustering indexes are passing for a table?
- When you will use cursor with hold option in DB2?
- Explain File opening modes in COBOL and corresponding dispositions?
- Explain what will happened .if the file is open in extend mode and corresponding is equal to old in JCL?
- How to know other person job status in DB2?
- What will happened, if the subprogram is called second time?
- Explain Performance Tuning on COBOL-DB2 program?
- What is stored in tables under creator SYSIBM?
- What do you mean by low values and high values in DB2?
- How to enter in xpediter in DB2?
- How to pass return codes from COBOL to JCL?
- What is difference between check pending and copy pending?
- Explain how can you Repair the table?
- Describe how can you see the status of the table?
- How can you eliminate duplicate values in DB2 SELECT?
- Explain how to load data to a table in DB2?
- What is difference between QMF & Spoofi?
- What is severity one error in production support?
- Explain Reuse and upgrade in detail.
- Explain how do you read VSAM file?
- How can we over come the same situation when using flat file.
- What are the compiler options we use? where the compiler option will be? What is the need of compiler options?
- After bind, how can we run a COBOL-db2 program?
- By using any condition is there any way to abend a program.? If so how?
- What is the difference between plan,package,dbrm?
- How to increase table space in DB2?
- What is the indexset and sequence set in VSAM ksds?
- How to read last record in VSAM file., I don't know how many records are there?
- What do you mean by a packed decimal in DB2?
Related Posts
No comments :