Hi,

We are currently having problems testing a remote cold restore of an
informix 7.31.TD6 database.

Scenario is:
server 1 running Windows 2000 SP4 and informix 7.31.TD6 with informix agent
and client agent
server 2 running Windows 2003 server and arcserve base installation. A
virtual file system is configured to back data to local disks.
Both servers are connected via crossover cable for the moment.
File backups and restores work fine.
Remote informix backups work fine.
Remote restores however fail after rootdbs is restored. Arcserve connects
to database and salvages any logs not backed up. Arcserve then restores
reserved pages and brings informix up in fast recovery mode. Arcseve then
restores rootdbs without error. Arcserve then tries to restore logdbs and
fails. onbar_d process is running and waiting.

There are no error messages in bar_act.log and online.log and as far as I
can tell bar_debug.log. In arcserve the following messages appears:
arcserve message log - E8603 Failed to write to database. (DBNAME=logdbs,
EC=Remote pipe open failed: time-out)

If I copy the tape data to server 1 and run a restore via arcserve locally,
restore works fine.

I have an issue open with CA regarding this but thought I'd ask for input
here. CA have asked about the BAR_TIMEOUT value and whether it is affecting
the restore process.

If the bar_timeout value is reached, does onbar wait for any input or for
the original XBSA api call to complete?
Do I need to increase this bar_timeout value for remote restores to work
correctly even though rootdbs seemed to work fine with current settings?

Below is the last bits of bar_debug.log with bar_debug set at 2.

Regards
Stefan


2005-08-05 09:57:34 2396 2396 write_rst_file: enter
2005-08-05 09:57:34 2396 2396 write_rst_file: return
2005-08-05 09:57:34 2396 2396 barBeginTxn: enter
2005-08-05 09:57:35 2396 2396 bar_alarm: enter
2005-08-05 09:57:35 2396 2396 bar_alarm: return
2005-08-05 09:57:35 2396 2396 bar_loadXBSA: return 0
2005-08-05 09:57:35 2396 2396 barBeginTxn: return 0 (0x00)
2005-08-05 09:57:35 2396 2396 barGetObject: enter
2005-08-05 09:57:35 2396 2396 barGetObject: bar_objdesc
obj_id 0 obj_name 'logdbs' obj_type 'CD' act_id 0 act_type 0
act_status 0
act_start '' act_end '2005-07-28 12:39:54'
ins_time 0 rsam_time 0 level 0 copyid hi:lo 2:61470 req_act_id 78
logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 last_log 0
partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
ins_verify 0 ins_verify_date '' restore order 0:0
objInfo ''
retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host ''
2005-08-05 09:57:35 2396 2396 initObjDesc: enter
2005-08-05 09:57:35 2396 2396 initObjDesc: input: bar_objdesc
obj_id 0 obj_name 'logdbs' obj_type 'CD' act_id 0 act_type 2
act_status 0
act_start '2005-08-05 09:57:35' act_end '2005-07-28 12:39:54'
ins_time 0 rsam_time 0 level 0 copyid hi:lo 2:61470 req_act_id 78
logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 last_log 0
partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
ins_verify 0 ins_verify_date '' restore order 0:0
objInfo ''
retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host ''
2005-08-05 09:57:35 2396 2396 initObjOwner: enter
2005-08-05 09:57:35 2396 2396 initObjOwner:bsa owner INFORMIX app owner
informix
2005-08-05 09:57:35 2396 2396 initObjOwner: return
2005-08-05 09:57:35 2396 2396 buildObjName: enter
2005-08-05 09:57:35 2396 2396 buildObjName: bar_objdesc
obj_id 0 obj_name 'logdbs' obj_type 'CD' act_id 0 act_type 2
act_status 0
act_start '2005-08-05 09:57:35' act_end '2005-07-28 12:39:54'
ins_time 0 rsam_time 0 level 0 copyid hi:lo 2:61470 req_act_id 78
logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 last_log 0
partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
ins_verify 0 ins_verify_date '' restore order 0:0
objInfo ''
retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host ''
2005-08-05 09:57:35 2396 2396 buildObjName: set server_name to
nylexnydnydtcp
2005-08-05 09:57:35 2396 2396 buildObjName: output objectSpaceName
\nylexnydnydtcp, pathName \nylexnydnydtcp\logdbs\0
2005-08-05 09:57:35 2396 2396 buildObjName: return 0 (0x00)
2005-08-05 09:57:35 2396 2396 initObjDesc: output: object owner name
createTime
2005-08-05 09:57:35 2396 2396 initObjDesc: output: INFORMIX informix
\nylexnydnydtcp \nylexnydnydtcp\logdbs\0 0 0 0 0 0 0
2005-08-05 09:57:35 2396 2396 initObjDesc: output: copytype copyid
restoreOrder size resource type status desc objectInfo
2005-08-05 09:57:35 2396 2396 initObjDesc: output: 3 0 0
0 0 0 0 4 2
2005-08-05 09:57:35 2396 2396 initObjDesc: return
2005-08-05 09:57:35 2396 2396 bar_loadXBSA: return 0
2005-08-05 09:58:08 2396 2396 sigalrm_event: active
2005-08-05 10:00:08 2396 2396 sigalrm_event: active
2005-08-05 10:02:08 2396 2396 sigalrm_event: active






************************************************** ********************

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. If you have received this email in error
please notify the sender and delete the material from any computer.

You can visit Nylex at http://www.nylex.com.au


************************************************** ********************
sending to informix-list