Interested to Buy Any Domain ? << Click Here >> for more details...
Why PS file called Physical seqential file?How to sore data
in sequential file and ESDS file?
What is the use of DBRM,PLAN,package and Collection.
- 1 Answers
- 4403 Views
- I also Faced
- E-Mail Answers
Answer / srini
What is the use of DBRM,PLAN,package and Collection.??
DBRM is just a SQL/DB2 part of a embeded COBOL and DB2
program,basically DB2 Precompiler creates this by just
commenting out all SQL/DB2 part.
PLAN is a collection of packages and its an executable for
DB2 system just like a loadmodule for Cobol.Plan stores all
the accee paths for table/database.
Package is a smaller version of package,we can say its a
bound DBRM or a plan for a single program,but its not
executable by itself,we can to bound it into plan,so that
plan can be executed.
We can directly have PLAN instead of going to package,but
we have many advantages of using package over the plan as
below.
1.We can have seperate versions(like same DBRM can be bound
into test package,model office package and production
package)
2.more granularity i.e when ever we change some sub
routine,we no need to bind all the calling/called chain and
block the entire transaction,we can just rebind the
perticular package so that the plan while executing
automatically picks it up the latest version of the package.
3.involves less cost,use the above said example.
4.easy maintanance.
COLLECTION
Collection is just a logical name given for a set of
packages that can be sed while creating the plan....there
is no physical existance of a collection...its a matter of
convenience to the user.
Hope this answers your query on DBRM,plan,package and
collection,if not let me know.
| Is This Answer Correct ? | 2 Yes | 0 No |
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is the syntax required for the creation of a cursor?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the advantage in De-normalizing tables in DB2?
What is filter factor?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain in detail about buffer manager and its functionalities?
What is the use of dclgen in db2?
What is a page?
What do you mean by between and in? Is between inclusive of specified range values?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
COBOL 
