Re: db2 restore error,SQL2062N

thanks.

I think that have some problem with the ENV.But the error is that the NWDB2’s error.

I had mike the CFG file:

DB2:/BIDW/NODE0000 nsrdb2sv -f /nsr/db2_cfg

db2 backup db BIDW online LOAD /usr/lib/libnsrdb2.o options @/nsr/db2_cfg

#If the node you are using is through a local connection, use the Instance Name.

NSR_SERVER=backup_server_name

NSR_CLIENT=client_name

DB2_NODE_NAME=node_name

DB2_ALIAS=alias_name

#end

DB2_VENDOR_LIB_PATH=/usr/lib/libnsrdb2.o

DB2_OPTIONS=DB2BACKUP_TABLESPACE,DB2BACKUP_ONLINE

DB2_TBS_LIST=SYSCATSPACE

#nsrdb2sv -f /nsr/db2_cfg -P password

DB2_USR=user_name

DB2_PSWD=password

and all of the client Remote Access is:*@*

Application information:DB2_R=Database_name:inst1:inst2

and I had recover a file of filesystem(not database data),it can be redirect to another computer.

With the suspicion with the networker module for db2 2.1 build 261,so I update the module with hotfix for LGTpa91317,But the error is the same.

So,I change the networker module is 1.6 with both the client and the recoverd client.The error as following:

SQL2542N No match for a database image file was found based on the source database alias “alias_name” and timestamp “20081013182509” provided.

the restore command(networker module for db2 2.1):

db2 “restore database bidw rebuild with tablespace(SYSCATSPACE) load /usr/lib/libnsrdb2.o options @/nsr/db2_cfg taken at 20081012165644 on /db2sys_res without prompting

Has anybody solved a problem like that?

Related:

  • No Related Posts

Leave a Reply