- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Informix 7.23 on HPUX 10.20 has maximum record...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 08:17 PM
тАО11-14-2003 08:17 PM
On of the table reached 19.7 million record, the table can not be added with error message "can not add new extent" informix error 136. The Disk allocation is 8 GB and the table size at 19.7 million record is 5.1 GB.
The number of extend is 2.
Why the extents can not be added?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2003 06:47 PM
тАО11-16-2003 06:47 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
dbspace in which the table resides.
do an onstat -d and take a look at the 'free' value for dbspace where the table resides.
The extend that INFORMIX wishes to allocate for the table must be bigger than the free space in the dbspace.
Add a new chunk to the dbspace and off you go.
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2003 01:35 PM
тАО11-17-2003 01:35 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
Actually I still have large free space for the new extents and you can see in the report that the chunk 22 for data and chunk 23 for index.
Thank you for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2003 07:02 PM
тАО11-17-2003 07:02 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
Then you will see if this extend will fit in the space.
databases sysmaster;
select nextsize from systables where tabname =
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2003 07:49 PM
тАО11-17-2003 07:49 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
I run dbaccess to get the report as attach.
It seem that the space is enough since the next size is 32.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2003 09:49 PM
тАО11-30-2003 09:49 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
have you checked the number of extents you have on your indices?
Please run the statement
oncheck -pt
Attach the result, maybe I see the problem.
Uli
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 12:00 PM
тАО12-01-2003 12:00 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
I run the oncheck as you suggested and I
attached the file. Please help me.
Best regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 05:15 PM
тАО12-01-2003 05:15 PM
Solutionwhat I see is that there are a lot of extents on your indices, the Baan-System tries to insert a row and the database can not add an extent for one of your Indices. I had the same problems here with Baan and Informix. So it is the best way to recreate the indices.
On the first Index you have 197 on the second 227 and on the third you have 229. So I think it is the best to recreate all of them. When I have done this, I run the dbschema to see how the table and the indices are defined. Then drop the index and create it new.
But you need downtime for this, because the table is locked when you create the index. For another table with more then 30 Mio. rows we need on a HP N-Class more than 4 hours. It is the best way to do this over a weekend. If possible try it on a test system or test table. For my interest, do you run Baan on Informix in level 1 or level 2 Mode.
I hope this helps you.
Uli
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2004 09:15 PM
тАО01-12-2004 09:15 PM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
Thanks for the help. It takes me sometime to figure out how to change the indices. I tried to change the inf_storage but it does not work. I dump the table and recreate with dump but I get the same number of extent for index. Could you assist me in reorganizing my databases so that the extent number can be smaller.
Thanks & regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2004 04:15 AM
тАО01-13-2004 04:15 AM
Re: Informix 7.23 on HPUX 10.20 has maximum record.
to change the inf_storage helps you only for the extents of the table itself. Normaly it is enough to drop the index and recreate it. The reason for this is that informix does not how many row you have in the table at the end when you load the data.
The dbschema-comand from informix genterates an sql-systax for any table to create with all the indices (dbschema -d