System Copy Issue

[Former Member]

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

[Former Member · Accepted solution]

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 ?

[former_member182505 · Accepted solution]

Hi

Refer Note 1457048 - DB6: SQL0727N with SQLCODE -150

for Grant

db2 grant secadm on database to user db2SID

db2 grant DBADM on database to user db2SID

db2 terminate

Thanks

Sadiq

[Former Member · Accepted solution]

You can drop the view as follows:

db2 "drop view SYSTOOLS.ADMIN_TASK_LIST"

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql...

BR,

Paul

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Robert,

If you drop the view as advised in my previous response, you should bypass this issue.

I have seen this several times in the past.

Best Regards,

Paul

[Former Member · Accepted solution]

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

[tomas-krojzl]

Hello,

here is explanation of error:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql...

The action attempted is shown by the action-type:
3 = implicit revalidation of an object

now let's check SQLCODE:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql...

name is an undefined name.

Read both notes and continue according to instructions.

Tomas