International Informix Users Group

	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 Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area Forums About IIUG Help

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

IDS Forum

reg: extent size

Posted By:
Date:

hi all,

i have checked the database catalogs uisng oncheck -cc and found many of
our tables have many extents. i think its not good to have smany extents.
awating for valuable suggetions regarding how to redue the extens of
existing tables.

TBLspace ggcl:informix.cng_tran
Physical Address 50404a
Creation date 02/01/02 09:31:23
TBLspace Flags 801 Page Locking
TBLspace use 4 bit bit-maps
Maximum row size 155
Number of special columns 0
Number of keys 3
Number of extents 90
Current serial value 1
First extent size 8
Next extent size 256
Number of pages allocated 15728
Number of pages used 15728
Number of data pages 12359
Number of rows 148290
Partition partnum 5242943
Partition lockid 5242943

Extents
Logical Page Physical Page Size
0 500a49 8
8 515bb9 16
24 517529 8
32 51797d 16
48 51f1f5 16
64 5a2c33 8
72 5a2d2b 8
80 5a2d73 24
104 5a2e03 8
112 5a2e1b 48
160 5a2ee7 24
184 5a2f9f 32
216 5a307f 8
224 5af309 24
248 5af685 384
632 5b007d 232
864 5b0754 496
1360 5ec7be 16
1376 5ec81e 16
1392 5ec9ae 16
1408 5ecbd6 240
1648 5a1061 80
1728 5a12cf 192
1920 5a13a7 48
1968 5a2b9b 144
2112 5a2c3b 16
2128 5eabc2 16
2144 5ec362 16
2160 5ec566 192
2352 5ec666 16
2368 5ec696 128
2496 5a2ddb 16
2512 5a2e4b 64
2576 5a2f0f 128
2704 5a2fbf 192
2896 5a3133 32
2928 5b0944 32
2960 5a2c5b 64
3024 5a2cbb 96
3120 5a2d33 64
3184 5a2d8b 64
3248 5a2e8b 32
3280 5c5850 32
3312 5ea412 32
3344 5eab42 64
3408 5eab92 32
3440 5eb1c2 32
3472 5eb206 32
3504 5ec27e 128
3632 5ec4c6 128
3760 5ec846 192
3952 5ec962 64
4016 5eccc6 64
4080 5ee3fe 64
4144 5eefa8 64
4208 5ef028 448
4656 5ef228 448
5104 91fd55 64
5168 91ff19 64
5232 920151 128
5360 952757 192
5552 920211 64
5616 920279 320
5936 92047d 64
6000 951313 128
6128 95146b 256
6384 951b47 128
6512 951c67 256
6768 951da3 128
6896 9523df 256
7152 952527 128
7280 953477 128
7408 9537d7 128
7536 953955 128
7664 d02e03 128
7792 d02f03 512
8304 d03693 384
8688 953b67 384
9072 953da7 128
9200 95439b 896
10096 9549e7 256
10352 952d93 256
10608 9530c3 256
10864 954cf9 256
11120 954fc7 256
11376 9552b7 512
11888 d0f725 1792
13680 d0ebd5 768
14448 d0efe5 512
14960 d0f2a5 768

Index information.
Number of indexes 3
Data record size 155
Index record size 2048
Number of records 148290

with regards

Nagarjuna.K

Messages In This Thread

reg: extent size
Nagarjuna Kurra -- Thursday, 13 February 2003, at 3:26 a.m.
- Re: reg: extent size
  Martin Fuerderer -- Thursday, 13 February 2003, at 7:15 a.m.
  - Antw: Re: reg: extent size
    Andreas.KUTSCHE@spar.at -- Thursday, 13 February 2003, at 10:36 a.m.
    - RE: Antw: Re: reg: extent size
      Berner, Carl (Carl)** CTR ** -- Thursday, 13 February 2003, at 1:15 p.m.
      - Re: Antw: Re: reg: extent size
        Jack Parker -- Thursday, 13 February 2003, at 1:37 p.m.
        
        RE: Antw: Re: reg: extent size
        Berner, Carl (Carl)** CTR ** -- Thursday, 13 February 2003, at 2:36 p.m.
        
        Re: Antw: Re: reg: extent size
        Jack Parker -- Thursday, 13 February 2003, at 2:54 p.m.
        
        RE: Antw: Re: reg: extent size
        John Carlson -- Thursday, 13 February 2003, at 3:57 p.m.
  - Re: reg: extent size
    Peter van Eck -- Thursday, 13 February 2003, at 10:47 a.m.
    - Re: reg: extent size
      rkusenet -- Thursday, 13 February 2003, at 11:32 a.m.
      - Re: 27/Jun IIUG/IBM Webcast: WebSphere & IDS & 4GL - FULL
        Peter J Diaz de Leon -- Friday, 27 June 2003, at 6:31 a.m.
        
        Re: 27/Jun IIUG/IBM Webcast: WebSphere & IDS & 4GL - FULL
        Mark Scranton -- Friday, 27 June 2003, at 10:59 a.m.
    - RE: reg: extent size
      Sam Gentsch -- Thursday, 13 February 2003, at 12:04 p.m.
    - Re: reg: extent size
      Peter van Eck -- Thursday, 13 February 2003, at 12:11 p.m.
    - Re: reg: extent size
      Martin Fuerderer -- Thursday, 13 February 2003, at 12:41 p.m.
- RE: extent size
  Yarlagadda, Ravi -- Thursday, 13 February 2003, at 9:54 a.m.
- RE: extent size
  John Adamski -- Thursday, 13 February 2003, at 10:16 a.m.
  - Re: dbimport
    ART KAGEL, BLOOMBERG/ 65E 55TH -- Thursday, 26 June 2003, at 8:33 a.m.
    - Re: dbimport
      Peter VAN ECK (DHL BE) -- Thursday, 26 June 2003, at 10:10 a.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.