Informix - Problem description
Problem IT05532 | Status: Closed |
WINDOWS: ONTAPE UNABLE TO RESTORE IF ONCONFIG ROOTPATH HAS SPACES WHEN TAKING L0 BACKUP | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Using 12.10.FC4W1, when creating a new instance during installation, ROOTPATH and Chunks will be created using Long File Name (LFN) format by the installer. Problem first reproduced using 12.10.FC2X5 Win64 Normal operations would work fine until DBA tries to restore an ontape Level 0 archive. When restoring, you would get the following error message at the prompt : ========================================================== Chunks chk/dbs offset size free bpages flags pathname 1 1 0 153600 101805 PO-B- C:\Program Files\IBM Informix Software Bundle\storage\rootdbs 2 2 0 16384 0 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_plog_p_1 3 3 0 16384 16331 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_llog_p_1 4 4 0 16384 16331 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_datadbs1_p_1 5 5 0 16384 16331 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_datadbs2_p_1 6 6 0 16384 16331 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_datadbs3_p_1 7 7 0 16384 16278 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_data8dbs1_p_1 8 8 0 16384 16278 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_data8dbs2_p_1 9 9 0 16384 16278 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_data8dbs3_p_1 10 10 0 16384 16252 PO-BE C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_tmpdbspace_p_1 11 11 0 16384 4138 POSB- C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_sbspace1_p_1 12 12 0 16384 4138 POSB- C:\Program Files\IBM Informix Software Bundle\storage\ol_informix1210_1_tmpsbspace_p_1 Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Physical restore failed - ONCONFIG ROOTPATH: 'C:\Program Files\IBM Informix Software Bundle\storage\rootdbs' differs from archive: 'C:\Program' Correct ONCONFIG before restoring this archive. Program over. ========================================================== At this point, modifying $ONCONFIG ROOTPATH to a short format would not help as the ROOTPATH value in the L0 Archive is the original LFN format. Rename restore would not work as it still compares the ROOTPATH value in Archive against $ONCONFIG ROOTPATH. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local Fix: | |
Workaround is to modify ROOTPATH in $ONCONFIG to the short name format and take a new Level 0 Archive, and use the new Level 0 Archive to restore From : ROOTPATH C:\Program Files\IBM Informix Software Bundle\storage\rootdbs To : ROOTPATH C:\PROGRA~1\IBMINF~1\storage\rootdbs | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.11.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |