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 / sunil a
1 DBRM , 1 PACKAGE and 1 PLAN
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is db2 purescale?
What is db2 catalog database?
What do you mean by cursor?
What is runstats and reorg in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What happens in bind step in a db2 program?
How can you find out the # of rows updated after an update statement?
What is data manager?
What is buffer pool?
How many types of page locks can be held in db2?
What are packages in db2?
What does db2 plan contain?
What are the full forms of spufi and dclgen and why are they used?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time