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


Please Help Members By Posting Answers For Below Questions

Where do you specify them?

686


Describe major components of db2?

644


What is the result of open cursor statement?

642


List out the three types of page locks that can be held.

691


If I have a view which is a join of two or more tables, can this view be updateable?

702






How would the varchar column remarks defined?

642


What is reorg?

624


What are the contents of a dclmgen?

635


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 ?...

3799


Can we update view in db2?

563


What is the role of union all and union

654


What is the role of data manager in the db2 database?

653


What is innodb buffer pool?

566


What are the various isolation levels possible?

652


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?

1630