Command Reference

db2rbind - Rebind all Packages

Rebinds packages in a database.

Authorization

One of the following:

• sysadm

• dbadm

Required Connection

None

Command Syntax

>>-db2rbind--database--/l logfile----+------+------------------->
                                     '-all--'
 
>-----+-------------------------+------------------------------><
      '-/u userid--/p password--'
 

Command Parameters

database

Specifies an alias name for the database whose packages are to be revalidated.

/l

Specifies the (optional) path and the (mandatory) file name to be used for recording errors that result from the package revalidation procedure.

all

Specifies that rebinding of all valid and invalid packages is to be done. If this option is not specified, all packages in the database are examined, but only those packages that are marked as invalid are rebound, so that they are not rebound implicitly during application execution.

/u

User ID. This parameter must be specified if a password is specified.

/p

Password. This parameter must be specified if a user ID is specified.

Usage Notes

This command uses the CLP REBIND command to attempt the revalidation of all packages in a database. Use of db2rbind is not mandatory. One may choose to allow package revalidation to occur implicitly when the package is first used, or to selectively revalidate particular packages with either the REBIND or the BIND command.

See Also

BIND

REBIND.

[ DB2 List of Books | Search the DB2 Books ]