Creating the OSMC application plans

After creating the databases for OSR, you must create the OSMC application plans. Member CBRHBIND in SAMPLIB is provided for this purpose. After running the job, the following DB2 messages should appear in the job output:

DSNT200I BIND FOR PLAN CBRHSMSI SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHOBJP SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHSOBP SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHSVOL SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHSBKV SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHRDAS SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHWDAS SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHDUPD SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHSBCC SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHSPCC SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHORCL SUCCESSFUL
DSNT200I BIND FOR PLAN CBRHCNTL SUCCESSFUL

Recommendation: The user ID associated with the CBRHBIND job must be the same as the user ID associated with the CBRISQL0 job, because the SQL statements in the OSMC application plans contain unqualified DB2 table names. When an unqualified DB2 table name is encountered during the BIND process, DB2 assumes the unqualified table name is the authorization ID of the binder.