Release-Informationen

12.2 db2updv7 - Update Database to Version 7 Current Fix Level

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 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.

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.