If this is your first visit, be sure 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.

 
Go Back  dBforums > Database Server Software > Other > Ingres 2.6: Managing dbs with tables bigger than 2 Gb

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-02-06, 10:34
bobyx bobyx is offline
Registered User
 
Join Date: Oct 2006
Posts: 1
Red face Ingres 2.6: Managing dbs with tables bigger than 2 Gb

We are running Ingres 2.6/0305 (rs4.us5/00) patch 9695 on AIX 5.3.x (kernel 32 bit) and we still have problem on managing tables bigger than 2GB. Anyone have some idea ?

We also have checked these series of settings:
- Dbs and working area have at least 20 GB of free space
- The limits of the kernel for ingres and others Dba users are setted correctly, infact we can create hand-made files bigger than 2gb in the dbs & working areas
- The file systems of dbs & working areas are created for managing big files

But when we use ingres for reload tables whose file are bigger than 2 GB we obtain these errors in the errlog.log:

MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM93AF_BAD_PAGE_CNT Wrong number of pages read or
written. At page 1048576, an attempt was made to read or write 16 pages, but only 0 pages were actually processed.
write() failed with operating system error 0 (Error 0)
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM9006_BAD_FILE_WRITE Disk file write error on datab
ase:databaseprod on table:test_table pathname:/database/ingres/data/default/databaseprod filename:a0aaaapu.m00 page:1048576 write() failed with operating system error 0 (Error 0)
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM9335_DM2F_ENDFILE End of file was reached during a read or write operation.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM92F0_DM1X_WRITE_GROUP Error writing a group of pages while building a table or index.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM92E5_DM1X_ALLOCATE Error allocating a page during build.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM92E3_DM1X_NEWPAGE Error allocating new page for build.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM925B_DM1B_BPUT Error occurred adding a record to a Btree table being built.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM9275_DM2R_LOAD Error adding a record to a sort table.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_DM008B_ERROR_PUTTING_RECORD Error trying to put arecord.
MERLDB ::[46741 , 320e2200]: Sun Sep 10 17:40:06 2006 E_QE007D_ERROR_PUTTING_RECORD Error trying to put arecord.

Any help will be very appreciated
Thanks in advance
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On