David,
     You are playing with fire but this is the only way.   After a file is
opened on server it remains "open" after the user thread closes the
database. It is kept open in the dbcache.  This improves performance the
next time the database is opened. You can perform a dbcache Flush to
release all database locks, except, names.nsf, log.nsf and mail.box.  If
you time your cl correctly you can obtain a lock on the file after the
release before anyone attempts to open the database.  If the server
attempts to open the file, for a User, UPdate task or mail delivery and the
database is locked by another process (your copy command) the server will
crash.

If you really need a copy of the database. Use the Notes C apis to create a
duplicate or replica database.  This is done via the server process so
there are no file lock issues.


Walter Scanlan
Advisory Software Engineer
Domino for iSeries Team Leader
Phone 507-286-6088
Fax  507-286-5028
Internet wscanlan@us.ibm.com


                                                                                
                                       
                    David Gibbs                                                 
                                       
                    <dgibbs@mks.com>         To:     "'DOMINO400 Mailing List'" 
<DOMINO400@midrange.com>, "'Midrange   
                    Sent by:                  Mailing List'" 
<MIDRANGE-L@midrange.com>                                 
                    owner-domino400@mi       cc:                                
                                       
                    drange.com               Subject:     Using CLP to copy a 
NSF file                                 
                                                                                
                                       
                                                                                
                                       
                    08/13/2001 02:37                                            
                                       
                    PM                                                          
                                       
                    Please respond to                                           
                                       
                    DOMINO400                                                   
                                       
                                                                                
                                       
                                                                                
                                       



Folks:

I'm trying to write a CL program that will copy a NSF file (in the IFS)
from
one location to another.

Problem is: More often than not, the copy fails because the NSF file is "IN
USE" (I'm assuming by Domino) ... I get a CPFA09E.  I know that the
database
is not actually being used by anyone (no clients or designers have it
open).

Does anyone know of a way to get that file released so it can be copied?

Thanks!

david

--
David Gibbs
Sr. Software Engineer
MKS, Inc.
2500 S. Highland Ave, Suite 200
Lombard, IL  60148

phone: (630) 495-2108 x5004
http://www.mks.com
mailto:dgibbs@mks.com

Need a laugh: http://www.userfriendly.org/static
+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---




+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.