this my onconfig file.

ROOTNAME prd2_sg_rootdbs # Root dbspace name

ROOTPATH /dev/infdevprd2/prd2_sg_rootdbs.1

# Path for device containing root
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 512000 # 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 prd2_sg_plogdbs1 # Location (dbspace) of physical log

PHYSFILE 200000 # Physical log file size (Kbytes)



# Logical Log Configuration



LOGFILES 40 # Number of logical log files

LOGSIZE 50000 # Logical log size (Kbytes)



# Diagnostics



MSGPATH /usr/informix_sg_prd2/logs/prd2_sg_srv.log

# System message log file path

CONSOLE /dev/console # System console message path

ALARMPROGRAM /usr/informix_sg_prd2/etc/no_log.sh # Alarm program
path SYSALARMPROGRAM /usr/informix_sg_prd2/etc/evidence.sh

# System Alarm program path

TBLSPACE_STATS 1



# System Archive Tape Device



TAPEDEV /dev/null # Tape device path

TAPEBLK 512 # Tape block size (Kbytes)

TAPESIZE 80000000 # Maximum amount of data to put on tape
(Kbytes)


# Log Archive Tape Device



LTAPEDEV /dev/null # Log tape device path

LTAPEBLK 512 # Log tape block size (Kbytes)

LTAPESIZE 8000000 # Max amount of data to put on log tape
(Kbytes)


# Optical



STAGEBLOB # Informix Dynamic Server/Optical
staging area


# System Configuration


SERVERNUM 3 # Unique id corresponding to a Dynamic
Server in
stance

DBSERVERNAME prd2_sg_srv # Name of default database server

DBSERVERALIASES # List of alternate dbservernames

NETTYPE soctcp,2,150,NET # Configure poll thread(s) for nettype

DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No =
0)


MULTIPROCESSOR 1 # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS 2 # Number of user (cpu) vps

SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
to one


NOAGE 1 # Process aging

AFF_SPROC 0 # Affinity start processor

AFF_NPROCS 0 # Affinity number of processors



# Shared Memory Parameters



LOCKS 500000 # Maximum number of locks

BUFFERS 100000 # Maximum number of shared buffers

NUMAIOVPS 30 # Number of IO vps

PHYSBUFF 512 # Physical log buffer size (Kbytes)


LOGBUFF 512 # Logical log buffer size (Kbytes)

LOGSMAX 100 # Maximum number of logical log files

CLEANERS 20 # Number of buffer cleaner processes

SHMBASE 0x0 # Shared memory base address

SHMVIRTSIZE 256000 # initial virtual shared memory segment
size
SHMADD 128000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 1200 # Check point interval (in sec)

LRUS 127 # Number of LRU queues

LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning
limit
LRU_MIN_DIRTY 2 # LRU percent dirty end cleaning limit

LTXHWM 50 # Long transaction high water mark
percentage
LTXEHWM 60 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)

STACKSIZE 32 # Stack size (Kbytes)



# System Page Size

# BUFFSIZE - Dynamic Server no longer supports this configuration
parameter.
# To determine the page size used by Dynamic Server on your
platform
# see the last line of output from the command, 'onstat -b'.





# Recovery Variables



# 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

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO 0 # DR automatic switchover

DRINTERVAL 30 # DR max time between DR buffer flushes
(in sec)
DRTIMEOUT 30 # DR network timeout (in sec)

DRLOSTFOUND /usr/informix_sg_prd2/etc/dr.lostfound # DR lost+found
file path


# CDR Variables

CDR_LOGBUFFERS 2048 # size of log reading buffer pool
(Kbytes)
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 (Kb
ytes)

CDR_LOGDELTA 30 # % of log space allowed in queue
memory
CDR_NUMCONNECT 16 # Expected connections per server

CDR_NIFRETRY 300 # Connection retry (seconds)



CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0
none, 9 ma
x)



# Backup/Restore variables

BAR_ACT_LOG /usr/informix_sg_prd2/logs/bar_act.log

# ON-Bar Log file - not in /tmp please

BAR_DEBUG_LOG /usr/informix_sg_prd2/logs/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



# Informix Storage Manager variables

ISM_DATA_POOL ISMData # If the data pool name is changed, be
sure to
# update $INFORMIXDIR/bin/onbar.
Change to
# ism_catalog -create_bootstrap -pool
<new name>
ISM_LOG_POOL ISMLogs



# Read Ahead Variables

RA_PAGES # Number of pages to attempt to read
ahead
RA_THRESHOLD # Number of pages left before next
group


# DBSPACETEMP:

# Dynamic Server equivalent of DBTEMP for SE. This is the list of
dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables
etc.
# If specified it must be a colon separated list of dbspaces that exist

