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

What are PACKAGES ?

 3 7749

Which catalog tables contain authorization information?

 1 5266

Is DECLARE TABLE in DCLGEN necessary? Why it used?

 3 8313

How does one remove entries from the SCT02 table?

 1 3850

what is the difference between join and union?

IBM,

4 17008

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

 2 8606

Explain what a plan is?

CTS,

3 7436

What is a synonym ?

 2 4647

What are the four lockable units for DB2?

 1 5490

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

IBM,

1 4533

Describe what a storage group(STOGROUP) is?

 2 9260

What is SPUFI?

 4 15453

What is the difference between SYNONYM and ALIAS?

TCS,

6 26333

What is a data page?

 1 3699

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

 1 6706

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 instance?

585

What does reorg do in db2?

567

Why do we need reorg in db2?

553

Can you tell me how can you find out the # of rows updated after an update statement?

602

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

634




What is node in db2?

599

What is the maximum size of a char data type in db2?

578

What is null indicator in db2?

591

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

590

What is the role of union all and union

642

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

736

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

697

What are the full forms of spufi and dclgen and why are they used?

646

What are bind parameters in db2?

605

What is a bind card?

675

For More Un-Answered { DB2 } Questions Click Here