![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions An application plan or package is generated by the bind to define an access path. Latest Answer : DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths. ... Latest Answer : a package/dbrm is binded to a plan after compilation of a cobol-db2 / cics-cobol-db2 program.a dbrm is produced during precompile step.usually dbrm is associated to a package and package is binded to a plan for cost effectiveness.Plan is created ... Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION. Read Answers (4) | Asked by : Anand Latest Answer : The main difference between Plan and package lies with the time. When a DBRM undergoes the bind process, the outcome in earlier days was called as a Plan and nowadays it can either be a Plan or a package. So, plan was what existed prior to DB2 V2R3 and ... Read Answers (1) | Asked by : priya a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The Latest Answer : e. access path created by bind command. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||