"RATHER" <myzahoor@yahoo.co.uk> wrote in message news:<btr40k$uko$1@terabinaries.xmission.com>...
> Hello
>
> I can't use DBACCESS gives me the following error
> 529: cabt attach to sharde mempr
> 129 : too many users
>

may be you should increase the /proc/sys/kernel/msg* values ?

> your help is appreaciated.
>
> here is the tbstat -u and my tbconfig file
> i tried to change the numebr of uesers from tbmonitors parameters area it
> asks to shutdown and initilize again do so but after checking again the
> users is same going down to 7 active users 7 total.
>
> regards
>
> RATHORE
>
> RSAM Version 5.20.UC1 -- On-Line -- Up 00:02:53 -- 3716 Kbytes
>
> Users
> address flags pid
> user tty wait tout locks nreads nwrites
> 10001a1c ------D 2531 informix
>
> pts/1 0 0 0 3 21
> 10001ab0 ------D 0 informix pts/1 0
>
> 0 0 0 0
> 10001b44 ------F 2532 informix 0 0 0 0 0
> 10001bd8 ------F 2533 informix 0 0 0 0 0
> 10001c6c ------F
>
> 2534 informix 0 0 0 0 0
> 10001d00 ------F 2535 informix 0 0 0 0 0
> 10001d94 ------F 2536 informix 0 0
> 0 0 0
> 7 active, 7 total
>
> Transactions
> address flags user locks log begin
>
> isolation retrys coordinator
> 10001e28 A---- 10001a1c 0 0 NOTRANS 0
> 1000244c A---- 10001ab0 0 0 NOTRANS 0
> 2 active, 20 total
>
> -----------------------------------------
>
>
> RSAM Version 5.20.UC1 -- On-Line -- Up 00:04:29 -- 3716 Kbytes
>
> Configuration File: /usr/informix/etc/tbconfig
> #************************************************* *************************
> #
> # IBM INFORMIX SOFTWARE, INC.
> #
> # Title: tbconfig.std
> # Sccsid: %W% %G% %U%
> # Description: IBM INFORMIX-OnLine Configuration Parameters
> #
> #************************************************* *************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /usr/chunks/rootchunk # Path for device containing root
> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 450000 # Size of root dbspace (Kbytes)
>
> # Disk Mirroring Configuration
>
> MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
> MIRRORPATH # Path for device containing root dbspace
> mirror
> MIRROROFFSET 0 # Offset into mirror device (Kbytes)
>
> # Physical Log Configuration
>
> PHYSDBS rootdbs # Name of dbspace that contains physical log
> PHYSFILE 20000 # Physical log file size (Kbytes)
>
> # Logical Log Configuration
>
> LOGFILES 12 # Number of logical log files
> LOGSIZE 5000 # Size of each logical log file (Kbytes)
>
> # Message Files
>
> MSGPATH /usr/informix/online.log # OnLine message log pathname
> CONSOLE /dev/console # System console message pathname
>
> # Archive Tape Device
>
> TAPEDEV /dev/null # Archive tape device pathname
> TAPEBLK 16 # Archive tape block size (Kbytes)
> TAPESIZE 10240 # Max amount of data to put on tape (Kbytes)
>
> # Logical Log Backup Tape Device
>
> LTAPEDEV /dev/null # Logical log tape device pathname
> LTAPEBLK 16 # Logical log tape block size (Kbytes)
> LTAPESIZE 10240 # Max amount of data to put on log tape
> (Kbytes)
>
> # Identification Parameters
>
> SERVERNUM 0 # Unique id associated with this OnLine
> instance
> DBSERVERNAME ONLINE # Unique name of this OnLine instance
>
> # Shared Memory Parameters
>
> RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
> USERS 15 # Maximum number of concurrent user
> processes
> TRANSACTIONS 20 # Maximum number of concurrent transactions
> LOCKS 2000 # Maximum number of locks
> BUFFERS 1000 # Maximum number of shared memory buffers
> TBLSPACES 200 # Maximum number of active tblspaces
> CHUNKS 18 # Maximum number of chunks
> DBSPACES 8 # Maximum number of dbspaces and blobspaces
> PHYSBUFF 256 # Size of physical log buffers (Kbytes)
> LOGBUFF 256 # Size of logical log buffers (Kbytes)
> LOGSMAX 12 # Maximum number of logical log files
> CLEANERS 8 # Number of page-cleaner processes
> SHMBASE 0x10000000 # Shared memory base address
> CKPTINTVL 300 # Checkpoint interval (in seconds)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit
> (percent)
> LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent)
> LTXHWM 50 # Long TX high-water mark (percent)
> LTXEHWM 60 # Long TX exclusive high-water mark
> (percent)
>
> # Machine- and Product-Specific Parameters
>
> DYNSHMSZ 0 # Dynamic shared memory size (Kbytes)
> GTRID_CMP_SZ 32 # Number of bytes to use in GTRID
> comparision
> DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed
> env.
> TXTIMEOUT 300 # Transaction timeout for I-STAR (in
> seconds)
> SPINCNT 0 # No. of times process tries for latch
> STAGEBLOB # Reserved for IBM INFORMIX-OnLine/Optical
>
> # System Page Size
>
> BUFFSIZE 2048 # Page size (do not change!)
>
>
> sending to informix-list