Optional: Binding the Apply program packages (Linux, UNIX, Windows)

The Apply program is bound automatically on Linux®, UNIX, and Windows during execution. You can bind packages manually if you want to specify bind options, schedule binding, or check that all bind processes completed successfully.

Procedure

To bind the Apply program packages:

  1. Change to the directory where the Apply program bind files are located.
    Linux, UNIX
    db2homedir/sqllib/bnd

    Where db2homedir is the Db2® instance home directory.

    Windows
    drive:\...\sqllib\bnd

    Where drive: is the drive where Db2 is installed.

  2. For each source server, target server, Capture control server, and Apply control server to which the Apply program connects, do the following steps:
    1. Connect to the database by entering the following command:
      
      db2 connect to database
      
      Where database is the source server, target server, Capture control server, or Apply control server. If the database is cataloged as a remote database, you might need to specify a user ID and password on the db2 connect to command. For example:
      
      db2 connect to database user userid using password
      
  3. Create and bind the Apply program package to the database by entering the following commands:
    
    db2 bind @applycs.lst isolation cs blocking all grant public
    
    
    db2 bind @applyur.lst isolation ur blocking all grant public
    
    Where cs specifies the list in cursor stability format, and ur specifies the list in uncommitted read format.
These commands create packages, the names of which are in the files applycs.lst and applyur.lst.