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 2292 9 0 3731 0.6 0 0
kio -1 4 i 0.1 453 434 19 0 678 0.7 0 0
kio -1 5 i 0.2 1081 1071 10 0 1974 0.5 0 0
msc 6 0 i 0.0 11 0 0 0 10 1.1 0 11
aio 5 0 i 0.0 233 25 0 0 234 1.0 0 0
pio 4 0 i 0.0 0 0 0 0 1 0.0 0 0
lio 3 0 i 0.0 0 0 0 0 1 0.0 0 0
==========================================================================
[informix@lpsrvexplo ~]$ onstat -g iof
IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 01:29:34 -- 2525184 Kbytes
AIO global files:
gfd pathname bytes read page reads bytes write page writes io/s
3 rootdbs 9230336 4507 1699840 830 1647.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2805 0.0006
kaio_writes 271 0.0006
4 logsdbs 268288 131 595968 291 3237.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 4 0.0011
kaio_writes 88 0.0003
5 tmp1dbs 2048 1 8192 4 3789.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 1 0.0002
kaio_writes 2 0.0003
6 tmp2dbs 2048 1 8192 4 4192.5
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 1 0.0002
kaio_writes 2 0.0003
7 tmp3dbs 2048 1 8192 4 3451.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 1 0.0003
kaio_writes 2 0.0003
8 dbs_1.0 39962624 19516 0 0 1240.4
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 6661 0.0008
kaio_writes 0 N/A
9 dbs_2.0 313344 153 16384 8 5572.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 153 0.0002
kaio_writes 8 0.0005
10 dbs_3.0 2689024 1313 0 0 2507.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 1313 0.0004
kaio_writes 0 N/A
11 dbs_4.0 6752256 3297 0 0 2575.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 3297 0.0004
kaio_writes 0 N/A
12 dbs_1.1 4096 2 0 0 5393.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
13 dbs_1.2 4096 2 0 0 5275.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
14 dbs_1.3 4096 2 0 0 4856.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
15 dbs_1.4 4096 2 0 0 5986.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
16 dbs_1.5 4096 2 0 0 4463.6
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
17 dbs_1.6 4096 2 0 0 5025.4
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
18 dbs_1.7 4096 2 0 0 5188.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
19 dbs_1.8 4096 2 0 0 5013.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
20 dbs_1.9 4096 2 0 0 4455.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
21 dbs_2.1 4096 2 0 0 4615.5
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
22 dbs_2.2 4096 2 0 0 5640.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
23 dbs_2.3 4096 2 0 0 5827.6
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
24 dbs_2.4 4096 2 0 0 6043.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
25 dbs_2.5 11356160 5545 0 0 3331.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 5545 0.0003
kaio_writes 0 N/A
26 dbs_2.6 4096 2 0 0 6052.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
27 dbs_2.7 4096 2 0 0 5281.6
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
28 dbs_2.8 4096 2 0 0 4518.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
29 dbs_2.9 4096 2 0 0 5182.1
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
30 dbs_3.1 6144 3 0 0 6149.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 3 0.0002
kaio_writes 0 N/A
31 dbs_3.2 4096 2 0 0 6240.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
32 dbs_3.3 358400 175 0 0 2379.6
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 175 0.0004
kaio_writes 0 N/A
33 dbs_3.4 4096 2 0 0 6171.4
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
34 dbs_3.5 4096 2 0 0 7211.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0001
kaio_writes 0 N/A
35 dbs_3.6 4096 2 0 0 3001.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0003
kaio_writes 0 N/A
36 dbs_3.7 4096 2 0 0 5438.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
37 dbs_3.8 4096 2 0 0 4050.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
38 dbs_3.9 4096 2 0 0 5128.4
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
39 dbs_4.1 444416 217 0 0 6234.2
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 217 0.0002
kaio_writes 0 N/A
40 dbs_4.2 4096 2 0 0 5964.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
41 dbs_4.3 522240 255 0 0 3815.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 255 0.0003
kaio_writes 0 N/A
42 dbs_4.4 4096 2 0 0 5940.3
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
43 dbs_4.5 4096 2 0 0 5871.5
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
44 dbs_4.6 4096 2 0 0 5904.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
45 dbs_4.7 4096 2 0 0 5841.9
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
46 dbs_4.8 4096 2 0 0 6377.8
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
47 dbs_4.9 4096 2 0 0 5948.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 2 0.0002
kaio_writes 0 N/A
48 PHYSLOG2GB 49152 24 446464 218 1068.0
op type count avg. time
seeks 0 N/A
reads 0 N/A
writes 0 N/A
kaio_reads 6 0.0026
kaio_writes 18 0.0004
==========================================================================
dbsname tabname (count(*)) (sum)
pina_e sysprocbody 9 768
pina_e sysobjstate 7 384
pina_e sysconstraints 7 384
pina_e lisart 7 1304
pina_e sysdistrib 6 896
pina_e sysfragments 6 256
pina_e sysprocedures 6 256
pina_e sysprocplan 5 128
pina_e syscoldepend 5 128
pina_e sysproccolumns 4 64
pina_e sysprocauth 4 64
pina_e sysindices 3 256
pina_e lin 3 3533602
pina_e systabauth 3 91
pina_e systables 3 66
pina_e k_cli 2 426
pina_e cli 2 5000
pina_e syscolumns 2 182
pina_e eur 2 16
pina_e ira 2 12
pina_e mov 2 2597149
pina_e sysseclabelcomp 2 16
pina_e i_tie 1 4
pina_e n_fre 1 13636
pina_e i_epr 1 521
pina_e j_cdf 1 945
pina_e i_tbc 1 2203
pina_e rap 1 16
pina_e rnl 1 25000
pina_e j_pps 1 8
pina_e i_pro 1 4
pina_e i_pva 1 9
pina_e k_ran 1 23
pina_e n_prv 1 202
pina_e j_acl 1 218502
pina_e i_rnv 1 25000
pina_e i_hhp 1 31690
pina_e m_rev 1 71428
pina_e paf 1 16
pina_e rco 1 8
pina_e rpp 1 50
pina_e ent 1 8
pina_e frx 1 100000
pina_e bal 1 100
pina_e crt 1 50000
pina_e inx 1 50
pina_e del 1 8
pina_e ctr 1 5000
pina_e ccf 1 2500
pina_e apo 1 2500
==========================================================================
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select rowid,codtie from tie where 1=1 and codtie between 2 and 2 order by codtie
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.tie: INDEX PATH
(1) Index Name: informix.i_tie
Index Keys: codtie (Key-Only) (Serial, fragments: ALL)
Lower Index Filter: informix.tie.codtie = 2
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from tie where rowid =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.tie: INDEX PATH
(1) Index Name: (ROWID)
Index Keys: ROWID
Lower Index Filter: informix.tie.ROWID = 258
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 integer 0x000 258
Table map :
----------------------------
Internal name Table name
----------------------------
t1 tie
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
------------------ START LOOP --------------------------------------
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from col where artcol =? and almcol =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.col: INDEX PATH
(1) Index Name: informix.j_col
Index Keys: artcol almcol (Serial, fragments: ALL)
Lower Index Filter: (informix.col.artcol = 30209054 AND informix.col.almcol = 2 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 30209054
2 decimal 0x000 2
Table map :
----------------------------
Internal name Table name
----------------------------
t1 col
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from art where claart =?
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.art: INDEX PATH
(1) Index Name: informix.i_art
Index Keys: claart (Serial, fragments: ALL)
Lower Index Filter: informix.art.claart = 30209054
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 art
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30209054 AND informix.pvp.tdtpvp = 5 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 5
2 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30209054 AND informix.pvp.tdtpvp = 10 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 10
2 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30209054 AND informix.pvp.tdtpvp = 5 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 5
2 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30209054 AND informix.pvp.tdtpvp = 4 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 4
2 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select almhue, ubihue, arthue, tiphue, reshue from hue where almhue =? and arthue =? and tiphue = "P" and reshue = 0 order by reshue, almhue, arthue, tiphue
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.hue: INDEX PATH
(1) Index Name: informix.r_hue
Index Keys: reshue almhue arthue tiphue (Serial, fragments: ALL)
Lower Index Filter: (((informix.hue.arthue = 30209054 AND informix.hue.tiphue = 'P' ) AND informix.hue.reshue = 0 ) AND informix.hue.almhue = '099 ' )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 char 0x000 099
2 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 hue
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from dar where artdar =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.dar: INDEX PATH
(1) Index Name: informix.i_dar
Index Keys: artdar (Serial, fragments: ALL)
Lower Index Filter: informix.dar.artdar = 30209054
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 30209054
Table map :
----------------------------
Internal name Table name
----------------------------
t1 dar
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
-------------------- END LOOP -----------------------------------------
-------------------- START LOOP -----------------------------------------
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from art where claart =?
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.art: INDEX PATH
(1) Index Name: informix.i_art
Index Keys: claart (Serial, fragments: ALL)
Lower Index Filter: informix.art.claart = 30601027
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 art
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30601027 AND informix.pvp.tdtpvp = 5 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 5
2 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30601027 AND informix.pvp.tdtpvp = 10 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 10
2 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30601027 AND informix.pvp.tdtpvp = 5 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 5
2 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from pvp where tdtpvp =? and artpvp =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.pvp: INDEX PATH
(1) Index Name: informix.m_pvp
Index Keys: artpvp tdtpvp (Serial, fragments: ALL)
Lower Index Filter: (informix.pvp.artpvp = 30601027 AND informix.pvp.tdtpvp = 4 )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 4
2 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 pvp
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 1
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select almhue, ubihue, arthue, tiphue, reshue from hue where almhue =? and arthue =? and tiphue = "P" and reshue = 0 order by reshue, almhue, arthue, tiphue
Estimated Cost: 3
Estimated # of Rows Returned: 1
1) informix.hue: INDEX PATH
(1) Index Name: informix.r_hue
Index Keys: reshue almhue arthue tiphue (Serial, fragments: ALL)
Lower Index Filter: (((informix.hue.arthue = 30601027 AND informix.hue.tiphue = 'P' ) AND informix.hue.reshue = 0 ) AND informix.hue.almhue = '099 ' )
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 char 0x000 099
2 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 hue
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 1 1 1 00:00.00 3
QUERY: (OPTIMIZATION TIMESTAMP: 08-22-2015 13:21:43)
------
select * from dar where artdar =?
Estimated Cost: 1
Estimated # of Rows Returned: 1
1) informix.dar: INDEX PATH
(1) Index Name: informix.i_dar
Index Keys: artdar (Serial, fragments: ALL)
Lower Index Filter: informix.dar.artdar = 30601027
Query statistics:
-----------------
Host variables:
---------------
No. type flags value
----------------------------
1 decimal 0x000 30601027
Table map :
----------------------------
Internal name Table name
----------------------------
t1 dar
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 0 1 0 00:00.00 1
-------------------- END LOOP -----------------------------------------
