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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the functions in DB2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
List down the types of triggers in the db2 database?
What is bind and rebind in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
how can u retrieve the data from null values using applicaion program.
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
How can you find out the # of rows updated after an update statement?
What is db2 connect?
What is reorg?
Explain how can you do the explain of a dynamic sql statement?