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?

2021

How can you count the number of rows from a table tab?

1039

What are the various data types available in db2?

1011

What is the function of logging in the db2 database?

1068

What is performance tuning db2?

1006

What is schema in db2?

961

Explain in detail about buffer manager and its functionalities?

992

Is it possible using max on a char column?

1083

What does a deadlock mean in DB2?

1094

Mention data types used in db2 ?

1105

What is the advantage in De-normalizing tables in DB2?

1114

What is isolation level in db2?

941

How do you select a row using indexes in db2?

1072

How do I optimize a query in db2?

1037

How can you quickly find out the # of rows updated after an update statement?

984