Informix Error 136 No More Extents
to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: Error: 136 No more extents Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-18-02,23:50 #1 TblXtnt View Profile View Forum Posts Registered User Join Date Mar 2002 Posts 5 Unanswered: Error: 136 No more extents Hi all, I must be overlooking something, I am running Informix730UC5 on solaris 7, I have a table that is around 16.77 million pages (300Million Rows) The row size is 62 bytes and is 15 columns no varchars mostly integers and a char(1) field, which is 17 extents. each extent around 999880 pages. There are 4 indexes they are each one integer column. By all my reckoning I should be able to support 221 extents based on the prevailing knowledge of the calculations of maximum extents ( as confusing as it is, but the two formulae that I have found each yield similar values ). Can anyone advise me as to where I have mis-calculated or give me a clue as to where I have gone wrong in planning this table. Thanks in advance. Confused Reply With Quote 03-19-02,17:38 #2 rnealejr View Profile View Forum Posts Registered User Join Date Feb 2002 Posts 2,232 Since you are only using 17 extents I would check the free space on your chunks. How big are your chunks/extents ??? Reply With Quote 03-19-02,18:08 #3 TblXtnt View Profile View Forum Posts Registered User Join Date Mar 2002 Posts 5 Originally posted by rnealejr Since you are only using 17 extents I would check the free space on your chunks. How big are your chunks/extents ??? I have 40 dbspaces each 2Gb, naturally enough 30 are full, 5 are at around 50% and 5 are completely empty so I have approximately 13Gb free in the instance. There is sufficient space for the creation of the extent and as such the error must be ( as far as I can ascertain ) related to the number of extents. I greatly appreciate any directions that can be suggested. Thanks Reply With Quote 03-21-02,09:14 #4 rnealejr View Profile View Forum Posts Registered User Join Date Feb 2002 Posts 2,232 What are your extent sizes ? Reply With Quote 03-21-02,12:23 #5 townscream View Profile View Forum Posts Registered User Join Date Mar 2002 Posts 19 Please send us : 1) systables information for
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 http://www.dbforums.com/showthread.php?325626-Error-136-No-more-extents 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 - http://members.iiug.org/forums/ids/index.cgi/noframes/read/3937 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
Management Business Intelligence & DW Solutions Jaspersoft Microsoft: SSAS, SSRS, SSIS Netezza View All CRM Integration & Customization Salesforce Infor CRM SugarCRM Microsoft Dynamics Database Support & Management Remote DBA Managed Services Database Professional Services IT Managed Services http://www.xtivia.com/informix-error-136-no-extents/ Database Software Licensing Supported Database Platforms SOA Consulting Technology Transformation Service Architectural Services Event Enterprise & Events Processing Implementation Services Managed Services Digital Experience Solutions Liferay DXP Consulting Hippo CMS Consulting Jahia DXM Consulting View a Free Liferay DXP Demo Blog Company Customers & Partners Customers Success Stories Industries Partners Insights Webinars Innovations About Us Awards & Recognition Leadership Team Vision Events, News & PR XTIVIA Careers Contact Us Today! informix error Informix error -136: “no more extents” December 20, 2012 Barrie Shaw Databases Informix software has a hard limit of 16,777,134 for the number of data pages that can be used in a single table partition. This is true for all versions of Informix software from 7.31 to 11.70. Unfortunately, if you hit this limit, the message that is returned is a misleading “no more extents” error. You can run “oncheck –pt dbname:tablename” to find out informix error 136 if the problem is the number of extents or pages. If the number of used pages is 16,777,215, then you have maxed out on pages. In order to resolve this problem, you can delete data out of the table or fragment the table into multiple partitions. Of course, the time to think about this is before you reach 16.7 million pages, as fragmenting such a large table could mean significant down time for a critical application. The number of allocated pages is just one of the metrics that is tracked by XTIVIA’s Virtual-DBA monitoring service to detect a potential problem before it happens. Facebook Twitter Google+ Pinterest LinkedIn December 20, 2012 Barrie Shaw data page, error -136, informix, limit, no more extents Complete the form to hear from us. Our Latest Posts Step by Step Guide to Migrating a Legacy Liferay MVC portlet to Liferay DXP 7 SharePoint to Liferay Migration Tool Portal-ext Changes in Liferay DXP Migrating to Liferay DXP: Things to Keep In Mind What is a Digital Experience Platform and Why You Need One? Leave a Comment cancel More from our blog See all posts Step by Step Guide to Migrating a Legacy Liferay MVC portlet to Liferay DXP 7 This article is intended to give you an overview of the steps… Continue reading SharePoint to Liferay Migration To