IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday 
Author Message
 IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday
Anybody had this experience pls comment.
We encountered system hangs one day 3 times.
According to Informix SUpport it was :-
1) Port 801 should not he the port must be greated than 1024.
   ( I agree but have checked the /etc/services file and find
     no processes using port 801 )
2) SCO SFNOLIMIT should be 128 not 65.
   ( I Changed it now it only hangs one per day ).

I am thinking to moving to 7.3UC10.

Anybody can offer any inputs.

Thanks and Regards
Francis



Wed, 18 Jun 1902 08:00:00 GMT
 IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday

I personnally use IDS 7.30.UC2 on Unixware 7.01 and have no
problems. It's up since weeks or months I don't remember.
I use port number1789

Regards

Francis Teo Ee Cheok a crit:

Quote:
> Anybody had this experience pls comment.
> We encountered system hangs one day 3 times.
> According to Informix SUpport it was :-
> 1) Port 801 should not he the port must be greated than 1024.
>    ( I agree but have checked the /etc/services file and find
>      no processes using port 801 )
> 2) SCO SFNOLIMIT should be 128 not 65.
>    ( I Changed it now it only hangs one per day ).

> I am thinking to moving to 7.3UC10.

> Anybody can offer any inputs.

> Thanks and Regards
> Francis


  vcard.vcf
< 1K Download


Wed, 18 Jun 1902 08:00:00 GMT
 IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday
We have several sites on UXW 7.0.1 and IDS 7.30.UC2.  I would be very
interested in knowing more information on both of your ONCONFIG settings and
Unixware 7.0.1 patch levels.

Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to
the database.

We had 2 sites running with no problems (150 and 200 users), a third site
went live in September and gets an Assert Failure every 5 to 21 days.  It
has more users and volume, but runs the same application.  No luck from
Informix Tech Support.  We have tuned a lot of parameters, but with no
success.  Most suggestions have come from us and not Informix.

We have just experience the same assert failure at one of the first sites
(once in 9 months), so this helps rule out some of the OS and Hardware
questions we had in the back of our minds.

A fourth site went live late November and is experiencing sporatic system
hangs.  UXW is up and running, but performance on existing IDS connections
degrades and no new connections are allowed.  Onstat commands are available,
but cannot execute onmode, etc.

My next course of action is to apply 7.30.UC10 (recently available on UXW
7.0.1), keep pushing Informix Tech Support and continue to try to isolate
the cause myself.

Any other suggestions???
Thanks,

Allan Wilson

online.log

                Thread(36117, sqlexec, 0, 3)
                File: mtex.c Line: 314
10:45:00   Results: Exception Caught. Type: MT_EX_OS, Context: mem

stack
#Stack Trace for p1, Program rpt_view.er
#*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df]
# [1] _semop(0x636, 0xbff4170c, 0x1)    [0xbffe2c21]
# [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483]
# [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec)  [0xbff33a63]
# [4] tlRecv(0x81b59ec, 0x81bb568)      [0xbff2d649]
# [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4)      [0xbff2b38c]
# [6] pfRecv(0x81b59ec, 0x8036fc4)      [0xbff25e26]
# [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0)  [0xbff1533d]
# [8] ASF_Call(0x81b5660, 0x8036fc0)    [0xbff17368]
# [9] asf_recv(0x81b5640)       [0xbfeb683d]
# [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640)      [0xbfeb6904]
# [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054)     [0xbfeb54cb]
# [12] _sqr_messages(0x81d749c, 0, 0x819a658)   [0xbff64ac3]
# [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0)    [0xbff58c1b]
# [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490)   [0xbff587e7]
# [15] ?(0x80c9436, 0x81b9490, 0)       [0x80a5c50]
# [16] ?()      [0x80a33c3]

Note: Looking at the stack, we have focused our search primarily on Informix
BUFFERS (and other related settings) and Unixware semaphore/ shared memory
settings (and UXW patches).

#**************************************************************************
#
#  Informix Dynamic Server Configuration Parameters
#
#

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /IFX_DEVICES/raw01
ROOTOFFSET      0               # Offset of root dbspace into device
(Kbytes)
ROOTSIZE        50000           # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         logspace        # Location (dbspace) of physical log
PHYSFILE        10000           # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        56              # Number of logical log files
LOGSIZE         4000            # Logical log size (Kbytes)

