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

DB2 Interview Questions

Questions Answers Views Company eMail

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

TCS,

7 72850

Is it possible to precompile if db2 goes down?

Target,

4 14026

Can we install 2 different versions of Db2 on same mainframe?

3 9084

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

Cap Gemini, Wipro,

10 58054

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 9007

How to solved 818 error

Keane India Ltd, Wipro,

4 14520

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 22825

How do you prepare a COBOL + DB2 program from coading till execution ?

Amdocs, Xansa,

1 10550

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

Xansa,

4 13944

How do you Load a table ?? and what is Load replace ?

Xansa,

2 33385

what is a plan and how do you refer the plan in the program?

Xansa,

2 7010

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

Infosys, TCS, Xansa,

9 35690

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

Xansa,

2 5964

what is copy pending and check pending ?

Xansa,

1 10541

what needs to be done if a table is in copy pending / check pending status?

Xansa,

5 22746

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the role of the data page in the db2 database?

972

Is schema the same as database?

1006

What is the use of value function?

1074

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1005

What is null indicator in cobol db2?

992

What is ibm db2 client?

880

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2278

What is dbrm library?

999

Explain how can you do the explain of a dynamic sql statement?

1063

What is the physical storage length of the data types date, time, and timestamp?

1040

Mention the different locking levels that are available in db2.

1070

Explain the function done by data manager?

1216

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

List down the types of triggers in the db2 database?

963

What are the full forms of spufi and dclgen and why are they used?

1023

For More Un-Answered { DB2 } Questions Click Here