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

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

 1 5195

What is the database descriptor?

 2 13015

What is the syntax required for the creation of a cursor?

 1 8547

What is meant by AUTO COMMIT?

 3 8844

What information is contained in a SYSCOPY entry?

 2 8902

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 18719

What is lock contention?

 1 4749

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

 1 3766

What is COPY PENDING status?

 6 34714

What is IMAGECOPY ?

 6 37048

What are the functions of Bind?

Amdocs, IBM,

2 7166

What is a cursor?

 2 5554

When is the authorization check on DB2 objects done - at BIND time or run time?

 1 12494

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

 2 4263

What can the Locate option of the Repair Utility accomplish?

 2 4665

Post New DB2 Questions

Un-Answered Questions { DB2 }

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10722

What is the difference between plan and package in db2?

564

what is utility for parm lib

1863

What do you mean by storage group (stogroup)?

574

What does db2 mean?

576




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 ?

1805

How do we specify index to include or not during bind process.

1667

What action db2 takes when a program aborts in the middle of a transaction?

647

Define sqlca.

642

What is the physical storage length of timestamp data type?

638

What is db2 plan table?

608

How does db2 sample database connect?

562

What is dbrm? When it will be created?

588

what is the responsibility of the construction superintendent

1652

What is role in db2?

608

For More Un-Answered { DB2 } Questions Click Here