版次注意事項


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

|Note:
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
    |


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]