Database Creation Error
Posted in 2006
Topics: Storage & Space Management, Server Administration, Logging & Checkpoints, Networking & sqlhosts Configuration
I am using HPUX 11.11 for Informix 7.31
when I run oninit -i I get this on the log. The database does not
initialize.
My file settings are as follows
>
> SERVICES
> srvr0001 8001/tcp #Informix port
>
> sqlhosts
> ok_srvr onipcshm 10.0.6.2 ipcs0000
> ok_tcp onsoctcp 10.0.6.2 srvr0001
have you tried "ontlitcp"? And ...
> onconfig
> DBSERVERNAME ok_srvr # Name of default database server
> DBSERVERALIASES ok_tcp # List of alternate dbservernames
> NETTYPE ipcshm,2,600,CPU # Configure poll thread(s) for nettype
> NETTYPE soctcp,1,5,NET # Configure poll thread(s) for nettype
Online.log
17:53:52 Informix Dynamic Server Initialized -- Complete DiskInitialized.
17:53:52 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP.
17:53:53 Checkpoint Completed: duration was 0 seconds.
17:53:53 Dataskip is now OFF for all dbspaces
17:53:53 On-Line Mode
17:53:53 Building 'sysmaster' database ...
17:59:55 Checkpoint Completed: duration was 0 seconds.
25588: The appl process cannot connect to Dynamic server ok_srvr.
Interrupted system call
Error in line 23Near character position 1
25588: The appl process cannot connect to Dynamic server ok_srvr.
Interrupted system call
Error in line 25Near character position 1
mchivaviro@okzim.co.zw said:
> I am using HPUX 11.11 for Informix 7.31
> when I run oninit -i I get this on the log. The database does not
> initialize.
> My file settings are as follows
>>
>> SERVICES
>> srvr0001 8001/tcp #Informix port
>>
>> sqlhosts
>> ok_srvr onipcshm 10.0.6.2 ipcs0000
>> ok_tcp onsoctcp 10.0.6.2 srvr0001>
> have you tried "ontlitcp"? And ...
>
>> onconfig
>> DBSERVERNAME ok_srvr # Name of default database server
>> DBSERVERALIASES ok_tcp # List of alternate dbservernames
>> NETTYPE ipcshm,2,600,CPU # Configure poll thread(s) for nettype
>> NETTYPE soctcp,1,5,NET # Configure poll thread(s) for nettype
Why 5? Try soctcp,2,100,NET
> Online.log
> 17:53:52 Informix Dynamic Server Initialized -- Complete Disk> Initialized.
> 17:53:52 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP.
> 17:53:53 Checkpoint Completed: duration was 0 seconds.
> 17:53:53 Dataskip is now OFF for all dbspaces
> 17:53:53 On-Line Mode
> 17:53:53 Building 'sysmaster' database ...
> 17:59:55 Checkpoint Completed: duration was 0 seconds.>
>
> 25588: The appl process cannot connect to Dynamic server ok_srvr.>
> Interrupted system call
> Error in line 23> Near character position 1
It looks like you might have some sort of resource constraint -- are your
kernel parameters in line with those used in the release notes?
--
Bye now,
Obnoxio
Information within this post contains forward looking statements within
the meaning of Section 27A of the Securities Act of 1933 and Section 21B
of the S E C Act of 1934. Statements that involve discussions with respect
to projections of future events are not statements of historical fact and
may be forward looking statements. Don't rely on them to make a decision.
The poster is not a reporting company registered under the Exchange Act of
1934.
I have received a life peerage from Her Majesty, who is not an officer,
minister or affiliate Labour party member.
I intend to recover my loan now, which could cause the parliamentary
majority to go down, resulting in losses for you. Today's Labour party
has: an accumulated deficit and a reliance on loans from officers and
affiliates to pay expenses. It is not an operating political party. The
party is going to need financing to continue as a going concern. A failure
to finance could cause the party to go out of business. This report shall
not be construed as any kind of investment advice or solicitation. You can
lose all your money by investing in this party.
Thanks It was the shmmax which was understated