toasters

toasters@lists.teaparty.net

13531 discussions

Start a nNew thread

AIT-2 support in 5.3.6R2?
by Michael Galloway 11 Aug '00

11 Aug '00

does OT5.3.6R2 have support for AIT-2 devices? thanks! -- michael

2 2

RE: SQL 7.0 and Oplocks
by Muhlestein, Mark 11 Aug '00

11 Aug '00

The reason the language is vague is that there is no hard and fast rule. It's a tradeoff you can make between performance and risk of data loss. When oplocks are enabled it allows the CIFS client (in this case the SQL server) to aggressively cache data. That can result in a nice performance gain, and everything is great as long as you don't have network problems, and the servers never crash. If that does happen, you are more likely to have data loss with oplocks enabled. On the other hand, many applications do write-throughs and/or flushes to avoid that problem. I haven't heard of anyone losing data on MS SQL because of having oplocks enabled, but if you're worried I'd suggest turning off oplocks on the qtree that has your database files. If the performance suffers too much, you can consider turning them back on if you are in a stable environment. Mark -----Original Message----- From: Mike Hopkins [mailto:Mike@broaddaylight.com] Sent: Thursday, August 10, 2000 10:17 AM To: 'toasters(a)mathworks.com' Subject: SQL 7.0 and Oplocks There are articles on Microsoft's website as well as the NOW site that indicate the possibility of oplocks causing data loss when using a filer to host a SQL 7 datbase device. http://support.microsoft.com/support/kb/articles/Q224/9/92.ASP <http://support.microsoft.com/support/kb/articles/Q224/9/92.ASP> http://now.netapp.com/NOW/knowledge/docs/ontap/rel535/html/sag/cifs25.htm <http://now.netapp.com/NOW/knowledge/docs/ontap/rel535/html/sag/cifs25.htm> We are running SQL 7.0 on a Win2K server with a gigabit connection to the filer. The database is a repository for a custom web application that we sell, so the database is getting a lot of transactions from the web server. The language in both articles is vague and inconclusive, so I am looking for those of you who have experience running SQL 7.0 with a network connection to it devices. I am not a dba, just the guy who looks after the filer among other things. Oplocks are currently enabled, should I leave them this way? Michael Hopkins mike(a)BroadDaylight.com Systems Administrator phone 408.450.7450 Broad Daylight, Inc. fax 408.327.0177

1 0

RE: user quota crashes filer
by Coartney, Paul 11 Aug '00

11 Aug '00

sysconfig -v It is at the top -----Original Message----- From: Jiang, Perry [mailto:Perry.Jiang@bmo.com] Sent: Friday, August 11, 2000 7:36 AM To: 'Heller, Jeffrey'; Fairchild, Peter; Krishnan, Prabhakar Cc: toasters Subject: RE: user quota crashes filer Hi, What command can I use to check my filter's firmware version? After install the system files to upgrade, it won't erase my data on the filer, right? Thanks Perry Jiang -----Original Message----- From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] Sent: Friday, August 11, 2000 10:10 AM To: Fairchild, Peter; Heller, Jeffrey; Krishnan, Prabhakar; Jiang, Perry Cc: toasters Subject: RE: user quota crashes filer Floppy booting 5.3.6R2 and then downloading that release should solve the problem. Call customer service if you are having problems with the procedure. Once 5.3.6R2 is loaded you should have no problem turning quotas back on. Jeff > -----Original Message----- > From: Fairchild, Peter [mailto:Peter.Fairchild@netapp.com] > Sent: Friday, August 11, 2000 6:42 AM > To: Heller, Jeffrey; Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > That doesn't fully answer the question. > How does one deal with this problem *before* patching 5.3.6R2? > Does one have to nuke the filer to get quota functional again? > > -----Original Message----- > From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] > Sent: Thursday, August 10, 2000 6:14 PM > To: Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > This problem is fixed in 5.3.6R2 which is on NOW as of today. > > > -----Original Message----- > From: Prabhakar Krishnan [mailto:kpkar@netapp.com] > Sent: Thursday, August 10, 2000 1:54 PM > To: Jiang, Perry > Cc: toasters > Subject: Re: user quota crashes filer > > > > this was a bug. > > - patch is availabe , contact the SE/CS > - fixed in the next release > > "Jiang, Perry" wrote: > > > Hi, > > I have a 740 filer with Data OnTAP 5.3.6 > > I put a quota entry for username "perry" into /vol/vol0/etc/quotas > > perry user 50M - > > > > But there is no entry for "perry" in /vol/vol0/etc/passwd, > so there is no > > UID for perry(No NIS running, of course). > > When I run "quota on vol0", the filer crashes. > > > > I have to boot up the filer from floppy disk, remove the > entry of "perry" in > > /vol/vol0/etc/quotas file, then reboot the filer. > > > > After the filter is up, everything is ok. However, I can't > enable quota > > anymore. Every time > > I run "quota on vol0", the filer would crash. > > > > The only thing I have in /vol/vol0/etc/quotas now is couple > of entries for > > Qtree quota. > > > > Can anybody explain when the filer still crashes after I > remove the "perry" > > entry? > > How can I make the quota work again? > > Do I have to rebuild the filer? > > > > Thanks > > > > Perry Jiang >

