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

What are PACKAGES ?

 3 7765

Which catalog tables contain authorization information?

 1 5280

Is DECLARE TABLE in DCLGEN necessary? Why it used?

 3 8326

How does one remove entries from the SCT02 table?

 1 3862

what is the difference between join and union?

IBM,

4 17028

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

 2 8624

Explain what a plan is?

CTS,

3 7456

What is a synonym ?

 2 4666

What are the four lockable units for DB2?

 1 5502

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

IBM,

1 4550

Describe what a storage group(STOGROUP) is?

 2 9273

What is SPUFI?

 4 15470

What is the difference between SYNONYM and ALIAS?

TCS,

6 26378

What is a data page?

 1 3712

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

 1 6717

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the location where the output received from explain statement is stored.

628

What is the picture clause of null indicator variable?

688

How to check sequence on a table in db2?

598

What is schema in db2?

572

can we view the access paths created by dbrm ? how ? thx

6240




What is the use of db2 optimizer?

606

When the like statement is used?

634

Why db2 is called db2?

589

How would you find out the total number of rows in a db2 table?

574

What is runstats and reorg in db2?

791

What are bind parameters in db2?

611

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

604

What is the role of union all and union

648

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2375

On which levels locks can be applied?

653

For More Un-Answered { DB2 } Questions Click Here