Updates the database system catalog to support the fix pack you have installed. This command can be used only on a database running DB2® for Linux, UNIX and Windows Version 9.7 Fix Pack 1 or later.
SYSADM
Database. The command automatically establishes a connection to the specified database.
>>-db2updv97-- -d--database name--------------------------------> >--+----------------------------+--+-----+--+-----+--+-----+--->< '- -u--userid-- -p--password-' '- -a-' '- -i-' '- -h-'
db2updv97 -d sample
If
your databases were created or upgraded to DB2 Version 9.7 GA and you applied DB2 Version 9.7 Fix Pack 1 or later, then running
the command automatically applies all updates required from Version
9.7 GA up to and including the fix pack level that you are installing.In a partitioned database environment, this command must be run on the catalog partition.
For Version 9.7 Fix Pack 2 or later, issuing the db2updv97 command is mandatory in order to execute the SYSPROC.ADMIN_GET_MSGS table function. However, if you revert to Version 9.7 Fix Pack 1 or earlier after running the db2updv97 command, contact your DB2 support representative before trying to run this table function.
For improved performance, the db2updv97 command applies only the updates that are required in order to make the databases appear as if they were created at the fix pack level that you are installing. Thus, if the command is issued more than once, no errors are reported and each of the system catalog updates is applied only once. However to force the reapplication of all updates, append the -a parameter.
SELECT TABSCHEMA, TABNAME
FROM SYSCAT.DATAPARTITIONS
WHERE INDEX_TBSPACEID = 0 AND
TBSPACEID IS NOT NULL AND
TABSCHEMA NOT IN ('SYSIBM', 'SYSCAT', 'SYSSTAT',
'SYSIBMADM', 'SYSCATV82')
GROUP BY (TABSCHEMA, TABNAME);
If this query returns any
results, then you can do one of the following steps:After updating to DB2 Version 9.7 Fix Pack 1 or later and running the db2updv97 command, the database cannot move back to DB2 Version 9.7 GA level. The SQL0901N error will be returned when trying to connect to the database.