# when the Dynamic Server 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 prd2_sg_tmpdbs1,prd2_sg_tmpdbs2 # Default temp dbspaces



# DUMP*:

# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion
failure) occurs
# during Dynamic Server operations.

# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.



DUMPDIR /infdump_prd2 # Preserve diagnostics in this
directory
DUMPSHMEM 1 # Dump a copy of shared memory

DUMPGCORE 0 # Dump a core image using 'gcore'

DUMPCORE 0 # Dump a core image (Warning:this
aborts Dynamic
Server)

DUMPCNT 1 # Number of shared memory or gcore
dumps for
# a single user's session

FILLFACTOR 90 # Fill factor for building indexes



# method for Dynamic Server to use when determining current time

USEOSTIME 0 # 0: use internal time(fast), 1: get
time from O
S(slow)



# Parallel Database Queries (pdq)

MAX_PDQPRIORITY 10 # Maximum allowed pdqpriority

DS_MAX_QUERIES 512 # Maximum number of decision support
queries
DS_TOTAL_MEMORY 1024000 # Decision support memory (Kbytes)

DS_MAX_SCANS 256 # Maximum number of decision support
scans
DATASKIP off # List of dbspaces to skip



# 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 0 # To hint the optimizer



ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1
= ABORT,
2 = WAIT

LBU_PRESERVE 0 # Preserve last log for log backup

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



# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS

OPT_GOAL -1



# Optimizer DIRECTIVES ON (1/Default) or OFF (0)

DIRECTIVES 1


# Status of restartable restore
RESTARTABLE_RESTORE on


onstat -p

dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached

22443290 38931744 1762631153 98.73 10487246 21339077 147144543 92.87



isamtot open start read write rewrite delete commit
rollbk
2448617386 15830478 43797300 2176055597 57182538 11652003 1215143
761713 15


gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs

0 0 0 0 0 0 0



ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes

0 0 0 69098.37 4920.61 514 1382



bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans

3038873 0 2542615244 0 0 105 301628 339257



ixda-RA idx-RA da-RA RA-pgsused lchwaits

8471719 218877 9286551 17976816 34129734


Onstat -d

Informix Dynamic Server Version 7.31.UD6W4 -- On-Line -- Up 9 days
14:53:19 --
499824 Kbytes



Dbspaces

address number flags fchunk nchunks flags owner name

d5c9b158 1 1 1 1 N informix
prd2_sg_rootdbs
d5cc64b0 2 1 2 1 N informix
prd2_sg_plogdbs1
d5cc6570 3 1 3 1 N informix
prd2_sg_logdbs1
d5cc6630 4 2001 4 1 N T informix
prd2_sg_tmpdbs1
d5cc66f0 5 2001 5 1 N T informix
prd2_sg_tmpdbs2
d5cc67b0 7 1001 14 30 N informix
prd2_sg_findbs1
6 active, 2047 maximum



Chunks

address chk/dbs offset size free bpages flags pathname

d5c9b218 1 1 0 256000 254905 PO-
/dev/infdevprd2/prd2_
sg_rootdbs.1

d5c9bd20 2 2 0 256000 155947 PO-
/dev/infdevprd2/prd2_
sg_plogdbs1.1

d5c9be28 3 3 0 1024000 23947 PO-
/dev/infdevprd2/prd2_
sg_logdbs1.1

sg_logdbs1.1

d5c9bf30 4 4 0 512000 511881 PO-
/dev/infdevprd2/prd2_
sg_tmpdbs1.1

d5c9c038 5 5 0 512000 511889 PO-
/dev/infdevprd2/prd2_
sg_tmpdbs2.1

d5c9c140 14 7 0 1024000 7 PO-
/dev/infdevprd2/prd2_
sg_findbs1.1

d5c9c248 15 7 0 1024000 144 PO-
/dev/infdevprd2/prd2_
sg_findbs1.2

d5c9c350 16 7 0 1024000 187 PO-
/dev/infdevprd2/prd2_
sg_findbs1.3

d5c9c458 17 7 0 1024000 9 PO-
/dev/infdevprd2/prd2_
sg_findbs1.4

d5c9c560 18 7 0 1024000 444 PO-
/dev/infdevprd2/prd2_
sg_findbs1.5

d5c9c668 19 7 0 1024000 51821 PO-
/dev/infdevprd2/prd2_
sg_findbs1.6

d5c9c770 20 7 0 1024000 347283 PO-
/dev/infdevprd2/prd2_
sg_findbs1.7

d5c9c878 21 7 0 1024000 691341 PO-
/dev/infdevprd2/prd2_
sg_findbs1.8

d5c9c980 22 7 0 1024000 1023997 PO-
/dev/infdevprd2/prd2_
sg_findbs1.9

