When performing a schema repair between two db2 databases I receive errors SQL 1092n permissions error and an "unable to read table space parts" error. The user is dbadmin. It does work for the sysadmin. This problem is only occurring on db2 v8.2.6 fix pack 13. It does not seem to have this problem on v8.1.5. The current user did not create the objects, but the user is dbadmin so it shouldn't matter.
Example:
Database A is on V8 FixPak 5
Database B is on V8 FixPak 5
Database C is on V8 FixPak 13
Schema compares between Database A and Database B succeed, even though the user running the compare has relatively few privileges on either database.
Comparing either database with Database C produces two permissions errors with the message "Unable to read tablespace parts" and a SQL1092N error, but the error does not specify which object was being accessed.
If I grant DBADM ON DATABASE to the particular user, the permissions errors still occur during a schema compare.
The only way I can get a schema compare to work with the V8.2 FixPak 13 database is to give Toad the instance owner's login to the database. So, on a V8.2 database, DBADM can't run a schema compare, but SYSADM can.
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center