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 disadvantages of PAGE level lock?
What is the use of predicate?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is the command used by TSO users to invoke DB2?
What is difference between alias and synonym in db2?
What is tablespace?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How do you Load a table ?? and what is Load replace ?
Is db2 a mainframe database?
Define check constraint.
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?