I restored a copy of our QA DB2 OnDemand database to our DEV system. They both run under different user ids archive and archdev.
Our Dev system runs with the following ars.ini:
[@SRV@_ARCHIVE]
HOST=someServerDev
PROTOCOL=2
PORT=0
SRVR_INSTANCE=archive
SRVR_INSTANCE_OWNER=archdev
SRVR_OD_CFG=/opt/ondemand/config/ars.cfg
SRVR_DB_CFG=/opt/ondemand/config/ars.dbfs
SRVR_SM_CFG=/opt/ondemand/config/ars.cache
SRVR_FLAGS_SECURITY_EXIT=1
[@SRV@_DD]
PROTOCOL=1
Our QA system has the following config:
[@SRV@_ARCHIVE]
HOST=someServerQa
PROTOCOL=2
PORT=0
SRVR_INSTANCE=archive
SRVR_INSTANCE_OWNER=archive
SRVR_OD_CFG=/opt/ondemand/config/ars.cfg
SRVR_DB_CFG=/opt/ondemand/config/ars.dbfs
SRVR_SM_CFG=/opt/ondemand/config/ars.cache
SRVR_FLAGS_SECURITY_EXIT=1
[@SRV@_DD]
PROTOCOL=1
ARCHIVE,02/06/12 16:48:48,0,ARSSOCKD,,2,13,DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "ARCHDEV.ARSAG" is an undefined name. SQLSTATE=42704 -- SQLSTATE=42S02, SQLCODE=-204, File=arsag.c, Line=4070
Is there a way to make arssockd SET CURRENT SCHEMA before issueing the SQL statements to DB2, AFAIK it is trying to use the schema associated with the user id it is runnign as.
Is there any guidelines on how to restore the DB when the users that system run as are different? archive vs archdev for instance.
Any help will be much appreciated.
Thanks.