# Diagnostics

MSGPATH         /usr2/informix/online.log # System message log file path
CONSOLE         /dev/null    # System console message path
ALARMPROGRAM    /usr2/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS  1

# System Archive Tape Device

TAPEDEV         /dev/rmt/ntape3

TAPEBLK         16              # Tape block size (Kbytes)
TAPESIZE        15000000        # Maximum amount of data to put on tape
(Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/rmt/ntape2
LTAPEBLK        16              # Log tape block size (Kbytes)
LTAPESIZE       15000000        # Max amount of data to put on log tape
(Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server/Optical staging
area

# System Configuration

SERVERNUM       3               # Unique id corresponding to a Dynamic
Server in
stance
DBSERVERNAME    ifx             # Name of default database server
DBSERVERALIASES ifxtcp          # List of alternate dbservernames
DEADLOCK_TIMEOUT 60              # Max time to wait of lock in distributed
env.
RESIDENT        0               # Forced residency flag (Yes = 1, No = 0)
NETTYPE         ipcshm,1,500,CPU
NETTYPE         tlitcp,1,200,NET

MULTIPROCESSOR  1               # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS       3               # Number of user (cpu) vps
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to
one

NOAGE           1               # Process aging
AFF_SPROC       0               # Affinity start processor
AFF_NPROCS      0               # Affinity number of processors

# Shared Memory Parameters

LOCKS           50000           # Maximum number of locks
BUFFERS         150000          # Maximum number of shared buffers
NUMAIOVPS       14              # Number of IO vps
PHYSBUFF        256             # Physical log buffer size (Kbytes)
LOGBUFF         32              # Logical log buffer size (Kbytes)
LOGSMAX         100             # Maximum number of logical log files
CLEANERS        16              # Number of buffer cleaner processes
SHMBASE         0xa000000L      # Shared memory base address
SHMVIRTSIZE     262144
SHMADD          65536           # Size of new shared memory segments
(Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       600             # Check point interval (in sec)
LRUS            64              # Number of LRU queues
LRU_MAX_DIRTY    2              # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY    1              # LRU percent dirty end cleaning limit
LTXHWM          40              # Long transaction high water mark
percentage
LTXEHWM         50              # Long transaction high water mark
(exclusive)
TXTIMEOUT       0x12c           # Transaction timeout (in sec)
STACKSIZE       32              # Stack size (Kbytes)

# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
#            To determine the page size used by Dynamic Server on your
platform
#            see the last line of output from the command, 'onstat -b'.

# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10              # Default number of offline worker
threads
ON_RECVRY_THREADS 1               # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO          0               # DR automatic switchover
DRINTERVAL      30              # DR max time between DR buffer flushes (in
sec)
DRTIMEOUT       30              # DR network timeout (in sec)
DRLOSTFOUND     /usr2/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
CDR_LOGBUFFERS  2048            # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2             # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)
CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue
(Kb
ytes)

# Backup/Restore variables
BAR_ACT_LOG     /tmp/bar_act.log
BAR_MAX_BACKUP  0
BAR_RETRY       1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData         # If the data pool name is changed, be sure
to
                                # update $INFORMIXDIR/bin/onbar.  Change to
                                # ism_catalog -create_bootstrap -pool <new
name>
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES                      # Number of pages to attempt to read ahead
RA_THRESHOLD                  # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP     tempdbs1,tempdbs2 # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR         /usr3/IFX_DUMP  # Preserve diagnostics in this directory
DUMPSHMEM       1               # Dump a copy of shared memory
DUMPGCORE       0               # Dump a core image using 'gcore'
DUMPCORE        0               # Dump a core image (Warning:this aborts
Dynamic
 Server)
DUMPCNT         1               # Number of shared memory or gcore dumps for
                                # a single user's session

FILLFACTOR      90              # Fill factor for building indexes

# method for Dynamic Server to use when determining current time
USEOSTIME       0               # 0: use internal time(fast), 1: get time
from O
S(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100        
...

read more »



Wed, 18 Jun 1902 08:00:00 GMT
 IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday
You're not alone in this  case,  Allan !:-)

I had also experience of Assert Failure with IDS 7.30.UC2 on UW7.0.1/Compaq
Raid5 platform. And I had to fix myself when the vendors  gave up but that
is the Assert Failure with 'bad page' in writting to raw devices. I had to
do something tuning and remove VLM to get out this problem but  I'm not sure
that is the case.

I'm curious to know if  you have the Assert Failure on which  hardware
setup?
How much physical memory  on the server?

Recently, I got one Assert Failure that you got below

File: mtex.c Line: 314
10:45:00   Results: Exception Caught. Type: MT_EX_OS, Context: mem

And can not fix !

And another relay to bad memory allocation....I don't remember exactly the
error message.
I still waiting the answer from Informix Support.
I hoped I won't have to find the problem myself another time :-)

H.V


Quote:
> We have several sites on UXW 7.0.1 and IDS 7.30.UC2.  I would be very
> interested in knowing more information on both of your ONCONFIG settings
and
> Unixware 7.0.1 patch levels.

> Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to
> the database.

> We had 2 sites running with no problems (150 and 200 users), a third site
> went live in September and gets an Assert Failure every 5 to 21 days.  It
> has more users and volume, but runs the same application.  No luck from
> Informix Tech Support.  We have tuned a lot of parameters, but with no
> success.  Most suggestions have come from us and not Informix.

> We have just experience the same assert failure at one of the first sites
> (once in 9 months), so this helps rule out some of the OS and Hardware
> questions we had in the back of our minds.

> A fourth site went live late November and is experiencing sporatic system
> hangs.  UXW is up and running, but performance on existing IDS connections
> degrades and no new connections are allowed.  Onstat commands are
available,
> but cannot execute onmode, etc.

> My next course of action is to apply 7.30.UC10 (recently available on UXW
> 7.0.1), keep pushing Informix Tech Support and continue to try to isolate
> the cause myself.

> Any other suggestions???
> Thanks,

> Allan Wilson

> online.log

>                 Thread(36117, sqlexec, 0, 3)
>                 File: mtex.c Line: 314
> 10:45:00   Results: Exception Caught. Type: MT_EX_OS, Context: mem

> stack
> #Stack Trace for p1, Program rpt_view.er
> #*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df]
> # [1] _semop(0x636, 0xbff4170c, 0x1)    [0xbffe2c21]
> # [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483]
> # [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec)  [0xbff33a63]
> # [4] tlRecv(0x81b59ec, 0x81bb568)      [0xbff2d649]
> # [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4)
[0xbff2b38c]
> # [6] pfRecv(0x81b59ec, 0x8036fc4)      [0xbff25e26]
> # [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0)  [0xbff1533d]
> # [8] ASF_Call(0x81b5660, 0x8036fc0)    [0xbff17368]
> # [9] asf_recv(0x81b5640)       [0xbfeb683d]
> # [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640)      [0xbfeb6904]
> # [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054)
[0xbfeb54cb]
> # [12] _sqr_messages(0x81d749c, 0, 0x819a658)   [0xbff64ac3]
> # [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0)    [0xbff58c1b]
> # [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490)   [0xbff587e7]
> # [15] ?(0x80c9436, 0x81b9490, 0)       [0x80a5c50]
> # [16] ?()      [0x80a33c3]

> Note: Looking at the stack, we have focused our search primarily on
Informix
> BUFFERS (and other related settings) and Unixware semaphore/ shared memory
> settings (and UXW patches).

#**************************************************************************

- Show quoted text -

Quote:
> #
> #  Informix Dynamic Server Configuration Parameters
> #
> #

> # Root Dbspace Configuration

> ROOTNAME        rootdbs         # Root dbspace name
> ROOTPATH        /IFX_DEVICES/raw01
> ROOTOFFSET      0               # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE        50000           # Size of root dbspace (Kbytes)

> # Disk Mirroring Configuration Parameters

> MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
> MIRRORPATH                      # Path for device containing mirrored root
> MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

> # Physical Log Configuration

> PHYSDBS         logspace        # Location (dbspace) of physical log
> PHYSFILE        10000           # Physical log file size (Kbytes)

> # Logical Log Configuration

> LOGFILES        56              # Number of logical log files
> LOGSIZE         4000            # Logical log size (Kbytes)

> # Diagnostics

> MSGPATH         /usr2/informix/online.log # System message log file path
> CONSOLE         /dev/null    # System console message path
> ALARMPROGRAM    /usr2/informix/etc/log_full.sh # Alarm program path
> SYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path
> TBLSPACE_STATS  1

> # System Archive Tape Device

> TAPEDEV         /dev/rmt/ntape3

> TAPEBLK         16              # Tape block size (Kbytes)
> TAPESIZE        15000000        # Maximum amount of data to put on tape
> (Kbytes)

> # Log Archive Tape Device

> LTAPEDEV        /dev/rmt/ntape2
> LTAPEBLK        16              # Log tape block size (Kbytes)
> LTAPESIZE       15000000        # Max amount of data to put on log tape
> (Kbytes)

> # Optical

> STAGEBLOB                       # Informix Dynamic Server/Optical staging
> area

> # System Configuration

> SERVERNUM       3               # Unique id corresponding to a Dynamic
> Server in
> stance
> DBSERVERNAME    ifx             # Name of default database server
> DBSERVERALIASES ifxtcp          # List of alternate dbservernames
> DEADLOCK_TIMEOUT 60              # Max time to wait of lock in distributed
> env.
> RESIDENT        0               # Forced residency flag (Yes = 1, No = 0)
> NETTYPE         ipcshm,1,500,CPU
> NETTYPE         tlitcp,1,200,NET

> MULTIPROCESSOR  1               # 0 for single-processor, 1 for
> multi-processor
> NUMCPUVPS       3               # Number of user (cpu) vps
> SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to
> one

> NOAGE           1               # Process aging
> AFF_SPROC       0               # Affinity start processor
> AFF_NPROCS      0               # Affinity number of processors

> # Shared Memory Parameters

> LOCKS           50000           # Maximum number of locks
> BUFFERS         150000          # Maximum number of shared buffers
> NUMAIOVPS       14              # Number of IO vps
> PHYSBUFF        256             # Physical log buffer size (Kbytes)
> LOGBUFF         32              # Logical log buffer size (Kbytes)
> LOGSMAX         100             # Maximum number of logical log files
> CLEANERS        16              # Number of buffer cleaner processes
> SHMBASE         0xa000000L      # Shared memory base address
> SHMVIRTSIZE     262144
> SHMADD          65536           # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL        0               # Total shared memory (Kbytes).
0=>unlimited
> CKPTINTVL       600             # Check point interval (in sec)
> LRUS            64              # Number of LRU queues
> LRU_MAX_DIRTY    2              # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY    1              # LRU percent dirty end cleaning limit
> LTXHWM          40              # Long transaction high water mark
> percentage
> LTXEHWM         50              # Long transaction high water mark
> (exclusive)
> TXTIMEOUT       0x12c           # Transaction timeout (in sec)
> STACKSIZE       32              # Stack size (Kbytes)

> # System Page Size
> # BUFFSIZE - Dynamic Server no longer supports this configuration
parameter.
> #            To determine the page size used by Dynamic Server on your
> platform
> #            see the last line of output from the command, 'onstat -b'.

> # Recovery Variables
> # OFF_RECVRY_THREADS:
> # Number of parallel worker threads during fast recovery or an offline
> restore.
> # ON_RECVRY_THREADS:
> # Number of parallel worker threads during an online restore.

> OFF_RECVRY_THREADS 10              # Default number of offline worker
> threads
> ON_RECVRY_THREADS 1               # Default number of online worker
threads

> # Data Replication Variables
> # DRAUTO: 0 manual, 1 retain type, 2 reverse type
> DRAUTO          0               # DR automatic switchover
> DRINTERVAL      30              # DR max time between DR buffer flushes
(in
> sec)
> DRTIMEOUT       30              # DR network timeout (in sec)
> DRLOSTFOUND     /usr2/informix/etc/dr.lostfound # DR lost+found file path

> # CDR Variables
> CDR_LOGBUFFERS  2048            # size of log reading buffer pool (Kbytes)
> CDR_EVALTHREADS 1,2             # evaluator threads

(per-cpu-vp,additional)

- Show quoted text -

Quote:
> CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)
> CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR
queue
> (Kb
> ytes)

> # Backup/Restore variables
> BAR_ACT_LOG     /tmp/bar_act.log
> BAR_MAX_BACKUP  0
> BAR_RETRY       1
> BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 31

> # Informix Storage Manager variables
> ISM_DATA_POOL   ISMData         # If the data pool name is changed, be
sure
> to
>                                 # update $INFORMIXDIR/bin/onbar.  Change
to
>                                 # ism_catalog -create_bootstrap -pool <new
> name>
> ISM_LOG_POOL    ISMLogs

> # Read Ahead Variables
> RA_PAGES                      # Number of pages to attempt to read ahead
> RA_THRESHOLD                  # Number of pages left before next group

> # DBSPACETEMP:
> # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
> # that the

...

read more »



Wed, 18 Jun 1902 08:00:00 GMT
 IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday
Hello Al:
I had problem very similar to yours with a site on DEC-UX and IDS 7.30. I
solved it with 7.31.

Pablo F. Herrero
Gijon (SPAIN)

-----Mensaje original-----

Enviado el: mircoles 26 de enero de 2000 18:45

Asunto: Re: IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday

We have several sites on UXW 7.0.1 and IDS 7.30.UC2.  I would be very
interested in knowing more information on both of your ONCONFIG settings and
Unixware 7.0.1 patch levels.

Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to
the database.

We had 2 sites running with no problems (150 and 200 users), a third site
went live in September and gets an Assert Failure every 5 to 21 days.  It
has more users and volume, but runs the same application.  No luck from
Informix Tech Support.  We have tuned a lot of parameters, but with no
success.  Most suggestions have come from us and not Informix.

We have just experience the same assert failure at one of the first sites
(once in 9 months), so this helps rule out some of the OS and Hardware
questions we had in the back of our minds.

A fourth site went live late November and is experiencing sporatic system
hangs.  UXW is up and running, but performance on existing IDS connections
degrades and no new connections are allowed.  Onstat commands are available,
but cannot execute onmode, etc.

My next course of action is to apply 7.30.UC10 (recently available on UXW
7.0.1), keep pushing Informix Tech Support and continue to try to isolate
the cause myself.

Any other suggestions???
Thanks,

Allan Wilson

online.log

                Thread(36117, sqlexec, 0, 3)
                File: mtex.c Line: 314
10:45:00   Results: Exception Caught. Type: MT_EX_OS, Context: mem

stack
#Stack Trace for p1, Program rpt_view.er
#*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df]
# [1] _semop(0x636, 0xbff4170c, 0x1)    [0xbffe2c21]
# [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483]
# [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec)  [0xbff33a63]
# [4] tlRecv(0x81b59ec, 0x81bb568)      [0xbff2d649]
# [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4)      [0xbff2b38c]
# [6] pfRecv(0x81b59ec, 0x8036fc4)      [0xbff25e26]
# [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0)  [0xbff1533d]
# [8] ASF_Call(0x81b5660, 0x8036fc0)    [0xbff17368]
# [9] asf_recv(0x81b5640)       [0xbfeb683d]
# [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640)      [0xbfeb6904]
# [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054)     [0xbfeb54cb]
# [12] _sqr_messages(0x81d749c, 0, 0x819a658)   [0xbff64ac3]
# [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0)    [0xbff58c1b]
# [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490)   [0xbff587e7]
# [15] ?(0x80c9436, 0x81b9490, 0)       [0x80a5c50]
# [16] ?()      [0x80a33c3]

Note: Looking at the stack, we have focused our search primarily on Informix
BUFFERS (and other related settings) and Unixware semaphore/ shared memory
settings (and UXW patches).

#**************************************************************************
#
#  Informix Dynamic Server Configuration Parameters
#
#

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /IFX_DEVICES/raw01
ROOTOFFSET      0               # Offset of root dbspace into device
(Kbytes)
ROOTSIZE        50000           # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         logspace        # Location (dbspace) of physical log
PHYSFILE        10000           # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        56              # Number of logical log files
LOGSIZE         4000            # Logical log size (Kbytes)

# Diagnostics

MSGPATH         /usr2/informix/online.log # System message log file path
CONSOLE         /dev/null    # System console message path
ALARMPROGRAM    /usr2/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS  1

# System Archive Tape Device

TAPEDEV         /dev/rmt/ntape3

TAPEBLK         16              # Tape block size (Kbytes)
TAPESIZE        15000000        # Maximum amount of data to put on tape
(Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/rmt/ntape2
LTAPEBLK        16              # Log tape block size (Kbytes)
LTAPESIZE       15000000        # Max amount of data to put on log tape
(Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server/Optical staging
area

# System Configuration

SERVERNUM       3               # Unique id corresponding to a Dynamic
Server in
stance
DBSERVERNAME    ifx             # Name of default database server
DBSERVERALIASES ifxtcp          # List of alternate dbservernames
DEADLOCK_TIMEOUT 60              # Max time to wait of lock in distributed
env.
RESIDENT        0               # Forced residency flag (Yes = 1, No = 0)
NETTYPE         ipcshm,1,500,CPU
NETTYPE         tlitcp,1,200,NET

MULTIPROCESSOR  1               # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS       3               # Number of user (cpu) vps
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to
one

NOAGE           1               # Process aging
AFF_SPROC       0               # Affinity start processor
AFF_NPROCS      0               # Affinity number of processors

# Shared Memory Parameters

LOCKS           50000           # Maximum number of locks
BUFFERS         150000          # Maximum number of shared buffers
NUMAIOVPS       14              # Number of IO vps
PHYSBUFF        256             # Physical log buffer size (Kbytes)
LOGBUFF         32              # Logical log buffer size (Kbytes)
LOGSMAX         100             # Maximum number of logical log files
CLEANERS        16              # Number of buffer cleaner processes
SHMBASE         0xa000000L      # Shared memory base address
SHMVIRTSIZE     262144
SHMADD          65536           # Size of new shared memory segments
(Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       600             # Check point interval (in sec)
LRUS            64              # Number of LRU queues
LRU_MAX_DIRTY    2              # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY    1              # LRU percent dirty end cleaning limit
LTXHWM          40              # Long transaction high water mark
percentage
LTXEHWM         50              # Long transaction high water mark
(exclusive)
TXTIMEOUT       0x12c           # Transaction timeout (in sec)
STACKSIZE       32              # Stack size (Kbytes)

# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
#            To determine the page size used by Dynamic Server on your
platform
#            see the last line of output from the command, 'onstat -b'.

# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10              # Default number of offline worker
threads
ON_RECVRY_THREADS 1               # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO          0               # DR automatic switchover
DRINTERVAL      30              # DR max time between DR buffer flushes (in
sec)
DRTIMEOUT       30              # DR network timeout (in sec)
DRLOSTFOUND     /usr2/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
CDR_LOGBUFFERS  2048            # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2             # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT  5               # DS lockwait timeout (seconds)
CDR_QUEUEMEM    4096            # Maximum amount of memory for any CDR queue
(Kb
ytes)

# Backup/Restore variables
BAR_ACT_LOG     /tmp/bar_act.log
BAR_MAX_BACKUP  0
BAR_RETRY       1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData         # If the data pool name is changed, be sure
to
                                # update $INFORMIXDIR/bin/onbar.  Change to
                                # ism_catalog -create_bootstrap -pool <new
name>
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES                      # Number of pages to attempt to read ahead
RA_THRESHOLD                  # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP     tempdbs1,tempdbs2 # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR         /usr3/IFX_DUMP  # Preserve diagnostics in this directory
DUMPSHMEM       1               # Dump a copy of shared memory
DUMPGCORE       0               # Dump a core image using 'gcore'
DUMPCORE        0               # Dump a core image (Warning:this aborts
Dynamic
 Server)
DUMPCNT         1               # Number of
...

read more »



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Informix 7.30 on SCO Unixware 7.01

2. progess 8.3A / unixware 7.01 problems

3. Informix Version 7.01 (?)

4. IDS 2000 and SCO Unixware 7.1

5. Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1

6. Backup Exec 7.01 and SQL 7SP1

7. Visual Basic 6.0 vs. Visual Dbase 7.01

8. ADO 2.5, ASA 7.01 Problem with LONG VARCHARS

9. Oracle 7.01 problem - HELP


 
Powered by phpBB® Forum Software