Thank you for your ideas, but i believe something is definitely wrong here.
You said that the citeriea for a badly sized file is the following condition: Total Frames > Groups Allocated. Ok, i calculated the new modulo and re-sized the file, check it out: jsh ~ -->jstat -v F.LOCKING File ../bnk.data/eb/F.LOCKING Type=J4 , Hash method = 5 Created at Wed Jan 6 19:45:35 2010 Groups = *1629 *, Frame size = 8192 bytes , Secondary Record Size = 16384 bytes Restore re-size parameters : (none) File size = 16457728 bytes , Inode = 2272742 , Device = Id 9223372217243402242 Last Accessed Wed Mar 3 08:30:39 2010 , Last Modified Wed Mar 3 08:30:39 2010 Backup = YES , Log = YES , Rollback = YES , Network = AUTO Record Count = 24206 , Record Bytes = 10265821 Bytes/Record = 424 , Bytes/Group = 6301 Primary file space: Total Frames = *1950 *, Total Bytes = 9840132 Secondary file space: Total Frames = 56 , Total Bytes = 425689 jsh ~ -->jrf -ES*3261*,2 F.LOCKING jsh ~ -->jstat -v F.LOCKING File ../bnk.data/eb/F.LOCKING Type=J4 , Hash method = 5 Created at Wed Mar 3 08:32:26 2010 Groups = *3261 *, Frame size = 8192 bytes , Secondary Record Size = 16384 bytes Restore re-size parameters : (none) File size = 27828224 bytes , Inode = 2295685 , Device = Id 9223372217243402242 Last Accessed Wed Mar 3 08:32:27 2010 , Last Modified Wed Mar 3 08:32:27 2010 Backup = YES , Log = YES , Rollback = YES , Network = AUTO Record Count = 24206 , Record Bytes = 10265821 Bytes/Record = 424 , Bytes/Group = 3148 Primary file space: Total Frames = *3340 *, Total Bytes = 9840132 Secondary file space: Total Frames = 56 , Total Bytes = 425689 With that kind of approach i'll be resizing in an infinite loop Can anybody clarify the issue? On Tue, Mar 2, 2010 at 21:51, Srinivas <[email protected]> wrote: > Dear , > > In the above output for F.LOCKING, it is confrimed that the file F.LOCKING > requires to be resized . When the count of Total Frames (i.e,1950) becomes > more than the Groups Allocated (i.e. 1629) , then the File is said to be > Badly sized. > > To Resize , the No of Groups or Frames count must be increased so that the > total size of the frames will be within the limit of the allocated Frame > Size. > > New Modulo can be calculated based on the total no of bytes divided by the > frame size currently hold by the file. > > total no of bytes = 16457728 > current frame size = DIV(9840241,1950) > = 5046 bytes > New Modulo = total no of bytes / current frame size > = 3261 > Using jrf utility , it has to be re-sized. > > Regards, > > Srinivas Yadav. > > > > On 2 March 2010 12:18, [Xze] <[email protected]> wrote: > >> Dear all, >> >> I'm using the jstat utility to check the attributes of hashed files and >> for some of them i can see data in primary space but for others in both, >> primary and secondary >> >> My question is how to find whether a file needs resize or not based on >> jstat output (for both cases) and if it needs how to calculate the new >> modulo >> >> As an example you can consider the following files: >> >> jsh ~ -->jstat -v F.LOCKING >> File ../bnk.data/eb/F.LOCKING >> Type=J4 , Hash method = 5 >> Created at Wed Jan 6 19:45:35 2010 >> Groups = 1629 , Frame size = 8192 bytes , Secondary Record Size = 16384 >> bytes >> Restore re-size parameters : (none) >> File size = 16457728 bytes , Inode = 1248028 , Device = Id >> 9223372212948434946 >> Last Accessed Tue Mar 2 08:40:18 2010 , Last Modified Tue Mar 2 08:40:18 >> 2010 >> Backup = YES , Log = YES , Rollback = YES , Network = AUTO >> >> >> Record Count = 24207 , Record Bytes = 10265930 >> Bytes/Record = 424 , Bytes/Group = 6301 >> Primary file space: Total Frames = 1950 , Total Bytes = 9840241 >> Secondary file space: Total Frames = 56 , Total Bytes = 425689 >> >> >> jsh ~ -->jstat -v FBNK.EB.CONTRACT.BALANCES >> File ../bnk.data/re/FBNK_EB_CONTRACT_BALANCES >> Type=J4 , Hash method = 5 >> Created at Wed Feb 24 10:56:56 2010 >> Groups = 250001 , Frame size = 4096 bytes , Secondary Record Size = 8192 >> bytes >> Restore re-size parameters : (none) >> File size = 1061769216 bytes , Inode = 1230014 , Device = Id >> 9223372212948434946 >> Last Accessed Wed Feb 24 14:34:34 2010 , Last Modified Wed Feb 24 14:34:34 >> 2010 >> Backup = YES , Log = YES , Rollback = YES , Network = AUTO >> >> >> Record Count = 1346947 , Record Bytes = 387310863 >> Bytes/Record = 287 , Bytes/Group = 1549 >> Primary file space: Total Frames = 259220 , Total Bytes = 387310863 >> Secondary file space: Total Frames = 0 , Total Bytes = 0 >> >> System Information >> ================== >> >> OS AIX 5.3.9.0 >> jbase: Major 5.0 , Minor 20 , Patch 0364 (Change 85159) >> >> Regards, >> Xze >> >> -- >> 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 > -- 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
