HI,
I would like to know how may 4Gl servers are connected to database.
Please find attached screen shot for number of users and server process list.
To avoid 748 error we are planning to monitor 4gl connection count from promon or using vst.
Please let me know how to find this count.
Version : 9.1e
OS : AIX 5.3
prdphx.pf
*p-10030*:/prd/dba/etc/pf: more db_prdphx.pf
#-------------------------------------------------------
# OVERRIDE database broker parms for PRDPHX
#-------------------------------------------------------
# MAX USERS = Ma*Mn
#-------------------------------------------------------
-B 70000 # Number of Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
-Ma 13 # Max number of REMOTE clients per db server
-Mn 50 # Max number of REMOTE client servers
-Mpb 30 # Maximum Servers per Broker
-n 1000 # Number of users
-Mxs 32768 # Shared memory overflow size (override)
-spin 4000 # Number of spin lock retries
-L 1024000 # Lock Table entries
Shared Resources:
Busy After Image Extent: /progdata/prd/phxai/prdphx.a1
Number of database buffers (-B): 70000
Number of before image buffers (-bibufs): 200
Number of after image buffers (-aibufs): 300
Before-image file name (-g): -
Before-image truncate interval (-G): 60
No crash protection (-i): Not enabled
Maximum private buffers per user (-Bpmax): 64
Current size of locking table (-L): 1024000
Locking table entries in use: 8
Locking table high water mark: 10
Maximum number of clients per server (-Ma): 13
Delay of before-image flush (-Mf): 3
Maximum number of servers (-Mn): 50
Maximum number of users (-n): 1051
Before-image file I/O (-r -R): Raw
Shared memory version number: 9136
Number of semaphores used: 1282
RETURN - show remaining, U - continue uninterrupted, Q - quit:
Broker status: Executing
BI Writer status: Executing
AI Writer status: Executing
Watchdog status: Executing
Number of page writers: 5
Number of self-service users: 3
Number of remote users: 1
Number of servers: 2
Number of shut-downs: 0
Number of monitors: 1
RETURN - repeat, U - continue uninterrupted, Q - quit:
I would like to know how may 4Gl servers are connected to database.
Please find attached screen shot for number of users and server process list.
To avoid 748 error we are planning to monitor 4gl connection count from promon or using vst.
Please let me know how to find this count.
Version : 9.1e
OS : AIX 5.3
prdphx.pf
*p-10030*:/prd/dba/etc/pf: more db_prdphx.pf
#-------------------------------------------------------
# OVERRIDE database broker parms for PRDPHX
#-------------------------------------------------------
# MAX USERS = Ma*Mn
#-------------------------------------------------------
-B 70000 # Number of Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
-Ma 13 # Max number of REMOTE clients per db server
-Mn 50 # Max number of REMOTE client servers
-Mpb 30 # Maximum Servers per Broker
-n 1000 # Number of users
-Mxs 32768 # Shared memory overflow size (override)
-spin 4000 # Number of spin lock retries
-L 1024000 # Lock Table entries
Shared Resources:
Busy After Image Extent: /progdata/prd/phxai/prdphx.a1
Number of database buffers (-B): 70000
Number of before image buffers (-bibufs): 200
Number of after image buffers (-aibufs): 300
Before-image file name (-g): -
Before-image truncate interval (-G): 60
No crash protection (-i): Not enabled
Maximum private buffers per user (-Bpmax): 64
Current size of locking table (-L): 1024000
Locking table entries in use: 8
Locking table high water mark: 10
Maximum number of clients per server (-Ma): 13
Delay of before-image flush (-Mf): 3
Maximum number of servers (-Mn): 50
Maximum number of users (-n): 1051
Before-image file I/O (-r -R): Raw
Shared memory version number: 9136
Number of semaphores used: 1282
RETURN - show remaining, U - continue uninterrupted, Q - quit:
Broker status: Executing
BI Writer status: Executing
AI Writer status: Executing
Watchdog status: Executing
Number of page writers: 5
Number of self-service users: 3
Number of remote users: 1
Number of servers: 2
Number of shut-downs: 0
Number of monitors: 1
RETURN - repeat, U - continue uninterrupted, Q - quit: