I can't use DBACCESS - after initializing online 5.20 UC1
Posted in 2004
Topics: Storage & Space Management, Server Administration, Transactions, Locking & Isolation, Logging & Checkpoints, Networking & sqlhosts Configuration
Hello
I can't use DBACCESS gives me the following error
529: cabt attach to sharde mempr
129 : too many users
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 nameROOTPATH /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 dbspacemirror
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 OnLineinstance
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 buffersTBLSPACES 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
"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