Checkpoints statistics
Hello Users,
We are using IDS 12.10 FC8 DB server,
Application is developed in Java and app server is JBOSS
Our application is taking long time to save the data into database trhough
application.
Find the online log details below:
09:23:22 Checkpoint Completed: duration was 0 seconds.
09:23:22 Mon Jan 22 - loguniq 401, logpos 0x4f9b018, timestamp: 0x7149beaf
Interval: 2987
09:23:22 Maximum server connections 46
09:23:22 Checkpoint Statistics - Avg. Txn Block Time 0.009, # Txns blocked 2,
Plog used 6450, Llog used 20509
10:28:32 Dynamically added 1 cpu VP
10:28:33 ** AUTO TUNING - Added CPU VP.
10:33:45 Checkpoint Completed: duration was 3 seconds.
10:33:46 Mon Jan 22 - loguniq 401, logpos 0x95a4b44, timestamp: 0x715ac4ce
Interval: 2988
10:33:46 Maximum server connections 87
10:33:46 Checkpoint Statistics - Avg. Txn Block Time 101.278, # Txns blocked
2, Plog used 7947, Llog used 17968
11:30:05 Checkpoint Completed: duration was 7 seconds.
11:30:05 Mon Jan 22 - loguniq 401, logpos 0xdbf7018, timestamp: 0x7167f105
Interval: 2989
11:30:05 Maximum server connections 126
11:30:05 Checkpoint Statistics - Avg. Txn Block Time 112.880, # Txns blocked
9, Plog used 7876, Llog used 18032
if you can find the Checkpoint Statistics, the Avg. Txn Block Time is 101.278
and 112.880
Why it is blocking the transactions for more time, what is the scenario to
find the root cause for this.
Please help on this.
output for onstat -p
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 16:39:54
-- 4395776 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
71044170 426052077 2775484776 97.50 1676165 3794823 545281140 99.98
isamtot open start read write rewrite delete commit rollbk
1989899613 16477171 4937867 323514127 268245332 28009 4239 39738 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
309214 2843 30420 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 32975.28 5837.82 3 8
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
16137531 15013 193865471 0 0 17 212315 418930
ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
62341090 490835 6950466 0 45516580 5635212
Hello.
What kind of cluster do you have? HDR? SDS? RSS? Seems you might be facing lag
on primary because of misconfigured cluster.
Is this a new installation, or an old one? Was it recently upgraded?
Please send us some outputs:
1) onstat -g cluster
2) onstat -c
What is your operational system (complete version number and name please)
That would clear up some things for us to help you.
Best regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Informix on Cloud - Database Administrator - 2017
IBM dashDB Managed Service for Analytics and Transactions - 2017
DB2 Advanced DBA - v10.5 for LUW
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
Informix independent consultant
________________________________
De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de MUKESH TANUKU
<mukeshbt1328@gmail.com>
Enviado: segunda-feira, 22 de janeiro de 2018 07:34
Para: ids@iiug.org
Assunto: Checkpoints statistics [40531]
Hello Users,
We are using IDS 12.10 FC8 DB server,
Application is developed in Java and app server is JBOSS
Our application is taking long time to save the data into database trhough
application.
Find the online log details below:
09:23:22 Checkpoint Completed: duration was 0 seconds.
09:23:22 Mon Jan 22 - loguniq 401, logpos 0x4f9b018, timestamp: 0x7149beaf
Interval: 2987
09:23:22 Maximum server connections 46
09:23:22 Checkpoint Statistics - Avg. Txn Block Time 0.009, # Txns blocked 2,
Plog used 6450, Llog used 20509
10:28:32 Dynamically added 1 cpu VP
10:28:33 ** AUTO TUNING - Added CPU VP.
10:33:45 Checkpoint Completed: duration was 3 seconds.
10:33:46 Mon Jan 22 - loguniq 401, logpos 0x95a4b44, timestamp: 0x715ac4ce
Interval: 2988
10:33:46 Maximum server connections 87
10:33:46 Checkpoint Statistics - Avg. Txn Block Time 101.278, # Txns blocked
2, Plog used 7947, Llog used 17968
11:30:05 Checkpoint Completed: duration was 7 seconds.
11:30:05 Mon Jan 22 - loguniq 401, logpos 0xdbf7018, timestamp: 0x7167f105
Interval: 2989
11:30:05 Maximum server connections 126
11:30:05 Checkpoint Statistics - Avg. Txn Block Time 112.880, # Txns blocked
9, Plog used 7876, Llog used 18032
if you can find the Checkpoint Statistics, the Avg. Txn Block Time is 101.278
and 112.880
Why it is blocking the transactions for more time, what is the scenario to
find the root cause for this.
Please help on this.
output for onstat -p
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 16:39:54
-- 4395776 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
71044170 426052077 2775484776 97.50 1676165 3794823 545281140 99.98
isamtot open start read write rewrite delete commit rollbk
1989899613 16477171 4937867 323514127 268245332 28009 4239 39738 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
309214 2843 30420 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 32975.28 5837.82 3 8
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
16137531 15013 193865471 0 0 17 212315 418930
ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
62341090 490835 6950466 0 45516580 5635212
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Please find the below information
Operating system: Windows 2012 R2
Cluster is HDR
onstat -g cluster
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 1 days
12:34:42 -- 4657920 Kbytes
Primary Server:primary
Current Log Page:404,33591
Index page logging status: Disabled
Server ACKed Log Applied Log Supports Status
(log, page) (log, page) Updates
hdr_secondary 404,33591 404,33590 No ASYNC(HDR),Connected,On
onstat -g cfg
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 1 days
12:46:24 -- 4657920 Kbytes
Configuration Parameter List
name current value
ROOTNAME rootdbs
ROOTPATH D:\\\\Informix\\\\storage\\\\rootdbs.000
ROOTOFFSET 0
ROOTSIZE 585728MIRROR 0
MIRRORPATH
MIRROROFFSET 0
DBSERVERNAME primary
DBSERVERALIASES
SERVERNUM 0
MSGPATH D:\\\\Informix\\\\online.log
CONSOLE D:\\\\Informix\\\\ol_informix1210.con
TAPEDEV D:\\\\Informix\\\\backups
TAPESIZE 0
TAPEBLK 16
LTAPEDEV D:\\\\Informix\\\\backups
LTAPESIZE 0
LTAPEBLK 16
PHYSFILE 2013308
PHYSBUFF 512
LOGFILES 70
LOGSIZE 56832
LOGBUFF 256
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
DEADLOCK_TIMEOUT 60
RESIDENT 0
LOCKS 40000
ONDBSPACEDOWN 2
CLEANERS 2
SHMBASE 0x80000000
CKPTINTVL 300
TXTIMEOUT 300
RA_PAGES
FILLFACTOR 90
DBSPACETEMP tmpdbspace
OFF_RECVRY_THREADS 72
ON_RECVRY_THREADS 2
DATASKIP off
HETERO_COMMIT 0
SYSALARMPROGRAM D:\\\\Informix/etc/evidence.bat
TBLSPACE_STATS 1
RESTARTABLE_RESTORE 1
DEF_TABLE_LOCKMODE row
PLOG_OVERFLOW_PATH D:\\\\Informix/tmp
MAX_FILL_DATA_PAGES 0
TBLTBLFIRST 1000
TBLTBLNEXT 200BUFFERPOOL default,memory=auto
BUFFERPOOL size=4K,memory=512000
BUFFERPOOL size=8K,memory=auto
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=med
DISABLE_B162428_XA_FIX 0
RTO_SERVER_RESTART 60
RAS_PLOG_SPEED 336
RAS_LLOG_SPEED 0
AUTO_TUNE 2
AUTO_TUNE_SERVER_SIZE LARGE
AUTO_LLOG 1,llog,1024000
AUTO_LRU_TUNING 1AUTO_CKPTS 1
AUTO_AIOVPS 1
USELASTCOMMITTED NONE
LOG_INDEX_BUILDS 0
BATCHEDREAD_INDEX 1
BATCHEDREAD_TABLE 1
BACKUP_FILTER
RESTORE_FILTER
STORAGE_FULL_ALARM 600,3
CONVERSION_GUARD 2
RESTORE_POINT_DIR D:\\\\Informix\\\\tmp
SB_CHECK_FOR_TEMP 0
SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30PN_STAGEBLOB_THRESHOLD 0
FULL_DISK_INIT 0
AUTO_READAHEAD 1,128SESSION_LIMIT_LOCKS 0
SESSION_LIMIT_MEMORY 0
SESSION_LIMIT_TEMPSPACE 0
SESSION_LIMIT_LOGSPACE 0
SESSION_LIMIT_TXN_TIME 0
TENANT_LIMIT_SPACE 0
TENANT_LIMIT_MEMORY 0
TENANT_LIMIT_CONNECTIONS 0
UNSECURE_ONSTAT 0
IFX_XA_UNIQUEXID_IN_DATABASE 0DISK_ENCRYPTION
SINGLE_CPU_VP 1
SHMVIRTSIZE 105472
USEOSTIME 0
QSTATS 0
WSTATS 0
MULTIPROCESSOR 1
STACKSIZE 64PAM_STACKSIZE 32
DUMPSHMEM 2
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
DUMPDIR D:\\\\Informix\\\\tmp
ALRM_ALL_EVENTS 0
SHMADD 2097152
SHMTOTAL 0
ALARMPROGRAM D:\\\\Informix\\\\etc\\\\alarmprogram.bat
VPCLASS cpu,num=1,noage
BLOCKTIMEOUT 3600
VP_MEMORY_CACHE_KB 0
EXTSHMADD 8192
SHMVIRT_ALLOCSEG 0,3
DIRECT_IO 0
SHMNOACCESS
MSG_DATE 0LIMITNUMSESSIONS 0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
PRELOAD_DLL_FILE
SBSPACENAME sbspace1
SYSSBSPACENAME
SBSPACETEMP tmpsbspace
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_QHDR_DBSPACE rootdbs
CDR_NIFCOMPRESS 0
CDR_QDATA_SBSPACE
CDR_SERIAL 0
CDR_DBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_DELAY_PURGE_DTC 0
CDR_APPLY 24,96
CDR_SUPPRESS_ATSRISWARN
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0KB
CDR_MAX_FLUSH_SIZE 50CDR_TSINSTANCEID 0
CDR_MEM 0
SHARD_MEM 0
SHARD_ID 0
DRAUTO 3
DRINTERVAL 0
DRTIMEOUT 30
DRLOSTFOUND D:\\\\Informix\\\\etc\\\\dr.lostfound
DRIDXAUTO 1
HDR_TXN_SCOPE NEAR_SYNC
SDS_ENABLE 0
SDS_TEMPDBS
ifx_sds_tmpdbs_ol_informix1210,D:\\\\Informix\\\\storage/ifx_sds_tmpdbs_ol_informix121
0,4,0,204800
SDS_PAGING
D:\\\\Informix\\\\storage/ifx_sds_paging1_ol_informix1210,D:\\\\Informix\\\\storage/ifx_sds_paging2_ol_informix1210
SDS_TIMEOUT 20
HA_ALIAS
HA_FOC_ORDER HDR
FAILOVER_CALLBACK
UPDATABLE_SECONDARY 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
FAILOVER_TX_TIMEOUT 0
ENABLE_SNAPSHOT_COPY 0
RSS_FLOW_CONTROL 0
SDS_FLOW_CONTROL 0
SDS_LOGCHECK 0
GRIDCOPY_DIR D:\\\\Informix
SDS_ALTERNATE NONE
SMX_PING_INTERVAL 10
SMX_PING_RETRY 6
CLUSTER_TXN_SCOPE SERVER
DD_HASHSIZE 31
DD_HASHMAX 10
PC_HASHSIZE 31
PC_POOLSIZE 127
DS_HASHSIZE 31
DS_POOLSIZE 427
DS_MAX_QUERIES 4
DS_TOTAL_MEMORY 26214400
DS_MAX_SCANS 10
OPTCOMPIND 2
MAX_PDQPRIORITY 100
DIRECTIVES 1
ALLOW_NEWLINE 0
OPT_GOAL -1
STMT_CACHE 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
STMT_CACHE_HITS 0DBCREATE_PERMISSION
SEQ_CACHE_SIZE 10
EXT_DIRECTIVES 0
IFX_EXTEND_ROLE 1
DS_NONPDQ_QUERY_MEM 2048
ONLIDX_MAXMEM 4194303
IFX_FOLDVIEW 1
EXPLAIN_STAT 1
SQLTRACE level=off,ntraces=1000,size=1
PLCY_HASHSIZE 31
PLCY_POOLSIZE 127
USRC_HASHSIZE 31
USRC_POOLSIZE 127
TEMPTAB_NOLOG 1AUTO_REPREPARE 1
SQL_LOGICAL_CHAR OFF
DEFAULTESCCHAR \\\\
AUTO_STAT_MODE 1
STATCHANGE 10
AUTOLOCATE 0
USTLOW_SAMPLE 1
DB_LIBRARY_PATH
MQSERVER
MQCHLLIB
MQCHLTAB
JVPCLASSPATH INFORMIXDIR\\\\extend\\\\krakatoa\\\\jdbc.jar
JVPHOME D:\\\\Informix\\\\extend\\\\krakatoa
JVPLOGFILE D:\\\\Informix\\\\jvp.log
JVPPROPFILE D:\\\\Informix\\\\extend\\\\krakatoa\\\\.jvpprops
JVPJAVAHOME D:\\\\Informix\\\\extend\\\\krakatoa\\\\jre
JVPJAVAVM jvm
JVPJAVALIB \\\\binJVMTHREAD green
JVPDEBUG 0
JVPARGS -Dcom.ibm.tools.attach.enable=no
NETTYPE soctcp,1,150,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
DRDA_COMMBUFFSIZE 64K
FASTPOLL 1
ADMIN_USER_MODE_WITH_DBSA 0
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL
NUMFDSERVERS 4
NS_CACHE host=900,service=900,user=900,group=900
SMX_COMPRESS 1
NET_IO_TIMEOUT_ALARM 0
TLS_VERSION 1.0,1.1,1.2
INFORMIXCONTIME 60
INFORMIXCONRETRY 1ADTMODE 0
ADTPATH /usr/informix/aaodir
ADTSIZE 50000
ADTERR 0
ADTROWS 0
BAR_ACT_LOG D:\\\\Informix\\\\tmp\\\\bar_act.log
BAR_DEBUG_LOG D:\\\\Informix\\\\tmp\\\\bar_dbug.log
BAR_MAX_BACKUP 4
BAR_MAX_RESTORE
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 16
BAR_DEBUG 0
BAR_BSALIB_PATH
BAR_PROGRESS_FREQ 0
BAR_HISTORY 0
BAR_SIZE_FACTOR 0
BAR_IXBAR_PATH
BAR_PERFORMANCE 0
BAR_CKPTSEC_TIMEOUT 16ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
PSM_ACT_LOG D:\\\\Informix\\\\tmp\\\\bar_act.log
PSM_DEBUG_LOG D:\\\\Informix\\\\tmp\\\\bar_dbug.log
PSM_DEBUG 0
PSM_CATALOG_PATH D:\\\\Informix\\\\etc\\\\psm
PSM_DBS_POOL DBSPOOL
PSM_LOG_POOL LOGPOOL
PSM_DEVICE D:\\\\Informix/backups
SECURITY_LOCALCONNECTION 0CHECKALLDOMAINSFORUSER 0
USERMAPPING OFFGSKIT_VERSION 8
REMOTE_SERVER_CFG
REMOTE_USERS_CFG
S6_USE_REMOTE_SERVER_CFG 0
ENCRYPT_CIPHERS
ENCRYPT_MAC medium
ENCRYPT_MACFILE builtin
ENCRYPT_CDR 0
ENCRYPT_HDR 0
ENCRYPT_SWITCH
ENCRYPT_SMX 0
EILSEQ_COMPAT_M
Ok, my friend.
You are running HDR in near sync mode.
Hope your network between both servers have a very low latency, and that you
don't need to failover, since you are not replicating indexes for the
secondary server.
What is the speed of the network link between them? Is it dedicated? LAN or
WAN?
There are also some parameters that could be tuned, if you are facing delays
on the primary server, that might (also) even have external causes (excessive
network connections, excessive IO - not directy related to HDR configurations,
I mean.
Seems you need a complete tuning on your Informix environment, but as you
asked for primary delay, these might help for start.
Hope it helps.
Best regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Informix on Cloud - Database Administrator - 2017
IBM dashDB Managed Service for Analytics and Transactions - 2017
DB2 Advanced DBA - v10.5 for LUW
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
Informix independent consultant
________________________________
De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de MUKESH TANUKU
<mukeshbt1328@gmail.com>
Enviado: terça-feira, 23 de janeiro de 2018 03:18
Para: ids@iiug.org
Assunto: Re: RE: Checkpoints statistics [40535]
Please find the below information
Operating system: Windows 2012 R2
Cluster is HDR
onstat -g cluster
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 1 days
12:34:42 -- 4657920 Kbytes
Primary Server:primary
Current Log Page:404,33591
Index page logging status: Disabled
Server ACKed Log Applied Log Supports Status
(log, page) (log, page) Updates
hdr_secondary 404,33591 404,33590 No ASYNC(HDR),Connected,On
onstat -g cfg
IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 1 days
12:46:24 -- 4657920 Kbytes
Configuration Parameter List
name current value
ROOTNAME rootdbs
ROOTPATH D:\\\\Informix\\\\storage\\\\rootdbs.000
ROOTOFFSET 0
ROOTSIZE 585728MIRROR 0
MIRRORPATH
MIRROROFFSET 0
DBSERVERNAME primary
DBSERVERALIASES
SERVERNUM 0
MSGPATH D:\\\\Informix\\\\online.log
CONSOLE D:\\\\Informix\\\\ol_informix1210.con
TAPEDEV D:\\\\Informix\\\\backups
TAPESIZE 0
TAPEBLK 16
LTAPEDEV D:\\\\Informix\\\\backups
LTAPESIZE 0
LTAPEBLK 16
PHYSFILE 2013308
PHYSBUFF 512
LOGFILES 70
LOGSIZE 56832
LOGBUFF 256
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
DEADLOCK_TIMEOUT 60
RESIDENT 0
LOCKS 40000
ONDBSPACEDOWN 2
CLEANERS 2
SHMBASE 0x80000000
CKPTINTVL 300
TXTIMEOUT 300
RA_PAGES
FILLFACTOR 90
DBSPACETEMP tmpdbspace
OFF_RECVRY_THREADS 72
ON_RECVRY_THREADS 2
DATASKIP off
HETERO_COMMIT 0
SYSALARMPROGRAM D:\\\\Informix/etc/evidence.bat
TBLSPACE_STATS 1
RESTARTABLE_RESTORE 1
DEF_TABLE_LOCKMODE row
PLOG_OVERFLOW_PATH D:\\\\Informix/tmp
MAX_FILL_DATA_PAGES 0
TBLTBLFIRST 1000
TBLTBLNEXT 200BUFFERPOOL default,memory=auto
BUFFERPOOL size=4K,memory=512000
BUFFERPOOL size=8K,memory=auto
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=med
DISABLE_B162428_XA_FIX 0
RTO_SERVER_RESTART 60
RAS_PLOG_SPEED 336
RAS_LLOG_SPEED 0
AUTO_TUNE 2
AUTO_TUNE_SERVER_SIZE LARGE
AUTO_LLOG 1,llog,1024000
AUTO_LRU_TUNING 1AUTO_CKPTS 1
AUTO_AIOVPS 1
USELASTCOMMITTED NONE
LOG_INDEX_BUILDS 0
BATCHEDREAD_INDEX 1
BATCHEDREAD_TABLE 1
BACKUP_FILTER
RESTORE_FILTER
STORAGE_FULL_ALARM 600,3
CONVERSION_GUARD 2
RESTORE_POINT_DIR D:\\\\Informix\\\\tmp
SB_CHECK_FOR_TEMP 0
SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30PN_STAGEBLOB_THRESHOLD 0
FULL_DISK_INIT 0
AUTO_READAHEAD 1,128SESSION_LIMIT_LOCKS 0
SESSION_LIMIT_MEMORY 0
SESSION_LIMIT_TEMPSPACE 0
SESSION_LIMIT_LOGSPACE 0
SESSION_LIMIT_TXN_TIME 0
TENANT_LIMIT_SPACE 0
TENANT_LIMIT_MEMORY 0
TENANT_LIMIT_CONNECTIONS 0
UNSECURE_ONSTAT 0
IFX_XA_UNIQUEXID_IN_DATABASE 0DISK_ENCRYPTION
SINGLE_CPU_VP 1
SHMVIRTSIZE 105472
USEOSTIME 0
QSTATS 0
WSTATS 0
MULTIPROCESSOR 1
STACKSIZE 64PAM_STACKSIZE 32
DUMPSHMEM 2
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1
DUMPDIR D:\\\\Informix\\\\tmp
ALRM_ALL_EVENTS 0
SHMADD 2097152
SHMTOTAL 0
ALARMPROGRAM D:\\\\Informix\\\\etc\\\\alarmprogram.bat
VPCLASS cpu,num=1,noage
BLOCKTIMEOUT 3600
VP_MEMORY_CACHE_KB 0
EXTSHMADD 8192
SHMVIRT_ALLOCSEG 0,3
DIRECT_IO 0
SHMNOACCESS
MSG_DATE 0LIMITNUMSESSIONS 0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0
PRELOAD_DLL_FILE
SBSPACENAME sbspace1
SYSSBSPACENAME
SBSPACETEMP tmpsbspace
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_QHDR_DBSPACE rootdbs
CDR_NIFCOMPRESS 0
CDR_QDATA_SBSPACE
CDR_SERIAL 0
CDR_DBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_DELAY_PURGE_DTC 0
CDR_APPLY 24,96
CDR_SUPPRESS_ATSRISWARN
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0KB
CDR_MAX_FLUSH_SIZE 50CDR_TSINSTANCEID 0
CDR_MEM 0
SHARD_MEM 0
SHARD_ID 0
DRAUTO 3
DRINTERVAL 0
DRTIMEOUT 30
DRLOSTFOUND D:\\\\Informix\\\\etc\\\\dr.lostfound
DRIDXAUTO 1
HDR_TXN_SCOPE NEAR_SYNC
SDS_ENABLE 0
SDS_TEMPDBS
ifx_sds_tmpdbs_ol_informix1210,D:\\\\Informix\\\\storage/ifx_sds_tmpdbs_ol_informix121
0,4,0,204800
SDS_PAGING
D:\\\\Informix\\\\storage/ifx_sds_paging1_ol_informix1210,D:\\\\Informix\\\\storage/ifx_sds_paging2_ol_informix1210
SDS_TIMEOUT 20
HA_ALIAS
HA_FOC_ORDER HDR
FAILOVER_CALLBACK
UPDATABLE_SECONDARY 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
FAILOVER_TX_TIMEOUT 0
ENABLE_SNAPSHOT_COPY 0
RSS_FLOW_CONTROL 0
SDS_FLOW_CONTROL 0
SDS_LOGCHECK 0
GRIDCOPY_DIR D:\\\\Informix
SDS_ALTERNATE NONE
SMX_PING_INTERVAL 10
SMX_PING_RETRY 6
CLUSTER_TXN_SCOPE SERVER
DD_HASHSIZE 31
DD_HASHMAX 10
PC_HASHSIZE 31
PC_POOLSIZE 127
DS_HASHSIZE 31
DS_POOLSIZE 427
DS_MAX_QUERIES 4
DS_TOTAL_MEMORY 26214400
DS_MAX_SCANS 10
OPTCOMPIND 2
MAX_PDQPRIORITY 100
DIRECTIVES 1
ALLOW_NEWLINE 0
OPT_GOAL -1
STMT_CACHE 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
STMT_CACHE_HITS 0DBCREATE_PERMISSION
SEQ_CACHE_SIZE 10
EXT_DIRECTIVES 0
IFX_EXTEND_ROLE 1
DS_NONPDQ_QUERY_MEM 2048
ONLIDX_MAXMEM 4194303
IFX_FOLDVIEW 1
EXPLAIN_STAT 1
SQLTRACE level=off,ntraces=1000,size=1
PLCY_HASHSIZE 31
PLCY_POOLSIZE 127
USRC_HASHSIZE 31
USRC_POOLSIZE 127
TEMPTAB_NOLOG 1AUTO_REPREPARE 1
SQL_LOGICAL_CHAR OFF
DEFAULTESCCHAR \\\\
AUTO_STAT_MODE 1
STATCHANGE 10
AUTOLOCATE 0
USTLOW_SAMPLE 1
DB_LIBRARY_PATH
MQSERVER
MQCHLLIB
MQCHLTAB
JVPCLASSPATH INFORMIXDIR\\\\extend\\\\krakatoa\\\\jdbc.jar
JVPHOME D:\\\\Informix\\\\extend\\\\krakatoa
JVPLOGFILE D:\\\\Informix\\\\jvp.log
JVPPROPFILE D:\\\\Informix\\\\extend\\\\krakatoa\\\\.jvpprops
JVPJAVAHOME D:\\\\Informix\\\\extend\\\\krakatoa\\\\jre
JVPJAVAVM jvm
JVPJAVALIB \\\\binJVMTHREAD green
JVPDEBUG 0
JVPARGS -Dcom.ibm.tools.attach.enable=no
NETTYPE soctcp,1,150,NET
LISTEN_TIMEOUT