Can we install 2 different versions of Db2 on same
mainframe?
Answers were Sorted based on User's Feedback
Answer / vinay
Yes you can. There could be multiple subsystems on a
mainframe machine and its not necessary to have the same
version of DB2 on all the Sub systems. One can have 7 and
the other can have 8.1 etc...
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / s
YES 2 diffrent DB2 Subsystems under the same MVS image can
be running different versions.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jack
Yes two different db2 started task can exist in one lpar
with two different version like db2xxxx and db2yyyyy....
Is This Answer Correct ? | 2 Yes | 0 No |
Explain in brief how does db2 determine what lock-size to use?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
My SQL is not performing well. Describe how will you fine tune it?
Is it possible using max on a char column?
What are the disadvantages of using VARCHAR?
What is a view? Why use it?
what is the input to PLAN? what is the input to DBRM?
What techniques will be used to avoid deadlock??
How do you pull up a query which was previously saved in qmf?
how will you retrieve first record in table
Can a array declared with an index be displayed(readable format) in spool?
What are the two types of logging in the db2 database? Explain them.