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
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

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

IDS Forum

Re: Performance Tuning Discussion

Posted By: MOHAMMAD IRFAN
Date: Monday, 4 March 2013, at 6:46 a.m.

In Response To: Re: Performance Tuning Discussion (Art Kagel)

What are the tools to perform monitoring and tuning on the informix instance? As far as I know I've been using onstat - (lots of options) but I doesn't seem to enable to interpret all the information.

My goals is to get Nice DSS Performance. For OLTP function it is necessary to load big data.

onstat -c result:

ROOTNAME rootdbs
ROOTPATH /opt/zzz/dbspaces/rootdbs
ROOTOFFSET 0
# ROOTSIZE 200000
ROOTSIZE 5000000
MIRROR 1
#MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRRORPATH /opt/zzz/mdbspaces/rootdbs

MIRROROFFSET 0

PHYSFILE 8304722
PLOG_OVERFLOW_PATH /opt/informix/tmp

PHYSBUFF 128

LOGFILES 17
LOGSIZE 5000
DYNAMIC_LOGS 0

LOGBUFF 128

LTXHWM 70

LTXEHWM 80

MSGPATH /opt/zzz/online.log

#CONSOLE $INFORMIXDIR/tmp/online.con
CONSOLE /opt/zzz/online.con

TBLTBLFIRST 0
TBLTBLNEXT 0

TBLSPACE_STATS 1

#DBSPACETEMP tempdbs:tempdbs1:tempdbs2:tempdbs4
DBSPACETEMP tempdbs1:tempdbs2:tempdbs3:tempdbs4

SBSPACETEMP

SBSPACENAME sbspace
SYSSBSPACENAME

ONDBSPACEDOWN 2

SERVERNUM 0
DBSERVERNAME zzz
# DBSERVERALIASES dr_informix1170

FULL_DISK_INIT 0

NETTYPE ipcshm,1,50,CPU
NETTYPE soctcp,1,150,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1

NS_CACHE host=900,service=900,user=900,group=900

MULTIPROCESSOR 1
VPCLASS cpu,num=15,noage
#VP_MEMORY_CACHE_KB 800
#VP_MEMORY_CACHE_KB 262144
VP_MEMORY_CACHE_KB 100000

SINGLE_CPU_VP 0

#VPCLASS aio,num=1
VPCLASS aio,num=10,noage
CLEANERS 8
AUTO_AIOVPS 1

DIRECT_IO 1

#LOCKS 100000
LOCKS 50000

#DEF_TABLE_LOCKMODE page
DEF_TABLE_LOCKMODE row

#RESIDENT 0
#RESIDENT 1
RESIDENT -1
SHMBASE 0x44000000
#SHMVIRTSIZE 32656
#SHMADD 8192
#EXTSHMADD 8192
SHMVIRTSIZE 35651584
SHMADD 32768
EXTSHMADD 32768
# SHMTOTAL 0
# SHMTOTAL 15099494
SHMTOTAL 48234496
SHMVIRT_ALLOCSEG 0.000000

SHMNOACCESS aio,num=10,noage

CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0

BLOCKTIMEOUT 3600

CONVERSION_GUARD 2

RESTORE_POINT_DIR /opt/informix/tmp

TXTIMEOUT 300
DEADLOCK_TIMEOUT 60

HETERO_COMMIT 0

TAPEDEV /dev/tapedev
TAPEBLK 32

TAPESIZE 0

LTAPEDEV /dev/null
LTAPEBLK 32

LTAPESIZE 0

BAR_ACT_LOG /opt/informix/tmp/bar_act.log
BAR_DEBUG_LOG /opt/informix/tmp/bar_dbug.log
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0

BAR_CKPTSEC_TIMEOUT 15

ISM_DATA_POOL ISMData

ISM_LOG_POOL ISMLogs

DD_HASHSIZE 31

DD_HASHMAX 10

DS_HASHSIZE 31

DS_POOLSIZE 127

PC_HASHSIZE 31
PC_POOLSIZE 127

#STMT_CACHE 0
#STMT_CACHE 1
STMT_CACHE 2
STMT_CACHE_HITS 0
#STMT_CACHE_SIZE 512
STMT_CACHE_SIZE 2046
STMT_CACHE_NOLIMIT 0

#STMT_CACHE_NUMPOOL 1
STMT_CACHE_NUMPOOL 256

USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0

USELASTCOMMITTED NONE

FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default

