IBM Support

onbar restore returns Unable to write storage space restore data to the database server, 43391, 43140, and 131 (0x83)

Troubleshooting


Problem

You run an onbar restore and see messages like these: 2012-07-04 17:34:01 3864 3506 /usr/informix/bin/onbar_d -r 2012-07-04 17:34:05 3864 3506 Successfully connected to Storage Manager. 2012-07-04 17:34:05 3864 3506 Begin reserved pages restore (level 0 of rootdbs, Storage Manager copy ID: 0 481491640). 2012-07-04 17:34:05 3864 3506 Completed reserved pages restore (level 0 of rootdbs). 2012-07-04 17:34:07 3864 3506 Successfully connected to Storage Manager. 2012-07-04 17:34:07 3864 3506 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 0 481491640). 2012-07-04 17:39:05 3864 3506 Unable to write storage space restore data to the database server: . 2012-07-04 17:39:05 3864 3506 (-43391) Skipped backup/restore of space 'rootdbs'. 2012-07-04 17:39:05 3864 3506 (-43140) Due to the previous error, logical restore will not be attempted. 2012-07-04 17:39:05 3864 3506 /usr/informix/bin/onbar_d complete, returning 131 (0x83)

Cause

INFORMIXSERVER environment variable is not set correctly. However, it is set to a servername that does exist in the sqlhosts file.

Note: There are other reasons to get these same errors

Diagnosing The Problem

The five minute gap in time between these two lines indicates this problem:

2012-07-04 17:34:07 3864 3506 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 0 481491640).
2012-07-04 17:39:05 3864 3506 Unable to write storage space restore data to the database server: .

Resolving The Problem


Set the INFORMIXSERVER environment variable to the correct value then rerun your onbar command.

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;11.7;12.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21597178