Hi,
Try setting OPTCOMPIND to 2 in case your queries are optimized for 7.3x.
MAX_PDQPRIO should be 100 in case you want to use PDQ when your machine is
executing only one heavy task.
Also DS_TOTAL_MEMORY should not be limited in this case (empty param).
Maybe this helps.
Marcus
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Doug
Fossmeyer
Sent: Tuesday, June 13, 2006 2:04 AM
To: ids@iiug.org
Subject: Re: Performance issue after 732 to 94fc6 upgra.... [6934]
Part 2 of posting
onstat -c
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:54:35
-- 2325280 Kbytes
Configuration File: /dbms/informix9/etc/onconfig.std
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server 9.4 Configuration Parameters
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dbms/links/rootdbs9 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 30000 #
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 plogdbs94 # Location (dbspace) of physical log PHYSFILE 127000 #
Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 101 # Number of logical log files LOGSIZE 2000 # Logical log size
(Kbytes)
# Diagnostics
MSGPATH /dbms/informix9/log/online.log # System message log file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set #
BACKUPLOGS=Y ALARMPROGRAM /dbms/informix9/etc/no_log.sh # Alarm program path
TBLSPACE_STATS 0 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 256 # Tape block size (Kbytes)
TAPESIZE 70000000 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dr_data/log.bak # Log tape device path LTAPEBLK 256 # Log tape
block size (Kbytes) LTAPESIZE 70000000 # Max amount of data to put on log
tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine instance DBSERVERNAME
online9 # Name of default database server DBSERVERALIASES test9 # List of
alternate dbservernames NETTYPE ipcshm,2,100,CPU NETTYPE soctcp,2,100,NET
#NETTYPE ipcshm,4,250,CPU DEADLOCK_TIMEOUT 120 # Max time to wait of lock in
distributed env.
RESIDENT 4294967295 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
#turn this off if using VPCLASS
#NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit
number of cpu vps to one #turn these 3 off if using above VPCLASS #NOAGE 0 #
Process aging #AFF_SPROC 1 # Affinity start processor #AFF_NPROCS 0 #
Affinity number of processors
# Shared Memory Parameters
LOCKS 200000 # Maximum number of locks
BUFFERS 900000 # Maximum number of shared buffers #turn this off if using
VPCLASS #NUMAIOVPS 3 # Number of IO vps PHYSBUFF 320 # Physical log buffer
size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes) CLEANERS 8 #
Number of buffer cleaner processes SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 327680 SHMADD 32768 # Size of new shared memory segments
(Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL
300 # Check point interval (in sec) LRUS 128 # Number of LRU queues
LRU_MAX_DIRTY 5.000000 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit TXTIMEOUT
0x12c # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON) # 1 :
notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add
logical log on the fly. (OFF) # # When dynamic logging is on, we can have
higher values for LTXHWM/LTXEHWM, # because the server can add new logical
logs during long transaction rollback.
# However, to limit the number of new logical logs being added,
LTXHWM/LTXEHWM # can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of
logical # log space, i.e. 50/60 or lower.
DYNAMIC_LOGS 0
LTXHWM 40
LTXEHWM 50
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine 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
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30
# DR network timeout (in sec) DRLOSTFOUND /usr/informix/etc/dr.lostfound #
DR lost+found file path
# CDR Variables
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 (Kbytes) CDR_NIFCOMPRESS 0 # Link level
compression (-1 never, 0 none, 9 max) CDR_SERIAL 0,0 # Serial Column
Sequence CDR_DBSPACE # dbspace for syscdr database CDR_QHDR_DBSPACE # CDR
queue dbspace (default same as catalog) CDR_QDATA_SBSPACE # List of CDR
queue smart blob spaces
# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
# 0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default
# Backup/Restore variables
BAR_ACT_LOG /dbms/informix9/log/bar_act.log
# ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /dbms/informix9/log/informix/bar_dbug.log
# ON-Bar Debug Log - not in /tmp please BAR_MAX_BACKUP 0 BAR_RETRY 1
BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
# was 16 and 8, using Belevue settings for test RA_PAGES 32 # Number of
pages to attempt to read ahead RA_THRESHOLD 30 # Number of pages left before
next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that
the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist #
when the OnLine 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 # Default temp dbspaces
DBSPACETEMP tempdbs6:tempdbs7:tempdbs8:tempdbs9:tempdbs10:ifasdbs94temp
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure)
occurs # during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory DUMPSHMEM 0 # Dump a
copy of shared memory DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine) DUMPCNT 1 #
Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time USEOSTIME 0 # 0:
use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 10 # Maximum allowed pdqpriority DS_MAX_QUERIES 2 # Maximum
number of decision support queries DS_TOTAL_MEMORY 17392 # Decision support
memory (Kbytes) DS_MAX_SCANS 20 # Maximum number of decision support scans
DATASKIP off # OPTCOMPIND # 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not # "repeatable read",
optimizer behaves as in (2) # below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation # mode. Nested loop
joins are not necessarily # preferred. Optimizer bases its decision purely #
on costs.
OPTCOMPIND 1 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0) ONDBSPACEDOWN
2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT OPCACHEMAX 0 #
Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions) # 1 =>
Heterogeneous Commit is enabled # 0 (or any other value) => Heterogeneous
Commit is disabled HETERO_COMMIT 0
SBSPACENAME # Default smartblob space name - this is where blobs
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME # Default smartblob space for use by the Informix
# Server. This is used primarily for Informix Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block SYSALARMPROGRAM
/dbms/informix9/etc/evidence.sh # System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
VPCLASS CPU,num=3,aff=1-3,noage
VPCLASS AIO,num=4,aff=0-3,noage
onstat -g glo
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:55:02
-- 2325280 Kbytes
MT global info:
sessions threads vps lngspins
4 36 13 0
sched calls thread switches yield 0 yield n yield forever
total: 49629877 18143907 33194897 1085138 4384761 per sec: 1016 248 839 9 6
Virtual processor summary:
class vps usercpu syscpu total
cpu 3 25401.71 486.28 25887.99
aio 4 12.18 33.48 45.66
lio 1 1.54 5.34 6.88
pio 1 1.57 5.40 6.97
adm 1 10.45 22.50 32.95
soc 2 76.91 394.85 471.76
msc 1 0.92 2.15 3.07
total 13 25505.28 950.00 26455.28
Individual virtual processors:
vp pid class usercpu syscpu total
1 1356 cpu 2897.76 155.49 3053.25
2 1360 adm 10.45 22.50 32.95
3 1361 cpu 16641.84 251.84 16893.68
4 1362 cpu 5862.11 78.95 5941.06
5 1363 lio 1.54 5.34 6.88
6 1364 pio 1.57 5.40 6.97
7 1365 aio 7.55 17.06 24.61
8 1366 msc 0.92 2.15 3.07
9 1367 aio 1.50 5.35 6.85
10 1368 aio 1.68 6.02 7.70
11 1369 aio 1.45 5.05 6.50
12 1370 soc 74.82 388.30 463.12
13 1371 soc 2.09 6.55 8.64
tot 25505.28 950.00 26455.28
onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:57:23
-- 2325280 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors kio
0 i 2.7 652241 635693 16548 0 1229591 0.5 0 kio 1 i 0.5 122726 110766 11960
0 223108 0.6 0 kio 2 i 2.6 639837 614446 25391 0 1202745 0.5 0 msc 0 i 0.1
13165 0 0 0 13160 1.0 0 aio 0 i 1.2 292412 0 292410 0 292145 1.0 0 aio 1 i
0.0 13 0 13 0 275 0.0 0 aio 2 i 0.0 0 0 0 0 5 0.0 0 aio 3 i 0.0 0 0 0 0 0
0.0 0 pio 0 i 0.0 0 0 0 0 0 0.0 0 lio 0 i 0.0 0 0 0 0 0 0.0 0
onstat -g iof
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:58:11
-- 2325280 Kbytes
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 rootdbs9 2556 483 2073 0.0
4 syscatdbs94 731 670 61 0.0
5 ifasnrdbs941 51364 51236 128 0.2
6 ifasnrdbs942 308 288 20 0.0
7 ifasnrdbs943 12789 12611 178 0.1
8 ifasnrdbs944 19948 18691 1257 0.1
9 ifasnrdbs945 30 26 4 0.0
10 ifasnrdbs946 2848 2842 6 0.0
11 ifasnrdbs947 9403 9337 66 0.0
12 ifasnrdbs948 0 0 0 0.0
13 ifasnrdbs949 5 1 4 0.0
14 ifasnrdbs9410 0 0 0 0.0
15 ifashrpy1 5 5 0 0.0
16 ifashrpy2 0 0 0 0.0
17 ifashrpy3 0 0 0 0.0
18 ifashrpy4 0 0 0 0.0
19 ifashrpy5 0 0 0 0.0
20 ifashrpy6 0 0 0 0.0
21 ifashrpy7 3 3 0 0.0
22 ifashrpy9 0 0 0 0.0
23 ifashrpy10 0 0 0 0.0
24 ifashrpy11 0 0 0 0.0
25 llogdbs94 2964 0 2964 0.0
26 tempdbs6 34591 4863 29728 0.1
27 tempdbs7 7698 3579 4119 0.0
28 tempdbs8 6663 3054 3609 0.0
29 tempdbs9 6621 3045 3576 0.0
30 tempdbs10 26 5 21 0.0
31 ifasdevdbs1 0 0 0 0.0
32 ifasdevdbs2 0 0 0 0.0
33 ifasdevdbs3 0 0 0 0.0
34 ifasdevdbs4 0 0 0 0.0
35 ifasdevdbs5 0 0 0 0.0
36 ifasdevdbs6 0 0 0 0.0
37 ifasdevdbs7 0 0 0 0.0
38 ifasdevdbs8 0 0 0 0.0
39 ifasdevdbs9 0 0 0 0.0
40 ifasdevdbs10 0 0 0 0.0
41 ifashrpy12 0 0 0 0.0
42 plogdbs94 588 0 588 0.0
43 ifasdbs94temp 9 4 5 0.0
44 ifasdev2dbspyt 7437 2176 5261 0.0
45 ifasdev2dbspyt2 258376 258142 234 1.1
46 ifasdev2dbspyt3 990414 990414 0 4.1
onstat -g rea
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:58:32
-- 2325280 Kbytes
Ready threads:
tid tcb rstcb prty status vp-class name
onstat -g dsc
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:58:51
-- 2325280 Kbytes
Distribution Cache:
Number of lists : 31
DS_POOLSIZE : 127
Distribution Cache Entries:
list# id ref_cnt dropped? heap_ptr distribution name
-----------------------------------------------------------------
0 0 0 0 c00000008f7b9038 ifasdev2:bsi.
0 0 0 0 c00000008f9e1c38 ifasdev2:bsi.
1 0 0 0 c00000008f9dfc38 ifasdev2:bsi.
1 0 0 0 c00000008f849838 ifasdev2:bsi.
1 0 0 0 c00000008fb01038 ifasdev2:bsi.
2 0 0 0 c00000008f96e438 ifasdev2:bsi.
2 0 0 0 c00000008fb21c38 ifasdev2:bsi.
2 0 0 0 c00000008f87e438 ifasdev2:bsi.
3 0 0 0 c00000008fb39438 ifasdev2:bsi.
3 0 0 0 c00000008fb1cc38 ifasdev2:bsi.
3 0 0 0 c00000008f7ad038 ifasdev2:bsi.
4 0 0 0 c00000008fd93838 ifasdev2:bsi.
4 0 0 0 c00000008fafb838 ifasdev2:bsidba.
4 0 0 0 c00000008f7fc438 ifasdev2:bsi.
5 0 0 0 c00000008f7ae438 ifasdev2:bsi.
5 0 0 0 c00000008fbfe038 ifasdev2:bsidba.
5 0 0 0 c00000008f888838 ifasdev2:bsi.
6 0 0 0 c00000008f8e1438 ifasdev2:bsi.
6 0 0 0 c00000008fd49038 ifasdev2:bsidba.
6 0 0 0 c00000008f881038 ifasdev2:bsi.
7 0 0 0 c00000008fb25c38 ifasdev2:bsidba.
7 0 0 0 c00000008f6b1438 ifasdev2:bsi.
7 0 0 0 c00000008f8bc038 ifasdev2:bsi.
8 0 0 0 c00000008f874038 ifasdev2:bsi.
8 0 0 0 c00000008f7ad438 ifasdev2:bsi.
8 0 0 0 c00000008fa5a838 ifasdev2:bsi.
9 0 0 0 c00000008f5e2038 ifasdev2:bsidba.
9 0 0 0 c00000008fc14438 ifasdev2:bsi.
9 0 0 0 c00000008f7d3838 ifasdev2:bsi.
10 0 0 0 c00000008f78d838 ifasdev2:bsi.
10 0 0 0 c00000008f7b6c38 ifasdev2:bsidba.
10 0 0 0 c00000008fd1f438 ifasdev2:bsi.
11 0 0 0 c00000008fa67438 ifasdev2:bsi.
11 0 0 0 c00000008f6edc38 ifasdev2:bsi.
11 0 0 0 c00000008f8d8c38 ifasdev2:bsi.
12 0 0 0 c00000008f8ef438 ifasdev2:bsidba.
12 0 0 0 c00000008f71d038 ifasdev2:bsi.
13 0 0 0 c00000008fb2e438 ifasdev2:bsidba.
13 0 0 0 c00000008ff63038 ifasdev2:bsi.
13 0 0 0 c00000008fc7d838 ifasdev2:bsi.
14 0 0 0 c00000008fd10438 ifasdev2:bsi.
14 0 0 0 c00000008f91a438 ifasdev2:bsi.
14 0 0 0 c00000008f734c38 ifasdev2:bsi.
15 0 0 0 c00000008fbe6c38 ifasdev2:bsi.
15 0 0 0 c00000008fb25038 ifasdev2:bsi.
16 0 0 0 c00000008f8ef838 ifasdev2:bsidba.
16 0 0 0 c00000008f8eec38 ifasdev2:bsi.
16 0 0 0 c00000008fdb5438 ifasdev2:bsi.
17 0 0 0 c00000008f843838 ifasdev2:bsi.
17 0 0 0 c00000008f68ec38 ifasdev2:bsi.
17 0 0 0 c00000008f7b6038 ifasdev2:bsi.
18 0 0 0 c00000008fa6c838 ifasdev2:bsidba.
18 0 0 0 c00000008f7a4838 ifasdev2:bsi.
18 0 0 0 c00000008fbf3038 ifasdev2:bsi.
19 0 0 0 c00000008fa68038 ifasdev2:bsi.
19 0 0 0 c00000008fb34038 ifasdev2:bsi.
19 0 0 0 c00000008ff70038 ifasdev2:bsi.
20 0 0 0 c00000008fa52038 ifasdev2:bsidba.
20 0 0 0 c00000008fb34438 ifasdev2:bsi.
20 0 0 0 c00000008fb41438 ifasdev2:bsi.
21 0 0 0 c00000008fd10838 ifasdev2:bsi.
21 0 0 0 c00000008f9a2838 ifasdev2:bsi.
21 0 0 0 c00000008f8e5438 ifasdev2:bsidba.
22 0 0 0 c00000008fb2ec38 ifasdev2:bsidba.
22 0 0 0 c00000008fb34838 ifasdev2:bsi.
22 0 0 0 c00000008f874438 ifasdev2:bsi.
23 0 0 0 c00000008fda9038 ifasdev2:bsi.
23 0 0 0 c00000008f962838 ifasdev2:bsi.
23 0 0 0 c00000008fe80838 ifasdev2:bsi.
24 0 0 0 c00000008f906438 ifasdev2:bsi.
24 0 0 0 c00000008f9ed038 ifasdev2:bsidba.
24 0 0 0 c00000008f68e838 syscat:bsi.
25 0 0 0 c00000008fb41c38 ifasdev2:bsi.
25 0 0 0 c00000008f731838 ifasdev2:bsidba.
25 0 0 0 c00000008fafb438 ifasdev2:bsi.
26 0 0 0 c00000008f784c38 ifasdev2:bsidba.
26 0 0 0 c00000008fa20438 ifasdev2:bsidba.
26 0 0 0 c00000008f957038 ifasdev2:bsi.
27 0 0 0 c00000008fa61438 ifasdev2:bsi.
27 0 0 0 c00000008f71a838 ifasdev2:bsi.
28 0 0 0 c00000008f686438 ifasdev2:bsi.
28 0 0 0 c00000008f906838 ifasdev2:bsidba.
28 0 0 0 c00000008fb21438 ifasdev2:bsidba.
29 0 0 0 c00000008f7b2c38 ifasdev2:bsi.
29 0 0 0 c00000008f6f9c38 ifasdev2:bsi.
29 0 0 0 c00000008f9c8038 ifasdev2:bsi.
30 0 0 0 c00000008f83e038 ifasdev2:bsi.
30 0 0 0 c00000008fcf8c38 ifasdev2:bsi.
Total number of distribution entries: 88.
Number of entries in use : 0
onstat -g dic
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:59:16
-- 2325280 Kbytes
Dictionary Cache: Number of lists: 31, Maximum list size: 10
list# size refcnt dirty? heapptr table name
--------------------------------------------------------
0 7 0 no c00000008f822038 ifasdev2@online9:bsidba.retwa_b
0 no c00000008f694038 ifashrpy@online9:bsidba.license_detail
0 no c00000008f6be838 ifasdev2@online9:bsi.glg_gen_mstr
0 no c00000008f78a838 ifasdev2@online9:bsi.qs_menu_dtl
0 no c00000008f7d9838 ifasdev2@online9:bsi.pya_assoc_dtl
0 no c00000008f808038 ifasdev2@online9:bsidba.hr_addlcont
0 no c00000008f873838 ifasdev2@online9:bsidba.hr_perdtble
1 5 0 no c00000008f844838 ifasdev2@online9:bsidba.retwart3
0 no c00000008f88f038 ifasdev2@online9:bsi.py_gen_mstr
0 no c00000008f7e2038 ifasdev2@online9:bsi.vw_help_mstr
0 no c00000008fec7838 ifasdev2@online9:bsidba.wf_model
0 no c00000008fea7838 ifasdev2@online9:bsi.py_sch_mstr
2 3 1 no c00000008f8c7838 ifasdev2@online9:bsi.pyh_hst_dtl
0 no c00000008f850038 ifasdev2@online9:bsi.pym_cdh_dtl
0 no c00000008fe04038 ifasdev2@online9:bsidba.hr_mandret
3 1 0 no c00000008fab7838 ifasdev2@online9:bsidba.hr_earndist
4 6 0 no c00000008fbeb838 syscat@online9:bsi.bsi_rpt_def
0 no c00000008fa04038 ifasdev2@online9:informix.sysusers
0 no c00000008fa01038 ifasdev2@online9:bsidba.retwaern
0 no c00000008fbce838 ifasdev2@online9:bsidba.hr_hrcode
0 no c00000008f8f9838 ifasdev2@online9:bsidba.sy_sat_def
0 no c00000008f8f8038 ifasdev2@online9:bsidba.sy_val_sec_def
5 2 0 no c00000008f728038 ifasdev2@online9:bsi.us_job_dtl
0 no c00000008f998838 ifasdev2@online9:bsi.us_ulink_dtl
6 4 0 no c00000008fe67838 ifashrpy@online9:bsidba.license_history
0 no c00000008f929038 sysmaster@online9:informix.systables
0 no c00000008fac6038 ifasdev2@online9:bsi.au_crash_dtl
0 no c00000008fd74038 ifasdev2@online9:bsidba.sy_dat_codes
7 3 1 no c00000008f8c7038 ifasdev2@online9:bsi.pyt_hrs_dtl
1 yes c00000008f9cf038 ifasdev2@online9:bsi.pyt_hrs_dtl
0 no c00000008fc91838 ifasdev2@online9:bsidba.hr_userenty
8 1 0 no c00000008fc85838 ifasdev2@online9:bsi.pe_zip_mstr
9 2 0 no c00000008fdb3838 syscat@online9:bsi.bsi_sys_blob
0 no c00000008f5e0038 syscat@online9:bsi.bsi_table_def
10 2 0 no c00000008f698038 ifasdev2@online9:bsi.cd_codes_mstr
0 no c00000008feab838 ifasdev2@online9:bsi.pys_sch_dtl
11 3 0 no c00000008f5d1838 ifasdev2@online9:bsi.au_audit_mstr
0 no c00000008f93d038 ifasdev2@online9:informix.sysindexes
0 no c00000008fec5038 ifasdev2@online9:bsidba.hr_emppay_l
12 1 0 no c00000008f6f4038 ifasdev2@online9:bsidba.license_detail
14 5 0 no c00000008f9be838 syscat@online9:bsi.bsi_seeds
0 no c00000008f7bb038 ifasdev2@online9:informix.syscolumns
0 no c00000008f7be838 ifasdev2@online9:informix.sysxtdtypes
0 no c00000008fc29038 ifasdev2@online9:bsidba.us_pw_dtl
0 no c00000008f3a2038 ifasdev@online9:informix.systables
15 3 2 no c00000008f7e7838 ifasdev2@online9:bsi.py_per_mstr
0 no c00000008f79e838 ifasdev2@online9:bsi.nq_next_mstr
0 no c00000008f88b838 ifasdev2@online9:bsidba.sy_dcl_def
16 6 0 no c00000008f862838 ifasdev2@online9:bsidba.retwahst
0 no c00000008f9c4838 syscat@online9:bsi.bsi_sec_views
0 no c00000008f83c838 ifasdev2@online9:bsidba.retwarat
0 no c00000008f756038 ifasdev2@online9:informix.sysams
0 no c00000008fd9a038 ifasdev2@online9:bsidba.hr_slrytble
0 no c00000008fd0a838 ifasdev2@online9:bsidba.sy_selclas_def
17 6 0 no c00000008f952038 ifasdev2@online9:bsi.pyn_num_dtl
0 no c00000008fcf2838 ifasdev2@online9:bsidba.hr_emppay
0 no c00000008fb46038 ifasdev2@online9:bsi.us_flat_dtl
0 no c00000008fe4c838 ifasdev2@online9:bsidba.hr_schdtble
0 no c00000008f921838 ifasdev2@online9:bsidba.sy_class_assign
0 no c00000008fbca038 ifasdev2@online9:bsidba.hr_hrencode
18 2 0 no c00000008f9bf838 syscat@online9:garyd.bsi_sec_folder_obj
0 no c00000008fc26038 ifasdev2@online9:bsidba.usa_assoc_dtl
19 4 0 no c00000008f9c5838 ifasdev2@online9:bsidba.hr_loctble
0 no c00000008fd91038 ifasdev2@online9:bsi.py_cld_mstr
0 no c00000008fd7d838 ifasdev2@online9:bsidba.hr_pcnotble
0 no c00000008fe8d838 ifasdev2@online9:bsi.pyc_cld_dtl
20 3 0 no c00000008f72b838 ifasdev2@online9:bsi.us_db_dtl
0 no c00000008fba9038 ifasdev2@online9:bsidba.hr_entytble
0 no c00000008fab7038 ifasdev2@online9:bsidba.hr_emppaylk
21 2 0 no c00000008f839038 ifasdev2@online9:bsidba.hr_rettblwa
0 no c00000008f9f0038 ifasdev2@online9:bsidba.sy_seldflt_def
22 3 0 no c00000008fc32038 ifasdev2@online9:bsidba.hr_empmstr
0 no c00000008f5e4838 ifasdev2@online9:informix.systables
0 no c00000008f846838 ifasdev2@online9:bsi.py_cdh_mstr
23 6 0 no c00000008f821038 ifasdev2@online9:bsidba.retwa_reported
0 no c00000008fc3f838 ifasdev2@online9:bsidba.us_role_dtl
0 no c00000008f0a8550 ifasdev2@online9:bsi.data_bases
0 no c00000008f6aa038 ifasdev2@online9:bsi.er_error_mstr
0 no c00000008fc22838 ifasdev2@online9:bsi.us_audit_dtl
0 no c00000008f8f0038 ifasdev2@online9:bsidba.sy_dat_def
24 1 0 no c00000008fca3038 ifasdev2@online9:bsidba.hr_dfltmand
25 3 0 no c00000008f7fd838 ifasdev2@online9:bsi.nq_jcl_dtl
0 no c00000008fd79038 ifasdev2@online9:bsi.py_pay_mstr
0 no c00000008fe8e038 ifasdev2@online9:bsidba.hr_jobtble
26 5 1 no c00000008f8b2038 ifasdev2@online9:bsi.hr_pe_mstr
0 no c00000008f693038 syscat@online9:bsi.bsi_cdd_tableref
0 no c00000008f771838 ifasdev2@online9:bsi.qs_quest_mstr
0 no c00000008fa47038 ifasdev2@online9:bsidba.sy_at_sec_def
0 no c00000008f858038 ifasdev2@online9:bsidba.sy_order_by
27 2 0 no c00000008f766038 ifasdev2@online9:bsi.ar_gen_mstr
0 no c00000008f796838 ifasdev2@online9:informix.sysindices
28 3 1 no c00000008f745038 ifasdev2@online9:bsidba.retwaadj
0 no c00000008f70c038 ifasdev2@online9:bsi.us_usno_mstr
0 no c00000008f6ba038 ifasdev2@online9:bsi.ds_subs_mstr
29 2 0 no c00000008f5d7838 ifasdev2@online9:bsidba.hr_pcntble
0 no c00000008fdaf038 ifasdev2@online9:bsidba.hr_bargtble
30 4 0 no c00000008f866838 ifasdev2@online9:bsidba.hr_retirewa
0 no c00000008f749838 syscat@online9:bsi.bsi_column_def
0 no c00000008f951038 ifasdev2@online9:bsi.us_jlog_dtl
0 no c00000008f942838 ifasdev2@online9:bsidba.sy_cl_sec_def
Total number of dictionary entries: 100
onstat -g prc
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days
19:59:37
-- 2325280 Kbytes
UDR Cache:
Number of lists : 31
PC_POOLSIZE : 127
UDR Cache Entries:
list# id ref_cnt dropped? heap_ptr udr name
--------------------------------------------------------------
11 231 0 0 c00000008f0acbc0 ifasdev2@online9:.getuniquekey2
11 1 0 0 c00000008fef7438 ifasdev2@online9:.indexkeyarray_out
21 230 0 0 c00000008fa82838 ifasdev2@online9:.getuserid
26 3 0 0 c00000008f777438 ifasdev2@online9:.ikeyextractcolno
27 229 0 0 c00000008f97d650 ifasdev2@online9:.setuserid
Total number of udr entries: 5.
Number of entries in use : 0
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.