版次注意事項


8.9 Appendix C. SQL Explain Tools

The section titled "Running db2expln and dynexpln" should have the last paragraph replaced with the following:

To run db2expln, you must have SELECT privilege to the system catalog views as well as EXECUTE authority for the db2expln package. To run dynexpln, you must have BINDADD authority for the database, the schema you are using to connect to the database must exist or you must have the EXPLICIT_SCHEMA authority for the database, and you must have any privileges needed for the SQL statements being explained. (Note that if you have SYSADM or DBADM authority, you will automatically have all these authorization levels.)


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