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 ]