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 5508

What is the database descriptor?

 2 13552

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

 1 8924

What is meant by AUTO COMMIT?

 3 9253

What information is contained in a SYSCOPY entry?

 2 9310

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

Emsang,

5 19370

What is lock contention?

 1 5008

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 4015

What is COPY PENDING status?

 6 35461

What is IMAGECOPY ?

 6 37906

What are the functions of Bind?

Amdocs, IBM,

2 7539

What is a cursor?

 2 5836

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

 1 12914

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

 2 4613

What can the Locate option of the Repair Utility accomplish?

 2 4961

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 tablespace?

723

Is db2 a programming language?

734

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1762

What is reorg and runstats in db2?

865

Is schema the same as database?

755




What is dclgen in db2?

815

How to view db2 table structure?

716

Explain the function done by data manager?

963

How to get the ddl of a table in db2?

801

can all users have the privilage to use the sql statement select * (dml)?

764

What is database alias db2?

739

Explain in detail about buffer manager and its functionalities?

690

What is iseries database?

711

What is package in cobol db2?

813

What are the 2 sqlcodes that are returned?

762

For More Un-Answered { DB2 } Questions Click Here