Skip to Content
0
Former Member
Dec 08, 2014 at 01:18 PM

Error while system copy

438 Views

Dear friends,

I faced with problem which I can't solve by myself. I didn't find any solution in google and now I just want ask gurus for help

Database - DB2 10.1

I do homogeneus system copy. I did full offline backup. Which was restored ok. And I stack in step - grant database privileges:

GRANT ROLE SAPMON TO ROLE SAPAPP

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0796N The grant of role "SAPMON" to role "SAPAPP" is not valid as it would

create a cycle. SQLSTATE=428GF

I found that I need to revoke roles...

I did on OS level from user db2SID next revoke:

db2 => revoke role sapmon from role saptools

DB20000I The SQL command completed successfully.

db2 => revoke role sapmon from role sapapp

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0478N DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "ROLE"

cannot be processed because there is an object "SAPTOOLS.DB2_WORKLOAD_CHECK",

of type "VIEW", which depends on it. SQLSTATE=42893

Please support me what I need to fix...