DB2 Interview Questions
Questions Answers Views Company eMail

What is ibm db2 connect?

734

What is database manager in db2?

741

What does reorg do in db2?

769

What is blu acceleration in db2?

804

What is multi row fetch in db2?

756

What is dpf in db2?

840

What does db2 blu stand for?

864

What is phantom read in db2?

814

What is runstats db2?

751

What is reorg and runstats in db2?

920

What is dclgen in db2?

866

What is ibm db2 used for?

807

What is runstats and reorg in db2?

1003

What is runstats utility in db2?

752

What does db2 plan contain?

743


Post New DB2 Questions

Un-Answered Questions { DB2 }

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2514


What is performance tuning db2?

812


What is sqlca’s maximum length?

877


How to retrieve rows from a db2 table in embedded sql?

953


What is a Foreign Key?

837


What is concurrency?

895


Where can you declare a cursor in a cobol-db2 program?

766


What are types of indexes?

751


What is the cobol picture clause of the db2 data types date, time, timestamp?

823


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

774


What is the difference between spufi and qmf?

803


How do I import a csv file into db2?

733


How do I import data from excel to db2?

801


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2093


Explain about rct.

849