Board index Informix

Oninit didn't work fine and I don't know why

Oninit didn't work fine and I don't know why

Post by Diego Morale » Sun, 31 Dec 1899 09:00:00



 Hi all !

 I have an Informix 7.31 UC2 with a HP-UX 10.20 and we work with Baan
 Triton 3.10_a1

 Yesterday afternoon I changed the SHMVIRTSIZE parameter to 200000 (we had
 190000 before).

 When I tried to initialize Informix with 'oninit'. With 'onstat -' I want
 to see when Informix was ready to work with the message 'On-Line". It
 didn't appear me.
 After an eternal 5 minutes Informix auto-killed itself. Then I made an
 'onmode -ky' because it didn't run ok but it was executing something that
 I couldn't see in the machine.

 I restored the SHMVIRTSIZE parameter and tried to initialize Informix
 again. It ran ok. But I wasn't happy. I thought that the parameter could
 not be because in a previous version we have this parameter set to 240000.
 I go down Informix, changed again the parameter to 200000, and this time
 the 'oninit' worked fine. Then I initialize the Baan application and all
 is running ok.

 Could someone tell me what's wrong the first time that I tried to
 initialize Informix?

 Thaks in advance and sorry because my English is very very bad.

 DJMoralesM

 
 
 
Top

Oninit didn't work fine and I don't know why

Post by Madison Prue » Sun, 31 Dec 1899 09:00:00


It's hard to say with the information that you have to tell what happened.
However since the only thing that you
changed was SHMVIRTSIZE and you are running on HP, I suspect that you might
have run into shared
memory allocation problems.  I'm guessing that you have several other
applications that are using shared memory
and thus had fragmented IPC shared memory addressing at the kernel level.  HPUX
can be a bit sensitive about
how shared memory is used.

You might be able to get a bit more information by running oninit with the -v
option.  This ("oninit -v") will
display messages during engine startup.  By discovering the last thing that was
done before the failure, you might
get some idea as to what was happening at the point of failure.


>  Hi all !

>  I have an Informix 7.31 UC2 with a HP-UX 10.20 and we work with Baan
>  Triton 3.10_a1

>  Yesterday afternoon I changed the SHMVIRTSIZE parameter to 200000 (we had
>  190000 before).

>  When I tried to initialize Informix with 'oninit'. With 'onstat -' I want
>  to see when Informix was ready to work with the message 'On-Line". It
>  didn't appear me.
>  After an eternal 5 minutes Informix auto-killed itself. Then I made an
>  'onmode -ky' because it didn't run ok but it was executing something that
>  I couldn't see in the machine.

>  I restored the SHMVIRTSIZE parameter and tried to initialize Informix
>  again. It ran ok. But I wasn't happy. I thought that the parameter could
>  not be because in a previous version we have this parameter set to 240000.
>  I go down Informix, changed again the parameter to 200000, and this time
>  the 'oninit' worked fine. Then I initialize the Baan application and all
>  is running ok.

>  Could someone tell me what's wrong the first time that I tried to
>  initialize Informix?

>  Thaks in advance and sorry because my English is very very bad.

>  DJMoralesM



 
 
 
Top

Oninit didn't work fine and I don't know why

Post by Paul Wats » Sun, 31 Dec 1899 09:00:00




>  Hi all !

>  I have an Informix 7.31 UC2 with a HP-UX 10.20 and we work with Baan
>  Triton 3.10_a1

>  Yesterday afternoon I changed the SHMVIRTSIZE parameter to 200000 (we
> had
>  190000 before).

>  When I tried to initialize Informix with 'oninit'. With 'onstat -' I
> want
>  to see when Informix was ready to work with the message 'On-Line". It
>  didn't appear me.
>  After an eternal 5 minutes Informix auto-killed itself. Then I made an
>  'onmode -ky' because it didn't run ok but it was executing something
> that
>  I couldn't see in the machine.

>  I restored the SHMVIRTSIZE parameter and tried to initialize Informix
>  again. It ran ok. But I wasn't happy. I thought that the parameter
> could
>  not be because in a previous version we have this parameter set to
> 240000.
>  I go down Informix, changed again the parameter to 200000, and this
> time
>  the 'oninit' worked fine. Then I initialize the Baan application and
> all
>  is running ok.

>  Could someone tell me what's wrong the first time that I tried to
>  initialize Informix?

I'd look at the memory, I suspect you didn't have the memory available at
the time, or there was insufficient swap available.  Nothing in the log
files?

Paul Watson              # I don't suffer from
WF Software Ltd.         # stress, I'm just
Tel. (+44) 1436 674729   # a carrier
Fax. (+44) 1436 678693   #
www.wfsoftware.com

 
 
 
Top

Oninit didn't work fine and I don't know why

Post by Art S. Kage » Sun, 31 Dec 1899 09:00:00


There is just no way to know unless you ran oninit with the -v option so
you can see what it was trying to do when it hung or used onstat to obtain
a shared memory dump or coredumped the master oninit process.

Art S. Kagel


>  Hi all !

>  I have an Informix 7.31 UC2 with a HP-UX 10.20 and we work with Baan
>  Triton 3.10_a1

>  Yesterday afternoon I changed the SHMVIRTSIZE parameter to 200000 (we had
>  190000 before).

>  When I tried to initialize Informix with 'oninit'. With 'onstat -' I want
>  to see when Informix was ready to work with the message 'On-Line". It
>  didn't appear me.
>  After an eternal 5 minutes Informix auto-killed itself. Then I made an
>  'onmode -ky' because it didn't run ok but it was executing something that
>  I couldn't see in the machine.

>  I restored the SHMVIRTSIZE parameter and tried to initialize Informix
>  again. It ran ok. But I wasn't happy. I thought that the parameter could
>  not be because in a previous version we have this parameter set to 240000.
>  I go down Informix, changed again the parameter to 200000, and this time
>  the 'oninit' worked fine. Then I initialize the Baan application and all
>  is running ok.

>  Could someone tell me what's wrong the first time that I tried to
>  initialize Informix?

>  Thaks in advance and sorry because my English is very very bad.

>  DJMoralesM


 
 
 
Top

1. MovePrevious don't work but the MoveNext work's fine

Hi
Does anyone know which of the CursorTypeEnum allow the moveprevious
method?
Because, I trying to use rs.moveprevious to show the previous record
as the result of this query:

Set Cn = New ADODB.Connection
Cn.ConnectionString = "provider=Microsoft.jet.oledb.4.0;Data Source="
& App.Path & "\gestmail.mdb"
Cn.Open
Set Rs10 = New ADODB.Recordset
Rs10.CursorLocation = adUseClient
Rs10.Open "[principal]", Cn, adOpenDynamic, adLockOptimistic,
adCmdTable
Set Rs10 = Cn.Execute(sqlstr$)
If Not Rs10.EOF Then
numreg = Rs10("reg_actual")
entidade = Rs10("entidade")
departamento = Rs10("departamento")
data = Rs10("data")
datadoc = Rs10("data_doc")
assunto = Rs10("assunto")
natureza = Rs10("natureza")
referencia = Rs10("referencia")
If Rs10("observacoes") <> "" Then
obs = Rs10("observacoes")
End If
Txt1.Text = data
Txt2.Text = numreg
Txt3.Text = departamento
Txt4.Text = entidade
Txt5.Text = referencia
Txt6.Text = datadoc
Txt7.Text = assunto
Txt8.Text = natureza
Txt9.Text = obs
End If
End Sub

Private Sub Cmd1_Click()
if not rs10.EOF then
Rs10.MovePrevious <-- error '3219' Operation is not allowed in this
context
end if
end Sub

Thanks!

    Pucca

2. Help! MAXMEM param on SCO/Informix 5.0

3. Confirmed D2 bug: cached updates don't work for master/detail - here's why

4. newbie question on Reports

5. why oh why don't labels ever work

6. How to change default font?

7. SQL server name has been changed and don't know why

8. Default MSDE2000 install = no program group or icons

9. I don't know why, do you????????????????/

10. Database properties settings changed back to default settings and I don't know why

11. ADO Error! Don't know why

12. New Request - I don't know why it is tricky

13. Subroutine not cataloged error, and I don't know why


All times are UTC
Board index