Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

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

IDS Forum

Re: Performance issue after 732 to 94fc6 upgrade p

Posted By: Doug Fossmeyer
Date: Monday, 12 June 2006, at 8:03 p.m.

In Response To: Re: Performance issue after 732 to 94fc6 upgrade (ART KAGEL, BLOOMBERG/ 731 LEXIN)

Part 3

onstat -g prc

IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days 19:59:37 -- 2325280 Kbytes

UDR Cache:

Number of lists : 31

PC_POOLSIZE : 127

UDR Cache Entries:

list# id ref_cnt dropped? heap_ptr udr name
--------------------------------------------------------------
11 231 0 0 c00000008f0acbc0 ifasdev2@online9:.getuniquekey2
11 1 0 0 c00000008fef7438 ifasdev2@online9:.indexkeyarray_out
21 230 0 0 c00000008fa82838 ifasdev2@online9:.getuserid
26 3 0 0 c00000008f777438 ifasdev2@online9:.ikeyextractcolno
27 229 0 0 c00000008f97d650 ifasdev2@online9:.setuserid

Total number of udr entries: 5.

Number of entries in use : 0

onstat -g cac

IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days 19:59:52 -- 2325280 Kbytes

UDR Cache:

Number of lists : 31

PC_POOLSIZE : 127

UDR Cache Entries:

list# id ref_cnt dropped? heap_ptr udr name
--------------------------------------------------------------
11 231 0 0 c00000008f0acbc0 ifasdev2@online9:.getuniquekey2
11 1 0 0 c00000008fef7438 ifasdev2@online9:.indexkeyarray_out
21 230 0 0 c00000008fa82838 ifasdev2@online9:.getuserid
26 3 0 0 c00000008f777438 ifasdev2@online9:.ikeyextractcolno
27 229 0 0 c00000008f97d650 ifasdev2@online9:.setuserid

Total number of udr entries: 5.

Number of entries in use : 0

Resolved Routine Cache:

Number of lists : 31

DS_POOLSIZE : 127

Resolved Routine Cache Entries:

list# id ref_cnt dropped? heap_ptr udr name
--------------------------------------------------------------
2 0 0 0 c00000008feaa438 ifasdev2@online9:.greaterthan
2 0 0 0 c00000008feaa038 ifasdev2@online9:.greaterthan
4 0 0 0 c00000008f6ef838 ifasdev2@online9:.lessthanorequal
4 0 0 0 c00000008fa51438 ifasdev2@online9:.lessthanorequal
10 0 0 0 c00000008fa51838 ifasdev2@online9:.greaterthanorequal
10 0 0 0 c00000008feaac38 ifasdev2@online9:.greaterthanorequal
12 0 0 0 c00000008fa51038 ifasdev2@online9:.notequal
12 0 0 0 c00000008fa7a838 ifasdev2@online9:.notequal
15 0 0 0 c00000008fa7a438 ifasdev2@online9:.matches
15 0 0 0 c00000008fa7a038 ifasdev2@online9:.matches
18 0 0 0 c00000008feaa838 ifasdev2@online9:.lessthan
18 0 0 0 c00000008f6efc38 ifasdev2@online9:.lessthan
29 0 0 0 c00000008fa7ac38 ifasdev2@online9:.setuserid

Total number of resolved routine entries: 13.

Number of entries in use : 0

Distribution Cache:

Number of lists : 31

DS_POOLSIZE : 127

Distribution Cache Entries:

list# id ref_cnt dropped? heap_ptr distribution name
-----------------------------------------------------------------

