PLANs + COLLECTIONs + VERSIONs + PACKAGEs + DBRMs = Confusion
4 stars based on
To perform the bind function, you must have DB2 authority. Reinstates all installed default values on all setup and installation screens to the values assigned during installation.
When you press Enter bind plan syntax in db2 this screen, the bind operation begins. Specify the method to be used to invoke the DB2 command bind plan syntax in db2.
Valid choices are Batch, Editjcl, and Foreground. If Batch is specified, a job will be submitted to bind the plan.
The JCL and control cards can be modified before submitting or saving them. If you specify Foreground, the DB2 command processor will be invoked in the foreground.
The plan name must follow the DB2 defined syntax for plan names. A DB2 bind plan syntax in db2 plan is the output from the bind function, which converts the output from the DB2 precompiler to a usable control structure called an application plan. During bind plan syntax in db2 process, access paths to the data are selected and some authorization checking is performed. Specify the first DBRM to be included in the bind process.
Specify the identifier of the package collection to be included in the bind, following the DB2 defined syntax for names. Specify whether the plan is a new plan Add or if it is to Replace another plan by the same name.
Otherwise, leave this field blank. For performance reasons, the validation of the plan should be done during the bind process. Use CS for better performance and reduced lockout situations. Use RR only if you want to retain locks on read pages until you reach a commit synchronization point. Indicates the level of messages you want to see resulting from the bind.
Specify one of the following options:. Specify Yes to obtain explain information at bind time. If you want to indicate an owner other than yourself, enter the authorization ID of that person. If omitted, you are, by default, the owner of the plan. Select this option to create or update a list of bind member names and the list of DBRM libraries in which they reside.
Use to create or update a list of packages that will be used when binding a plan. Required only if the DBRM members specified are not contained in the list of installation libraries. You can specify up to four libraries. Normal concatenation rules are in effect—libraries bind plan syntax in db2 first are searched first, and buffer space for the library list is determined by the first library specified.
The installer entered the dsnames of common DBRM libraries that should be allocated to any sessions. These libraries are included in the DBRM library list for a plan that is created using the bind process. You can override the installed default libraries by specifying new libraries in these fields.
Warning, error, and completion messages. Only error and completion messages. To allocate DB2 resources when and as needed. To allocate the resources at the time the plan is allocated. To free up the resources after a commit is successfully executed. To deallocate any resources when the plan is deallocated.