DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 5571

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

8 14141

wht happens if we close cursor with cursor with hold option?

Valtech,

3 12399

what is main use of table space and index object? please its urgent

CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

5 16162

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

IBM,

3 18583

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

IBM, TCS,

2146

How can we define a table? How can we apply SEARCH ALL on it ?

1 4653

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

Deloitte,

2 7339

what is the use of commit ? and what is the syntax?

Deloitte,

2 10315

what is the difference between declaring the cursor in WS section and Procedure division?

HCL,

1 8439

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

Cap Gemini,

9 14596

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 10181

Can any one tell me about Restart logic in DB2.

2 7302

Do we need cursor for Count(*)?

iGate,

4 9020

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I copy a table in db2?

1000

What is the maximum No of rows per page?

1067

What language is db2 written in?

1047

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

Explain the function done by data manager?

1280

What is meant by dclgen?

1109

What is precompiler in db2?

1018

Explain about mirror activator disk mirroring?

1009

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535

Explain packages.

1112

What types of tables are there in the db2 database?

1056

How can you do the explain of a dynamic sql statement?

1069

Are view updateable?

1043

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

B37 abend during spufi?

1455

For More Un-Answered { DB2 } Questions Click Here