d5c9ca88 23 7 0 1024000 1023997 PO-
/dev/infdevprd2/prd2_
sg_findbs1.10

d5c9cb90 24 7 0 1024000 1023997 PO-
/dev/infdevprd2/prd2_
sg_findbs1.11

d5c9cc98 25 7 0 1024000 1023997 PO-
/dev/infdevprd2/prd2_
sg_findbs1.12

d5c9cda0 26 7 0 1024000 1023997 PO-
/dev/infdevprd2/prd2_
sg_findbs1.13



onstat -D

address number flags fchunk nchunks flags owner name

d5c9b158 1 1 1 1 N informix
prd2_sg_rootdbs
d5cc64b0 2 1 2 1 N informix
prd2_sg_plogdbs1
d5cc6570 3 1 3 1 N informix
prd2_sg_logdbs1
d5cc6630 4 2001 4 1 N T informix
prd2_sg_tmpdbs1
d5cc66f0 5 2001 5 1 N T informix
prd2_sg_tmpdbs2
d5cc67b0 7 1 14 30 N informix
prd2_sg_findbs1
6 active, 2047 maximum



Chunks

address chk/dbs offset page Rd page Wr pathname

d5c9b218 1 1 0 2195 90192
/dev/infdevprd2/prd2_sg_rootdbs.1
d5c9bd20 2 2 0 6 2307983
/dev/infdevprd2/prd2_sg_plogdbs1.1
d5c9be28 3 3 0 6686 5809397
/dev/infdevprd2/prd2_sg_logdbs1.1
d5c9bf30 4 4 0 1477702 1564759
/dev/infdevprd2/prd2_sg_tmpdbs1.1
d5c9c038 5 5 0 1554013 1642218
/dev/infdevprd2/prd2_sg_tmpdbs2.1
d5c9c140 14 7 0 8325283 1005154
/dev/infdevprd2/prd2_sg_findbs1.1
d5c9c248 15 7 0 5359087 1806832
/dev/infdevprd2/prd2_sg_findbs1.2
d5c9c350 16 7 0 3097633 95843
/dev/infdevprd2/prd2_sg_findbs1.3
d5c9c458 17 7 0 3306387 35803
/dev/infdevprd2/prd2_sg_findbs1.4
d5c9c560 18 7 0 4350604 4162410
/dev/infdevprd2/prd2_sg_findbs1.5
d5c9c668 19 7 0 6028801 958518
/dev/infdevprd2/prd2_sg_findbs1.6
d5c9c770 20 7 0 4525545 1841657
/dev/infdevprd2/prd2_sg_findbs1.7
d5c9c878 21 7 0 898104 18384
/dev/infdevprd2/prd2_sg_findbs1.8
d5c9c980 22 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.9
d5c9ca88 23 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.10
d5c9cb90 24 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.11
d5c9cc98 25 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.12
d5c9cda0 26 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.13
d5c9cea8 27 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.14
d5cc5430 28 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.15
d5cc5538 29 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.16
d5cc5640 30 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.17
d5cc5748 31 7 0 1 0
/dev/infdevprd2/prd2_sg_findbs1.18


onstat - g glo

Informix Dynamic Server Version 7.31.UD6W4 -- On-Line -- Up 9 days
15:08:30 --
499824 Kbytes



MT global info:

sessions threads vps lngspins

57 117 38 5



sched calls thread switches yield 0 yield n yield
forever
total: 1508257557 300675072 1207931920 5064776 28641586

per sec: 924 0 924 0 0



Virtual processor summary:

class vps usercpu syscpu total

cpu 2 68167.85 1283.22 69451.07

aio 30 373.19 693.38 1066.57

lio 1 2.73 7.66 10.39

pio 1 2.46 6.28 8.74

adm 1 9.99 20.76 30.75

soc 2 557.49 2929.28 3486.77

msc 1 3.28 1.28 4.56

total 38 69116.99 4941.86 74058.85



onstat -F

Fg Writes LRU Writes Chunk Writes
0 9722172 541175

address flusher state data
d5c9d520 0 I 0 = 0X0
d5c9da28 1 I 0 = 0X0
d5c9df30 2 I 0 = 0X0
d5c9e438 3 I 0 = 0X0
d5c9e940 4 I 0 = 0X0
d5c9ee48 5 I 0 = 0X0
d5c9f350 6 I 0 = 0X0
d5c9f858 7 I 0 = 0X0
d5c9fd60 8 I 0 = 0X0
d5ca0268 9 I 0 = 0X0
d5ca0770 10 I 0 = 0X0
d5ca0c78 11 I 0 = 0X0


onstat -R

