Can we install 2 different versions of Db2 on same
mainframe?
- 3 Answers
- 7778 Views
- I also Faced
- E-Mail Answers
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 |
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?
What is difference between alias and synonym in db2?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is isolation level?
Once you create a view, where would information about the view be stored?
What do you need to do before you do EXPLAIN ?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
what is SMP/E? and what are the major steps of it? thanks...
What is db2 connect?
COBOL 
