SCHAPI: Error -566 Cannot initiate sort...........
Posted in 2008
Topics: Error Codes & Troubleshooting, Server Administration, Logging & Checkpoints, Platform-Specific Issues, Internationalization & Character Sets
Folks,
Program Name: onstat
Build Version: 11.10.UC2
Build Number: N158
Build Host: vach
Build OS: AIX 5.3
Build Date: Thu Oct 25 22:56:40 CDT 2007
GLS Version: glslib-4.50.UC2
After run out of memory, we terminated the big session( that caused the
problem), but the error messages keep repeating continuously in online
log( see below).
How can we resolve it?
Thanks,
Frank
14:13:31 Maximum server connections 1
14:13:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
1, Plog used 0, Llog used 1
14:15:34 Contiguous shared memory segment allocation failed at 0xd0000000.
Allocation successful at 0x30000000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
14:15:34 Dynamically allocated new virtual shared memory segment (size
8192KB)
14:15:34 Memory sizes:resident:1713984 KB, virtual:139392 KB, no SHMTOTAL
limit
14:15:45 Contiguous shared memory segment allocation failed at 0xd0000000.
Allocation successful at 0xe0000000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
14:15:45 Dynamically allocated new virtual shared memory segment (size
8192KB)
14:15:45 Memory sizes:resident:1713984 KB, virtual:147584 KB, no SHMTOTAL
limit
14:15:54 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:15:54 out of virtual shared memory
14:15:55 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:15:55 out of virtual shared memory
14:17:41 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:17:41 out of virtual shared memory
14:17:41 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:41 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:42 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:42 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:17:51 SCHAPI: Error -566 Cannot initiate sort.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:18:01 out of virtual shared memory
14:18:01 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:18:11 SCHAPI: Error -566 Cannot initiate sort.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:18:21 out of virtual shared memory
14:18:21 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
14:18:31 SCHAPI: Error -566 Cannot initiate sort.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 Checkpoint Completed: duration was 0 seconds.
14:18:31 Mon May 5 - loguniq 65622, logpos 0x578303c, timestamp:
0xf321305c Interval: 8954
14:18:31 Maximum server connections 1
.............................
I think the only way to make that stop is to stop the db engine.
Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
FRANK
Sent: Monday, May 05, 2008 10:42 AM
To: ids@iiug.org
Subject: SCHAPI: Error -566 Cannot initiate sort........... [11967]
Folks,
Program Name: onstat
Build Version: 11.10.UC2
Build Number: N158
Build Host: vach
Build OS: AIX 5.3
Build Date: Thu Oct 25 22:56:40 CDT 2007
GLS Version: glslib-4.50.UC2
After run out of memory, we terminated the big session( that caused the
problem), but the error messages keep repeating continuously in online
log( see below).
How can we resolve it?
Thanks,
Frank
14:13:31 Maximum server connections 1
14:13:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
blocked
1, Plog used 0, Llog used 1
14:15:34 Contiguous shared memory segment allocation failed at
0xd0000000.
Allocation successful at 0x30000000.
Check SHMBASE is consistent with the value in
$INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
14:15:34 Dynamically allocated new virtual shared memory segment (size
8192KB)
14:15:34 Memory sizes:resident:1713984 KB, virtual:139392 KB, no
SHMTOTALlimit
14:15:45 Contiguous shared memory segment allocation failed at
0xd0000000.
Allocation successful at 0xe0000000.
Check SHMBASE is consistent with the value in
$INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
14:15:45 Dynamically allocated new virtual shared memory segment (size
8192KB)
14:15:45 Memory sizes:resident:1713984 KB, virtual:147584 KB, no
SHMTOTALlimit
14:15:54 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:15:54 out of virtual shared memory
14:15:55 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:15:55 out of virtual shared memory
14:17:41 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:17:41 out of virtual shared memory
14:17:41 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:41 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:42 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:42 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:17:51 SCHAPI: Error -566 Cannot initiate sort.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:18:01 out of virtual shared memory
14:18:01 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:18:11 SCHAPI: Error -566 Cannot initiate sort.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:11 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:18:21 out of virtual shared memory
14:18:21 SCHAPI: Error -243 Could not position within a table
(informix.ph_task).
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 shmat: [EMFILE][24]: out of shared memory segments, check
system
SHMSEG
14:18:31 SCHAPI: Error -566 Cannot initiate sort.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -7442 The statement must be opened before this
operation can be performed.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
14:18:31 Checkpoint Completed: duration was 0 seconds.
14:18:31 Mon May 5 - loguniq 65622, logpos 0x578303c, timestamp:
0xf321305c Interval: 8954
14:18:31 Maximum server connections 1
..............................
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
hmmm....
Probably you are right, since after that happened, the worse is that nobody
can use the db anymore!
On Mon, May 5, 2008 at 11:27 AM, Robert Roussey(IT) <
Robert.Roussey@spiritair.com> wrote:
> I think the only way to make that stop is to stop the db engine.
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> FRANK
> Sent: Monday, May 05, 2008 10:42 AM
> To: ids@iiug.org
> Subject: SCHAPI: Error -566 Cannot initiate sort........... [11967]
>
> Folks,
>
> Program Name: onstat
> Build Version: 11.10.UC2
> Build Number: N158
> Build Host: vach
> Build OS: AIX 5.3
> Build Date: Thu Oct 25 22:56:40 CDT 2007
> GLS Version: glslib-4.50.UC2
>
> After run out of memory, we terminated the big session( that caused the
> problem), but the error messages keep repeating continuously in online
> log( see below).
>
> How can we resolve it?
>
> Thanks,
> Frank
>
> 14:13:31 Maximum server connections 1
> 14:13:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> 1, Plog used 0, Llog used 1
>
> 14:15:34 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
>
> 14:15:34 Dynamically allocated new virtual shared memory segment (size
> 8192KB)
> 14:15:34 Memory sizes:resident:1713984 KB, virtual:139392 KB, no
> SHMTOTAL> limit
> 14:15:45 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> Allocation successful at 0xe0000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
>
> 14:15:45 Dynamically allocated new virtual shared memory segment (size
> 8192KB)
> 14:15:45 Memory sizes:resident:1713984 KB, virtual:147584 KB, no
> SHMTOTAL> limit
> 14:15:54 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:15:54 out of virtual shared memory
>
> 14:15:55 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:15:55 out of virtual shared memory
>
> 14:17:41 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:17:41 out of virtual shared memory
>
> 14:17:41 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:41 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:42 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:42 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:17:51 SCHAPI: Error -566 Cannot initiate sort.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:01 out of virtual shared memory
>
> 14:18:01 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:11 SCHAPI: Error -566 Cannot initiate sort.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
>
> 14:18:21 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:21 out of virtual shared memory
>
> 14:18:21 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:31 SCHAPI: Error -566 Cannot initiate sort.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Error -7442 The statement must be opened before this
> operation can be performed.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 Checkpoint Completed: duration was 0 seconds.
> 14:18:31 Mon May 5 - loguniq 65622, logpos 0x578303c, timestamp:
> 0xf321305c Interval: 8954
>
> 14:18:31 Maximum server connections 1
> ...............................
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power C
I would suggest trying the following:
as user informix run the following
dbaccess sysadmin
execute function task("scheduler shutdown");
execute function task("scheduler start");
It will reset the database scheduler which seems to have
a problem.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS) -
http://www.ibm.com/software/data/informix/ids/
=
"FRANK" =
<yunyaoqu@gmail.c =
om> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: SCHAPI: Error -566 Cannot =
05/05/2008 10:23 initiate sort....... [11969] =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
hmmm....
Probably you are right, since after that happened, the worse is that no=
body
can use the db anymore!
On Mon, May 5, 2008 at 11:27 AM, Robert Roussey(IT) <
Robert.Roussey@spiritair.com> wrote:
> I think the only way to make that stop is to stop the db engine.
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=
> FRANK
> Sent: Monday, May 05, 2008 10:42 AM
> To: ids@iiug.org
> Subject: SCHAPI: Error -566 Cannot initiate sort........... [11967]
>
> Folks,
>
> Program Name: onstat
> Build Version: 11.10.UC2
> Build Number: N158
> Build Host: vach
> Build OS: AIX 5.3
> Build Date: Thu Oct 25 22:56:40 CDT 2007
> GLS Version: glslib-4.50.UC2
>
> After run out of memory, we terminated the big session( that caused t=
he
> problem), but the error messages keep repeating continuously in onlin=
e
> log( see below).
>
> How can we resolve it?
>
> Thanks,
> Frank
>
> 14:13:31 Maximum server connections 1
> 14:13:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> 1, Plog used 0, Llog used 1
>
> 14:15:34 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, the=
n
> consider this message informational only.
>
> 14:15:34 Dynamically allocated new virtual shared memory segment (siz=
e
> 8192KB)
> 14:15:34 Memory sizes:resident:1713984 KB, virtual:139392 KB, no
> SHMTOTAL> limit
> 14:15:45 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> Allocation successful at 0xe0000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, the=
n
> consider this message informational only.
>
> 14:15:45 Dynamically allocated new virtual shared memory segment (siz=
e
> 8192KB)
> 14:15:45 Memory sizes:resident:1713984 KB, virtual:147584 KB, no
> SHMTOTAL> limit
> 14:15:54 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:15:54 out of virtual shared memory
>
> 14:15:55 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:15:55 out of virtual shared memory
>
> 14:17:41 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:17:41 out of virtual shared memory
>
> 14:17:41 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:41 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:41 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:42 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:42 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:42 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:17:51 SCHAPI: Error -566 Cannot initiate sort.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:17:51 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:17:51 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:01 out of virtual shared memory
>
> 14:18:01 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:01 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:01 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:11 SCHAPI: Error -566 Cannot initiate sort.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:11 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:18:11 SCHAPI: Type: , Name: NULL, Location: NULL.
>
> 14:18:21 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:21 out of virtual shared memory
>
> 14:18:21 SCHAPI: Error -243 Could not position within a table
> (informix.ph_task).
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:21 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:21 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 shmat: [EMFILE][24]: out of shared memory segments, check
> system
> SHMSEG
>
> 14:18:31 SCHAPI: Error -566 Cannot initiate sort.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Error -116 ISAM error: cannot allocate memory.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Error -7442 The statement must be opened before this=
> operation can be performed.
> 14:18:31 SCHAPI: Type: , Name: NULL, Location: NULL.
> 14:18:31 SCHAPI: Err