Error in Informix on Windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don Gollahon - 27 Sep 2004 14:07 GMT

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

Reply to this Message

Claus Samuelsen - 28 Sep 2004 17:09 GMT

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'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
[quoted text clipped - 17 lines]
> Don Gollahon
> don.gollahon@asbury.edu

Reply to this Message

superboer - 29 Sep 2004 07:17 GMT

> reinitialization from here: 'onmode -ivy' (carefull, any existing data

i assume you mean
starts %INFORMIXSERVER% -ivy

See you

Superboer.

> Examine the message log, usually named %INFORMIXDIR%\online.log. This
> file will most likely contain information about any IDS related problem.
[quoted text clipped - 26 lines]
> > Don Gollahon
> > don.gollahon@asbury.edu

Reply to this Message

Don Gollahon - 29 Sep 2004 13:33 GMT

> Examine the message log, usually named %INFORMIXDIR%\online.log. This
> file will most likely contain information about any IDS related problem.
[quoted text clipped - 4 lines]
> 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 device
containing root dbspace
ROOTOFFSET    0        # Offset of root dbspace into device (Kbytes)
ROOTSIZE    51200        # Size of root dbspace (Kbytes)

Don Gollahon
don.gollahon@asbury.edu

Reply to this Message

Don Gollahon - 29 Sep 2004 13:46 GMT

I just noticed this at the end of the buildsmi_out file:

275: No INSERT permission.
Error in line 1667
Near character position 24

Database closed.

Cleaning up whatever was successfully created

Database selected.

274: No DELETE permission.
Error in line 1
Near 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

Reply to this Message