Re: I can't use DBACCESS - after initializing online 5.20 UC1
This is a multi-part message in MIME format.
------=_NextPart_000_0086_01C3D9B6.8A452B50
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0087_01C3D9B6.8A452B50"
------=_NextPart_001_0087_01C3D9B6.8A452B50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello there.
yeh i am using the Linux Edition which i downloaded form IIUG site. =
What next.
----- Original Message -----=20
From: Venkatesh Gopal=20
To: RATHER=20
Sent: Monday, January 12, 2004 5:32 PM
Subject: Re: I can't use DBACCESS - after initializing online 5.20 UC1
Are you using the Linux edition downloaded from the IIUG site? This =
edition limits the numbers of users that can connect to the engine =
concurrently.
Venkatesh.
"RATHER" <myzahoor@yahoo.co.uk>
=20
"RATHER" <myzahoor@yahoo.co.uk>
Sent by: owner-informix-list@iiug.org=20
01/11/2004 02:49 AM
=20
To: "iiug" <informix-list@iiug.org>
cc:=20
Subject: I can't use DBACCESS - after initializing online 5.20 =
UC1=20
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 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 =3D 1, No =3D 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 =3D 1, No =
=3D 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
BUFFS