You may be able to resize it, but I doubt it, I think you should archive some of the entries basically. You are on 3.x and you can now get 5.x through jBASE I believe, you are on XP and should probably be looking at Windows 7 now and so on. Technology moves on and while it doesn't usually behoove you to be shipping windows 7 and jBASE 5.x the day after they come out, it does behoove you to keep up with the times.
Generally if you have a single file with 2GB of data in it, it tells you that perhaps your application design is a bit wonky. You could distribute the files, that is true, but then if you try and SELECT from the whole distributed file, you are hammering the system for no good reason (even with indexes in some cases). Does this file not have some sort of archiving scheme, or does your application really need to keep 2GB of written checks altogether in one lump? (Hint: the answer to that is no ;-). Jim > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of jlogdup > Sent: Monday, December 28, 2009 10:54 AM > To: jBASE > Subject: Re: Error 2007 During READNEXT statement > > Thank you Jim, It looks like Is size problem because the file is close > to 2gb: > :JCHECK CHECKWRITER > Checking file CHECKWRITER > WARNING! Record Key length greater than 250 characters, KeyLen > 00180000 > ERROR! Group 46341 Scanning record key, skipping rest of group > ERROR! SeekValue 78015b00 greater then file size 7503d000 > ERROR! Group 82350 Problem with seek value 0000000078015b00, error 0 > ERROR! SeekValue 7503e000 greater then file size 7503d000 > ERROR! Group 98422 Problem with seek value 000000007503e000, error 0 > ERROR! Group 98422 InGroup Reclen exceeds available, skipping rest of > group > ERROR! SeekValue 7503d034 greater then file size 7503d000 > ERROR! Group 175790 Cannot Seek to offset 000000007503d034 > ERROR! Freespace EOF 000000007503d000 incorrect should be > 000000007503f000 > > :jstat -v CHECKWRITER > File .\CHECKWRITER > Type=J4 , Hash method = 4 > Create at Sun May 24 09:01:34 2009 > Groups = 190027 , Frame size = 4096 bytes , Secondary Record Size = > 8192 bytes > Restore re-size parameters : (none) > File size = 1963204608 bytes , Inode = 12833 , Device = Id 47057 > Last Accessed Mon Dec 28 18:47:54 2009 , Last Modified Mon Dec 28 > 18:47:54 2009 > Backup = YES , Log = YES , Rollback = YES , Network = NO > > .\CHECKWRITER: File is corrupt > > > I would need more time to interpret the output of jstat. According to > its output, can I resize this file? or definetly i have to purge and/ > or distribute it? > > > Thanks a lot for your help. > > On Dec 28, 11:24 am, "Jim Idle" <[email protected]> wrote: > > Please remember to use the group search facility at > jbase.markmail.org: > > > > http://jbase.markmail.org/search/?q=error%202007 > > > > Where you will find that your file is corrupt, and may follow all the > threads about repairing/reloading them. > > > > Jim > > > > > > > > > -----Original Message----- > > > From: [email protected] [mailto:[email protected]] On > Behalf > > > Of jlogdup > > > Sent: Monday, December 28, 2009 8:19 AM > > > To: jBASE > > > Subject: Error 2007 During READNEXT statement > > > > > Good Morning, I got the error 2007 during a READNEXT statement: > > > ****************************Error**************************** > > > jBASE: Fatal memory signal seen on process id 7896 > > > jBASE: Because of this, there may be file corruption on file . > > > \CHECKWRITER > > > ** Error [ READNEXT_ERROR ] ** > > > READNEXT operation failed , error number 2007 on file > .\CHECKWRITER > > > ****************************End Error**************************** > > > > > This is something I need to fix with jcheck command, or just the > > > jbackup/jrestore can handle? > > > Thanks in advance for your help. > > > > > Below is the jdiag output > > > ************************************jdiag > > > Result************************************************** > > > :jdiag > > > jdiag - jBASE diagnostic > > > > > System Information > > > ================== > > > > > System : WinXP ICMIAPD01 5.2 i386 > > > OS Release : Win XP Build 3790 Service Pack 2 > > > NT User : encpdadmn > > > jBASE User (JBCLOGNAME) : ADMINISTRATOR > > > Time : Wed Dec 23 11:11:56 2009 > > > > > Environment > > > =========== > > > > > JBCRELEASEDIR : 'E:\JBASE30' > > > JBCGLOBALDIR : 'E:\JBASE30' > > > HOME : 'E:\Pick\ACCOUNTS\SYSPROG' > > > JEDIFILEPATH : '.' > > > JEDIFILENAME_MD : 'E:\Pick\ACCOUNTS\SYSPROG\MD' > > > MD file is (DICT) : 'E:\Pick\ACCOUNTS\SYSPROG\MD]D' > > > JEDIFILENAME_SYSTEM : 'E:\Pick\SYSTEM\SYSTEM' > > > SYSTEM File is (DICT) : 'E:\Pick\SYSTEM\SYSTEM]D' > > > JBCBASETMP : 'e:\JBASE30\tmp\ADMINWORK' > > > JBCNOINTERNAL : Not Set > > > JEDI_NOSHMEM : Not Set > > > RELEASE Information : Major 3.4 , Minor 3 , Patch 0159 > > > Spooler dir (Default) : 'E:\JBASE30\jspooler' > > > JBCEMULATE : 'sequoia' > > > Object path (JBCOBJECTLIST) : 'E:\Pick\ACCOUNTS\SYSPROG\lib;E:\Pick > > > \ACCOUNTS\INS > > > TA-CHECK\lib;E:\Pick\ACCOUNTS\SALES\lib;E:\Pick\ACCOUNTS\JET- > INSTALL > > > \lib;E:\Pick > > > \ACCOUNTS\LIBRARY\lib;E:\Pick\ACCOUNTS\SYSPROG\lib;E:\Pick\ACCOUNTS > > > \ACCUTERM\lib > > > ' > > > VC++ Registry : Version 6; Path C:\Program Files > > > \Microsoft Visual > > > Studio\VC98 > > > Program dir (JBCDEV_BIN) : 'E:\Pick\ACCOUNTS\SYSPROG\bin' > > > Subroutine dir (JBCDEV_LIB) : 'E:\Pick\ACCOUNTS\SYSPROG\lib' > > > There are No warnings, jBASE seems to be loaded correctly > > > > > ************************************End jdiag > > > Result************************************************** > > > > > -- > > > Please read the posting guidelines at: > > >http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > > IMPORTANT: Type T24: at the start of the subject line for questions > > > specific to Globus/T24 > > > > > To post, send email to [email protected] > > > To unsubscribe, send email to [email protected] > > > For more options, visit this group at > > >http://groups.google.com/group/jBASE?hl=en- Hide quoted text - > > > > - Show quoted text - > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
