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

IIUG on Facebook IIUG on Twitter

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

IDS Forum

Re: Page Limit

Posted By: BENJAMIN THOMPSON
Date: Wednesday, 7 November 2018, at 9:38 a.m.

In Response To: Page Limit (DIRK MOOLMAN)

Hi Dirk,

Some options:

1. Follow your plan but add a lot more logical logs to the system beforehand.

2. Compress the table: this requires Advanced Enterprise edition to be compliant with licensing. This option is really only a deferment of the problem.

3. Delete some data :-)

4. You can create a partitioned (fragmented) table with the same schema and then attach the current table to it, provided you can identify a suitable key on which to partition. Use this procedure outlined below at your own risk.

The steps for (4) are:

- Create a new table fragmented by expression with an identical schema to the current one. Identical means same column names in the same order with the same data types and same "not null" constraints. The table must be placed in a dbspace of the same page size.

- The expression-based fragments should be ideally be based on the primary key of the existing. Let's say, for example, the key is a serial, serial8, bigserial or other incrementing id field called "my_id". Find the maximum value of this key in the existing table and create as many expression-based partitions as you need in the new partitioned table based on this key. All these partitions should only accept values greater than the current maximum value, i.e. all the data in the current table must not match the criteria for any of the new fragments. Do not create a remainder fragment for now.

- The new table should not have any constraints of any kind including PK, FK(s) for now except maybe "not null". It should also not have any indices.

- Drop any foreign keys on other tables referencing the original table. Be aware that if these FKs don't have an explicit index supporting them any implicit index will be dropped too.

- Run this to attach the old table to the new partitioned table:
alter fragment on table new_partitioned_table attach old_full_up_table as partition my_existing_data my_id<=CURRENT_MAXIMUM_ID_VALUE;
Docs for this command: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0081.htm

- Rename the new partitioned table to the name of the original table.

- Rebuild your original indices on the new fragmented table. Bear in mind that if you have LOG_INDEX_BUILDS set to 1, you need to make sure you have enough logical log space.

- Re-add your original primary key on the new fragmented table.

- Re-add any FKs on the new fragmented table with the NOVALIDATE option.

- Re-add any FKs on other tables referencing the original table with the NOVALIDATE option.

- Re-add any other constraints with the NOVALIDATE option (12.10.xC7+).

If you do decide to use this procedure I strongly recommend you test it first using a copy of your production schema and some dummy data. Make sure the procedure meets your expectations before proceeding in live.

It may also be possible to do this with range partitioning instead of expression, something to try.

Ben.

Messages In This Thread

  • Page Limit
    DIRK MOOLMAN -- Wednesday, 7 November 2018, at 6:11 a.m.
    • Re: Page Limit
      BENJAMIN THOMPSON -- Wednesday, 7 November 2018, at 9:38 a.m.
      • Re: Page Limit
        DIRK MOOLMAN -- Thursday, 8 November 2018, at 3:49 a.m.
    • Re: Page Limit
      MARK JALKIEWICZ -- Thursday, 8 November 2018, at 10:43 a.m.
    • Re: Page Limit
      ART KAGEL -- Monday, 12 November 2018, at 4:39 p.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.