RE: [U2] UV - Files Stats Question
ACCOUNT.FILE.STATS does keep history - all records in STAT.FILE are timestamped. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
POSTED FOR NON-MEMBER ADDRESS: Drew Henderson <[EMAIL PROTECTED]> Bounce notice: Your recent post to our lists bounced because either you are not a member or because you are not signed up using the e-mail address which you used to post. To subscribe or resubscribe please visit http://listserver.u2ug.org/. I think that had Jeff initiated the discussion of FAST as a solution to the original problem, the need to delineate the discussion as an advertisement would, indeed, be obvious. However, as the original poster mentioned having FAST, I took Jeff's comments as helping the originator make use of tools they already had, rather than encouraging the purchase of a commercial product. Having said that, the nature of this list will often include such grey areas, and I think it advisable for posters to consider the various ways their comments can be interpreted, and act accordingly. Drew --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
Jeff, I wouldn't worry about the cyberspanking. We pay Charles those big bucks to monitor this list, and he's earning his keep. (He insisted on 75% the u2 users list subscription fees goes to him, but the U2UG former president, Charles Barouch, chiselled him down to 50%.) I always appreciate vendor response to questions. You've always been very helpful. The fact is, FAST probably does what the original poster wants, if he can figure out how to do it technically. The rules on [AD] are are a bit loose. I don't think we make IBM people add "[AD]" when then giving technical info or mentioning something about a new release or routine admonitions to take the Internals class. I suppose you maybe strayed when announcing rev 6. Hey, I think that's the first I heard of 6. You know, you could stand to be a little more marketing oriented. Charles "not the cyber-spanking Barouch one" Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
> can you tell me where FAST keeps the list of files under its control ? There should be a universe account called fastcs. FAST.STATS is its main interesting file you should become familiar with. Where the fastcs directory resides is up to you. For me, it is a sister of the universe home dir. In other words, when I do LIST UV.ACCOUNT I see: LIST UV.ACCOUNT 05:44:11pm 26 Aug 2007 PAGE1 Account... UNIX pathname. uv /dbms/uv fastcs /dbms/fastcs List the FAST.STATS dictionary and then write your own queries. The key to FAST.STATS is the pathname. There are ancillary control files like FAST.LISTS, FAST.SESSIONS, etc.. You'll figure it out once you start looking. One complaint I have with FAST is that it doesn't keep history. I want to see where a file has been and where it is going, so after I run my weekly "Gather Stats", I copy each newly updated FAST.STATS record to my own FAST.STATS.HIST where the key is [idate]*[fast.statsID(i.e.,path)]. Indexed on date, path, filename. Then I can look at how a file is changing over time (number of data bytes, items, etc.). I and my comrades have found that useful not just in sizing but in application analysis & research. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
Charles, Cyber-spanking accepted! I offer my apologies if I seemed to be making a sales pitch (which I hadn't intended). However, since the original poster asked specific questions about a product it didn't seem particularly out of line to answer them. Your judgment of my post is "touting" -- my intent was to offer a helpful answer to a question. Perhaps I should have answered by private email, but I didn't since the poster chose to raise the issue in the list. Just as you could have delivered your admonishment by private email you chose not to; presumably because others might benefit from exposure to the list guidelines. I hoped my answering Jim's question on the list might be helpful to other list members, many of whom are FAST users. And I did suggest to him that a continuation of the discussion be done via private email. My company is not particularly marketing oriented. I think if you examine my postings to the list and its predecessors you will find the "signal to noise" ratio to be pretty high. But, all that said, I will try very hard to follow the list guidelines. Would you like the [AD] - [AD\] brackets in the subject line so that offended list members can filter or hit the delete key or would you like them bracketing the sections of the message body that could be judged as "touting" a product? Thanks for your feedback! Jeff Fitzgerald [AD] www.fitzlong.com [AD\] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Sunday, August 26, 2007 9:37 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV - Files Stats Question Jeff, [AD] brackets [AD\] are required, even when just trying to be helpful, once you start touting the usage and features of a commercial product. - Charles Barouch, Moderator Jeff Fitzgerald wrote: > 3) Why reinvent the wheel when you already have FAST which is pretty > intelligent about determining if the file needs resizing? > > We have just completed a new release of FAST, release 6. It has a > feature that will help your situation. Our expert mode executable, > fastbatch, has a new option "-acct xxx" -- xxx can be an account > pathname or the name of a list of accounts. FAST will, at run time, > create a dynamic list of all hashed files in the account(s) and process > them. This allows you to run the Gather Statistics and Type Analysis > processes and make sure any new files are picked up. Then after > reviewing the FAST recommendations you can either resize according to > FAST's recommendations or override / modify as you wish. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - Files Stats Question
Jeff, [AD] brackets [AD\] are required, even when just trying to be helpful, once you start touting the usage and features of a commercial product. - Charles Barouch, Moderator Jeff Fitzgerald wrote: 3) Why reinvent the wheel when you already have FAST which is pretty intelligent about determining if the file needs resizing? We have just completed a new release of FAST, release 6. It has a feature that will help your situation. Our expert mode executable, fastbatch, has a new option "-acct xxx" -- xxx can be an account pathname or the name of a list of accounts. FAST will, at run time, create a dynamic list of all hashed files in the account(s) and process them. This allows you to run the Gather Statistics and Type Analysis processes and make sure any new files are picked up. Then after reviewing the FAST recommendations you can either resize according to FAST's recommendations or override / modify as you wish. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
I see where you're coming from, but I'd steer you away from that approach for a few reasons: 1) Even if a file isn't badly in need, you'd like to have it run through the FAST Gather Statistics process -- that checks the file for integrity, makes sure it is not damaged and creates a descriptive record in the FAST database so that the file is included in reports, etc. 2) "All groups being in overflow to the 200% level" isn't a valid rule to determine whether a file needs resizing. It quite common to see files with quite a few groups either empty or sparsely populated while many other groups are badly in overflow. This becomes especially apparent if an inappropriate file type is in use or if the file doesn't hash well. 3) Why reinvent the wheel when you already have FAST which is pretty intelligent about determining if the file needs resizing? We have just completed a new release of FAST, release 6. It has a feature that will help your situation. Our expert mode executable, fastbatch, has a new option "-acct xxx" -- xxx can be an account pathname or the name of a list of accounts. FAST will, at run time, create a dynamic list of all hashed files in the account(s) and process them. This allows you to run the Gather Statistics and Type Analysis processes and make sure any new files are picked up. Then after reviewing the FAST recommendations you can either resize according to FAST's recommendations or override / modify as you wish. Assuming your maintenance agreement with us is current you can order the upgrade to the new release via our website at no charge. If you don't think this will work for you, let me know via private email and I'll try to further assist if I can. Jeff Fitzgerald Fitzgerald & Long, Inc. www.fitzlong.com [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Koca Sent: Saturday, August 25, 2007 11:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Files Stats Question We create new files from time to time, and forget to add them to FAST to be resized. We are planning to look at the files in an account, and if all the group are at 200 % and the file is not currently being review by FAST, add it to the FAST files for resizing. Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
We create new files from time to time, and forget to add them to FAST to be resized. We are planning to look at the files in an account, and if all the group are at 200 % and the file is not currently being review by FAST, add it to the FAST files for resizing. Jim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fitzgerald > Sent: Saturday, August 25, 2007 12:11 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UV - Files Stats Question > > > I am one of the authors of FAST; we'll be happy to help you if you can > give us a bit more of an idea what you are trying to accomplish... > > Jeff Fitzgerald > Fitzgerald & Long, Inc. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim Koca > Sent: Friday, August 24, 2007 10:00 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV - Files Stats Question > > I need to select files in an account and determine if all the records > fall > in the 200% groups. This will be done in a Basic program. Other than > FILE.STAT each file and examine the output, can it be done simpler ? > > Also if anyone is using FAST, can you tell me where FAST keeps the list > of > files under its control ? > > Thanks, > > Jim Koca > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Files Stats Question
I am one of the authors of FAST; we'll be happy to help you if you can give us a bit more of an idea what you are trying to accomplish... Jeff Fitzgerald Fitzgerald & Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Koca Sent: Friday, August 24, 2007 10:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Files Stats Question I need to select files in an account and determine if all the records fall in the 200% groups. This will be done in a Basic program. Other than FILE.STAT each file and examine the output, can it be done simpler ? Also if anyone is using FAST, can you tell me where FAST keeps the list of files under its control ? Thanks, Jim Koca --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - Files Stats Question
Run ACCOUNT.FILE.STATS ALL LOCAL in the account. This will run FILE.STAT (or ANALYZE.FILE as appropriate) and make various other calls to gather all the information you need into a file called STAT.FILE. You can query this file with the usual query tools. (As a bonus, you get a map of device and inode to filename, useful for determining the file in which a locked record occurs, as reported by LIST.READU command.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/