Release Notes

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

|

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