Hello forum,

I am using AIX 7.1 and DB2 v10.1.0.3, i achieved this by applying fix pack 3 on v10.1.0.0.

when giving the command

db2look -d mydb -a -e -l -xd -o db2look.ddl

error is coming :

"SQL0206N "A.TYPERULES" is not valid in the context where it is used.
SQLSTATE=42703"

so i tried

db2updv10 -d mydb

but it fails with following error:


_____ DB2 Service Tools _____

I B M

db2updv10

This tool is a service utility designed to update a DB2 Version 10.1
database to the current fix pack level.

__________________________________________________ _______________________


DB2 Universal Database Version 10.1, 5622-044 (c) Copyright IBM Corp. 2011
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool

MESSAGE: SYSCAT.ROUTINEAUTH had 29 rows successfully updated.
MESSAGE: SYSCAT.MODULEAUTH had 0 rows successfully updated.
MESSAGE: Error granting execute on SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS_NEW to role SYSDEBUGPRIVATE, -204
MESSAGE: Rolling back work due to sqlcode: -204 on line 833.
db2updv10 processing failed for database 'mydb'.
[db2inst1@ho ~]$

please suggest any solution

regards