0 0 0 0 c00000008f6f8838 ifasdev2:bsi.
0 0 0 0 c00000008fa6c838 ifasdev2:bsi.
1 0 0 0 c00000008f9dfc38 ifasdev2:bsi.
1 0 0 0 c00000008f849838 ifasdev2:bsi.
1 0 0 0 c00000008fb01038 ifasdev2:bsi.
2 0 0 0 c00000008f96e438 ifasdev2:bsi.
2 0 0 0 c00000008fb21c38 ifasdev2:bsi.
2 0 0 0 c00000008f87e438 ifasdev2:bsi.
3 0 0 0 c00000008f7ad038 ifasdev2:bsi.
3 0 0 0 c00000008fb39438 ifasdev2:bsi.
3 0 0 0 c00000008fb1cc38 ifasdev2:bsi.
4 0 0 0 c00000008fd93838 ifasdev2:bsi.
4 0 0 0 c00000008f7fc438 ifasdev2:bsi.
4 0 0 0 c00000008fafb838 ifasdev2:bsidba.
5 0 0 0 c00000008f7ae438 ifasdev2:bsi.
5 0 0 0 c00000008fbfe038 ifasdev2:bsidba.
5 0 0 0 c00000008f888838 ifasdev2:bsi.
6 0 0 0 c00000008f8e1438 ifasdev2:bsi.
6 0 0 0 c00000008f881038 ifasdev2:bsi.
6 0 0 0 c00000008fd49038 ifasdev2:bsidba.
7 0 0 0 c00000008f6b1438 ifasdev2:bsi.
7 0 0 0 c00000008fb25c38 ifasdev2:bsidba.
7 0 0 0 c00000008f8bc038 ifasdev2:bsi.
8 0 0 0 c00000008f874038 ifasdev2:bsi.
8 0 0 0 c00000008f7ad438 ifasdev2:bsi.
8 0 0 0 c00000008fa5a838 ifasdev2:bsi.
9 0 0 0 c00000008f5e2038 ifasdev2:bsidba.
9 0 0 0 c00000008fc14438 ifasdev2:bsi.
9 0 0 0 c00000008f7d3838 ifasdev2:bsi.
10 0 0 0 c00000008f887438 ifasdev2:bsidba.
10 0 0 0 c00000008fa20038 ifasdev2:bsi.
11 0 0 0 c00000008fa67438 ifasdev2:bsi.
11 0 0 0 c00000008f6edc38 ifasdev2:bsi.
11 0 0 0 c00000008f8d8c38 ifasdev2:bsi.
12 0 0 0 c00000008fb41838 ifasdev2:bsidba.
12 0 0 0 c00000008f71d038 ifasdev2:bsi.
13 0 0 0 c00000008fb2e438 ifasdev2:bsidba.
13 0 0 0 c00000008ff63038 ifasdev2:bsi.
13 0 0 0 c00000008fc7d838 ifasdev2:bsi.
14 0 0 0 c00000008fd10438 ifasdev2:bsi.
14 0 0 0 c00000008f91a438 ifasdev2:bsi.
14 0 0 0 c00000008f734c38 ifasdev2:bsi.
15 0 0 0 c00000008f726038 ifasdev2:bsi.
15 0 0 0 c00000008f8ef838 ifasdev2:bsi.
16 0 0 0 c00000008f6cd438 ifasdev2:bsidba.
16 0 0 0 c00000008f6f3838 ifasdev2:bsi.
16 0 0 0 c00000008fa9bc38 ifasdev2:bsi.
17 0 0 0 c00000008f843838 ifasdev2:bsi.
17 0 0 0 c00000008f68ec38 ifasdev2:bsi.
17 0 0 0 c00000008f7b6038 ifasdev2:bsi.
18 0 0 0 c00000008fd1f438 ifasdev2:bsi.
18 0 0 0 c00000008f962438 ifasdev2:bsi.
19 0 0 0 c00000008fa68038 ifasdev2:bsi.
19 0 0 0 c00000008fb34038 ifasdev2:bsi.
19 0 0 0 c00000008ff70038 ifasdev2:bsi.
20 0 0 0 c00000008fb34438 ifasdev2:bsi.
20 0 0 0 c00000008fb41438 ifasdev2:bsi.
20 0 0 0 c00000008fa52038 ifasdev2:bsidba.
21 0 0 0 c00000008fd10838 ifasdev2:bsi.
21 0 0 0 c00000008f9a2838 ifasdev2:bsi.
21 0 0 0 c00000008f8e5438 ifasdev2:bsidba.
22 0 0 0 c00000008fb34838 ifasdev2:bsi.
22 0 0 0 c00000008fb2ec38 ifasdev2:bsidba.
22 0 0 0 c00000008f874438 ifasdev2:bsi.
23 0 0 0 c00000008fda9038 ifasdev2:bsi.
23 0 0 0 c00000008fe80838 ifasdev2:bsi.
23 0 0 0 c00000008f962838 ifasdev2:bsi.
24 0 0 0 c00000008f906438 ifasdev2:bsi.
24 0 0 0 c00000008f9ed038 ifasdev2:bsidba.
24 0 0 0 c00000008f68e838 syscat:bsi.
25 0 0 0 c00000008f887038 ifasdev2:bsidba.
25 0 0 0 c00000008fdb5838 ifasdev2:bsi.
26 0 0 0 c00000008f784c38 ifasdev2:bsidba.
26 0 0 0 c00000008f957038 ifasdev2:bsi.
26 0 0 0 c00000008fa20438 ifasdev2:bsidba.
27 0 0 0 c00000008fa61438 ifasdev2:bsi.
27 0 0 0 c00000008f71a838 ifasdev2:bsi.
28 0 0 0 c00000008f686438 ifasdev2:bsi.
28 0 0 0 c00000008f906838 ifasdev2:bsidba.
28 0 0 0 c00000008fb21438 ifasdev2:bsidba.
29 0 0 0 c00000008f7b2c38 ifasdev2:bsi.
29 0 0 0 c00000008f6f9c38 ifasdev2:bsi.
29 0 0 0 c00000008f9c8038 ifasdev2:bsi.
30 0 0 0 c00000008fd93038 ifasdev2:bsi.
30 0 0 0 c00000008f7d3038 ifasdev2:bsi.

