Performance issue after migrate to IDS from Online
After migrating from Informix OnLine 5.20 (32-bit RHEL4/Xen) to IDS 12.10.FC5WE on CentOS 6.7/VMware, a 4GL batch job that looped through a large cursor slowed from ~30s to ~50-60s and caused other terminals to stall, even though the new hardware benchmarked much faster and the same logic rewritten as a stored procedure ran in 4 seconds. Suggestions included checking isolation level (dirty read was already used), running proper UPDATE STATISTICS rather than relying on AUS, verifying extent sizing, and fixing oversized DS_TOTAL_MEMORY/DS_NONPDQ_QUERY_MEM versus SHMVIRTSIZE; onstat output was posted and the memory parameters were lowered, but performance was unchanged. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
(first of all: I post here because IDS has changed but 4GL no.)
Hi All,
After migration, the new virtual server shows a no smooth behavior(I don't
know how to express it in English) when running 4GL database processes.
When we run certain processes, other terminals get stalled for seconds.
Also, a process (we'll call it "malo") that took about 30 seconds, now takes
about 1 minute.
The problem is that all has changed. Nevertheless, before posting here we have
checked that (almost) all is perfect in the platform.
After all kind of optimizations, we reached about a 50sec time.
In a nutshell, the "malo" process iterates through a big cursor, accesing
other tables and doing several for loops.
SET EXPLAIN reports no sequential access at all.
We have (now I don't know if) enough experience tunning Unix/Linux/informix.
All benchmarks show that the new platform is in the worst case, 8 times faster
than old one.
Intense I/O O.S. processes such as copying or managing big files are very fast
and don't cause latency problems to other terminals.
When migrating database, DBLOAD tasks were incredibly fast.
We have replicated the "malo" 4GL program into a stored procedure and it took
4 seconds!
If you just suspect something, please tell me.
Thanks
Antonio
Technical info follows:
--------------------------------------------------------------------------------
Previous platform:
Server: Fujitsu-Siemens RX300S4 8GB RAM 2 sockets 4cores/each
CPUid:1067A@2667MHz
Storage: Fujitsu-Siemens SX80. Two Controllers 1GB cache/each FC4Gb/s
Hypervisor: RHEL5 Xen 3
guest OS: RHEL4 (32bit)
Database: Informix Online 5.20
Tools: 4GL 7.50UC1
--------------------------------------------------------------------------------
New platform:
Server: Fujitsu RX300S8 32GB RAM 2 sockets 6cores/each
CPUid:0306E4@2100MHz(Xeon E5-2620v2)
Storage: Fujitsu DX200S3. Two Controllers 8GB cache/each FC8Gb/s
Hypervisor: VMware ESXi 6.0
guest OS: Centos 6.7 (64bit)
Database: IDS 12.10.FC5WE
Tools: 4GL 7.50.FC6
--------------------------------------------------------------------------------
ONCONFIG: (we have tried hundreds of changes whithout appreciable changes)
--------
ROOTNAME rootdbs
ROOTPATH /apl/dev/trozos/rootdbs
ROOTOFFSET 0
ROOTSIZE 2097152 # 2gbMIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0
PHYSFILE 99894 # 100MB
PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp
PHYSBUFF 512
LOGFILES 100
LOGSIZE 10240
DYNAMIC_LOGS 2
LOGBUFF 256
LTXHWM 50
LTXEHWM 60
MSGPATH /apl/informix/turlo.log # linkak a turbo.log!!
CONSOLE /apl/informix/turbo.con
TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1
SBSPACETEMP
SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 1
SERVERNUM 0
DBSERVERNAME idspina
DBSERVERALIASES lo_informix1210
FULL_DISK_INIT 0
NETTYPE ipcshm,5,50,CPU
NETTYPE soctcp,5,10,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
NUMFDSERVERS 4
NS_CACHE host=900,service=900,user=900,group=900
MULTIPROCESSOR 1
VPCLASS cpu,num=6,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0
AUTO_TUNE 1AUTO_CKPTS 0
CLEANERS 21
DIRECT_IO 1
LOCKS 100000
DEF_TABLE_LOCKMODE row
RESIDENT -1
SHMBASE 0x44000000L
SHMVIRTSIZE 201376
SHMADD 32768
EXTSHMADD 20480
SHMTOTAL 6291456
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS
CKPTINTVL 300
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600
CONVERSION_GUARD 0
RESTORE_POINT_DIR $INFORMIXDIR/tmp
TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0
TAPEDEV /DBLOAD/TRASPASO-DB/backup/c0
TAPEBLK 1024
TAPESIZE 0
LTAPEDEV /apl/dev/cbfolder
LTAPEBLK 1024
LTAPESIZE 0
BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/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 $INFORMIXDIR/lib/libbsapsm.so
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
BAR_CKPTSEC_TIMEOUT 15
PSM_DBS_POOL DBSPOOL
PSM_LOG_POOL LOGPOOL
DD_HASHSIZE 31
DD_HASHMAX 10
DS_HASHSIZE 31
DS_POOLSIZE 127
PC_HASHSIZE 31
PC_POOLSIZE 127
PRELOAD_DLL_FILE
STMT_CACHE 2
STMT_CACHE_HITS 2
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
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 5242880
MAX_PDQPRIORITY 0
DS_MAX_QUERIES 5
DS_TOTAL_MEMORY 26214400
DS_MAX_SCANS 5
DS_NONPDQ_QUERY_MEM 1310720
DATASKIP
OPTCOMPIND 0
DIRECTIVES 1
EXT_DIRECTIVES 2
OPT_GOAL -1
IFX_FOLDVIEW 1
STATCHANGE 0
USTLOW_SAMPLE 1
BATCHEDREAD_TABLE 1
BATCHEDREAD_INDEX 1
EXPLAIN_STAT 1
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL
TLS_VERSION
PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31
SQL_LOGICAL_CHAR OFF
SEQ_CACHE_SIZE 10
ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_SUPPRESS_ATSRISWARN
CDR_DELAY_PURGE_DTC 0
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0
CDR_MAX_DYNAMIC_LOGS 0GRIDCOPY_DIR $INFORMIXDIR
CDR_TSINSTANCEID 0
CDR_MAX_FLUSH_SIZE 50
CDR_AUTO_DISCOVER 0
CDR_MEM 0
DRAUTO 0
DRINTERVAL 0
HDR_TXN_SCOPE NEAR_SYNC
DRTIMEOUT 30
HA_ALIAS
HA_FOC_ORDER SDS,HDR,RSSDRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT 20
SDS_TEMPDBS
SDS_PAGING
SDS_LOGCHECK 10
SDS_ALTERNATE NONE
SDS_FLOW_CONTROL 0
UPDATABLE_SECONDARY 0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT 0
TEMPTAB_NOLOG 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
RSS_FLOW_CONTROL 0
SMX_NUMPIPES 1
ENABLE_SNAPSHOT_COPY 0
SMX_COMPRESS 0
SMX_PING_INTERVAL 10
SMX_PING_RETRY 6
CLUSTER_TXN_SCOPE SERVER
ON_RECVRY_THREADS 2
OFF_RECVRY_THREADS 5
DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh
RAS_PLOG_SPEED 132717
RAS_LLOG_SPEED 5333
EILSEQ_COMPAT_MODE 0
QSTATS 0
WSTATS 0
USERMAPPING OFF
SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30
AUTOLOCATE 0
DEFAULTESCCHAR \\\\
MQSERVER
MQCHLLIB
MQCHLTAB
REMOTE_SERVER_CFG
REMOTE_USERS_CFG
S6_USE_REMOTE_SERVER_CFG 0
LOW_MEMORY_RESERVE 0
LOW_MEMORY_MGR 0GSKIT_VERSION
INFORMIXCONTIME 60
INFORMIXCONRETRY 1
JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE $INFORMIXDIR/tmp/jvp.log
JVPARGS -Dcom.ibm.tools.attach.enable=noJ
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px
#715FFA solid !important; padding-left:1ex !important; background-color:white
!important; } I suspect repeatable reads.
Sent from Yahoo Mail for iPad
On Friday, October 23, 2015, 8:53 AM, ANTONIO DIAZ <> wrote:
(first of all: I post here because IDS has changed but 4GL no.)
Hi All,
After migration, the new virtual server shows a no smooth behavior(I don't
know how to express it in English) when running 4GL database processes.
When we run certain processes, other terminals get stalled for seconds.
Also, a process (we'll call it "malo") that took about 30 seconds, now takes
about 1 minute.
The problem is that all has changed. Nevertheless, before posting here we have
checked that (almost) all is perfect in the platform.
After all kind of optimizations, we reached about a 50sec time.
In a nutshell, the "malo" process iterates through a big cursor, accesing
other tables and doing several for loops.
SET EXPLAIN reports no sequential access at all.
We have (now I don't know if) enough experience tunning Unix/Linux/informix.
All benchmarks show that the new platform is in the worst case, 8 times faster
than old one.
Intense I/O O.S. processes such as copying or managing big files are very fast
and don't cause latency problems to other terminals.
When migrating database, DBLOAD tasks were incredibly fast.
We have replicated the "malo" 4GL program into a stored procedure and it took
4 seconds!
If you just suspect something, please tell me.
Thanks
Antonio
Technical info follows:
--------------------------------------------------------------------------------
Previous platform:
Server: Fujitsu-Siemens RX300S4 8GB RAM 2 sockets 4cores/each
CPUid:1067A@2667MHz
Storage: Fujitsu-Siemens SX80. Two Controllers 1GB cache/each FC4Gb/s
Hypervisor: RHEL5 Xen 3
guest OS: RHEL4 (32bit)
Database: Informix Online 5.20
Tools: 4GL 7.50UC1
--------------------------------------------------------------------------------
New platform:
Server: Fujitsu RX300S8 32GB RAM 2 sockets 6cores/each
CPUid:0306E4@2100MHz(Xeon E5-2620v2)
Storage: Fujitsu DX200S3. Two Controllers 8GB cache/each FC8Gb/s
Hypervisor: VMware ESXi 6.0
guest OS: Centos 6.7 (64bit)
Database: IDS 12.10.FC5WE
Tools: 4GL 7.50.FC6
--------------------------------------------------------------------------------
ONCONFIG: (we have tried hundreds of changes whithout appreciable changes)
--------
ROOTNAME rootdbs
ROOTPATH /apl/dev/trozos/rootdbs
ROOTOFFSET 0
ROOTSIZE 2097152 # 2gbMIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0
PHYSFILE 99894 # 100MB
PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp
PHYSBUFF 512
LOGFILES 100
LOGSIZE 10240
DYNAMIC_LOGS 2
LOGBUFF 256
LTXHWM 50
LTXEHWM 60
MSGPATH /apl/informix/turlo.log # linkak a turbo.log!!
CONSOLE /apl/informix/turbo.con
TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1
SBSPACETEMP
SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 1
SERVERNUM 0
DBSERVERNAME idspina
DBSERVERALIASES lo_informix1210
FULL_DISK_INIT 0
NETTYPE ipcshm,5,50,CPU
NETTYPE soctcp,5,10,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
NUMFDSERVERS 4
NS_CACHE host=900,service=900,user=900,group=900
MULTIPROCESSOR 1
VPCLASS cpu,num=6,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0
AUTO_TUNE 1AUTO_CKPTS 0
CLEANERS 21
DIRECT_IO 1
LOCKS 100000
DEF_TABLE_LOCKMODE row
RESIDENT -1
SHMBASE 0x44000000L
SHMVIRTSIZE 201376
SHMADD 32768
EXTSHMADD 20480
SHMTOTAL 6291456
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS
CKPTINTVL 300
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600
CONVERSION_GUARD 0
RESTORE_POINT_DIR $INFORMIXDIR/tmp
TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0
TAPEDEV /DBLOAD/TRASPASO-DB/backup/c0
TAPEBLK 1024
TAPESIZE 0
LTAPEDEV /apl/dev/cbfolder
LTAPEBLK 1024
LTAPESIZE 0
BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/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 $INFORMIXDIR/lib/libbsapsm.so
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
BAR_CKPTSEC_TIMEOUT 15
PSM_DBS_POOL DBSPOOL
PSM_LOG_POOL LOGPOOL
DD_HASHSIZE 31
DD_HASHMAX 10
DS_HASHSIZE 31
DS_POOLSIZE 127
PC_HASHSIZE 31
PC_POOLSIZE 127
PRELOAD_DLL_FILE
STMT_CACHE 2
STMT_CACHE_HITS 2
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1
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 5242880
MAX_PDQPRIORITY 0
DS_MAX_QUERIES 5
DS_TOTAL_MEMORY 26214400
DS_MAX_SCANS 5
DS_NONPDQ_QUERY_MEM 1310720
DATASKIP
OPTCOMPIND 0
DIRECTIVES 1
EXT_DIRECTIVES 2
OPT_GOAL -1
IFX_FOLDVIEW 1
STATCHANGE 0
USTLOW_SAMPLE 1
BATCHEDREAD_TABLE 1
BATCHEDREAD_INDEX 1
EXPLAIN_STAT 1
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL
TLS_VERSION
PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31
SQL_LOGICAL_CHAR OFF
SEQ_CACHE_SIZE 10
ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_SUPPRESS_ATSRISWARN
CDR_DELAY_PURGE_DTC 0
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0
CDR_MAX_DYNAMIC_LOGS 0GRIDCOPY_DIR $INFORMIXDIR
CDR_TSINSTANCEID 0
CDR_MAX_FLUSH_SIZE 50
CDR_AUTO_DISCOVER 0
CDR_MEM 0
DRAUTO 0
DRINTERVAL 0
HDR_TXN_SCOPE NEAR_SYNC
DRTIMEOUT 30
HA_ALIAS
HA_FOC_ORDER SDS,HDR,RSSDRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT 20
SDS_TEMPDBS
SDS_PAGING
SDS_LOGCHECK 10
SDS_ALTERNATE NONE
SDS_FLOW_CONTROL 0
UPDATABLE_SECONDARY 0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT 0
TEMPTAB_NOLOG 0
DELAY_APPLY 0
STOP_APPLY 0
LOG_STAGING_DIR
RSS_FLOW_CONTROL 0
SMX_NUMPIPES 1
ENABLE_SNAPSHOT_COPY 0
SMX_COMPRESS 0
SMX_PING_INTERVAL 10
SMX_PING_RETRY 6
CLUSTER_TXN_SCOPE SERVER
ON_RECVRY_THREADS 2
OFF_RECVRY_THREADS 5
DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh
RAS_PLOG_SPEED 132717
RAS_LLOG_SPEED 5333
EILSEQ_COMPAT_MODE 0
QSTATS 0
WSTATS 0
USERMAPPING OFF
SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30
AUTOLOCATE 0
DEFAULTESCCHAR \\\\
MQSERVER
MQCHLLIBMQCH
Questions:
1. After the database was recreated and loaded did you run the
recommended suite of Update Statistics commands as described in the
Performance Guide manual (or as implemented by my dostats utility) or are
you depending on Auto Update Statistics (AUS)?
2. So, you mention using dbload to reload the data from the source
server. I assume that you manually recreated the database using a dbschema
output from online. Did you use -ss when you ran the dbschema? Did you
adjust the EXTENT SIZE and NEXT SIZE settings documented for the tables to
take account of the size of the tables at the point they were exported?
Requests:
Post the performance stats listed below and we'll see if we can help:
1. Post the output from:
onstat -d
onstat -p
onstat -g glo
onstat -g iov
onstat -g iof
2. Post the output from:
select first 50 dbsname, tabname, count(*), sum(size)
from sysextents
where dbsname = 'art'
group by 1, 2
order by 3 desc;
FYI: You cannot successfully attach anything to a post to the forum, so
you'll have to copy/paste the output into the body of the posting.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Oct 23, 2015 at 9:52 AM, <> wrote:
> (first of all: I post here because IDS has changed but 4GL no.)
>
> Hi All,
>
> After migration, the new virtual server shows a no smooth behavior(I don't
> know how to express it in English) when running 4GL database processes.
> When we run certain processes, other terminals get stalled for seconds.
> Also, a process (we'll call it "malo") that took about 30 seconds, now
> takes
> about 1 minute.
>
> The problem is that all has changed. Nevertheless, before posting here we
> have
> checked that (almost) all is perfect in the platform.
>
> After all kind of optimizations, we reached about a 50sec time.
>
> In a nutshell, the "malo" process iterates through a big cursor, accesing
> other tables and doing several for loops.
> SET EXPLAIN reports no sequential access at all.>
> We have (now I don't know if) enough experience tunning
> Unix/Linux/informix.
> All benchmarks show that the new platform is in the worst case, 8 times
> faster
> than old one.
> Intense I/O O.S. processes such as copying or managing big files are very
> fast
> and don't cause latency problems to other terminals.
> When migrating database, DBLOAD tasks were incredibly fast.
>
> We have replicated the "malo" 4GL program into a stored procedure and it
> took
> 4 seconds!
>
> If you just suspect something, please tell me.
>
> Thanks
>
> Antonio
>
> Technical info follows:
>
>
>
--------------------------------------------------------------------------------
> Previous platform:
> Server: Fujitsu-Siemens RX300S4 8GB RAM 2 sockets 4cores/each
> CPUid:1067A@2667MHz
> Storage: Fujitsu-Siemens SX80. Two Controllers 1GB cache/each FC4Gb/s
> Hypervisor: RHEL5 Xen 3
> guest OS: RHEL4 (32bit)
> Database: Informix Online 5.20
> Tools: 4GL 7.50UC1
>
>
>
--------------------------------------------------------------------------------
> New platform:
> Server: Fujitsu RX300S8 32GB RAM 2 sockets 6cores/each
> CPUid:0306E4@2100MHz(Xeon E5-2620v2)
> Storage: Fujitsu DX200S3. Two Controllers 8GB cache/each FC8Gb/s
> Hypervisor: VMware ESXi 6.0
> guest OS: Centos 6.7 (64bit)
> Database: IDS 12.10.FC5WE
> Tools: 4GL 7.50.FC6
>
>
>
--------------------------------------------------------------------------------
> ONCONFIG: (we have tried hundreds of changes whithout appreciable changes)
> --------
>
> ROOTNAME rootdbs
> ROOTPATH /apl/dev/trozos/rootdbs
> ROOTOFFSET 0
> ROOTSIZE 2097152 # 2gb> MIRROR 0
> MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
> MIRROROFFSET 0
> PHYSFILE 99894 # 100MB
> PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp
> PHYSBUFF 512
> LOGFILES 100
> LOGSIZE 10240
> DYNAMIC_LOGS 2
> LOGBUFF 256
> LTXHWM 50
> LTXEHWM 60
> MSGPATH /apl/informix/turlo.log # linkak a turbo.log!!
> CONSOLE /apl/informix/turbo.con
> TBLTBLFIRST 0
> TBLTBLNEXT 0
> TBLSPACE_STATS 1
> SBSPACETEMP
> SBSPACENAME
> SYSSBSPACENAME
> ONDBSPACEDOWN 1
> SERVERNUM 0
> DBSERVERNAME idspina
> DBSERVERALIASES lo_informix1210
> FULL_DISK_INIT 0
> NETTYPE ipcshm,5,50,CPU
> NETTYPE soctcp,5,10,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1
> NUMFDSERVERS 4
> NS_CACHE host=900,service=900,user=900,group=900
> MULTIPROCESSOR 1
> VPCLASS cpu,num=6,noage
> VP_MEMORY_CACHE_KB 0
> SINGLE_CPU_VP 0
> AUTO_TUNE 1> AUTO_CKPTS 0
> CLEANERS 21
> DIRECT_IO 1
> LOCKS 100000
> DEF_TABLE_LOCKMODE row
> RESIDENT -1
> SHMBASE 0x44000000L
> SHMVIRTSIZE 201376
> SHMADD 32768
> EXTSHMADD 20480
> SHMTOTAL 6291456
> SHMVIRT_ALLOCSEG 0,3
> SHMNOACCESS
> CKPTINTVL 300
> RTO_SERVER_RESTART 0
> BLOCKTIMEOUT 3600
> CONVERSION_GUARD 0
> RESTORE_POINT_DIR $INFORMIXDIR/tmp
> TXTIMEOUT 300
> DEADLOCK_TIMEOUT 60
> HETERO_COMMIT 0
> TAPEDEV /DBLOAD/TRASPASO-DB/backup/c0
> TAPEBLK 1024
> TAPESIZE 0
> LTAPEDEV /apl/dev/cbfolder
> LTAPEBLK 1024
> LTAPESIZE 0
> BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
> BAR_DEBUG_LOG $INFORMIXDIR/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 $INFORMIXDIR/lib/libbsapsm.so
> BACKUP_FILTER
> RESTORE_FILTER
> BAR_PERFORMANCE 0
> BAR_CKPTSEC_TIMEOUT 15
> PSM_DBS_POOL DBSPOOL
> PSM_LOG_POOL LOGPOOL
> DD_HASHSIZE 31
> DD_HASHMAX 10
> DS_HASHSIZE 31
> DS_POOLSIZE 127
> PC_HASHSIZE 31
> PC_POOLSIZE 127
> PRELOAD_DLL_FILE
> STMT_CACHE 2
> STMT_CACHE_HITS 2
> STMT_CACHE_SIZE 512
> STMT_CACHE_NOLIMIT 0
> STMT_CACHE_NUMPOOL 1
> 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 5242880
> MAX_PDQPRIORITY 0
> DS_MAX_QUERIES 5
> DS_TOTAL_MEMORY 26214400
> DS_MAX_SCANS 5
> DS_NONPDQ_QUERY_MEM 1310720
> DATASKIP
> OPTCOMPIND 0
> DIRECTIVES 1
> EXT_DIRECTIVES 2
> OPT_GOAL -1
> IFX_FOLDVIEW 1
> STATCHANGE 0
> USTLOW_SAMPLE 1
> BATCHEDREAD_TABLE 1
> BATCHEDREAD_INDEX 1
> EXPLAIN_STAT 1
> IFX_EXTEND_ROLE 1
> SECURITY_L
Hi Madison. Thanks for your answer. We always use the "dirty read" isolation level. Moreover, we run the "malo" program whith no other users logged in the system.
Hi Art. Thanks for answering.
1. We are using AUS, but Statistics seems to be working well.
(you can see the info at very bottom)
2. I think Informix Online's dbaccess doesn't have the -ss option.
Nevertheless we have a script that modifies the original database schema file
adding dbspace and size info previously configured.
All tables are well sized. There are just 7 tables (of several hundreds) whith
more than 1 extent. There is only one table which exceeds 3 extents.
OUTPUTS
==========================================================================
[informix@lpsrvexplo ~]$ onstat -d
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 01:23:51 --2525184 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
45aa1028 1 0x40001 1 1 2048 N B informix rootdbs
482f73f8 2 0x40001 2 1 2048 N B informix logsdbs
482f7628 4 0x42001 4 1 2048 N TB informix tmp1dbs
482f7858 5 0x42001 5 1 2048 N TB informix tmp2dbs
482f7a88 6 0x42001 6 1 2048 N TB informix tmp3dbs
482f7cb8 7 0x40001 7 10 2048 N B informix dbs_1
482f8028 8 0x40001 8 10 2048 N B informix dbs_2
482f8258 9 0x40001 9 10 2048 N B informix dbs_3
482f8488 10 0x40001 10 10 2048 N B informix dbs_4
482f86b8 11 0x1040001 47 1 2048 N PBA informix physlog2gb
10 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
45aa1258 1 1 0 1048576 1018531 PO-B-D /apl/dev/trozos/rootdbs
482fa028 2 2 0 1572864 1060811 PO-B-D /apl/dev/trozos/logsdbs
482fb028 4 4 0 86016 85963 PO-B-- /apl/dev/trozos/tmp1dbs
482fc028 5 5 0 86016 85963 PO-B-- /apl/dev/trozos/tmp2dbs
482fd028 6 6 0 83968 83915 PO-B-- /apl/dev/trozos/tmp3dbs
482fe028 7 7 0 2097152 1040 PO-B-D /apl/dev/trozos/dbs_1.0
482ff028 8 8 0 2097152 50269 PO-B-D /apl/dev/trozos/dbs_2.0
48300028 9 9 0 2097152 0 PO-B-D /apl/dev/trozos/dbs_3.0
48301028 10 10 0 2097152 0 PO-B-D /apl/dev/trozos/dbs_4.0
48302028 11 7 0 2097152 329 PO-B-D /apl/dev/trozos/dbs_1.1
48303028 12 7 0 2097152 0 PO-B-D /apl/dev/trozos/dbs_1.2
48304028 13 7 0 2097152 1199 PO-B-D /apl/dev/trozos/dbs_1.3
48305028 14 7 0 2097152 502 PO-B-D /apl/dev/trozos/dbs_1.4
48306028 15 7 0 2097152 184 PO-B-D /apl/dev/trozos/dbs_1.5
48307028 16 7 0 2097152 17604 PO-B-D /apl/dev/trozos/dbs_1.6
48308028 17 7 0 2097152 510373 PO-B-D /apl/dev/trozos/dbs_1.7
48309028 18 7 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_1.8
4830a028 19 7 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_1.9
4830b028 20 8 0 2097152 420 PO-B-D /apl/dev/trozos/dbs_2.1
4830c028 21 8 0 2097152 677 PO-B-D /apl/dev/trozos/dbs_2.2
4830d028 22 8 0 2097152 34818 PO-B-D /apl/dev/trozos/dbs_2.3
4830e028 23 8 0 2097152 18014 PO-B-D /apl/dev/trozos/dbs_2.4
4830f028 24 8 0 2097152 2595 PO-B-D /apl/dev/trozos/dbs_2.5
48310028 25 8 0 2097152 1800149 PO-B-D /apl/dev/trozos/dbs_2.6
48311028 26 8 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_2.7
48312028 27 8 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_2.8
48313028 28 8 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_2.9
48314028 29 9 0 2097152 2 PO-B-D /apl/dev/trozos/dbs_3.1
48315028 30 9 0 2097152 0 PO-B-D /apl/dev/trozos/dbs_3.2
48316028 31 9 0 2097152 15839 PO-B-D /apl/dev/trozos/dbs_3.3
48317028 32 9 0 2097152 2025090 PO-B-D /apl/dev/trozos/dbs_3.4
48318028 33 9 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_3.5
48319028 34 9 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_3.6
4831a028 35 9 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_3.7
4831b028 36 9 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_3.8
4831c028 37 9 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_3.9
4831d028 38 10 0 2097152 37 PO-B-D /apl/dev/trozos/dbs_4.1
4831e028 39 10 0 2097152 0 PO-B-D /apl/dev/trozos/dbs_4.2
4831f028 40 10 0 2097152 149435 PO-B-D /apl/dev/trozos/dbs_4.3
48320028 41 10 0 2097152 25722 PO-B-D /apl/dev/trozos/dbs_4.4
48321028 42 10 0 2097152 1454292 PO-B-D /apl/dev/trozos/dbs_4.5
48322028 43 10 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_4.6
48323028 44 10 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_4.7
48324028 45 10 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_4.8
48325028 46 10 0 2097152 2097149 PO-B-D /apl/dev/trozos/dbs_4.9
48326028 47 11 0 1048576 0 PO-BED /apl/dev/trozos/PHYSLOG2GB
46 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
==========================================================================
[informix@lpsrvexplo ~]$ onstat -p
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 01:26:35 --2525184 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
29168 33542 6027505 99.52 956 1359 856898 99.89
isamtot open start read write rewrite delete commit rollbk
21990935 2897513 1006506 2175866 436348 103 13 849 0
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 203.54 69.50 11 11
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
342 0 1243079 0 0 0 440 712
ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
51926 1414 635 2 14149 1250
==========================================================================
[informix@lpsrvexplo ~]$ onstat -g glo
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 01:28:12 --2525184 Kbytes
MT global info:
sessions threads vps lngspins time
1 55 17 0 5291
sched calls thread switches yield 0 yield n yield forever
total: 6280527 4150963 2130602 143946 52694
per sec: 17319 17292 30 36 7
Virtual processor summary:
class vps usercpu syscpu total
cpu 6 254.77 48.40 303.17
aio 1 0.01 0.05 0.06
lio 1 0.00 0.04 0.04
pio 1 0.01 0.04 0.05
adm 1 0.10 0.29 0.39
soc 5 10.29 42.38 52.67
msc 1 0.00 0.00 0.00
fifo 1 0.01 0.03 0.04
total 17 265.19 91.23 356.42
Individual virtual processors:
vp pid class usercpu syscpu total Thread Eff
1 3891 cpu 82.96 16.38 99.34 99.34 100%
2 3893 adm 0.10 0.29 0.39 0.00 0%
3 3894 lio 0.00 0.04 0.04 0.04 100%
4 3895 pio 0.01 0.04 0.05 0.05 100%
5 3896 aio 0.01 0.05 0.06 0.54 11%
6 3897 msc 0.00 0.00 0.00 0.01 0%
7 3898 fifo 0.01 0.03 0.04 0.04 100%
8 3899 cpu 76.52 13.71 90.23 90.23 100%
9 3900 cpu 46.33 8.51 54.84 54.84 100%
10 3901 cpu 31.64 6.14 37.78 37.78 100%
11 3902 cpu 4.39 0.90 5.29 5.29 100%
12 3903 cpu 12.93 2.76 15.69 15.69 100%
13 3904 soc 6.16 25.78 31.94 NA NA
14 3905 soc 3.41 15.78 19.19 NA NA
15 3906 soc 0.25 0.31 0.56 NA NA
16 3907 soc 0.22 0.27 0.49 NA NA
17 3908 soc 0.25 0.24 0.49 NA NA
tot 265.19 91.23 356.42
==========================================================================
[informix@lpsrvexplo ~]$ onstat -g iov
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 01:28:57 --2525184 Kbytes
AIO I/O vps:
class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
tempops
fifo 7 0 i 0.0 0 0 0 0 1 0.0 0 0
kio -1 0 i 1.1 6051 5936 115 0 10635 0.6 0 0
kio -1 1 i 1.3 6890 6722 168 0 12277 0.6 0 0
kio -1 2 i 0.7 3981 3911 70 0 6627 0.6 0 0
kio -1 3 i 0.4 2301
Oops!
I mean dbschema instead of dbaccess in point 2.
Hi,
I looked through all your onstats. Some observations:
1. The values used for DS_TOTAL_MEMORY and DS_NONPDQ_QUERY_MEM are way too
high.
SHMVIRTSIZE 201376
DS_TOTAL_MEMORY 26214400
DS_NONPDQ_QUERY_MEM 131072016GB RAM
So that's just under 200 Mb for SHMVIRTSIZE but 26 Gb for DS_TOTAL_MEMORY on a
16 Gb server? I am actually not sure if this is possible since DS_TOTAL_MEMORY
should fit into SHMVIRTSIZE and DS_NONPDQ_QUERY_MEM should be only 25% of
DS_TOTAL_MEMORY. Is the engine ignoring these parameters?
2. I can see most of your I/O takes place in rootdbs.
3. I looked through the sqexplain output and couldn't see any remotely costly
queries. Are those the queries with poor performance? If not, could you post a
"set explain statistics" for that query? Is the poor performance repeatable or
just with a cold buffer cache?
4. 'onstat -g ppf' would be useful.
Ben.
Hi,
1. I think that IDS Workgroup Edition doesn't support PDQ or DSS. The IDS
installer set up that parameters. Maybe my virtual machine had 32GB RAM when I
installed ids.
Please tell me if I am wrong.
I have not set any parameters that looks like PDQ or DS related.
I saw the warnings starting IDS, but as the engine adjusted values
​​and I supposed that was not used, so I left them as it were.
Now, I have adjusted that parameters and posted below. Performance remains the
same.
I suppose the engine is not ignoring these parameters, but adjusting them.
(extracted from instance's log)
| Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
| Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
| Parameter's user-configured value was adjusted. (DS_TOTAL_MEMORY)
2. [I can see most of your I/O takes place in rootdbs.]
I don't know why. The application tables are located in other dbspaces.
I think rootdbs just have system databases. And temp tables, because there is
a bug with temp dbspaces. I created 3 tmp dbspaces but they aren't active.
3. [Are those the queries with poor performance?]
The queries are very simple. They retrieve (not big) records via simple codes.
[If not, could you post a set explain statistics" for that query? ]
Queries aren't complex and slow, but simple ones inside loops.
[Is the poor performance repeatable or just with a cold buffer cache?]
The poor performance repeats even with all data in cache.
Nevertheless the worst thing is not low performance but high latency character
terminals (putty/ssh).
4. ['onstat -g ppf' would be useful.]
onstat -g ppf output was very strange. sysptnbit table (0xe) had 22267085isrd. I have run onstat -z to reset counters and after a while of processing,
I have got the following output:
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 06:26:09 --2525184 Kbytes
Partition profiles
partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc
rhitratio
0x6 0 0 0 0 2 0 0 0 0 0 0 0
0x1a 0 0 0 0 4 0 0 0 0 0 0 0
0x1f 0 0 0 0 6 0 0 0 0 0 0 0
0x27 0 0 0 0 78 0 0 0 0 0 0 0
0x28 0 0 0 0 71 0 0 0 0 0 0 0
0x29 0 0 0 0 7 0 0 0 0 0 0 0
0x2a 0 0 0 0 4 0 0 0 0 0 0 0
0x2f 0 0 0 0 3 0 0 0 0 0 0 0
0x30 0 0 0 0 6 0 0 0 0 0 0 0
0x57 0 0 0 0 6 0 0 0 0 0 0 0
0x58 0 0 0 0 2 0 0 0 0 0 0 0
0x59 0 0 0 0 1 0 0 0 0 0 0 0
0x74 0 0 0 0 2 0 0 0 0 0 0 0
0x99 0 0 0 0 3798 0 0 0 3 0 0 67
0x100001 0 0 0 0 0 0 0 0 709 0 0 100
0x100002 544 0 0 0 207 0 0 0 686 1 3 100
0x100004 3041 0 0 0 2963 0 0 0 6396 0 0 100
0x100005 926 0 0 0 454 0 0 0 1040 0 0 97
0x100006 35 0 0 0 11 0 0 0 62 0 0 86
0x100007 68 0 0 0 39 0 0 0 113 0 0 89
0x100008 9 0 0 0 5 0 0 0 29 0 0 94
0x100009 26 0 0 0 26 0 0 0 84 0 0 86
0x10000a 2 0 0 0 3 0 0 0 6 0 1 50
0x10000e 0 0 0 0 0 0 0 0 18 0 0 95
0x100011 0 0 0 0 0 0 0 0 18 0 0 95
0x100013 12 0 0 0 12 0 0 0 96 0 0 42
0x100014 12 0 0 0 12 0 0 0 32 0 0 85
0x100015 6 0 0 0 2 0 0 0 14 0 0 79
0x100017 0 0 0 0 18 0 0 0 18 0 0 95
0x100018 0 0 0 0 18 0 0 0 18 0 0 95
0x100019 0 0 0 0 0 0 0 0 18 0 0 95
0x10001b 0 0 0 0 0 0 0 0 30 0 0 97
0x10001c 12 0 0 0 0 0 0 0 72 0 0 96
0x10001e 1 0 0 0 1 0 0 0 3 0 0 34
0x100021 0 0 0 0 1 0 0 0 0 0 0 0
0x100024 1 0 0 0 1 0 0 0 4 0 0 25
0x100030 36 0 0 0 24 0 0 0 54 0 0 82
0x100031 0 0 0 0 0 0 0 0 54 0 0 95
0x100033 0 0 0 0 1 0 0 0 0 0 0 0
0x100076 702 0 0 0 370 0 0 0 946 0 2 98
0x100077 623 0 0 0 436 0 0 0 901 0 0 99
0x100078 57 0 0 0 43 0 0 0 95 0 0 90
0x100079 92 0 0 0 56 0 0 0 144 0 0 94
0x10007a 28 0 0 0 15 0 0 0 50 0 0 96
0x10007b 29 0 0 0 29 0 0 0 70 0 0 93
0x10007c 4 0 0 0 5 0 0 0 6 0 1 50
0x100080 29 0 0 0 5 0 0 0 47 0 0 96
0x100081 4 0 0 0 2 0 0 0 6 0 0 67
0x100082 198 0 0 0 97 0 0 0 206 0 0 96
0x100083 54 0 0 0 29 0 0 0 75 0 0 92
0x100084 30 0 0 0 10 0 0 0 30 0 0 94
0x100085 248 0 0 0 204 0 0 0 967 0 0 86
0x100086 408 0 0 0 384 0 0 0 1086 0 0 91
0x100087 450 0 0 0 202 0 0 0 675 0 0 96
0x100089 0 0 0 0 20 0 0 0 20 0 0 95
0x10008a 0 0 0 0 20 0 0 0 20 0 0 95
0x10008b 7 0 0 0 1 0 0 0 25 0 0 92
0x10008c 52 0 0 0 25 0 0 0 56 0 0 92
0x10008d 742 0 0 0 350 0 0 0 777 0 0 90
0x10008e 42 0 0 0 25 0 0 0 124 0 0 94
0x100090 18 0 0 0 34 0 0 0 70 0 0 95
0x100093 0 0 0 0 1 0 0 0 0 0 0 0
0x100094 0 0 0 0 40 0 0 0 20 0 0 95
0x100096 33 0 0 0 33 0 0 0 176 0 0 93
0x100098 1 0 0 0 1 0 0 0 3 0 0 34
0x10009a 1 0 0 0 1 0 0 0 6 0 0 50
0x1000a2 96 0 0 0 64 0 0 0 131 0 0 93
0x1000a3 0 0 0 0 0 0 0 0 60 0 0 95
0x1000a5 2 0 0 0 2 0 0 0 0 0 0 0
0x1000bd 518 0 0 0 4852 0 167 0 12679 170 192 100
0x1000bf 96 0 0 0 164 0 0 0 164 0 0 100
0x1000c0 4 0 0 0 12 0 0 0 22 0 0 87
0x1000c1 281 0 0 0 13 61 0 61 122 124 0 100
0x1000c2 10246 0 0 0 0 48 0 41 32274 131 0 100
0x1000c3 154 0 0 0 0 48 0 41 181 96 0 96
0x1000c4 63418 2 0 0 56826 48 0 41 58727 168 0 100
0x1000c5 10424 0 0 0 10328 48 0 41 11516 90 0 99
0x1000c9 0 0 0 0 6 0 0 0 12 0 0 84
0x1000cb 0 0 0 0 9 0 0 0 9 0 0 89
0x1000d6 0 0 0 0 0 0 0 0 27 0 0 93
0x1000d7 0 0 0 0 16 0 0 0 13 0 0 93
0x100103 170818 0 0 0 558 276 0 276 7094 580 6 94
0x100104 9 0 0 0 1473 3 0 0 48222 5 338 100
0x100105 3 0 0 0 1 1 0 0 3 2 0 34
0x10010a 5993 0 0 0 6 23 0 35 1120 74 6 95
0x10010b 82 0 0 0 47 23 0 35 155 63 0 96
0x10010c 12 0 0 0 3 9 0 0 15 12 0 87
0x100110 178323 0 0 0 282 276 0 276 15167 607 6 94
0x100111 7967 0 0 0 0 1602 0 1602 6493 3297 0 100
0x100112 15262 0 0 0 1692 1602 0 1602 17200 3427 0 100
0x100113 81 0 0 0 4 17 0 0 22 21 0 87
0x100114 3191 0 0 0 66 26 0 52 574 86 1 79
0x100116 2260 0 0 0 1096 0 0 0 2296 0 0 100
0x100117 86 0 0 0 42 0 0 0 99 0 0 93
0x100118 8 0 0 0 4 0 0 0 12 0 0 75
0x100119 6 0 0 0 4 0 0 0 12 0 0 59
0x10011f 0 0 0 0 0 0 0 0 2 0 0 50
0x100191 82 0 0 0 35 0 0 0 84 0 1 97
0x100195 33 0 0 0 1 0 0 0 36 0 0 95
0x100197 0 0 0 0 0 0 0 0 3 0 0 67
0x100198 0 0 0 0 0 0 0 0 1 0 0 0
0x100199 48 0 0 0 16 0 0 0 48 0 0 96
0x10019a 54 0 0 0 24 0 0 0 158 0 0 65
0x10019b 28 0 0 0 12 0 0 0 32 0 0 82
0x10019c 0 0 0 0 0 0 0 0 8 0 0 75
0x10019e 0 0 0 0 2 0 0 0 2 0 0 50
0x10019f 0 0 0 0 2 0 0 0 2 0 0 50
0x1001a0 0 0 0 0 0 0 0 0 1 0 0 0
0x1001a9 280 0 0 0 57 0 0 0 124 0 0 87
0x1001aa 3 0 0 0 2 0 0 0 7 0 0 72
0x1001ac 9 0 0 0 3 0 0 0 9 0 0 78
0x1001af 1 0 0 0 1 0 0 0 0 0 0 0
0x1001be 51 0 0 0 34 0 0 0 54 0 0 95
0x1001bf 0 0 0 0 0 0 0 0 6 0 0 50
0x1001c1 26 0 0 0 26 0 0 0 0 0 0 0
0x1001d3 5454 0 0 0 2688 0 0 0 6091 0 0 100
0x1001d4 4318 0 0 0 2198 0 0 0 4595 0 0 100
0x1001d5 855 0 0 0 343 0 0 0 976 0 0 98
0x1001d6 56 0 0 0 37 0 0 0 113 0 0 83
0x1001d7 19 0 0 0 10 0 0 0 39 0 0 95
0x1001d8 176 0 0 0 80 0 0 0 179 0 0 99
0x1001d9 231 0 0 0 92 0 0 0 232 0 1 99
0x1001dd 332 0 0 0 14 0 0 0 411 0 0 93
0x1001df 0 0 0 0 0 0 0 0 3 0 0 67
0x1001e0 0 0 0 0 0 0 0 0 14 0 0 93
0x1001e1 477 0 0 0 159 0 0 0 636 0 0 98
0x1001e2 146 0 0 0 65 0 0 0 297 0 0 76
0x1001e3 66 0 0 0 28 0 0 0 76 0 0 85
0x1001e4 0 0 0 0 0 0 0 0 20 0 0 85
0x1001e6 0 0 0 0 18 0 0 0 18 0 0 95
0x1001e7 0 0 0 0 18 0 0 0 18 0 0 95
0x1001e8 0 0 0 0 0 0 0 0 14 0 0 93
0x1001ea 908 0 0 0 427 0 0 0 944 0 0 87
0x1001eb 71 0 0 0 41 0 0 0 159 0 0 84
0x1001ed 21 0 0 0 7 0 0 0 21 0 0 86@@NL@
I'm sorry. I don't know how to maintain tabs here.
Now, after your ccomments, I have a new onconfig.
I changed the following parameters:
ONLIDX_MAXMEM 5242880 --> 1048576
DS_TOTAL_MEMORY 26214400 --> 1048576
DS_MAX_SCANS 5 --> 20
DS_NONPDQ_QUERY_MEM 1310720 --> 262144
behaviour is still the same.
Yes, most of the DS_ parameters and PDQPRIORITY are ignored in workgroup
edition. As for your temp tables going to ROOTDBS, a) make sure that the
temp dbspaces are indeed marked as temp (ie have the "T" flag set in the
onstat -d output) and b) set TEMPTAB_NOLOG 1 in the ONCONFIG file (you candynamically set it with "onmode -wf TEMPTAB_NOLOG=1").
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, Oct 27, 2015 at 4:53 PM, <> wrote:
> Hi,
>
> 1. I think that IDS Workgroup Edition doesn't support PDQ or DSS. The IDS
> installer set up that parameters. Maybe my virtual machine had 32GB RAM
> when I
> installed ids.
> Please tell me if I am wrong.
> I have not set any parameters that looks like PDQ or DS related.
> I saw the warnings starting IDS, but as the engine adjusted values
> ​​and I supposed that was not used, so I left them as it were.
> Now, I have adjusted that parameters and posted below. Performance remains
> the
> same.
>
> I suppose the engine is not ignoring these parameters, but adjusting them.
> (extracted from instance's log)
>
> | Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
>
> | Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
>
> | Parameter's user-configured value was adjusted. (DS_TOTAL_MEMORY)
>
> 2. [I can see most of your I/O takes place in rootdbs.]
> I don't know why. The application tables are located in other dbspaces.
> I think rootdbs just have system databases. And temp tables, because there
> is
> a bug with temp dbspaces. I created 3 tmp dbspaces but they aren't active.
>
> 3. [Are those the queries with poor performance?]
> The queries are very simple. They retrieve (not big) records via simple
> codes.
>
> [If not, could you post a set explain statistics" for that query? ]
> Queries aren't complex and slow, but simple ones inside loops.
>
> [Is the poor performance repeatable or just with a cold buffer cache?]
> The poor performance repeats even with all data in cache.
> Nevertheless the worst thing is not low performance but high latency
> character
> terminals (putty/ssh).
>
> 4. ['onstat -g ppf' would be useful.]
> onstat -g ppf output was very strange. sysptnbit table (0xe) had 22267085> isrd. I have run onstat -z to reset counters and after a while of
> processing,
> I have got the following output:
> IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 06:26:09
> --> 2525184 Kbytes
>
> Partition profiles
> partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc
> rhitratio
> 0x6 0 0 0 0 2 0 0 0 0 0 0 0
> 0x1a 0 0 0 0 4 0 0 0 0 0 0 0
> 0x1f 0 0 0 0 6 0 0 0 0 0 0 0
> 0x27 0 0 0 0 78 0 0 0 0 0 0 0
> 0x28 0 0 0 0 71 0 0 0 0 0 0 0
> 0x29 0 0 0 0 7 0 0 0 0 0 0 0
> 0x2a 0 0 0 0 4 0 0 0 0 0 0 0
> 0x2f 0 0 0 0 3 0 0 0 0 0 0 0
> 0x30 0 0 0 0 6 0 0 0 0 0 0 0
> 0x57 0 0 0 0 6 0 0 0 0 0 0 0
> 0x58 0 0 0 0 2 0 0 0 0 0 0 0
> 0x59 0 0 0 0 1 0 0 0 0 0 0 0
> 0x74 0 0 0 0 2 0 0 0 0 0 0 0
> 0x99 0 0 0 0 3798 0 0 0 3 0 0 67
> 0x100001 0 0 0 0 0 0 0 0 709 0 0 100
> 0x100002 544 0 0 0 207 0 0 0 686 1 3 100
> 0x100004 3041 0 0 0 2963 0 0 0 6396 0 0 100
> 0x100005 926 0 0 0 454 0 0 0 1040 0 0 97
> 0x100006 35 0 0 0 11 0 0 0 62 0 0 86
> 0x100007 68 0 0 0 39 0 0 0 113 0 0 89
> 0x100008 9 0 0 0 5 0 0 0 29 0 0 94
> 0x100009 26 0 0 0 26 0 0 0 84 0 0 86
> 0x10000a 2 0 0 0 3 0 0 0 6 0 1 50
> 0x10000e 0 0 0 0 0 0 0 0 18 0 0 95
> 0x100011 0 0 0 0 0 0 0 0 18 0 0 95
> 0x100013 12 0 0 0 12 0 0 0 96 0 0 42
> 0x100014 12 0 0 0 12 0 0 0 32 0 0 85
> 0x100015 6 0 0 0 2 0 0 0 14 0 0 79
> 0x100017 0 0 0 0 18 0 0 0 18 0 0 95
> 0x100018 0 0 0 0 18 0 0 0 18 0 0 95
> 0x100019 0 0 0 0 0 0 0 0 18 0 0 95
> 0x10001b 0 0 0 0 0 0 0 0 30 0 0 97
> 0x10001c 12 0 0 0 0 0 0 0 72 0 0 96
> 0x10001e 1 0 0 0 1 0 0 0 3 0 0 34
> 0x100021 0 0 0 0 1 0 0 0 0 0 0 0
> 0x100024 1 0 0 0 1 0 0 0 4 0 0 25
> 0x100030 36 0 0 0 24 0 0 0 54 0 0 82
> 0x100031 0 0 0 0 0 0 0 0 54 0 0 95
> 0x100033 0 0 0 0 1 0 0 0 0 0 0 0
> 0x100076 702 0 0 0 370 0 0 0 946 0 2 98
> 0x100077 623 0 0 0 436 0 0 0 901 0 0 99
> 0x100078 57 0 0 0 43 0 0 0 95 0 0 90
> 0x100079 92 0 0 0 56 0 0 0 144 0 0 94
> 0x10007a 28 0 0 0 15 0 0 0 50 0 0 96
> 0x10007b 29 0 0 0 29 0 0 0 70 0 0 93
> 0x10007c 4 0 0 0 5 0 0 0 6 0 1 50
> 0x100080 29 0 0 0 5 0 0 0 47 0 0 96
> 0x100081 4 0 0 0 2 0 0 0 6 0 0 67
> 0x100082 198 0 0 0 97 0 0 0 206 0 0 96
> 0x100083 54 0 0 0 29 0 0 0 75 0 0 92
> 0x100084 30 0 0 0 10 0 0 0 30 0 0 94
> 0x100085 248 0 0 0 204 0 0 0 967 0 0 86
> 0x100086 408 0 0 0 384 0 0 0 1086 0 0 91
> 0x100087 450 0 0 0 202 0 0 0 675 0 0 96
> 0x100089 0 0 0 0 20 0 0 0 20 0 0 95
> 0x10008a 0 0 0 0 20 0 0 0 20 0 0 95
> 0x10008b 7 0 0 0 1 0 0 0 25 0 0 92
> 0x10008c 52 0 0 0 25 0 0 0 56 0 0 92
> 0x10008d 742 0 0 0 350 0 0 0 777 0 0 90
> 0x10008e 42 0 0 0 25 0 0 0 124 0 0 94
> 0x100090 18 0 0 0 34 0 0 0 70 0 0 95
> 0x100093 0 0 0 0 1 0 0 0 0 0 0 0
> 0x100094 0 0 0 0 40 0 0 0 20 0 0 95
> 0x100096 33 0 0 0 33 0 0 0 176 0 0 93
> 0x100098 1 0 0 0 1 0 0 0 3 0 0 34
> 0x10009a 1 0 0 0 1 0 0 0 6 0 0 50
> 0x1000a2 96 0 0 0 64 0 0 0 131 0 0 93
> 0x1000a3 0 0 0 0 0 0 0 0 60 0 0 95
> 0x1000a5 2 0 0 0 2 0 0 0 0 0 0 0
> 0x1000bd 518 0 0 0 4852 0 167 0 12679 170 192 100
> 0x1000bf 96 0 0 0 164 0 0 0 164 0 0 100
> 0x1000c0 4 0 0 0 12 0 0 0 22 0 0 87
> 0x1000c1 281 0 0 0 13 61 0 61 122 124 0 100
> 0x1000c2 10246 0 0 0 0 48 0 41 32274 131 0 100
> 0x1000c3 154 0 0 0 0 48 0 41 181 96 0 96
> 0x1000c4 63418 2 0 0 56826 48 0 41 58727 168 0 100
> 0x1000c5 10424 0 0 0 10328 48 0 41 11516 90 0 99
> 0x1000c9 0 0 0 0 6 0 0 0 12 0 0 84
> 0x1000cb 0 0 0 0 9 0 0 0 9 0 0 89
> 0x1000d6 0 0 0 0 0 0 0 0 27 0 0 93
> 0x1000d7 0 0 0 0 16 0 0 0 13 0 0 93
> 0x100103 170818 0 0 0 558 276 0 276 7094 580 6 94
> 0x100104 9 0 0 0 1473 3 0 0 48222 5 338 100
> 0x100105 3 0 0 0 1 1 0 0 3 2 0 34
> 0x10010a 5993 0 0 0 6 23 0 35 1120 74 6 95
> 0x10010b 82 0 0 0 47 23 0 35 155 63 0 96
> 0x10010c 12 0 0 0 3 9 0 0 15 12 0 87
> 0x100110 178323 0 0 0 282 276 0 276 15167 607 6 94
> 0x100111 7967 0 0 0 0 1602 0 1602 6493 3297 0 100
> 0x100112 15262 0 0 0 1692 1602 0 1602 17200 3427 0 100
> 0x100113 81 0 0 0 4 17 0 0 22 21 0 87
> 0x100114 3191 0 0 0 66 26 0 52 574 86 1 79
> 0x100116 2260 0 0 0 1096 0 0 0 2296 0 0 100
> 0x100117 86 0 0 0 42 0 0 0 99 0 0 93
> 0x100118 8 0 0 0 4 0 0 0 12 0 0 75
> 0x100119 6 0 0 0 4 0 0 0 12 0 0 59
> 0x10011f 0 0 0 0 0 0 0 0 2 0 0 50
> 0x100191 82 0 0 0 35 0 0 0 84 0 1 97
> 0x100195 33 0 0 0 1 0 0 0 36 0 0 95
> 0x100197 0 0 0 0 0 0 0 0 3 0 0 67
> 0x100198 0 0 0 0 0 0 0 0 1 0 0 0
> 0x100199 48 0 0 0 16 0 0 0 48 0 0 96
> 0x10019a 54 0 0 0
Hi,
There's nothing too obvious here...
I think I agree with Art and your observation that, as you are using workgroup
edition, the DS parameters are not relevant.
Temp table spaces work ok in most versions as far as I know. From memory temp
tables for sorting or joins go into one of the temp tables specified in
DBSPACETEMP but rootdbs will be used if none of these has sufficient free
space, even if the free space rootdbs is less.
For user-created temp tables they may go in rootdbs if your database was
created in that dbspace. TEMPTAB_NOLOG is generally a good idea.
I look at the ppf output. As an aside, I can see you have the bug where a
number close to 2^32 like 4294967290 appears in the rhitratio column: I was
supposed to raise a specific PMR with IBM support about this but have never
got around to it. Unless someone else has spotted and raised it, I don't think
there is a defect number.
Tables with the most reads are:
0xa00016
0xa00039
0x700005
0x800058
0xa0006c
0x900175
0xa000a5
0x800093
You also have a lot of lock requests on 0x100202.
You could try looking at user thread wait conditions by monitoring 'onstat -u'
and looking for lock waits, waiting on buffers etc.
Ben.
Partnum 0x100202 table is Sysdirectives.
I have set IFX_EXTDIRECTIVES parameter to 0 trying to minimize so many hits on
that table.
The buffer cache holds all the database activity of the "malo" process.
We set TEMPTAB_NOLOG in some places into 4GL code.
onstat -g ppf updated (I have deleted the all-zero rows)
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 03:29:09 --2525184 Kbytes
Partition profiles
partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc
rhitratio
0x6 0 0 0 0 3 0 0 0 0 0 0 0
0xf 0 0 0 0 2432 0 0 0 119415 0 0 100
0x14 0 0 0 0 137717 0 0 0 108 0 0 100
0x17 0 0 0 0 174 0 0 0 0 0 0 0
0x18 0 0 0 0 81 0 0 0 0 0 0 0
0x1a 0 0 0 0 3 0 0 0 0 0 0 0
0x1f 0 0 0 0 135 0 0 0 0 0 0 0
0x26 0 0 0 0 60 0 0 0 0 0 0 0
0x27 0 0 0 0 39 0 0 0 0 0 0 0
0x28 0 0 0 0 72 0 0 0 0 0 0 0
0x29 0 0 0 0 3 0 0 0 0 0 0 0
0x2a 0 0 0 0 173 0 0 0 0 0 0 0
0x2e 0 0 0 0 22 0 0 0 0 0 0 0
0x2f 0 0 0 0 8 0 0 0 0 0 0 0
0x30 0 0 0 0 3 0 0 0 0 0 0 0
0x57 0 0 0 0 3 0 0 0 0 0 0 0
0x58 0 0 0 0 8 0 0 0 0 0 0 0
0x59 0 0 0 0 0 0 0 0 0 0 0 0
0x5b 0 0 0 0 203 0 0 0 0 0 0 0
0x5c 0 0 0 0 4 0 0 0 0 0 0 0
0x60 0 0 0 0 2 0 0 0 0 0 0 0
0x6d 0 0 0 0 42 0 0 0 0 0 0 0
0x74 0 0 0 0 46 0 0 0 0 0 0 0
0x75 0 0 0 0 10 0 0 0 1295 0 0 99
0x99 0 0 0 0 1946 0 0 0 0 0 0 0
0x100001 0 0 0 0 0 0 0 0 3492 0 0 100
0x100002 1921 0 0 0 520 0 0 0 1676 0 74 100
0x100003 0 0 0 0 0 0 0 0 0 0 0 0
0x100004 26778 0 0 0 13725 0 0 0 29153 0 0 100
0x100005 966 0 0 0 474 0 0 0 1059 0 0 98
0x100006 32 0 0 0 10 0 0 0 55 0 0 91
0x100007 62 0 0 0 37 0 0 0 93 0 0 99
0x100008 0 0 0 0 0 0 0 0 18 0 0 100
0x100009 1059 0 0 0 448 0 0 0 1071 0 0 100
0x10000e 0 0 0 0 0 0 0 0 18 0 0 100
0x100011 0 0 0 0 0 0 0 0 18 0 0 100
0x100013 16 0 0 0 7 0 0 0 22 0 0 100
0x100015 0 0 0 0 0 0 0 0 6 0 0 100
0x100017 0 0 0 0 18 0 0 0 18 0 0 100
0x100018 0 0 0 0 18 0 0 0 18 0 0 100
0x100019 0 0 0 0 0 0 0 0 18 0 0 100
0x10001b 0 0 0 0 0 0 0 0 39 0 0 100
0x10001c 13 0 0 0 2 0 0 0 75 0 0 99
0x10001e 0 0 0 0 2 0 0 0 2 0 0 50
0x100024 99 0 0 0 33 0 0 0 136 0 0 95
0x100030 33 0 0 0 22 0 0 0 44 0 0 96
0x100031 0 0 0 0 0 0 0 0 54 0 0 100
0x100076 1898 0 0 0 913 0 0 0 1913 0 0 100
0x100077 275 0 0 0 126 0 0 0 303 0 0 100
0x100078 21 0 0 0 5 0 0 0 26 0 0 89
0x100079 57 0 0 0 34 0 0 0 79 0 0 100
0x10007a 9 0 0 0 5 0 0 0 20 0 0 100
0x10007b 12 0 0 0 12 0 0 0 27 0 0 100
0x100080 19 0 0 0 3 0 0 0 30 0 0 100
0x100082 341 0 0 0 168 0 0 0 349 0 0 98
0x100083 23 0 0 0 13 0 0 0 37 0 0 95
0x100084 24 0 0 0 8 0 0 0 24 0 0 100
0x100085 96 0 0 0 64 0 0 0 351 0 0 94
0x100086 421 0 0 0 304 0 0 0 766 0 0 93
0x100087 208 0 0 0 95 0 0 0 316 0 0 96
0x100089 0 0 0 0 11 0 0 0 11 0 0 100
0x10008a 0 0 0 0 11 0 0 0 11 0 0 100
0x10008b 0 0 0 0 0 0 0 0 11 0 0 100
0x10008d 197 0 0 0 91 0 0 0 214 0 0 90
0x10008e 21 0 0 0 13 0 0 0 65 0 0 99
0x100090 1 0 0 0 11 0 0 0 19 0 0 100
0x100094 0 0 0 0 12 0 0 0 6 0 0 100
0x100096 1 0 0 0 1 0 0 0 4 0 0 100
0x1000a2 48 0 0 0 32 0 0 0 64 0 0 99
0x1000a3 0 0 0 0 0 0 0 0 33 0 0 100
0x1000b7 168 0 0 0 13 4 4 0 81 81 0 66
0x1000b8 1351 0 0 0 26 4 0 0 44 4 0 78
0x1000b9 88 0 0 0 0 4 0 0 10 4 0 70
0x1000ba 36 0 0 0 39 0 0 0 39 0 3 98
0x1000bd 380 0 0 0 2483 0 50 0 6621 52 100 100
0x1000bf 52 0 0 0 87 0 0 0 87 0 0 100
0x1000c0 78 0 0 0 7 0 0 0 28 0 0 90
0x1000c1 119 0 0 0 0 24 0 24 48 49 0 100
0x1000c2 9217 0 0 0 0 25 0 24 19660 67 0 100
0x1000c3 74 0 0 0 0 25 0 24 98 49 0 96
0x1000c4 163 0 0 0 0 25 0 24 104 51 0 90
0x1000c5 14659 0 0 0 9311 25 0 24 10233 49 0 99
0x1000c6 5 0 0 0 0 1 0 0 3 4 0 34
0x1000c7 2 0 0 0 0 1 0 0 2 1 0 0
0x1000c8 2 0 0 0 0 1 0 0 2 1 0 0
0x1000c9 64 0 0 0 4 0 0 0 28 0 2 79
0x1000cb 0 0 0 0 5 0 0 0 5 0 0 80
0x100103 85418 0 0 0 233 92 0 138 3740 243 3 88
0x10010a 2957 0 0 0 3 19 0 16 609 44 3 90
0x10010b 54 0 0 0 22 19 0 16 88 35 0 96
0x10010c 3900 0 0 0 10 6 0 6 209 18 2 95
0x100110 87134 0 0 0 141 138 0 138 8060 303 3 88
0x100111 4029 0 0 0 0 801 0 801 3246 1648 0 100
0x100112 4816 0 0 0 846 801 0 801 8240 1637 0 100
0x100113 35 0 0 0 4 17 0 0 20 19 0 90
0x100116 998 0 0 0 483 0 0 0 1022 0 0 100
0x100117 86 0 0 0 42 0 0 0 97 0 0 94
0x100118 8 0 0 0 4 0 0 0 12 0 0 75
0x100119 6 0 0 0 4 0 0 0 12 0 0 59
0x10011f 0 0 0 0 0 0 0 0 2 0 0 50
0x100120 32 0 0 0 0 0 0 0 32 0 0 97
0x100121 32 0 0 0 35 0 0 0 102 0 0 96
0x100191 37 0 0 0 17 0 0 0 39 0 1 93
0x100195 33 0 0 0 1 0 0 0 36 0 0 95
0x100198 0 0 0 0 0 0 0 0 1 0 0 0
0x100199 48 0 0 0 16 0 0 0 48 0 0 96
0x10019a 54 0 0 0 24 0 0 0 158 0 0 65
0x10019b 28 0 0 0 12 0 0 0 32 0 0 82
0x10019c 0 0 0 0 0 0 0 0 8 0 0 75
0x10019d 0 0 0 0 0 0 0 0 0 0 0 0
0x10019e 0 0 0 0 2 0 0 0 2 0 0 50
0x10019f 0 0 0 0 2 0 0 0 2 0 0 50
0x1001a0 0 0 0 0 0 0 0 0 1 0 0 0
0x1001a9 280 0 0 0 57 0 0 0 124 0 0 87
0x1001aa 3 0 0 0 2 0 0 0 7 0 0 72
0x1001ac 9 0 0 0 3 0 0 0 9 0 0 78
0x1001af 1 0 0 0 1 0 0 0 0 0 0 0
0x1001be 51 0 0 0 34 0 0 0 51 0 0 97
0x1001bf 0 0 0 0 0 0 0 0 6 0 0 50
0x1001c1 1 0 0 0 1 0 0 0 0 0 0 0
0x1001d3 352 0 0 0 160 0 0 0 421 0 0 92
0x1001d4 316 0 0 0 152 0 0 0 377 0 0 95
0x1001d5 66 0 0 0 12 0 0 0 107 0 0 80
0x1001d6 36 0 0 0 24 0 0 0 74 0 0 80
0x1001d7 0 0 0 0 0 0 0 0 12 0 0 92
0x1001d9 13 0 0 0 8 0 0 0 14 0 1 79
0x1001dd 316 0 0 0 12 0 0 0 385 0 0 94
0x1001e0 0 0 0 0 0 0 0 0 12 0 0 92
0x1001e1 456 0 0 0 152 0 0 0 608 0 0 98
0x1001e2 38 0 0 0 38 0 0 0 196 0 0 71
0x1001e3 24 0 0 0 24 0 0 0 64 0 0 86
0x1001e4 0 0 0 0 0 0 0 0 16 0 0 88
0x1001e6 0 0 0 0 12 0 0 0 12 0 0 92
0x1001e7 0 0 0 0 12 0 0 0 12 0 0 92
0x1001e8 0 0 0 0 0 0 0 0 12 0 0 92
0x1001ea 173 0 0 0 67 0 0 0 192 0 0 85
0x1001eb 65 0 0 0 37 0 0 0 131 0 0 81
0x1001ed 4 0 0 0 4 0 0 0 12 0 0 75
0x1001f0 1 0 0 0 1 0 0 0 0 0 0 0
0x1001f3 1 0 0 0 1 0 0 0 4 0 0 25
0x1001ff 531 0 0 0 354 0 0 0 885 0 0 94
0x100200 0 0 0 0 0 0 0 0 36 0 0 92
0x100202 1 0 0 0 1 0 0 0 0 0 0 0
0x400001 0 0 0 0 0 0 0 0 90 0 0 100
0x500001 0 0 0 0 0 0 0 0 88 0 0 100
0x600001 0 0 0 0 0 0 0 0 88 0 0 100
0x700001 0 0 0 0 0 0 0 0 76 0 0 100
0x700002 16 0 0 0 0 0 0 0 16 0 0 94
0x700003 16 0 0 0 16 0 0 0 16 0 0 94
0x700005 0 0 0 0 0 0 0 0 128941 0 0 100
0x70002f 0 0 0 0 4 0 0 0 8 0 0 88
0x700058 0 0 0 0 944 0 0 0 3830 0 0 4294967195
0x7000a0 0 0 0 0 4 0 0 0 4 0 0 75
0x800001 0 0 0 0 0 0 0 0 152 0 0 100
0x800004 14 0 0 0 0 2 0 2 12 6 0 84
0x800036 12 0 0 0 2 2 0 2 6 4 0 84
0x800058 0 0 0 0 0 0 0 0 219556 0 0 100
0x800093 0 0 0 0 241200 0 0 0 725776 0 0 100
0x900001 0 0 0 0 0 0 0 0 152 0 0 100
0x900012 0 0 0 0 0 0 0 0 2 0 0 50
0x90001d 0 0 0 0 2 0 0 0 2 0 2 50
0x90003a 0 0 0 0 0 0 0 0 2 0 0 50
0x900078 0 0 0 0 0 0 0 0 16876 0 0 95
0x9000a3 0 0 0 0 2 0 0 0 2 0 0 50
0x9000d3 0 0 0 0 2 0 0 0 2 0 0 50
0x900175 0 0 0 0 120600 0 0 0 362453 0 0 100
0xa00009 0 0 0 0 0 0 0 0 32 0 0 88
0xa00016 0 0 0 0 0 0 0 0 59092 0 0 100
0xa00039 0 0 0 0 0 0 0 0 120600 0 0 98
0xa0004f 0 0 0 0 32 0 0 0 64 0 0 96
0xa0006c 0 0 0 0 120600 0 0 0 241932 0 0 100
0xa000a5 0 0 0 0 120604 0 0 0 362808 0 0 100
.parenthesis. Of course, I don't write TEMPTAB_NOLOG in 4GL code, but WITH NO LOG in create temp table. .parenthesis. By the way, can I edit a posted message?
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape