Creating a DB2 package

To create a DB2 package, follow these steps:

  1. Create the collection using the following command:

    GRANT CREATE ON COLLECTION SYAMD2 TO PUBLIC

  2. Bind the plan to include the collection and grant access to the packages using the following command:

    BIND PLAN(AMD2PLAN) ACTION(REPLACE) PKLIST(*.SYAMD2.*) + ISOLATION(CS) VALIDATE(BIND) GRANT RUN ON PLAN AMD2PLAN TO PUBLIC

  3. Bind the packages in the collection using the following command:

    BIND PACKAGE(SYAMD2) ACT(REPLACE) + LIBRARY('SYBASE.AMD2105.CICSDB2.DBRM') MEMBER(RSPA) + ISOLATION(CS) VALIDATE(BIND) GRANT EXECUTE ON PACKAGE SYAMD2.RSPA TO PUBLIC BIND PACKAGE(SYAMD2) ACT(REPLACE) + LIBRARY('SYBASE.AMD2105.CICSDB2.DBRM') MEMBER(RSPB) + ISOLATION(CS) VALIDATE(BIND) GRANT EXECUTE ON PACKAGE SYAMD2.RSPB TO PUBLIC