Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Performance issue after 732 to 94fc6 upgrade p

Posted By: Doug Fossmeyer
Date: Monday, 12 June 2006, at 8:04 p.m.

In Response To: Re: Performance issue after 732 to 94fc6 upgrade (ART KAGEL, BLOOMBERG/ 731 LEXIN)

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

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.