database - restore from different server on a db2 server -
we have production server , restored file system of server on quality server. after restore, changed directory name because here source instance/database name different target instance/database name.
we created configuration file used initializing database on target server.
we uncatalogued database on server , started database instance.
for initializing database executed :
db2inidb e2q snapshot relocate using relocate_e2q_mar31st_2015
but gave me error:
relocating database... dbt1020n configuration file contains invalid entry @ line "3". reason code = "7". unable relocate database, cannot continue
the content of configuration file :
instance=source_instance,target_instance db_name=source_db,target_db nodenum=0 <some other source target information>
what wrong in using nodenum=0 here?
i tried list db directories gave me 1 entry of report_db. when tried list db directories on default path, got entry:
local database directory on <path> number of entries in directory = 1 database 1 entry: database alias = source_db database name = source_db database directory = sql00001 database release level = d.00 comment = sap database q01 directory entry type = home catalog database partition number = 0 database partition number = 0
where going wrong? missing?
ps: using db2 version 9.7
Comments
Post a Comment