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--'
 
                                       .-conservative--.
>-----+-------------------------+--/r--+-any-----------+-------><
      '-/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.

/r

Resolve. Specifies whether rebinding of the package is to be performed with or without conservative binding semantics. This affects whether new functions and data types are considered during function resolution and type resolution on static DML statements in the package. This option is not supported by DRDA. Valid values are:

conservative

Only functions and types in the SQL path that were defined before the last explicit bind time stamp are considered for function and type resolution. Conservative binding semantics are used. This is the default.

any

Any of the functions and types in the SQL path are considered for function and type resolution. Conservative binding semantics are not used.

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.