Define db2.

755

How can deadlocks be resolved?

625

What is difference between rollback and commit?

730

What is an instance in db2?

646

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?

1722

What are union and union all?

623

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2848

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7099

What is load replace in db2?

639

What is the maximum length of sqlca?

976

What is the syntax for FETCH in DB2 ?

764

Which is faster delete or truncate?

766

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

831

Why do we need reorg in db2?

642

What are bind parameters in db2?

689