Hi, You mentioned that the STMT.ENTRY file size is 2.56 GB. Jbase supports flat files upto 2GB only. You need to immediately distribute files in your system which are above or approaching 2GB or otherwise archive records of STMT.ENTRY.
Regards, Saud On Wed, Dec 8, 2010 at 11:25 AM, master <[email protected]> wrote: > Thanx. I wanted to do the salvage but then again STMT is one of those > files whereby its all or nothing. > > I have a backup (this is a test environment). Primarily my concern was > how this happened and what I can do to prevent it from happening > again. If this were to happen on the live system I will be doomed. > > You seem to suggest file size as the issue. The file in question is > 2.56 GB in size > > ~ -->du -g ../bnk.data/ac/FBNK.STMT008 > 2.56 ../bnk.data/ac/FBNK.STMT008 > > > On Dec 8, 1:56 am, "Alexey" <[email protected]> wrote: > > Hi there! > > > > Try jcheck -S ../bnk.data/ac/FBNK.STMT008 > > > > And contact TCHD to details about redistribution of large files. > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf > Of > > > > master > > Sent: Tuesday, December 07, 2010 9:52 AM > > To: jBASE > > Subject: jbase File Access Error > > > > Hello people, > > > > Platform: > > > > OS: AIX ver 6 > > > > jBase Version : Major 5.0 , Minor 17 , Patch 0335 (Change 80765) > > > > Problem Description: > > > > Getting Error 2007 when reading STMT.ENTRY file. > > > > ~ -->COUNT FBNK.STMT.ENTRY > > ERROR! Select processing detected key error > > > > jstat FBNK.STMT.ENTRY > > File ../bnk.data/ac/FBNK.STMT008 > > Type=J4 , Hash method = 5 > > Groups = 492251 , Frame size = 4096 bytes , Secondary Record Size = > > 8192 bytes > > > > ../bnk.data/ac/FBNK.STMT008: Error 2007 occurred. > > > > Record Count = 4142640 , Record Bytes = 1669434688 Bytes/Record = 402 , > > Bytes/Group = 3391 > > Primary file space: Total Frames = 618946 , Total Bytes = > > 1669434688 > > Secondary file space: Total Frames = 0 , Total Bytes = 0 > > > > I went ahead and performed a jcheck: > > > > ~ -->jcheck ../bnk.data/ac/FBNK.STMT008 > > > > Checking file ../bnk.data/ac/FBNK.STMT008 ERROR! Group 2 Problem with > seek > > value ffffffff85b26000, error 22 ERROR! Group 2 InGroup Reclen exceeds > > available, skipping rest of group ERROR! Group 12 Problem with seek value > > ffffffff8d0b9000, error 22 ERROR! Group 12 InGroup Reclen exceeds > available, > > skipping rest of group ERROR! Group 15 Problem with seek value > > ffffffff93365000, error 22 ERROR! Group 15 InGroup Reclen exceeds > available, > > skipping rest of group ERROR! Group 16 Problem with seek value > > ffffffff86689000, error 22 ERROR! Group 16 InGroup Reclen exceeds > available, > > skipping rest of group ERROR! Group 25 Problem with seek value > > ffffffff84565000, error 22 ERROR! Group 25 InGroup Reclen exceeds > available, > > skipping rest of group ERROR! Group 30 Problem with seek value > > ffffffff8b1c4000, error 22 ERROR! Group 30 InGroup Reclen exceeds > available, > > skipping rest of group ERROR! Group 33 Problem with seek value > > ffffffff967e1000, error 22 > > > > The log is quite large. This is just a snippet. > > > > My question is, has anyone experienced this before? > > > > What could be the problem and how woud you advise I approach it? > > > > By the way, this does not apply to STMT.ENTRY only. There are other files > > affected as well. > > > > -- > > 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 athttp:// > 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 > -- 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
