Is it possible to precompile if db2 goes down?
Answer Posted / reddy kanupuru
Yes. DB2 need not be up during precompilation stage. at
that stage DB2 will get the info about tables using DCLGEN
not from the tables
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where do you specify them?
Describe major components of db2?
What is the result of open cursor statement?
List out the three types of page locks that can be held.
If I have a view which is a join of two or more tables, can this view be updateable?
How would the varchar column remarks defined?
What is reorg?
What are the contents of a dclmgen?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Can we update view in db2?
What is the role of union all and union
What is the role of data manager in the db2 database?
What is innodb buffer pool?
What are the various isolation levels possible?
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?