Release-Informationen

36.3 Migrating from Version 6 of DB2 Query Patroller Using dqpmigrate

The dqpmigrate command must be used if the Version 7 Query Patroller Server was installed over the Version 6 Query Patroller Server. For FixPak 2 or later, you do not have to run dqpmigrate manually as the installation of the FixPak runs this command for you. Without using this command, the existing users defined in v6 have no EXECUTE privileges on several new stored procedures added in Version 7.

Anmerkung:

dqpmigrate.bnd is found in the sqllib/bnd directory and dqpmigrate.exe is found in the sqllib/bin directory.

To use dqpmigrate manually to grant the EXECUTE privileges, perform the following after installing the FixPak:

1. Bind the /sqllib/bnd/dqpmigrate.bnd package file to the database where the Query Patroller server has been installed by entering the following command:

   db2 bind dqpmigrate.bnd
   

2. Execute dqpmigrate by entering the following:

   dqpmigrate dbalias userid passwd