RE: Backup
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C027C4.FEC599D0
Content-Type: text/plain;
charset="iso-8859-1"
1. Read the 'Backup and Restore Guide' on answer online
2. Temporarily set LTAPEDEV to nul in onconfig to set logs to backed up
3. Retrieve to the previous setting of LTAPEDEV
4. Configure ISM
(My batch is in enclosure for help.)
5. You should set LBU_PRESERVE in onconfig to 1 to avoid problem for future
Andor Rozsnyai
Developer
GE Medical Systems
Hungary
-----Original Message-----
From: Yann PICHOT [mailto:ypichot@sigma.fr]
Sent: Tuesday, September 26, 2000 10:29 AM
To: informix-list@iiug.org
Subject: Backup
I have IDS 2000 on win NT server 4.0
I try to backup may logical file but when i do "onbar -b -l", i have
this on my bar log file :
2000-09-26 09:57:30 103 103 F:\\PROGRA~1\\informix\\bin\\onbar_d -b -l -c
2000-09-26 09:57:30 103 103 Begin backup logical log 1.
2000-09-26 09:57:32 103 103 Successfully connected to Storage Manager.
2000-09-26 09:57:33 103 103 XBSA Error: (BSACreateObject) A system
error occurred. Aborting XBSA session.
2000-09-26 09:57:33 103 103 The logical logs are full. ON-Bar may
encounter errors writing to
the sysutils database.
2000-09-26 09:57:33 103 103 SQL -275 No INSERT permission.
2000-09-26 09:57:33 103 103 The logical logs are full. ON-Bar may
encounter errors writing to
the sysutils database.
2000-09-26 09:57:33 103 103 SQL -275 No INSERT permission.
2000-09-26 09:57:33 103 103 F:\\PROGRA~1\\informix\\bin\\onbar_d
complete, returning 3 (0x03)
when i do "onstat -l" i see i have space on last logical log file.
What is my pb ?
--
Yann PICHOT ypichot@sigma.fr
SIGMA Informatique poste : 1690
La Gesvrine - 3 rue Newton - BP 4127
44241 La Chapelle Sur Erdre - FRANCE
Tel : +33 02 40 37 66 20 Site web : http://www.sigma.fr
Fax : +33 02 51 12 79 52
Sent via Deja.com http://www.deja.com/
Before you buy.
------_=_NextPart_000_01C027C4.FEC599D0
Content-Type: application/octet-stream;
name="IfxSetBackup.bat"
Content-Disposition: attachment;
filename="IfxSetBackup.bat"
@ECHO OFF
IF NOT "%1" == "" GOTO Usage
IF NOT DEFINED INFORMIXSERVER GOTO Usage
GOTO SetBackup
:Usage
ECHO Usage: %0
ECHO Must be executed under an Informix prompt
GOTO End
:SetBackup
set IFXSAVDATADIR=c:\\Ifmxsavdata
set IFXSAVLOGDIR=c:\\Ifmxsavlog
REM Save the current directory
PUSHD .
REM Set enviroment of ISM (Informix Storage Management)
call setism
c:
cd %ismdir%\\bin\\
ECHO ------------------------------------------------------------------------
ECHO 1. Creating backup directories...
mkdir %IFXSAVDATADIR%
mkdir %IFXSAVLOGDIR%
ECHO ------------------------------------------------------------------------
ECHO 2. Add devices...
ism_add -device %IFXSAVDATADIR% -type file
IF ERRORLEVEL 1 GOTO Error
ism_add -device %IFXSAVLOGDIR% -type file
IF ERRORLEVEL 1 GOTO Error
ECHO ------------------------------------------------------------------------
ECHO 3. Assign pools to devices...
ism_op -label %IFXSAVDATADIR% -volume DAT0 -pool ISMData -force
IF ERRORLEVEL 1 GOTO Error
ism_op -label %IFXSAVLOGDIR% -volume LOG0 -pool ISMLogs -force
IF ERRORLEVEL 1 GOTO Error
ECHO ------------------------------------------------------------------------
ECHO 4. Mount devices...
ism_op -mount %IFXSAVDATADIR%
IF ERRORLEVEL 1 GOTO Error
ism_op -mount %IFXSAVLOGDIR%
IF ERRORLEVEL 1 GOTO Error
ECHO ------------------------------------------------------------------------
ECHO %0 script success!
set ERRORLEVEL=0
GOTO End
:Error
ECHO %0 script error!
set ERRORLEVEL=1
:End
REM Restore the current directory
POPD
------_=_NextPart_000_01C027C4.FEC599D0--