MEMBER bind option
The MEMBER option determines what database request modules (DBRMs) to include in the package.
| Command option | Option values | Used with |
|---|---|---|
| MEMBER |
|
The MEMBER option is deprecated for BIND PLAN. Use it only when you cannot run BIND PACKAGE to bind DBRMs into packages explicitly. When you specify MEMBER, Db2 binds the DBRMs into packages, and includes those packages in a package list for the specified plan.
Option descriptions for MEMBER
- MEMBER(dbrm-member-name)
- Specifies the name of a partitioned data set member or zFS file that contains a DBRM.
When the LIBRARY parameter is also specified, and dbrm-library-name is not delimited, LIBRARY identifies a partitioned data set, and dbrm-member-name identifies the data set member.
When the LIBRARY parameter is also specified, and dbrm-library-name is delimited with double quotation marks ("), LIBRARY identifies the absolute path of a zFS file, and dbrm-member-name identifies the zFS file. DBRMs in zFS files are supported only for DBRMs that are generated from SQLJ programs.
When dbrm-member-name is delimited with double quotation marks, it can contain mixed-case characters. For example, the following command binds a package from a DBRM file with absolute path name /u/mylib1/myMem1:
BIND PACKAGE (MYCOLL1) MEMBER("myMem1") LIBRARY("/u/mylib1")Names beginning with DSN are reserved; you receive a warning message if dbrm-member-name begins with DSN.
dbrm-member-name becomes the package name.
For BIND PACKAGE, you can use only one member. If you do not use MEMBER, you must use COPY. You cannot use both options.
Default values for MEMBER
| Process | Default value |
|---|---|
| BIND PLAN | N/A |
| BIND PACKAGE | None |
| REBIND PLAN | N/A |
| REBIND PACKAGE | N/A |
Catalog records for MEMBER
See the NAME columns in SYSPACKAGE catalog table and SYSPACKLIST catalog tableT.