ONLIDX_MAXMEM 5120

MAX_PDQPRIORITY 100
#DS_MAX_QUERIES
DS_MAX_QUERIES 245760
#DS_TOTAL_MEMORY
DS_TOTAL_MEMORY 33554432
#DS_MAX_SCANS 1048576
DS_MAX_SCANS 1048576
#DS_NONPDQ_QUERY_MEM 128
DS_NONPDQ_QUERY_MEM 7864320

PSORT_NPROCS 4

DATASKIP off

#OPTCOMPIND 2
OPTCOMPIND 0
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
#IFX_FOLDVIEW 0
IFX_FOLDVIEW 1
AUTO_REPREPARE 1
AUTO_STAT_MODE 1

STATCHANGE 10

RA_PAGES 128
RA_THRESHOLD 120
BATCHEDREAD_TABLE 1
BATCHEDREAD_INDEX 1

BATCHEDREAD_KEYONLY 0

#SQLTRACE level=low,ntraces=1000,size=2,mode=global
EXPLAIN_STAT 1
SQLTRACE level=low,ntraces=1000,size=2,mode=global

#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION 0
UNSECURE_ONSTAT 0
ADMIN_USER_MODE_WITH_DBSA 0

PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127

USRC_HASHSIZE 31

STAGEBLOB

OPCACHEMAX 0

ENCRYPT_HDR 0
ENCRYPT_SMX 0
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC medium
ENCRYPT_MACFILE builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin,builtin

ENCRYPT_SWITCH 0,0

CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0,0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_SUPPRESS_ATSRISWARN
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0

CDR_MAX_DYNAMIC_LOGS 0

DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
HA_ALIAS
DRLOSTFOUND /opt/informix/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS 0
SDS_ENABLE 0
SDS_TIMEOUT 20
SDS_PAGING
UPDATABLE_SECONDARY 0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT 0
TEMPTAB_NOLOG 0
ENABLE_SNAPSHOT_COPY 0

SMX_COMPRESS 0

ON_RECVRY_THREADS 1

OFF_RECVRY_THREADS 10

DUMPDIR /opt/informix/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0

DUMPCNT 1

ALARMPROGRAM /opt/informix/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3

SYSALARMPROGRAM /opt/informix/etc/evidence.sh

RAS_PLOG_SPEED 12232

RAS_LLOG_SPEED 0

EILSEQ_COMPAT_MODE 0

QSTATS 0
WSTATS 0
USERMAPPING OFF

SP_AUTOEXPAND 1
SP_THRESHOLD 0.000000

SP_WAITTIME 30

DEFAULTESCCHAR \

#VPCLASS MQ,noyield
MQSERVER
MQCHLLIB

#VPCLASS jvp,num=1
#JVPJAVAHOME $INFORMIXDIR/extend/krakatoa/jre
#JVPHOME $INFORMIXDIR/extend/krakatoa
JVPPROPFILE /opt/informix/extend/krakatoa/.jvpprops
#JDKVERSION 1.5
JVPLOGFILE /opt/informix/tmp/jvp.log
#JVPJAVALIB /bin/j9vm
#JVPJAVAVM jvm
#JVPARGS -verbose:jni
#JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar

JVPCLASSPATH /opt/informix/extend/krakatoa/krakatoa.jar:/opt/informix/extend/krakatoa/jdbc.jar

BUFFERPOOL default,buffers=1000,lrus=15,lru_min_dirty=50.00,lru_max_dirty=60.00
BUFFERPOOL size=2K,buffers=500000,lrus=60,lru_min_dirty=50.00,lru_max_dirty=60.00
BUFFERPOOL size=16K,buffers=500000,lrus=60,lru_min_dirty=50.00,lru_max_dirty=60.00
AUTO_LRU_TUNING 0
DBSERVERALIASES
NUMFDSERVERS 4
USTLOW_SAMPLE 0
ADMIN_MODE_USERS
SQL_LOGICAL_CHAR off
SEQ_CACHE_SIZE 10
SDS_LOGCHECK 0
DELAY_APPLY
STOP_APPLY
LOG_STAGING_DIR
RSS_FLOW_CONTROL
REMOTE_SERVER_CFG
REMOTE_USERS_CFG
S6_USE_REMOTE_SERVER_CFG 0
LOW_MEMORY_RESERVE
LOW_MEMORY_MGR 0
GSKIT_VERSION 0x8
JVPARGS
DBUPSPACE 0:50

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.