1 0

RE: user quota crashes filer
by Jiang, Perry 11 Aug '00

11 Aug '00

Hi, What command can I use to check my filter's firmware version? After install the system files to upgrade, it won't erase my data on the filer, right? Thanks Perry Jiang -----Original Message----- From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] Sent: Friday, August 11, 2000 10:10 AM To: Fairchild, Peter; Heller, Jeffrey; Krishnan, Prabhakar; Jiang, Perry Cc: toasters Subject: RE: user quota crashes filer Floppy booting 5.3.6R2 and then downloading that release should solve the problem. Call customer service if you are having problems with the procedure. Once 5.3.6R2 is loaded you should have no problem turning quotas back on. Jeff > -----Original Message----- > From: Fairchild, Peter [mailto:Peter.Fairchild@netapp.com] > Sent: Friday, August 11, 2000 6:42 AM > To: Heller, Jeffrey; Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > That doesn't fully answer the question. > How does one deal with this problem *before* patching 5.3.6R2? > Does one have to nuke the filer to get quota functional again? > > -----Original Message----- > From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] > Sent: Thursday, August 10, 2000 6:14 PM > To: Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > This problem is fixed in 5.3.6R2 which is on NOW as of today. > > > -----Original Message----- > From: Prabhakar Krishnan [mailto:kpkar@netapp.com] > Sent: Thursday, August 10, 2000 1:54 PM > To: Jiang, Perry > Cc: toasters > Subject: Re: user quota crashes filer > > > > this was a bug. > > - patch is availabe , contact the SE/CS > - fixed in the next release > > "Jiang, Perry" wrote: > > > Hi, > > I have a 740 filer with Data OnTAP 5.3.6 > > I put a quota entry for username "perry" into /vol/vol0/etc/quotas > > perry user 50M - > > > > But there is no entry for "perry" in /vol/vol0/etc/passwd, > so there is no > > UID for perry(No NIS running, of course). > > When I run "quota on vol0", the filer crashes. > > > > I have to boot up the filer from floppy disk, remove the > entry of "perry" in > > /vol/vol0/etc/quotas file, then reboot the filer. > > > > After the filter is up, everything is ok. However, I can't > enable quota > > anymore. Every time > > I run "quota on vol0", the filer would crash. > > > > The only thing I have in /vol/vol0/etc/quotas now is couple > of entries for > > Qtree quota. > > > > Can anybody explain when the filer still crashes after I > remove the "perry" > > entry? > > How can I make the quota work again? > > Do I have to rebuild the filer? > > > > Thanks > > > > Perry Jiang >

1 0

Re: RE: Snapshots and Oracle
by Brian Hostetter 11 Aug '00

11 Aug '00

Treat the control files just as you would any other critical DB file. When you shut your DB down and snapshot it, make a backup copy of the control files also. Control files only change when you do structural changes to your database, and thus must be backed up only then. Of course that is best case, just incorporate control files into your normal backups. As for redo logs they do not nee to be backed up. In fact you really cannot use them for anything other than instance recovery when you have the database crash. If you do a clean shutdown there is no data in these redo's. It gets flushed to disk during the shutdown. I would also recommend not putting redo's on your netapp, it is just an incredible waste of I/O. Buy some cheap 4G drives and install them. If you multiplex your redo's you should not have to worry about disk failures. --Brian >>> X X <gynt(a)post.com> 08/11 3:42 AM >>> >1. Does a hot backup (as described on >http://www.netapp.com/tech_library/3049.html) present any >restoration problems? Has anyone done a restore from a hot >backup? How about handling of the control files? In other hot-backup schemes I have seen, there are a lot of stuff on how and when to do the "ALTER DATABASE BACKUP CONTROLFILE ... ..." command. Also also some stuff on "ALTER SYSTEM SWITCH LOGFILE" or "ARCHIVE LOG NEXT" None of these are mentioned in the above TechLibrary article. /Gynt ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

1 0

RE: user quota crashes filer
by Heller, Jeffrey 11 Aug '00

11 Aug '00

Floppy booting 5.3.6R2 and then downloading that release should solve the problem. Call customer service if you are having problems with the procedure. Once 5.3.6R2 is loaded you should have no problem turning quotas back on. Jeff > -----Original Message----- > From: Fairchild, Peter [mailto:Peter.Fairchild@netapp.com] > Sent: Friday, August 11, 2000 6:42 AM > To: Heller, Jeffrey; Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > That doesn't fully answer the question. > How does one deal with this problem *before* patching 5.3.6R2? > Does one have to nuke the filer to get quota functional again? > > -----Original Message----- > From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] > Sent: Thursday, August 10, 2000 6:14 PM > To: Krishnan, Prabhakar; Jiang, Perry > Cc: toasters > Subject: RE: user quota crashes filer > > > This problem is fixed in 5.3.6R2 which is on NOW as of today. > > > -----Original Message----- > From: Prabhakar Krishnan [mailto:kpkar@netapp.com] > Sent: Thursday, August 10, 2000 1:54 PM > To: Jiang, Perry > Cc: toasters > Subject: Re: user quota crashes filer > > > > this was a bug. > > - patch is availabe , contact the SE/CS > - fixed in the next release > > "Jiang, Perry" wrote: > > > Hi, > > I have a 740 filer with Data OnTAP 5.3.6 > > I put a quota entry for username "perry" into /vol/vol0/etc/quotas > > perry user 50M - > > > > But there is no entry for "perry" in /vol/vol0/etc/passwd, > so there is no > > UID for perry(No NIS running, of course). > > When I run "quota on vol0", the filer crashes. > > > > I have to boot up the filer from floppy disk, remove the > entry of "perry" in > > /vol/vol0/etc/quotas file, then reboot the filer. > > > > After the filter is up, everything is ok. However, I can't > enable quota > > anymore. Every time > > I run "quota on vol0", the filer would crash. > > > > The only thing I have in /vol/vol0/etc/quotas now is couple > of entries for > > Qtree quota. > > > > Can anybody explain when the filer still crashes after I > remove the "perry" > > entry? > > How can I make the quota work again? > > Do I have to rebuild the filer? > > > > Thanks > > > > Perry Jiang >

1 0

RE: user quota crashes filer
by Fairchild, Peter 11 Aug '00

11 Aug '00

That doesn't fully answer the question. How does one deal with this problem *before* patching 5.3.6R2? Does one have to nuke the filer to get quota functional again? -----Original Message----- From: Heller, Jeffrey [mailto:Jeffrey.Heller@netapp.com] Sent: Thursday, August 10, 2000 6:14 PM To: Krishnan, Prabhakar; Jiang, Perry Cc: toasters Subject: RE: user quota crashes filer This problem is fixed in 5.3.6R2 which is on NOW as of today. -----Original Message----- From: Prabhakar Krishnan [mailto:kpkar@netapp.com] Sent: Thursday, August 10, 2000 1:54 PM To: Jiang, Perry Cc: toasters Subject: Re: user quota crashes filer this was a bug. - patch is availabe , contact the SE/CS - fixed in the next release "Jiang, Perry" wrote: > Hi, > I have a 740 filer with Data OnTAP 5.3.6 > I put a quota entry for username "perry" into /vol/vol0/etc/quotas > perry user 50M - > > But there is no entry for "perry" in /vol/vol0/etc/passwd, so there is no > UID for perry(No NIS running, of course). > When I run "quota on vol0", the filer crashes. > > I have to boot up the filer from floppy disk, remove the entry of "perry" in > /vol/vol0/etc/quotas file, then reboot the filer. > > After the filter is up, everything is ok. However, I can't enable quota > anymore. Every time > I run "quota on vol0", the filer would crash. > > The only thing I have in /vol/vol0/etc/quotas now is couple of entries for > Qtree quota. > > Can anybody explain when the filer still crashes after I remove the "perry" > entry? > How can I make the quota work again? > Do I have to rebuild the filer? > > Thanks > > Perry Jiang

1 0

RE: Snapshots and Oracle
by X X 11 Aug '00

11 Aug '00

>1. Does a hot backup (as described on >http://www.netapp.com/tech_library/3049.html) present any >restoration problems? Has anyone done a restore from a hot >backup? How about handling of the control files? In other hot-backup schemes I have seen, there are a lot of stuff on how and when to do the "ALTER DATABASE BACKUP CONTROLFILE ... ..." command. Also also some stuff on "ALTER SYSTEM SWITCH LOGFILE" or "ARCHIVE LOG NEXT" None of these are mentioned in the above TechLibrary article. /Gynt ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

1 0

RE: Snapshots and Oracle
by X X 11 Aug '00

11 Aug '00

1 0

RE: user quota crashes filer
by Heller, Jeffrey 11 Aug '00

11 Aug '00

This problem is fixed in 5.3.6R2 which is on NOW as of today. -----Original Message----- From: Prabhakar Krishnan [mailto:kpkar@netapp.com] Sent: Thursday, August 10, 2000 1:54 PM To: Jiang, Perry Cc: toasters Subject: Re: user quota crashes filer this was a bug. - patch is availabe , contact the SE/CS - fixed in the next release "Jiang, Perry" wrote: > Hi, > I have a 740 filer with Data OnTAP 5.3.6 > I put a quota entry for username "perry" into /vol/vol0/etc/quotas > perry user 50M - > > But there is no entry for "perry" in /vol/vol0/etc/passwd, so there is no > UID for perry(No NIS running, of course). > When I run "quota on vol0", the filer crashes. > > I have to boot up the filer from floppy disk, remove the entry of "perry" in > /vol/vol0/etc/quotas file, then reboot the filer. > > After the filter is up, everything is ok. However, I can't enable quota > anymore. Every time > I run "quota on vol0", the filer would crash. > > The only thing I have in /vol/vol0/etc/quotas now is couple of entries for > Qtree quota. > > Can anybody explain when the filer still crashes after I remove the "perry" > entry? > How can I make the quota work again? > Do I have to rebuild the filer? > > Thanks > > Perry Jiang

1 0

Jump to page:

2026

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