Release Notes
|This command updates the system catalogs in a database to support the
|current FixPak in the following ways:
|
- |Enables the use of the new built-in functions: ABS, DECRYPT_BIN,
|DECRYPT_CHAR, ENCRYPT, GETHINT, MULTIPLY_ALT, and ROUND.
- |Enables the use of the new built-in functions for Unicode databases:
|DATE(vargraphic), TIME(vargraphic), TIMESTAMP(vargraphic),
|GRAPHIC(datetime-expression), GRAPHIC(date-expression),
|GRAPHIC(time-expression), and VARGRAPHIC(datetime-expression).
- |Enables the use of the new built-in procedures (GET_ROUTINE_SAR and
|PUT_ROUTINE_SAR).
- |Adds or applies corrections to WEEK_ISO and DAYOFWEEK_ISO functions on
|Windows and OS/2 databases.
- |Applies a correction to table packed descriptors for tables migrated from
|Version 2 to Version 6.
- |Creates the view SYSCAT.SEQUENCES.
- |Creates the system objects needed in order to use a DB2 version 8
|client to connect to a DB2 version 7 server.
|
|
- |Authorization
- |sysadm
- |Required Connection
- |Database. This command automatically establishes a connection to
|the specified database.
- |Command Syntax
-
|>>-db2updv7---d--database_name--+--------------------------+---->
| '--u--userid---p--password-'
|
|>--+----+------------------------------------------------------><
| '--h-'
|
|
- |Command Parameters
-
|
- |-d database-name
- |Specifies the name of the database to be updated.
- |-u userid
- |Specifies the user ID.
- |-p password
- |Specifies the password for the user.
- |-h
- |Displays help information. When this option is specified, all other
|options are ignored, and only the help information is displayed.
|
- |Example
- |After installing the FixPak, update the system catalog in the sample
|database by issuing the following command:
|db2updv7 -d sample
- |Usage Notes
- |This tool can only be used on a database running DB2 Version 7.1 or
|Version 7.2 with at least FixPak 2 installed. If the command is
|issued more than once, no errors are reported and each of the catalog updates
|is applied only once.
|To enable the new built-in functions, all applications must disconnect from
|this database and the database must be deactivated if it has been
|activated.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]