Mention the downsides of page level lock.

905

What is lock escalation in db2?

764

Explain the function of data manager.

782

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?

1828

Is db2 a database?

725

What are packages in db2?

769

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3313

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1996

What is the connection string to connect to the DB2 Database ?

829

What is cursor stability in db2?

1034

What does db2 plan contain?

743

What is the usage of open cursor command?

765

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

801

Which component is used to execute the sql statements?

819

Mention the various locks that are available in db2.

767