版本注意事項
|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.
|
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]