127 buffer LRU queue pairs priority levels
# f/m pair total % of length LOW MED_LOW MED_HIGH HIGH
0 f 788 100.0% 788 0 741 41 6
1 m 0.0% 0 0 0 0 0
2 f 786 100.0% 786 0 651 128 7
3 m 0.0% 0 0 0 0 0
4 f 787 100.0% 787 0 613 165 9
5 m 0.0% 0 0 0 0 0
6 f 787 100.0% 787 0 638 134 15
7 m 0.0% 0 0 0 0 0
8 f 787 99.7% 785 0 663 111 11
9 m 0.3% 2 0 2 0 0
10 f 788 100.0% 788 0 717 64 7
11 m 0.0% 0 0 0 0 0
12 f 787 99.9% 786 0 655 120 11
13 m 0.1% 1 0 1 0 0
14 f 788 100.0% 788 0 694 89 5
15 m 0.0% 0 0 0 0 0
16 f 787 100.0% 787 0 633 142 12

................
............................

9 dirty, 99985 queued, 100000 total, 131072 hash buckets, 2048 buffer
size
start clean at 5% (of pair total) dirty, or 39 buffs dirty, stop at 2%

0 priority downgrades, 0 priority upgrades

Onstat -g iov

AIO I/O vps:

class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
errors
msc 0 i 0.0 27322 0 0 0 27316 1.0
0
aio 0 i 13.6 11320908 6520225 4790287 0 11109995 1.0
0
aio 1 i 1.7 1449763 997376 452323 0 1260541 1.2
0
aio 2 i 0.9 788831 367336 421479 0 602720 1.3
0
aio 3 i 0.8 659872 248222 411644 0 478409 1.4
0
aio 4 i 0.7 604880 194467 410405 0 426193 1.4
0
aio 5 i 0.7 569845 157933 411902 0 390623 1.5
0
aio 6 i 0.7 544471 132510 411952 0 365990 1.5
0
aio 7 i 0.6 519884 108441 411432 0 341331 1.5
0
aio 8 i 0.6 474049 71648 402397 0 299454 1.6
0
aio 9 i 0.5 449891 72416 377474 0 275901 1.6
0
aio 10 i 0.5 420238 60045 360177 0 247067 1.7
0
aio 11 i 0.5 406097 56144 349950 0 235832 1.7
0
aio 12 i 0.5 397799 52774 345021 0 228341 1.7
0
aio 13 i 0.5 390289 49905 340380 0 222339 1.8
0
aio 14 i 0.5 382714 46572 336140 0 216251 1.8
0
aio 15 i 0.5 375140 43720 331416 0 210542 1.8
0
..................
..........
pio 0 i 0.0 17583 0 17583 0 17584 1.0
0
lio 0 i 0.0 26918 0 26918 0 26919 1.0
0

Kindly suggest me to perf tuning for the above.

<calyanram@hotmail.com> wrote in message
news:1159758651.195534.6330@e3g2000cwe.googlegroup s.com...
> this my onconfig file.

> Kindly suggest me to perf tuning for the above.

Kindly assist us by providing vital data such as your version of Informix,
operating system, hardware, number of processoes, amount of memory, type of
system (reporting or transactional), details of any performance problems you
are already having, and what your performance tuning objectines are.

calyanram@hotmail.com wrote:

> DBSPACETEMP prd2_sg_tmpdbs1,prd2_sg_tmpdbs2 # Default temp
[snip]
> dbspaces Kindly suggest me to perf tuning for the above.

No idea without information Neil has requested but your syntax is wrong
here: should be a colon not comma separated list.

Ben.

Neil Truby wrote:
> <calyanram@hotmail.com> wrote in message
> news:1159758651.195534.6330@e3g2000cwe.googlegroup s.com...
> > this my onconfig file.
>
> > Kindly suggest me to perf tuning for the above.
>
> Kindly assist us by providing vital data such as your version of Informix,
> operating system, hardware, number of processoes, amount of memory, type of
> system (reporting or transactional), details of any performance problems you
> are already having, and what your performance tuning objectines are.

Informix version : 7.31.UD6W4
HPux 11.00

type of system:transactional oltp

"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message
news:efqiq3$3qo$1$8302bc10@news.demon.co.uk...
> calyanram@hotmail.com wrote:
>
>> DBSPACETEMP prd2_sg_tmpdbs1,prd2_sg_tmpdbs2 # Default temp
> [snip]
>> dbspaces Kindly suggest me to perf tuning for the above.
>
> No idea without information Neil has requested but your syntax is wrong
> here: should be a colon not comma separated list.
>
> Ben.

True, although commas work too ...

You want performance tuning suggestions,

is there a particular problem you are trying to solve or do you just
want it to "go faster"?

if so, is there any more bandwidth available on the machine?

Also, I note you want it to go fast but you don't appear to care if it
all goes wrong :

