IDS Forum

RE: RE: Checkpoints statistics

Posted By: Alexandre Marini
Date: Tuesday, 23 January 2018, at 8:54 a.m.

In Response To: Re: RE: Checkpoints statistics (MUKESH TANUKU)

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 585728
MIRROR 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 200
BUFFERPOOL 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 1
AUTO_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 30
PN_STAGEBLOB_THRESHOLD 0
FULL_DISK_INIT 0
AUTO_READAHEAD 1,128
SESSION_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 0
DISK_ENCRYPTION
SINGLE_CPU_VP 1
SHMVIRTSIZE 105472
USEOSTIME 0
QSTATS 0
WSTATS 0
MULTIPROCESSOR 1
STACKSIZE 64
PAM_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 0
LIMITNUMSESSIONS 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 50
CDR_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_informix1210,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 0
DBCREATE_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 1
AUTO_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 \bin
JVMTHREAD 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 1
ADTMODE 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 16
ISM_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 0
CHECKALLDOMAINSFORUSER 0
USERMAPPING OFF
GSKIT_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_MODE 0
CDR_AUTO_DISCOVER 1
IFXGUARD enable=1,timeout=-1
SMX_NUMPIPES 1

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Checkpoints statistics
  MUKESH TANUKU -- Monday, 22 January 2018, at 4:34 a.m.
  • RE: Checkpoints statistics
    Alexandre Marini -- Monday, 22 January 2018, at 7:12 a.m.
    • Re: RE: Checkpoints statistics
      MUKESH TANUKU -- Tuesday, 23 January 2018, at 12:18 a.m.
      • RE: RE: Checkpoints statistics
        Alexandre Marini -- Tuesday, 23 January 2018, at 8:54 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.