Re: Error in Informix on Windows
Examine the message log, usually named %INFORMIXDIR%\\online.log. This
file will most likely contain information about any IDS related problem.
Further: In Start->Programs->Informix there's a command window
(ol_machinename), which has all needed environment. Issue the command
'onstat -', this will return the state of IDS. You can also issue a
reinitialization from here: 'onmode -ivy' (carefull, any existing data
will be lost). The v-option will show progress output.
Don Gollahon wrote:
> I'm trying out Informix IDS 9.4 on Windows XP Pro. Finally got it
> installed and got ISA running. But when I do "Check" I get the
> following error:
>
> "Unexpected Error
> Unable to retrieve information about databases. If the server is
> online, then the sqlhosts file may be damaged, or perhaps sysmaster
> didn't build or is still building, or the database may be locked by
> another user, or DBSPACETEMP is not accessible. at
> c:\\ibm\\isa\\bin\\check.pl line 19 "
>
>
> I don't think the sysmaster ever completes creation.
>
> I also get this error when I try to do the ON-BAR backup:
>
> "File not found: C:\\PROGRA~1\\Informix\\bar_ol_mgrgolla.log"
>
> Thanks for any help you can give.
>
> Don Gollahon
> don.gollahon@asbury.edu
> reinitialization from here: 'onmode -ivy' (carefull, any existing data
i assume you mean
starts %INFORMIXSERVER% -ivy
See you
Superboer.
Claus Samuelsen <csa@eye-bee-em.com> wrote in message news:<41598cc9$0$55824$14726298@news.sunsite.dk>...
> Examine the message log, usually named %INFORMIXDIR%\\online.log. This
> file will most likely contain information about any IDS related problem.
>
> Further: In Start->Programs->Informix there's a command window
> (ol_machinename), which has all needed environment. Issue the command
> 'onstat -', this will return the state of IDS. You can also issue a
> reinitialization from here: 'onmode -ivy' (carefull, any existing data
> will be lost). The v-option will show progress output.
>
> Don Gollahon wrote:
>
> > I'm trying out Informix IDS 9.4 on Windows XP Pro. Finally got it
> > installed and got ISA running. But when I do "Check" I get the
> > following error:
> >
> > "Unexpected Error
> > Unable to retrieve information about databases. If the server is
> > online, then the sqlhosts file may be damaged, or perhaps sysmaster
> > didn't build or is still building, or the database may be locked by
> > another user, or DBSPACETEMP is not accessible. at
> > c:\\ibm\\isa\\bin\\check.pl line 19 "
> >
> >
> > I don't think the sysmaster ever completes creation.
> >
> > I also get this error when I try to do the ON-BAR backup:
> >
> > "File not found: C:\\PROGRA~1\\Informix\\bar_ol_mgrgolla.log"
> >
> > Thanks for any help you can give.
> >
> > Don Gollahon
> > don.gollahon@asbury.edu
Claus Samuelsen <csa@eye-bee-em.com> wrote in message news:<41598cc9$0$55824$14726298@news.sunsite.dk>...
> Examine the message log, usually named %INFORMIXDIR%\\online.log. This
> file will most likely contain information about any IDS related problem.
>
> Further: In Start->Programs->Informix there's a command window
> (ol_machinename), which has all needed environment. Issue the command
> 'onstat -', this will return the state of IDS. You can also issue a
> reinitialization from here: 'onmode -ivy' (carefull, any existing data
> will be lost). The v-option will show progress output.
>
I did this and then did onstat -a. As you can see build_smi failed.
Here is output from the beginning of this:
Informix Dynamic Server Version 9.40.TC1 -- On-Line -- Up 00:05:32
-- 17536 Kbytes
Message Log File: C:\\PROGRA~1\\Informix\\ol_mgrgolla.log
08:15:48 Maximum server connections 0
08:15:48 Dataskip is now OFF for all dbspaces
08:15:48 On-Line Mode
08:15:48 Building 'sysmaster' database ...
08:16:06 Checkpoint Completed: duration was 0 seconds.
08:16:06 Checkpoint loguniq 1, logpos 0x1d321c, timestamp: 15397
08:16:06 Maximum server connections 1
08:16:07 Logical Log 1 Complete, timestamp:23890.
08:16:09 Assert Failed: build_smi failed
08:16:09 Informix Dynamic Server Version 9.40.TC1
08:16:09 Who: Session(9, informix@mgrgolla.asbury.edu, 0, 00000000)
Thread(15, build_smi, 0, 1)
File: rspseudo.c Line: 7808
08:16:09 Results: Cannot build/check 'sysmaster' database
08:16:09 stack trace for pid 3068 written to C:\\tmp\\af.3f7a788
08:16:09 See Also: C:\\tmp\\af.3f7a788, shmem.3f7a788.0
08:16:18 build_smi failed
08:16:21 build_smi failed
Configuration File: C:\\PROGRA~1\\Informix/etc/ONCONFIG.ol_mgrgolla
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH C:\\IFMXDATA\\ol_mgrgolla\\rootdbs_dat.000 # Path for devicecontaining root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 51200 # Size of root dbspace (Kbytes)
Don Gollahon
don.gollahon@asbury.edu
Claus Samuelsen <csa@eye-bee-em.com> wrote in message news:<41598cc9$0$55824$14726298@news.sunsite.dk>...
> Examine the message log, usually named %INFORMIXDIR%\\online.log. This
> file will most likely contain information about any IDS related problem.
>
> Further: In Start->Programs->Informix there's a command window
> (ol_machinename), which has all needed environment. Issue the command
> 'onstat -', this will return the state of IDS. You can also issue a
> reinitialization from here: 'onmode -ivy' (carefull, any existing data
> will be lost). The v-option will show progress output.
>
I just noticed this at the end of the buildsmi_out file:
275: No INSERT permission.
Error in line 1667Near character position 24
Database closed.
Cleaning up whatever was successfully created
Database selected.
274: No DELETE permission.
Error in line 1Near character position 23
Database closed.
Did permissions not get set right or something? Does it use the
informix login to run this stuff?
Don Gollahon
don.gollahon@asbury.edu