> TAPEDEV /dev/null # Tape device path
>
>
> LTAPEDEV /dev/null # Log tape device path
>

so no archives and no transaction logging?





calyanram@hotmail.com wrote:
> this my onconfig file.
>
> ROOTNAME prd2_sg_rootdbs # Root dbspace name
>
> ROOTPATH /dev/infdevprd2/prd2_sg_rootdbs.1
>
> # Path for device containing root
> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 512000 # 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 prd2_sg_plogdbs1 # Location (dbspace) of physical log
>
> PHYSFILE 200000 # Physical log file size (Kbytes)
>
>
>
> # Logical Log Configuration
>
>
>
> LOGFILES 40 # Number of logical log files
>
> LOGSIZE 50000 # Logical log size (Kbytes)
>
>
>
> # Diagnostics
>
>
>
> MSGPATH /usr/informix_sg_prd2/logs/prd2_sg_srv.log
>
> # System message log file path
>
> CONSOLE /dev/console # System console message path
>
> ALARMPROGRAM /usr/informix_sg_prd2/etc/no_log.sh # Alarm program
> path SYSALARMPROGRAM /usr/informix_sg_prd2/etc/evidence.sh
>
> # System Alarm program path
>
> TBLSPACE_STATS 1
>
>
>
> # System Archive Tape Device
>
>
>
> TAPEDEV /dev/null # Tape device path
>
> TAPEBLK 512 # Tape block size (Kbytes)
>
> TAPESIZE 80000000 # Maximum amount of data to put on tape
> (Kbytes)
>
>
> # Log Archive Tape Device
>
>
>
> LTAPEDEV /dev/null # Log tape device path
>
> LTAPEBLK 512 # Log tape block size (Kbytes)
>
> LTAPESIZE 8000000 # Max amount of data to put on log tape
> (Kbytes)
>
>
> # Optical
>
>
>
> STAGEBLOB # Informix Dynamic Server/Optical
> staging area
>
>
> # System Configuration
>
>
> SERVERNUM 3 # Unique id corresponding to a Dynamic
> Server in
> stance
>
> DBSERVERNAME prd2_sg_srv # Name of default database server
>
> DBSERVERALIASES # List of alternate dbservernames
>
> NETTYPE soctcp,2,150,NET # Configure poll thread(s) for nettype
>
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
> distributed env.
> RESIDENT 1 # Forced residency flag (Yes = 1, No =
> 0)
>
>
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for
> multi-processor
> NUMCPUVPS 2 # Number of user (cpu) vps
>
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
> to one
>
>
> NOAGE 1 # Process aging
>
> AFF_SPROC 0 # Affinity start processor
>
> AFF_NPROCS 0 # Affinity number of processors
>
>
>
> # Shared Memory Parameters
>
>
>
> LOCKS 500000 # Maximum number of locks
>
> BUFFERS 100000 # Maximum number of shared buffers
>
> NUMAIOVPS 30 # Number of IO vps
>
> PHYSBUFF 512 # Physical log buffer size (Kbytes)
>
>
> LOGBUFF 512 # Logical log buffer size (Kbytes)
>
> LOGSMAX 100 # Maximum number of logical log files
>
> CLEANERS 20 # Number of buffer cleaner processes
>
> SHMBASE 0x0 # Shared memory base address
>
> SHMVIRTSIZE 256000 # initial virtual shared memory segment
> size
> SHMADD 128000 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 1200 # Check point interval (in sec)
>
> LRUS 127 # Number of LRU queues
>
> LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning
> limit
> LRU_MIN_DIRTY 2 # LRU percent dirty end cleaning limit
>
> LTXHWM 50 # Long transaction high water mark
> percentage
> LTXEHWM 60 # Long transaction high water mark
> (exclusive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
>
> STACKSIZE 32 # Stack size (Kbytes)
>
>
>
> # System Page Size
>
> # BUFFSIZE - Dynamic Server no longer supports this configuration
> parameter.
> # To determine the page size used by Dynamic Server on your
> platform
> # see the last line of output from the command, 'onstat -b'.
>
>
>
>
>
> # Recovery Variables
>
>
>
> # 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
>
> # DRAUTO: 0 manual, 1 retain type, 2 reverse type
>
> DRAUTO 0 # DR automatic switchover
>
> DRINTERVAL 30 # DR max time between DR buffer flushes
> (in sec)
> DRTIMEOUT 30 # DR network timeout (in sec)
>
> DRLOSTFOUND /usr/informix_sg_prd2/etc/dr.lostfound # DR lost+found
> file path
>
>
> # CDR Variables
>
> CDR_LOGBUFFERS 2048 # size of log reading buffer pool
> (Kbytes)
> 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 (Kb
> ytes)
>
> CDR_LOGDELTA 30 # % of log space allowed in queue
> memory
> CDR_NUMCONNECT 16 # Expected connections per server
>
> CDR_NIFRETRY 300 # Connection retry (seconds)
>
>
>
> CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0
> none, 9 ma
> x)
>
>
>
> # Backup/Restore variables
>
> BAR_ACT_LOG /usr/informix_sg_prd2/logs/bar_act.log
>
> # ON-Bar Log file - not in /tmp please
>
> BAR_DEBUG_LOG /usr/informix_sg_prd2/logs/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
>
>
>
> # Informix Storage Manager variables
>
> ISM_DATA_POOL ISMData # If the data pool name is changed, be
> sure to
> # update $INFORMIXDIR/bin/onbar.
> Change to
> # ism_catalog -create_bootstrap -pool
> <new name>
> ISM_LOG_POOL ISMLogs
>
>
>
> # Read Ahead Variables
>
> RA_PAGES # Number of pages to attempt to read
> ahead
> RA_THRESHOLD # Number of pages left before next
> group
>
>
> # DBSPACETEMP:
>
> # Dynamic Server equivalent of DBTEMP for SE. This is the list of
> dbspaces
> # that the Dynamic Server SQL Engine will use to create temp tables
> etc.
> # If specified it must be a colon separated list of dbspaces that exist
>
> # when the Dynamic Server 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 prd2_sg_tmpdbs1,prd2_sg_tmpdbs2 # Default temp dbspaces
>
>
>
> # DUMP*:
>
> # The following parameters control the type of diagnostics information
> which
> # is preserved when an unanticipated error condition (assertion
> failure) occurs
> # during Dynamic Server operations.
>
> # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
>
>
>
> DUMPDIR /infdump_prd2 # Preserve diagnostics in this
> directory
> DUMPSHMEM 1 # Dump a copy of shared memory
>
> DUMPGCORE 0 # Dump a core image using 'gcore'
>
> DUMPCORE 0 # Dump a core image (Warning:this
> aborts Dynamic
> Server)
>
> DUMPCNT 1 # Number of shared memory or gcore
> dumps for
> # a single user's session
>
> FILLFACTOR 90 # Fill factor for building indexes
>
>
>
> # method for Dynamic Server to use when determining current time
>
> USEOSTIME 0 # 0: use internal time(fast), 1: get
> time from O
> S(slow)
>
>
>
> # Parallel Database Queries (pdq)
>
> MAX_PDQPRIORITY 10 # Maximum allowed pdqpriority
>
> DS_MAX_QUERIES 512 # Maximum number of decision support
> queries
> DS_TOTAL_MEMORY 1024000 # Decision support memory (Kbytes)
>
> DS_MAX_SCANS 256 # Maximum number of decision support
> scans
> DATASKIP off # List of dbspaces to skip
>
>
>
> # 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 0 # To hint the optimizer
>
>
>
> ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1
> = ABORT,
> 2 = WAIT
>
> LBU_PRESERVE 0 # Preserve last log for log backup
>
> 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
>
>
>
> # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
>
> OPT_GOAL -1
>
>
>
> # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
>
> DIRECTIVES 1
>
>
> # Status of restartable restore
> RESTARTABLE_RESTORE on
>
>
> onstat -p
>
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
>
> 22443290 38931744 1762631153 98.73 10487246 21339077 147144543 92.87
>
>
>
> isamtot open start read write rewrite delete commit
> rollbk
> 2448617386 15830478 43797300 2176055597 57182538 11652003 1215143
> 761713 15
>
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
>
> 0 0 0 0 0 0 0
>
>
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
>
> 0 0 0 69098.37 4920.61 514 1382
>
>
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
>
> 3038873 0 2542615244 0 0 105 301628 339257
>
>
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
>
> 8471719 218877 9286551 17976816 34129734
>
>
> Onstat -d
>
> Informix Dynamic Server Version 7.31.UD6W4 -- On-Line -- Up 9 days
> 14:53:19 --
> 499824 Kbytes
>
>
>
> Dbspaces
>
> address number flags fchunk nchunks flags owner name
>
> d5c9b158 1 1 1 1 N informix
> prd2_sg_rootdbs
> d5cc64b0 2 1 2 1 N informix
> prd2_sg_plogdbs1
> d5cc6570 3 1 3 1 N informix
> prd2_sg_logdbs1
> d5cc6630 4 2001 4 1 N T informix
> prd2_sg_tmpdbs1
> d5cc66f0 5 2001 5 1 N T informix
> prd2_sg_tmpdbs2
> d5cc67b0 7 1001 14 30 N informix
> prd2_sg_findbs1
> 6 active, 2047 maximum
>
>
>
> Chunks
>
> address chk/dbs offset size free bpages flags pathname
>
> d5c9b218 1 1 0 256000 254905 PO-
> /dev/infdevprd2/prd2_
> sg_rootdbs.1
>
> d5c9bd20 2 2 0 256000 155947 PO-
> /dev/infdevprd2/prd2_
> sg_plogdbs1.1
>
> d5c9be28 3 3 0 1024000 23947 PO-
> /dev/infdevprd2/prd2_
> sg_logdbs1.1
>
> sg_logdbs1.1
>
> d5c9bf30 4 4 0 512000 511881 PO-
> /dev/infdevprd2/prd2_
> sg_tmpdbs1.1
>
> d5c9c038 5 5 0 512000 511889 PO-
> /dev/infdevprd2/prd2_
> sg_tmpdbs2.1
>
> d5c9c140 14 7 0 1024000 7 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.1
>
> d5c9c248 15 7 0 1024000 144 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.2
>
> d5c9c350 16 7 0 1024000 187 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.3
>
> d5c9c458 17 7 0 1024000 9 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.4
>
> d5c9c560 18 7 0 1024000 444 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.5
>
> d5c9c668 19 7 0 1024000 51821 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.6
>
> d5c9c770 20 7 0 1024000 347283 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.7
>
> d5c9c878 21 7 0 1024000 691341 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.8
>
> d5c9c980 22 7 0 1024000 1023997 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.9
>
> d5c9ca88 23 7 0 1024000 1023997 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.10
>
> d5c9cb90 24 7 0 1024000 1023997 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.11
>
> d5c9cc98 25 7 0 1024000 1023997 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.12
>
> d5c9cda0 26 7 0 1024000 1023997 PO-
> /dev/infdevprd2/prd2_
> sg_findbs1.13
>
>
>
> onstat -D
>
> address number flags fchunk nchunks flags owner name
>
> d5c9b158 1 1 1 1 N informix
> prd2_sg_rootdbs
> d5cc64b0 2 1 2 1 N informix
> prd2_sg_plogdbs1
> d5cc6570 3 1 3 1 N informix
> prd2_sg_logdbs1
> d5cc6630 4 2001 4 1 N T informix
> prd2_sg_tmpdbs1
> d5cc66f0 5 2001 5 1 N T informix
> prd2_sg_tmpdbs2
> d5cc67b0 7 1 14 30 N informix
> prd2_sg_findbs1
> 6 active, 2047 maximum
>
>
>
> Chunks
>
> address chk/dbs offset page Rd page Wr pathname
>
> d5c9b218 1 1 0 2195 90192
> /dev/infdevprd2/prd2_sg_rootdbs.1
> d5c9bd20 2 2 0 6 2307983
> /dev/infdevprd2/prd2_sg_plogdbs1.1
> d5c9be28 3 3 0 6686 5809397
> /dev/infdevprd2/prd2_sg_logdbs1.1
> d5c9bf30 4 4 0 1477702 1564759
> /dev/infdevprd2/prd2_sg_tmpdbs1.1
> d5c9c038 5 5 0 1554013 1642218
> /dev/infdevprd2/prd2_sg_tmpdbs2.1
> d5c9c140 14 7 0 8325283 1005154
> /dev/infdevprd2/prd2_sg_findbs1.1
> d5c9c248 15 7 0 5359087 1806832
> /dev/infdevprd2/prd2_sg_findbs1.2
> d5c9c350 16 7 0 3097633 95843
> /dev/infdevprd2/prd2_sg_findbs1.3
> d5c9c458 17 7 0 3306387 35803
> /dev/infdevprd2/prd2_sg_findbs1.4
> d5c9c560 18 7 0 4350604 4162410
> /dev/infdevprd2/prd2_sg_findbs1.5
> d5c9c668 19 7 0 6028801 958518
> /dev/infdevprd2/prd2_sg_findbs1.6
> d5c9c770 20 7 0 4525545 1841657
> /dev/infdevprd2/prd2_sg_findbs1.7
> d5c9c878 21 7 0 898104 18384
> /dev/infdevprd2/prd2_sg_findbs1.8
> d5c9c980 22 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.9
> d5c9ca88 23 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.10
> d5c9cb90 24 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.11
> d5c9cc98 25 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.12
> d5c9cda0 26 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.13
> d5c9cea8 27 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.14
> d5cc5430 28 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.15
> d5cc5538 29 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.16
> d5cc5640 30 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.17
> d5cc5748 31 7 0 1 0
> /dev/infdevprd2/prd2_sg_findbs1.18
>
>
> onstat - g glo
>
> Informix Dynamic Server Version 7.31.UD6W4 -- On-Line -- Up 9 days
> 15:08:30 --
> 499824 Kbytes
>
>
>
> MT global info:
>
> sessions threads vps lngspins
>
> 57 117 38 5
>
>
>
> sched calls thread switches yield 0 yield n yield
> forever
> total: 1508257557 300675072 1207931920 5064776 28641586
>
> per sec: 924 0 924 0 0
>
>
>
> Virtual processor summary:
>
> class vps usercpu syscpu total
>
> cpu 2 68167.85 1283.22 69451.07
>
> aio 30 373.19 693.38 1066.57
>
> lio 1 2.73 7.66 10.39
>
> pio 1 2.46 6.28 8.74
>
> adm 1 9.99 20.76 30.75
>
> soc 2 557.49 2929.28 3486.77
>
> msc 1 3.28 1.28 4.56
>
> total 38 69116.99 4941.86 74058.85
>
>
>
> onstat -F
>
> Fg Writes LRU Writes Chunk Writes
> 0 9722172 541175
>
> address flusher state data
> d5c9d520 0 I 0 = 0X0
> d5c9da28 1 I 0 = 0X0
> d5c9df30 2 I 0 = 0X0
> d5c9e438 3 I 0 = 0X0
> d5c9e940 4 I 0 = 0X0
> d5c9ee48 5 I 0 = 0X0
> d5c9f350 6 I 0 = 0X0
> d5c9f858 7 I 0 = 0X0
> d5c9fd60 8 I 0 = 0X0
> d5ca0268 9 I 0 = 0X0
> d5ca0770 10 I 0 = 0X0
> d5ca0c78 11 I 0 = 0X0
>
>
> onstat -R
>
> 127 buffer LRU queue pairs priority levels
> # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH
> 0 f 788 100.0% 788 0 741 41 6
> 1 m 0.0% 0 0 0 0 0
> 2 f 786 100.0% 786 0 651 128 7
> 3 m 0.0% 0 0 0 0 0
> 4 f 787 100.0% 787 0 613 165 9
> 5 m 0.0% 0 0 0 0 0
> 6 f 787 100.0% 787 0 638 134 15
> 7 m 0.0% 0 0 0 0 0
> 8 f 787 99.7% 785 0 663 111 11
> 9 m 0.3% 2 0 2 0 0
> 10 f 788 100.0% 788 0 717 64 7
> 11 m 0.0% 0 0 0 0 0
> 12 f 787 99.9% 786 0 655 120 11
> 13 m 0.1% 1 0 1 0 0
> 14 f 788 100.0% 788 0 694 89 5
> 15 m 0.0% 0 0 0 0 0
> 16 f 787 100.0% 787 0 633 142 12
>
> ...............
> ...........................
>
> 9 dirty, 99985 queued, 100000 total, 131072 hash buckets, 2048 buffer
> size
> start clean at 5% (of pair total) dirty, or 39 buffs dirty, stop at 2%
>
> 0 priority downgrades, 0 priority upgrades
>
> Onstat -g iov
>
> AIO I/O vps:
>
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
> errors
> msc 0 i 0.0 27322 0 0 0 27316 1.0
> 0
> aio 0 i 13.6 11320908 6520225 4790287 0 11109995 1.0
> 0
> aio 1 i 1.7 1449763 997376 452323 0 1260541 1.2
> 0
> aio 2 i 0.9 788831 367336 421479 0 602720 1.3
> 0
> aio 3 i 0.8 659872 248222 411644 0 478409 1.4
> 0
> aio 4 i 0.7 604880 194467 410405 0 426193 1.4
> 0
> aio 5 i 0.7 569845 157933 411902 0 390623 1.5
> 0
> aio 6 i 0.7 544471 132510 411952 0 365990 1.5
> 0
> aio 7 i 0.6 519884 108441 411432 0 341331 1.5
> 0
> aio 8 i 0.6 474049 71648 402397 0 299454 1.6
> 0
> aio 9 i 0.5 449891 72416 377474 0 275901 1.6
> 0
> aio 10 i 0.5 420238 60045 360177 0 247067 1.7
> 0
> aio 11 i 0.5 406097 56144 349950 0 235832 1.7
> 0
> aio 12 i 0.5 397799 52774 345021 0 228341 1.7
> 0
> aio 13 i 0.5 390289 49905 340380 0 222339 1.8
> 0
> aio 14 i 0.5 382714 46572 336140 0 216251 1.8
> 0
> aio 15 i 0.5 375140 43720 331416 0 210542 1.8
> 0
> .................
> .........
> pio 0 i 0.0 17583 0 17583 0 17584 1.0
> 0
> lio 0 i 0.0 26918 0 26918 0 26919 1.0
> 0
>
> Kindly suggest me to perf tuning for the above.

On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote:

>this my onconfig file.
>

....onconfig file snipped...

Please give us a bit more information. Hardware specs (number of
CPUs, memory, OS. etc.) would be good . . .

JWC