Total number of distribution entries: 85.

Number of entries in use : 0

Extended Type Name Cache:

Number of lists : 31

DS_POOLSIZE : 127

Extended Type Name Cache Entries:

list# id ref_cnt dropped? heap_ptr item
--------------------------------------------------------------
1 7 2 0 c00000008f74b838 ifasdev2@online9:informix.indexkeyarray (40,7)
3 1 1 0 c00000008f74bc38 ifasdev2@online9:informix.lvarchar (40,1)

Total number of entries: 2.

Number of entries in use : 2

Extended Type ID Cache:

Number of lists : 31

DS_POOLSIZE : 127

Extended Type ID Cache Entries:

list# id ref_cnt dropped? heap_ptr item
--------------------------------------------------------------

12 7 0 0 c00000008f74b038 ifasdev2@online9:informix.indexkeyarray (40,7)

19 1 0 0 c00000008f74b438 ifasdev2@online9:informix.lvarchar (40,1)

Total number of entries: 2.

Number of entries in use : 0

Cast Cache:

Number of lists : 31

DS_POOLSIZE : 127

Cast Cache Entries:

list# id ref_cnt dropped? heap_ptr item
--------------------------------------------------------------

0 0 0 0 c00000008f6e6c38 ifasdev2@online9:. (7,0):(16,0) S

2 0 1 0 c00000008f8ccc38 ifasdev2@online9:. (0,0):(10,0) S

2 0 0 0 c00000008f84b838 ifasdev2@online9:. (13,0):(15,0)

3 0 0 0 c00000008f5ec038 ifasdev2@online9:. (7,0):(1,0) S

5 0 0 0 c00000008f84b438 ifasdev2@online9:. (13,0):(0,0) S

7 0 0 0 c00000008f5ecc38 ifasdev2@online9:. (7,0):(4,0) S

9 0 0 0 c00000008f6e6438 ifasdev2@online9:. (7,0):(15,0) S

10 0 0 0 c00000008f84bc38 syscat@online9:. (0,0):(2,0) S

10 0 0 0 c00000008f0c1670 ifasdev2@online9:. (0,0):(2,0) S

