on 2011 Dec 13 6:05 PM
I've done an homogeneous system copy using a redirected restore of our PROD system to a Sandbox system.
In the Sandbox system, I now see the following in the system log :
08:11:42 BTC 003 000 DDIC BY 2 Database error -727 at OPC
08:11:42 BTC 003 000 DDIC BY 0 > SQL0727N An error occurred during implicit system action
08:11:42 BTC 003 000 DDIC BY 0 > type "3". Information returned for the error includes SQLCOD
08:11:42 BTC 003 000 DDIC BY 0 > "-204", SQLSTATE "42704" and message tokens
08:11:42 BTC 003 000 DDIC BY 0 > "SYSTOOLS.ADMINTASKS". SQLSTATE=56098
08:11:42 BTC 003 000 DDIC BY 1 Database error -727
I also see similar messages in the db2diag.log file.
Any ideas why ?
Thanks,
Robert
Do you see any other error nearby to these error lines ?
Just to confirm, did you grant full access to systool tablespace, for e.g. SYSTOOLSPACE for the user sapsid ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can drop the view as follows:
db2 "drop view SYSTOOLS.ADMIN_TASK_LIST"
BR,
Paul
Everyone,
Thanks for your responses.
PUBLIC has been granted USE of tablespace SYSTOOLSPACE.
DBADM and SECADM has been granted to db2<sid> and <sid>adm.
It appears that view SYSTOOLS.ADMIN_TASK_LIST is invalid because it references table SYSTOOLS.ADMINTASKS. That table does not exist in the database. What creates this table ?
As documented in the SYSTEM COPY guide, I dropped and recreated tablespace SYSTOOLSPACE so all database objects in that tablespace would also be dropped.
What am I missing ?
Thanks,
Robert
Paul,
Dropping the views resolved this issue. Thanks.
Do you know what creates the tables (systools.admintask and systools.admintaskstatus) and the views (systools.admin_task_list and systools.admin_task_status) ? These tables and views exist in my production system but no longer in the system I created during the system copy.
Thanks again,
Robert
Hello,
here is explanation of error:
The action attempted is shown by the action-type:
3 = implicit revalidation of an object
now let's check SQLCODE:
name is an undefined name.
Read both notes and continue according to instructions.
Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.