If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / satish
yes only 1 DBRM will create
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How does a cursor work?
Why cursor is used in db2?
How is deadlock resolved?
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?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the difference between using bind () and rebind () methods of naming class?
What is db2 and what is the use of db2 optimizer?
what is utility for parm lib
How to resolve deadlock issue
Before you give the explain statement, what are the prerogatives?
What is the role of the data page in the db2 database?
What is an instance database?