11 0 1 0 c00000008f8cc438 ifasdev2@online9:. (10,0):(7,0) S

12 0 0 0 c00000008f6e6038 ifasdev2@online9:. (7,0):(0,0) S

16 0 0 0 c00000008f8cc038 ifasdev2@online9:. (7,0):(3,0) S

18 0 0 0 c00000008f84b038 ifasdev2@online9:. (13,0):(2,0) S

18 0 0 0 c00000008f775038 ifasdev2@online9:. (40,7):(40,1) E

22 0 0 0 c00000008f5ec438 ifasdev2@online9:. (7,0):(17,0) S

25 0 0 0 c00000008f0c1a70 ifasdev2@online9:. (7,0):(2,0) S

27 0 0 0 c00000008f6e6838 ifasdev2@online9:. (7,0):(13,0) S

29 0 1 0 c00000008f8cc838 ifasdev2@online9:. (0,0):(7,0) S

29 0 0 0 c00000008f5ec838 ifasdev2@online9:. (7,0):(5,0) S

Total number of entries: 19.

Number of entries in use : 3

Opclass Instance Cache:

Number of lists : 31

DS_POOLSIZE : 127

Opclass Instance Cache Entries:

list# id ref_cnt dropped? heap_ptr item
--------------------------------------------------------------

0 0 2 0 c00000008f802038 ifasdev2@online9:. (btree_ops):(5,1) (2,0)

0 0 0 0 c00000008fae7038 syscat@online9:. (btree_ops):(5,1) (2,0)

2 0 0 0 c00000008f802838 ifasdev2@online9:. (btree_ops):(5,1) (13,0)

2 0 0 0 c00000008f6ad838 sysmaster@online9:. (btree_ops):(5,1) (13,0)

2 0 0 0 c00000008f6ad438 ifasdev@online9:. (btree_ops):(5,1) (13,0)

9 0 5 0 c00000008f0dba70 ifasdev2@online9:. (btree_ops):(5,1) (1,0)

18 0 6 0 c00000008f0db670 ifasdev2@online9:. (btree_ops):(5,1) (0,0)

18 0 0 0 c00000008fae7438 ifashrpy@online9:. (btree_ops):(5,1) (0,0)

18 0 0 0 c00000008f6ad038 syscat@online9:. (btree_ops):(5,1) (0,0)

19 0 5 0 c00000008f802438 ifasdev2@online9:. (btree_ops):(5,1) (7,0)

26 0 0 0 c00000008f802c38 ifasdev2@online9:. (btree_ops):(5,1) (6,0)

26 0 0 0 c00000008fae7c38 sysmaster@online9:. (btree_ops):(5,1) (6,0)

26 0 0 0 c00000008f6adc38 ifasdev@online9:. (btree_ops):(5,1) (6,0)

Total number of entries: 13.

Number of entries in use : 4

Access Method Cache:

Access Method Cache Entries:

Secondary Access Method: sysmaster@online9:informix.btree

Secondary Access Method: syscat@online9:informix.btree

Secondary Access Method: ifasdev@online9:informix.btree

Secondary Access Method: ifashrpy@online9:informix.btree

Secondary Access Method: ifasdev2@online9:informix.btree

Total number of entries: 5.

Statement Cache Summary:
#lrus currsize maxsize Poolsize #hits nolimit
6 0 524288 12288 0 0

Statement Cache Entries:

lru hash ref_cnt hits flag heap_ptr database user
--------------------------------------------------------------------------------

Stmt Cache is empty.

User-defined Aggregate Cache:

Number of lists : 31

DS_POOLSIZE : 127

User-defined Aggregate Cache Entries:

list# id ref_cnt dropped? heap_ptr item
--------------------------------------------------------------

User-defined Aggregate Cache is empty.

DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.FC2
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number AAA#B000000
{

Distribution for bsidba.retwahst.compdefer

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)
1: ( 4505, 4018, 126.76)
2: ( 4505, 3105, 161.64)
3: ( 4505, 3531, 659.43)
4: ( 4505, 4262, 2661.54)
5: ( 4505, 4018, 4648.32)
6: ( 3714, 3044, 8438.03)

--- OVERFLOW ---

1: ( 152577, 0.00)
2: ( 1583, 179.80)

Distribution for bsidba.retwahst.compearn

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)
1: ( 4512, 4018, 101.96)
2: ( 4512, 3166, 145.69)
3: ( 4512, 3044, 200.44)
4: ( 4512, 3714, 366.66)
5: ( 4512, 4323, 660.44)
6: ( 4512, 4384, 960.65)
7: ( 4512, 4384, 1190.23)
8: ( 4512, 4384, 1378.83)
9: ( 4512, 4079, 1553.30)
10: ( 4512, 4384, 1711.31)
11: ( 4512, 4201, 1832.88)
12: ( 4512, 4201, 1970.65)
13: ( 4512, 3957, 2089.40)
14: ( 4512, 4384, 2254.28)
15: ( 4512, 3592, 2466.05)
16: ( 4512, 3957, 2637.51)
17: ( 4512, 4079, 2791.36)
18: ( 4512, 3897, 2976.61)
19: ( 4512, 3470, 3175.85)
20: ( 4512, 3531, 3397.73)
21: ( 4512, 3897, 3569.59)
22: ( 4512, 3897, 3793.50)
23: ( 4512, 3714, 3963.45)
24: ( 4512, 4079, 4187.10)
25: ( 4512, 4079, 4398.65)
26: ( 4512, 4018, 4648.32)
27: ( 4512, 3288, 4844.71)
28: ( 4512, 3836, 5063.61)
29: ( 4512, 3714, 5403.81)
30: ( 4512, 4201, 5757.26)
31: ( 4512, 3470, 6074.95)
32: ( 4512, 3166, 6357.35)
33: ( 4512, 3166, 6607.18)
34: ( 4512, 2679, 6921.15)
35: ( 4512, 2740, 7151.23)
36: ( 4512, 2253, 7412.76)
37: ( 4512, 2922, 7895.00)
38: ( 4512, 3531, 9925.91)
39: ( 1827, 1400, 16090.84)

--- OVERFLOW ---

1: ( 4749, 0.00)
2: ( 2374, 179.80)

Distribution for bsidba.retwahst.comppaid

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)
1: ( 4521, 4079, 100.53)
2: ( 4521, 3288, 141.42)
3: ( 4521, 3044, 192.14)
4: ( 4521, 3897, 310.92)
5: ( 4521, 4262, 570.08)
6: ( 4521, 4384, 863.05)
7: ( 4521, 4445, 1099.65)
8: ( 4521, 4384, 1316.30)
9: ( 4521, 3957, 1483.22)
10: ( 4521, 4262, 1674.85)
11: ( 4521, 4262, 1808.14)
12: ( 4521, 4384, 1952.73)
13: ( 4521, 4018, 2082.43)
14: ( 4521, 4323, 2261.48)
15: ( 4521, 3592, 2476.89)
16: ( 4521, 3957, 2659.48)
17: ( 4521, 3897, 2805.48)
18: ( 4521, 3775, 3015.77)
19: ( 4521, 3897, 3265.91)
20: ( 4521, 3531, 3475.04)
21: ( 4521, 3775, 3674.00)
22: ( 4521, 3957, 3885.17)
23: ( 4521, 4140, 4130.82)
24: ( 4521, 4018, 4361.31)
25: ( 4521, 4140, 4648.32)
26: ( 4521, 3288, 4836.89)
27: ( 4521, 3836, 5101.43)
28: ( 4521, 3836, 5461.28)
29: ( 4521, 4018, 5827.73)
30: ( 4521, 3410, 6164.90)
31: ( 4521, 2679, 6415.84)
32: ( 4521, 2862, 6662.64)
33: ( 4521, 2983, 7039.54)
34: ( 4521, 2314, 7247.66)
35: ( 4521, 3105, 7826.19)
36: ( 4521, 3470, 9925.91)
37: ( 1827, 1279, 16090.84)

