On my workstation I have IBM Data Server Client 32 bit 10.5.500 installed and I am using Toad for DB2 Freeware version 6.1.0.125.I do get errors when I try to access indexes or script of a table in TOAD, I do not get any on Columns tab or Data tab. The user has all the privileges and I still get the errors.
– ERROR [] [IBM][DB2/AIX64] SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: “XXX_ETL”.
– ERROR [38553] [IBM][DB2/AIX64] SQL0443N Routine “SYSPROC.ADMIN_LIST_DB_PATHS” (specific name “ADMIN_LIST_DB_PATHS”) has returned an error SQLSTATE with diagnostic text “ADMIN_LIST_DB_PATHS”.
For Indexes, TOAD will run a query on the SYSCAT.INDEXES view. I suspect your userID does not have access to this view. In the editor try running “SELECT COUNT(*) FROM SYSCAT.INDEXES” and see what the results are.
For the script tab of a table or object I believe TOAD is using db2look to get the ddl. If that is correct then SELECT privilege is needed on the system catalog tables.
In Toad DB2 v6.1 when generating scripts, we initially called ADMIN_LIST_DB_PATHS to obtain database level information whether we needed to or not. So for example, we were calling that on the table’s Indexes tab and the table’s script tab. In Toad DB2 v6.2 we no long call ADMIN_LISTS_DB_PATHS during generic scripting. So you will not run into that issue. Also on the script tab we do not rely on db2look, but select information from the SYSCAT views. You can get the list of the catalog views and procedures we access in v6.2 from our release notes at: