IBM DB2 Realtime Interview Questions:

11/10/2009 No Comment

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 :

 

Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer