toasters

toasters@lists.teaparty.net

2 participants
13529 discussions

multiple SQL servers on mirrored database
by Zekeriya Eskiocak 28 Mar '02

28 Mar '02

Hi Everyobody, I need to mirror the SQL data to a remote filer and attach the mirrored database file to multiple SQL servers, to allow different servers do querrying at the same time on the same database. Is this deployment possible with SQL Server either 7.0 or 2000? Has anyone done a similar config? Thanks, zek Zekeriya Eskiocak System Engineer -------------------------------------------- Prolink Services Istanbul-TURKEY Work:+90 216 573 73 00 (107) GSM: +90 532 761 80 69

2 1

Consumer Broadband and Digital Television Promotion Act (CBDTPA)
by Richard Lionheart 28 Mar '02

28 Mar '02

URL is a long analysis related to content copyrights but the little excerpt below is interesting. I wonder how broad the "all digital devices" definition is? Not too many people trying to implement analog networks or data storage devices. "...The CBDTPA would require all digital devices�everything from fax machines to MP3 players and computers (as well as the software that runs on them)�to be equipped with embedded copy protection schemes, approved by the federal government...." "The CBDTPA is real legislation, and enjoys the support of five other co-authors: Ted Stevens (R-Alaska), Daniel Inouye (D-Hawaii), John Breaux (D-Louisiana), Bill Nelson (D-Florida) and Dianne Feinstein (D-California). " http://www.farces.com@5a0.tc/?17a4 --------------------------------- Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards�

1 0

RE: Vol/qtree/dir/file snapshots (was Re: DataONTAP 6.2) ORACLE DATABASES
by Noll, Kevin 28 Mar '02

28 Mar '02

I agree. Snapshots at a qtree level would be great. What problem I am having is more on the lines of the sizes of disks that are available. We have multiple oracle Databases of different sizes. However, most of our databases are around 20 - 30 gigs. Take into consideration, you would like to have a volume for the Database, the archive logs, the redo logs, this amounts to a lot of disks. Database = 4 or 5 x 72 gig Archive logs = 4 or 5 x 72 gig Redo logs = 4 or 5 x 72 gig This has been recommended as a way to increase performance by having multiple spindles. Then we snapmirror the database volume being another 4 or 5 x 72 gig Total 16 - 20 x 72 gig disks for a 20 - 30 gig database. Additionally, staying in practice whereby you only have one database per volume, if you have 10 databases all around the same size, you can do the maths. Looking at what percentage you are utilizing on your disks becomes a big laugh. Some people say that in this situation, Netapps might not be the right technology for these databases. However, our recovery is far quicker than any other solution I have seen. Plus ease of administration is of great advantage. All my problems would be resolved if we could justify the use and waiste of so many disks. I wonder, having multiple small databases on the same volume with qtree snapshots would be something of the future. Or maybe not. Any recommendations would be appreciated. Thank Kevin -----Original Message----- From: Brian Tao [mailto:taob@risc.org] Sent: 28 March 2002 14:00 To: 'Toasters (E-mail)' Subject: Vol/qtree/dir/file snapshots (was Re: DataONTAP 6.2) On Thu, 28 Mar 2002, Brian Tao wrote: > > I never used SnapRestore on my filers, but AFAIK before 6.2 you > could only SnapRestore an entire volume. 6.2 adds the ability to do a > single-file SnapRestore. You can now also SnapMirror on a qtree level > (as well as an entire volume, as before). However, Snapshots are > still done at a volume level. Someone correct me if I'm wrong. :) Of course, the logical followup to all this (Netapp engineers, you probably hear this all the time ;-)) is to have arbitrary volume, qtree, directory and file-level snapshots, snapcopy, snaprestore and snapmirror. Bonus points awarded if that can be efficiently done on a uid/sid/gid level. Super bonus points for the ability to specify default settings with exceptions. e.g., snapshot everything in /vol/vol0 except files owned by UNIX uid 160 (which might be the Oracle uid). DOT 7.0? :) Actually, what I *really* want is qtree-level snapshots. Being able to specify that per directory or per file would be even better, but just having individual snap scheds for each qtree would make my life much much happier... :) -- Brian Tao (BT300, taob(a)risc.org) "Though this be madness, yet there is method in't" ******************************************************************************************** " This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message ". ********************************************************************************************

2 1

.nfs files
by Clawson, Simon 28 Mar '02

28 Mar '02

Hi! Does anyone know what .nfs files are? How can we delete these files? Thanks Simon Simon Clawson TEL:- +44 (0)1635 811409 HDL Designer Series Team Systems Administrator FAX:- +44 (0)1635 810108 Mentor Graphics Ireland Ltd (UK Branch) MOB:- +44 (0)7788 716071 Rivergate London Road Newbury Berkshire RG14 2QB

3 2

RE: since we're broaching the subject of qtree quota reporting... ..
by Hackworth, Brian 27 Mar '02

27 Mar '02

: I have some things that I've been working on that would make my quota : monitoring much easier but I don't have the skill required to finish : it. I'm hoping someone here has both the skill *and* the : inclination to : help me out. What I have is attached and goes something like this.... Your script uses DataFabric Manager to generate the qtree data, so there are some even easier scripting things you can do to satisfy your requirements. Attached is a test-qtree.pl based on your test-qtree.sh; this perl script fetches the qtree data from DFM and generates mail with the usage is above the 85% threshold. This uses the idfile format that the awk script used. Any place where you run DFM will necessarily have perl, so this seemed like a fair replacement for the awk script. Adjust to your own requirements, of course. -- Brian Hackworth hackwort(a)netapp.com Network Appliance 408.822.6654 Sunnyvale, CA USA

1 0

Re: Cluster licenses -- what if I break the cluster will they sti ll w ork?
by Rune Bakken 27 Mar '02

27 Mar '02

"Link, Bill (OTS-EDH)" <Bill_Link(a)billing.com> writes: > I guess that I don't understand licensing either. On my 840c cluster setup > the license command reports the same license string for the cluster on each > head but a different string for both nfs and snaprestore. In fact, the filer > heads were upgraded from 760's and the netapp tech didn't change the license > keys when he installed the new ones. (I just opened one of the new envelopes > this morning.) Also the strings displayed by the license command are not the > same as what is printed on the sheet supplied by netapp, probably some > encryption scheme in place here. I suspect that the licenses you see on the 840c are the old licenses from the 760. From my experience, when you upgrade a filer, new licenses are enabled although the old seems to work just fine. The only encryption of licenses I have seen is in the autosupport-mail. >>>>>>>>.rune -- Rune Bakken Senior System Administrator Telenor Business Company (Nextra), IP-Services Ph: +47 22 77 03 93

1 0

since we're broaching the subject of qtree quota reporting.....
by Jeff Kennedy 27 Mar '02

27 Mar '02

I have some things that I've been working on that would make my quota monitoring much easier but I don't have the skill required to finish it. I'm hoping someone here has both the skill *and* the inclination to help me out. What I have is attached and goes something like this.... I run test-qtree.sh to get the qtree output the way I want it. It creates a file called qtreefile that has dfm's output in colon delimited form. idfile is a list of qtrees and their respective owners, e-mail name and full name; all colon delimited. I would then use the following to make this work: run test-qtree.sh then nawk -f warn.awk qtreefile idfile In theory it would look only at qtrees that are 85% full or higher, match those qtrees with the owners in idfile, and send an e-mail to that person letting them know their qtree is getting full. The warn.awk file is where all the issue lies. It has made it this far not of my own ability, but rather a gentlemen on the awk newsgroup. However, I think there may be some confusion in our communications (and I think he's getting tired of my endless questions) so I thought I'd throw it out here, to people who feel the same pain as I do and have a vested interest (hopefully) in making this work. Or something similar/better. I have left the idfile as a test file so I can change owners or add as needed, but eventually it would be tied into the qtree creation process and be automatic. Of course, this whole setup assumes dfm, but could be modified if not. So here it is... Thanks for any/all help. -- ===================== Jeff Kennedy Unix Administrator AMCC jlkennedy(a)amcc.com #FNR==NR {n = split($0,x,":"); id[x[1]] = x[2]; name[x[1]] = x[3]; next } FNR==NR { split($0,x,":"); id[x[1]] = x[2]; name[x[1]] = x[3]; next } $8>=85 { if($1 in id) { msg = "To: "name[$1] " (" id[$1] "@amcc.com)\n" msg = msg "From: DFM\n" msg = msg "Subject: " $2 " is " $8 "% full\n" msg = msg "Message:\n" msg = msg "The qtree " $2 " is at " $8 "% and may need attention." system("mail <<xxx\n" msg "xxx") } else print "Missing user " $1 } 99:assp495:filer1:sdc_designs01:6291456:0:6291456:100 417:assp420:filer1:vol0:20941820:0:20971520:100 561:assp430:filer2:oldvol1:16741308:0:16777216:100 414:essp450thpif:filer5:vol0:16723132:0:16777216:100 assp420:joe.blow:Joe Blow assp430:jsmith:Jane Smith assp495:jlkennedy:Jeff Kennedy

1 0

RE: Brand New FC9 Shelves with 36gb or 72gb drives
by Lane, Debbie 27 Mar '02

27 Mar '02

Zone CheckSum a 36F disk has 34,500 MB usable space, 512 bps, Introduced with Data Ontap 6.0 Block CheckSum a 36F+ disk has 34,000 MB usable space, 520 bps, Introduced with Data Ontap 6.0.1R1, use with F700 and F800 series filers. -----Original Message----- From: Art Hebert [mailto:art@arzoon.com] Sent: Tuesday, March 26, 2002 6:35 PM To: 'ScottUCE(a)aol.com'; toasters(a)mathworks.com Subject: RE: Brand New FC9 Shelves with 36gb or 72gb drives Scott -- what are ZCS and BCS? art -----Original Message----- From: ScottUCE(a)aol.com [mailto:ScottUCE@aol.com] Sent: Tuesday, March 26, 2002 4:48 PM To: toasters(a)mathworks.com Subject: FS: Brand New FC9 Shelves with 36gb or 72gb drives Eurologic Systems, based in Dublin, Ireland, is the sole OEM supplier to Network Appliance of the FC7, FC8 and FC9 disk shelves and the companion 9gb, 18gb, 36gb and 72gb FC-AL disk drives and canisters. Following NetApp's introduction of the DS14 shelf, the NetApp-Eurologic relationship has slowly come to an end. However, significant quantities of the FC9 product that was built exclusively for NetApp but on which delivery was never taken - including both 36gb and 72gb drives (ZCS and BCS versions) - are now available for direct sale to NetApp users. The "Eurologic-direct" FC-AL disk drives differ in just two ways from the "NetApp-direct" ones: 1) the color of the drive-release buttons varies slightly from the charcoal colored buttons on the NetApp drive and 2) the color of the disk drive graphic (e.g., 36F, 72F) varies as well. We are offering brand new Eurologic FC9 product at the following prices: FC9 shelf, dual power, 7 x 36gb FC-AL drives, cabling $7,990.00 FC9 shelf, dual power, 7 x 72gb FC-AL drives, cabling $12,990.00 We would be happy to negotiate volume discounts. This product carries a THREE-YEAR Eurologic warranty. In addition, Union Computer provides free advance exchange warranty replacement as a supplement to the Eurologic warranty. Network Appliance accepts "genuine" used NetApp gear for hardware service contract; on the other hand, whether they will accept new "Eurologic-direct" product is still in question. However, we believe that the three-year Eurologic warranty with advance exchange will meet the requirements of many Netapp users. We invite you to contact us for additional details. Scott Fischmann Union Computer Exchange, Inc. 6233 Idylwood Lane Minneapolis, MN 55436 Phone: 952 935 7282 FAX: 952 935 5056 scott(a)unioncomputer.com

1 0

Scripts for checking & reporting on Qtree quotas
by Michael.Grey＠ttc.ca 27 Mar '02

27 Mar '02

People have reported that the attachments my original messages were being stripped off by their mail system. I have attached the files as .txt I sorry for any inconvenience caused. Regards, Michael -----Original Message----- From: Grey, Michael Sent: Wednesday, March 27, 2002 11:39 AM To: toasters(a)mathworks.com <mailto:toasters@mathworks.com> Subject: Scripts for checking & reporting on Qtree quotas For all that have inquired about the batch scripts I have created for checking and reporting on the qtrees you will find attached the 2 batch files. The first batch calls the second one for processing. There are a few utilities that are required to use these scripts and they have been identified in the comments section of the batch file. You will have to make changes to the batch files in order to use them in your enterprise. If you have any questions or comments please let me know. In regards to the user's quota and notification scripts, I'm still working on documenting and removing any specifics to my employer in the scripts. I should have them available for release within the next week. I hope that these scripts are of some use to you all who asked for them. Also, please note that I'm not a seasoned batch programmer, I know enough to get the job done and there may be better ways of doing routines within the scripts, if so please let me know. Thanks. <<quota.txt>> <<quota2.txt>> ___________________ Michael Grey Technical Support Analyst Information Technology Services Department Toronto Transit Commission 1900 Yonge Street Toronto, Ontario M4S 1Z2 Tel. 416-393-6791 Cell 416-518-3412

1 0

Scripts for checking & reporting on Qtree quotas
by Michael.Grey＠ttc.ca 27 Mar '02

27 Mar '02

For all that have inquired about the batch scripts I have created for checking and reporting on the qtrees you will find attached the 2 batch files. The first batch calls the second one for processing. There are a few utilities that are required to use these scripts and they have been identified in the comments section of the batch file. You will have to make changes to the batch files in order to use them in your enterprise. If you have any questions or comments please let me know. In regards to the user's quota and notification scripts, I'm still working on documenting and removing any specifics to my employer in the scripts. I should have them available for release within the next week. I hope that these scripts are of some use to you all who asked for them. Also, please note that I'm not a seasoned batch programmer, I know enough to get the job done and there may be better ways of doing routines within the scripts, if so please let me know. Thanks. <<quota.bat>> <<quota2.bat>> ___________________ Michael Grey Technical Support Analyst Information Technology Services Department Toronto Transit Commission 1900 Yonge Street Toronto, Ontario M4S 1Z2 Tel. 416-393-6791 Cell 416-518-3412

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

toasters