DB2 Interview Questions
Questions Answers Views Company eMail

What are PACKAGES ?

3 8038

Which catalog tables contain authorization information?

1 5460

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 8640

How does one remove entries from the SCT02 table?

1 3999

what is the difference between join and union?

IBM,

4 17375

I use CS and update a page. Will the lock be released after I am done with that page?

2 8886

Explain what a plan is?

CTS,

3 7755

What is a synonym ?

2 4853

What are the four lockable units for DB2?

1 5645

In a DB2-CICS program which is acts as co-ordinator and which is participant?

IBM,

1 4723

Describe what a storage group(STOGROUP) is?

2 9505

What is SPUFI?

4 15857

What is the difference between SYNONYM and ALIAS?

TCS,

6 27049

What is a data page?

1 3860

What is a subselect? Is it different from a nested select?

1 6893


Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain in brief how does db2 determine what lock-size to use?

673


What is copy pending and check pending in db2?

663


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1981


List down the data types in the db2 database.

716


What is cascading rollback?

711






What is a plan and package in db2?

729


How to check table size in db2 sap?

667


What is reorg?

691


What is netezza database?

662


How to restart a DB2 program?

1453


What is db2 bind process?

829


Is db2 a mainframe?

677


What parameters are used to control the free space in DB2?

726


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 ?

1917


Explain about open switch business continuity software?

667