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

DB2 Interview Questions

Questions Answers Views Company eMail

What techniques will be used to avoid deadlock??

IBM, SUN,

5 14416

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 17988

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 18499

pls tell me abt the normalization five types....

2 5862

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

Cap Gemini, Verizon,

4 11709

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

Cap Gemini, RBS,

3 12823

Can we able to find all the Table names under a Particular Plan?

CTS,

1 6653

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

Cap Gemini,

1 8469

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 11478

What if we fail to give values in columns declared as NOT NULL ?

Cap Gemini,

3 9914

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

Cap Gemini,

2 9279

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

Cap Gemini,

1 6628

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

Cap Gemini,

3 12841

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

2394

How Plan is created while executing the query using SPUFI?

3 8638

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is innodb buffer pool?

1055

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2181

Is db2 a database?

973

What is db2? Explain.

1043

Mention data types used in db2 ?

1159

How to find primary key of a table in db2?

1066

Highlight all the advantages that are attached to a package.

1119

What does a deadlock mean in DB2?

1168

What is meant by dclgen?

1110

How to find the number of rows in a db2 table?

1120

Describe major components of db2?

1094

What is sqlca?

1077

How to access db2 tables in mainframe?

1054

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

Explain about cursor stability?

1051

For More Un-Answered { DB2 } Questions Click Here