1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is the syntax for FETCH in DB2 ?

MCN Solutions,

653

How many databases can be created inside an instance in db2 ?

MCN Solutions,

587

What is the connection string to connect to the DB2 Database ?

MCN Solutions,

600

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

MCN Solutions,

696

Which command is used to connect to a database in DB2 ? Give the Syntax.

MCN Solutions,

590

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

 731

Mention the downsides of page level lock.

 694

What is concurrency?

 695

Explain the function of data manager.

 623

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

 696

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

 564

Define check constraint.

 629

define clustering index.

 607

List out the three types of page locks that can be held.

 674

Explain about rct.

 633

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you find the maximum value in a column in db2?

638

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

708

How do I start db2 in windows?

544

How to find the number of rows in db2 tables?

605

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

637




what is utility for parm lib

1859

What is the physical storage length of time data type?

654

How to find the maximum value in a column in the db2 database?

591

How is deadlock resolved?

636

What is precompiler in db2?

577

What's The Percentage Free Space ?

751

What is an instance database?

587

What is the result of open cursor statement?

625

How can you count the number of rows from a table tab?

623

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.

2313

For More Un-Answered { DB2 } Questions Click Here