Hi, I have a file where most the records are having large no of multi-values. Due to this, the records are falling to secondary frame as the separation is set to 1. I am thinking of increasing the Separation value to 2 or 3 so that the records will move back to the primary frame. Can someone explain whether i;ts bad to have many records in the secondary frame? Below is the jstat output for the file. jsh ~ -->jstat -v FBNK.XYZ File ../bnk.data/re/FBNK.XYZ Type=J4 , Hash method = 5 Created at Sun Jul 19 00:08:35 2009 Groups = 85643 , Frame size = 4096 bytes , Secondary Record Size = 8192 bytes Restore re-size parameters : (none) File size = 1591939072 bytes , Inode = 1401343 , Device = Id 9223372221538369537 Last Accessed Sat Dec 1 14:04:14 2012 , Last Modified Sat Dec 1 14:04:14 2012 Backup = YES , Log = YES , Rollback = YES , Network = AUTO
Record Count = 96365 , Record Bytes = 1247160632 Bytes/Record = 12942 , Bytes/Group = 14562 Primary file space: Total Frames = 91754 , Total Bytes = 69284115 Secondary file space: Total Frames = 296902 , Total Bytes = 1177876517 Thanks, UL -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. 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