--- OVERFLOW ---

1: ( 13455, 0.00)
2: ( 2374, 179.80)

Distribution for bsidba.retwahst.compreport

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)

--- OVERFLOW ---

1: ( 180401, 0.00)

Distribution for bsidba.retwahst.cont

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)
1: ( 4505, 3349, 3.64)
2: ( 4505, 1948, 4.95)
3: ( 4505, 3470, 26.45)
4: ( 4505, 3592, 142.21)
5: ( 122, 122, 155.54)

--- OVERFLOW ---

1: ( 159822, 0.00)
2: ( 2435, 5.25)

Distribution for bsidba.retwahst.contdefer

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( NULL)

--- OVERFLOW ---

1: ( 180401, NULL)

Distribution for bsidba.retwahst.contreport

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)

--- OVERFLOW ---

1: ( 180401, 0.00)

Distribution for bsidba.retwahst.creation

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 2006-06-06 20:52:03)
1: ( 4505, 4445, 2006-06-06 21:10:42)
2: ( 4505, 4323, 2006-06-06 21:31:59)
3: ( 4505, 4445, 2006-06-06 21:51:30)
4: ( 4505, 4262, 2006-06-06 22:13:46)
5: ( 4505, 4262, 2006-06-06 22:44:31)
6: ( 4505, 4505, 2006-06-06 23:13:52)
7: ( 4505, 4323, 2006-06-06 23:33:35)
8: ( 4505, 4505, 2006-06-06 23:59:00)
9: ( 4505, 4445, 2006-06-07 00:30:08)
10: ( 4505, 4384, 2006-06-07 00:52:11)
11: ( 4505, 4323, 2006-06-07 01:18:06)
12: ( 4505, 4445, 2006-06-07 01:43:20)
13: ( 4505, 4262, 2006-06-07 02:02:27)
14: ( 4505, 4079, 2006-06-07 02:24:52)
15: ( 4505, 4445, 2006-06-07 02:45:11)
16: ( 4505, 4445, 2006-06-07 03:07:09)
17: ( 4505, 4323, 2006-06-07 03:28:17)
18: ( 4505, 4262, 2006-06-07 03:53:44)
19: ( 4505, 4505, 2006-06-07 04:09:39)
20: ( 4505, 4384, 2006-06-07 04:25:04)
21: ( 4505, 4445, 2006-06-07 04:41:26)
22: ( 4505, 4445, 2006-06-07 04:56:01)
23: ( 4505, 4445, 2006-06-07 05:11:12)
24: ( 4505, 4384, 2006-06-07 05:26:52)
25: ( 4505, 4505, 2006-06-07 05:40:46)
26: ( 4505, 4262, 2006-06-07 05:56:49)
27: ( 4505, 4445, 2006-06-07 06:13:20)
28: ( 4505, 4384, 2006-06-07 06:30:20)
29: ( 4505, 4445, 2006-06-07 06:47:17)
30: ( 4505, 4445, 2006-06-07 07:05:07)
31: ( 4505, 4505, 2006-06-07 07:22:17)
32: ( 4505, 4323, 2006-06-07 07:40:24)
33: ( 4505, 4445, 2006-06-07 07:59:50)
34: ( 4505, 4445, 2006-06-07 08:19:40)
35: ( 4505, 4384, 2006-06-07 08:42:05)
36: ( 4505, 4323, 2006-06-07 09:00:50)
37: ( 4505, 4384, 2006-06-07 09:23:16)
38: ( 4505, 4505, 2006-06-07 09:43:04)
39: ( 4505, 4505, 2006-06-07 10:01:56)
40: ( 4505, 4505, 2006-06-07 10:18:05)
41: ( 183, 183, 2006-06-07 10:18:43)

Distribution for bsidba.retwahst.days

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.0)
1: ( 4505, 1400, 18.7)
2: ( 1705, 1157, 32.0)

