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?

2097

Explain various types of locks in db2?

1150

How to fetch the last row from the table in SQL (db2)?

1653

How to find the number of rows in a db2 table?

1120

How does cobol compile db2 program?

1057

Define predicate?

1131

What do you mean by storage group (stogroup)?

1041

What is a bind in db2?

1042

How can we retrieve the total number of records in RPG & CLLE?

655

How do I optimize a query in db2?

1101

What's The Percentage Free Space ?

1224

Define buffer pool.

1054

What is a trigger in the db2 database?

1080

What are the different types of base tables?

1092

What is scrollable cursor in db2?

1055