Skip to Content
Former Member
Feb 28, 2007 at 09:27 AM

After Redirected Restore with different schema problems with db13


Hello, we made a redirected restore. We have different schema between production and quality system.

According to note 713524 we made the following changes:

create db connect user from the source system in the target system (unix user, sap<sid>)

set parameter dbs/db6/schema=sap<sid> in the instance profile

set dbs_db6_schema = sap<sid> in the environment for <sid>adm and db2<sid> (dbenv...)

add user sap<sid> into /sapmnt/<SID>/global/dscdb6.conf and set password with dscdb6up sap<sid> <password>

The system is now up and running. But transaction db13 is not working

SQL0443N Routine "*SHOT_DBM" (specific name "")

has returned an error SQLSTATE with diagnostic

text "SQL1092 Reason code or token: SAPR3

". SQLSTATE=38553