--- OVERFLOW ---

1: ( 167676, 0.0)
2: ( 1766, 19.0)
3: ( 1218, 20.0)
4: ( 1887, 21.0)
5: ( 1644, 23.0)

Distribution for bsidba.retwahst.daysreport

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.0)

--- OVERFLOW ---

1: ( 180401, 0.0)

Distribution for bsidba.retwahst.ded

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)
1: ( 4505, 3653, 6.41)
2: ( 4505, 3288, 10.61)
3: ( 4505, 2740, 17.98)
4: ( 4505, 4262, 141.64)
5: ( 2435, 2192, 728.19)

--- OVERFLOW ---

1: ( 159944, 0.00)

Distribution for bsidba.retwahst.deddefer

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( NULL)

--- OVERFLOW ---

1: ( 180401, NULL)

Distribution for bsidba.retwahst.dedreport

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.00)

--- OVERFLOW ---

1: ( 180401, 0.00)

Distribution for bsidba.retwahst.earnper

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 200208 )
1: ( 3227, 365, 200607 )

--- OVERFLOW ---

1: ( 2801, 200209 )
2: ( 2679, 200210 )
3: ( 3714, 200211 )
4: ( 3653, 200212 )
5: ( 3470, 200301 )
6: ( 3775, 200302 )
7: ( 3470, 200303 )
8: ( 3044, 200304 )
9: ( 3410, 200305 )
10: ( 3227, 200306 )
11: ( 3105, 200308 )
12: ( 3653, 200309 )
13: ( 3166, 200310 )
14: ( 3288, 200311 )
15: ( 3470, 200312 )
16: ( 3897, 200401 )
17: ( 2801, 200402 )
18: ( 4323, 200403 )
19: ( 3044, 200404 )
20: ( 2983, 200405 )
21: ( 4262, 200406 )
22: ( 1522, 200408 )
23: ( 3410, 200409 )
24: ( 4932, 200410 )
25: ( 3836, 200411 )
26: ( 3897, 200412 )
27: ( 3775, 200501 )
28: ( 4627, 200502 )
29: ( 3410, 200503 )
30: ( 3288, 200504 )
31: ( 4018, 200505 )
32: ( 3470, 200506 )
33: ( 6758, 200509 )
34: ( 6393, 200510 )
35: ( 5845, 200511 )
36: ( 5480, 200512 )
37: ( 5419, 200601 )
38: ( 5480, 200602 )
39: ( 6636, 200603 )
40: ( 6271, 200604 )
41: ( 7915, 200605 )
42: ( 9559, 200606 )

Distribution for bsidba.retwahst.empid

Constructed on 06/12/2006

High Mode, 0.500000 Resolution

--- DISTRIBUTION ---

( 100001 )

1: ( 903, 21, 100059 )

2: ( 903, 21, 100138 )

3: ( 903, 20, 100199 )

4: ( 903, 20, 100258 )

5: ( 903, 20, 100310 )

6: ( 903, 21, 100384 )

7: ( 903, 22, 100446 )

8: ( 903, 20, 100524 )

9: ( 903, 23, 100591 )
10: ( 903, 20, 100645 )
snip
190: ( 903, 69, 121518 )
191: ( 903, 62, 121693 )
192: ( 903, 51, 121825 )
193: ( 903, 51, 121903 )
194: ( 903, 81, 122044 )
195: ( 903, 95, 122247 )
196: ( 903, 105, 122416 )
197: ( 903, 118, 122591 )
198: ( 903, 73, 122678 )
199: ( 903, 231, 122975 )
200: ( 770, 260, 123300 )

Distribution for bsidba.retwahst.fiscalyear

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( NULL)

--- OVERFLOW ---

1: ( 180401, NULL)

Distribution for bsidba.retwahst.hours

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.0)
1: ( 4556, 3227, 28.0)
2: ( 4556, 1887, 48.0)
3: ( 4556, 2070, 66.5)
4: ( 4556, 1583, 79.8)
5: ( 4556, 1766, 96.0)
6: ( 4556, 1522, 106.4)
7: ( 4556, 1522, 115.5)
8: ( 4556, 2009, 129.6)
9: ( 4556, 1339, 136.7)
10: ( 4556, 2253, 152.0)
11: ( 4556, 2740, 165.7)
12: ( 4556, 3592, 237.8)
13: ( 244, 244, 252.4)

--- OVERFLOW ---

1: ( 39210, 0.0)
2: ( 1279, 7.0)
3: ( 1948, 63.0)
4: ( 4445, 84.0)
5: ( 1279, 91.0)
6: ( 3653, 105.0)
7: ( 1705, 112.0)
8: ( 3288, 119.0)
9: ( 1644, 120.0)
10: ( 4079, 126.0)
11: ( 12908, 133.0)
12: ( 1218, 138.0)
13: ( 3288, 140.0)
14: ( 7976, 147.0)
15: ( 2009, 154.0)
16: ( 4079, 160.0)
17: ( 7306, 161.0)
18: ( 6819, 168.0)
19: ( 11872, 176.0)
20: ( 5480, 184.0)

Distribution for bsidba.retwahst.hoursrpt

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0.0)

--- OVERFLOW ---

1: ( 180401, 0.0)

Distribution for bsidba.retwahst.lock_flag

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( NULL)

--- OVERFLOW ---

1: ( 180401, NULL)

Distribution for bsidba.retwahst.plancode

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( 0 )

--- OVERFLOW ---

1: ( 8889, 0 )
2: ( 20883, 1 )
3: ( 38783, 2 )
4: ( 111845, 3 )

Distribution for bsidba.retwahst.reportper

Constructed on 06/12/2006

High Mode, 0.500000 Resolution

--- DISTRIBUTION ---

( 000000 )

--- OVERFLOW ---

1: ( 154599, 000000 )
2: ( 25802, 200606 )

Distribution for bsidba.retwahst.statuscode

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( A )
1: ( 609, 61, G )

--- OVERFLOW ---

1: ( 178148, A )
2: ( 1644, B )

Distribution for bsidba.retwahst.system

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( ? )
1: ( 61, 61, T )

--- OVERFLOW ---

1: ( 66242, E )
2: ( 5601, P )
3: ( 108496, T )

Distribution for bsidba.retwahst.warn

Constructed on 06/12/2006

Medium Mode, 2.500000 Resolution, 0.950000 Confidence

--- DISTRIBUTION ---

( )
1: ( 61, 61, Repd )

--- OVERFLOW ---

1: ( 21249, )
2: ( 1644, B )
3: ( 3105, OHrs )
4: ( 154342, Repd )

Distribution for bsidba.retwahst.unique_key

Constructed on 06/12/2006

High Mode, 0.500000 Resolution

--- DISTRIBUTION ---

( pattyn-060606-20:51:54-1 )

1: ( 902, 902, pattyn-060606-20:55:09-902 )

2: ( 902, 902, pattyn-060606-20:58:03-1804 )

3: ( 902, 902, pattyn-060606-21:00:57-2706 )

4: ( 902, 902, pattyn-060606-21:05:39-3608 )

5: ( 902, 902, pattyn-060606-21:09:58-4510 )

6: ( 902, 902, pattyn-060606-21:14:28-5412 )

7: ( 902, 902, pattyn-060606-21:18:14-6314 )

8: ( 902, 902, pattyn-060606-21:23:52-7216 )

9: ( 902, 902, pattyn-060606-21:28:30-8118 )
10: ( 902, 902, pattyn-060606-21:31:58-9020 )
snip--
199: ( 902, 902, pattyn-060607-10:15:36-179498 )
200: ( 902, 902, pattyn-060607-10:18:47-180400 )
201: ( 1, 1, pattyn-060607-10:18:47-180401 )

}

Messages In This Thread

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

IDS Forum is maintained by Administrator with WebBBS 5.12.