Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2003

Tip: Looking for answers? Try searching our database.

DB2 for Linux - Backup to NFS filesystem?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ember - 30 Oct 2003 16:38 GMT
I'm trying to take an offline backup on Linux to an NFS mounted
filesystem. I have no trouble creating files or directories manually
in this filesystem. Here's the df -h for it:
Filesystem            Size  Used Avail Use% Mounted on
<IPaddressHere - ommitted>:/db2backup                                
                      84G  677M   82G   1% /mnt1    
Each time I try the backup, no matter what buffer size I use, I get:
SQL2025N  An I/O error "" occurred on media "6".
No return code, and a media of "6" - strange. And this is written to
the db2diag.log:
2003-10-30-09.58.04.927844   Instance:crawl   Node:000          
PID:7190(db2med.16302.0)   Appid:none                          
oper_system_services  sqloflock   Probe:36                      
                                                               
errno: 2500 0000                                     %...      
                                                               
                                                               
2003-10-30-09.58.04.932820   Instance:crawl   Node:000          
PID:7190(db2med.16302.0)   Appid:none                          
database_utilities  sqluifdev   Probe:49                        
                                                               
DiagData                                                        
06d6 ffff                                     ....              
                                                               
                                                               
2003-10-30-09.58.04.935664   Instance:crawl   Node:000          
PID:7190(db2med.16302.0)   Appid:none                          
database_utilities  sqluMCInitBackupMC   Probe:80              
                                                               
Media controller -- device initialization warning              
                                                               
2003-10-30-09.58.04.938661   Instance:crawl   Node:000          
PID:16302(db2agent (FOUNTAIN))   Appid:*LOCAL.crawl.03103014420
database_utilities  sqlubMWResponse   Probe:5   Database:FOUNTAIN  
                                                                 
DiagData                                                          
17f8 ffff ff36 ff2f 6d6e 7431 2f46 4f55       .....6./mnt1/FOU    
4e54 4149 4e2e 302e 6372 6177 6c2e 4e4f       NTAIN.0.crawl.NO    
4445 3030 3030 2e43 4154 4e30 3030 302e       DE0000.CATN0000.    
3230 3033 3130 3330 3039 3538 3034 2e30       20031030095804.0    
3031 00                                       01.                  
                                                                 
                                                                 
2003-10-30-09.58.04.944622   Instance:crawl   Node:000            
PID:16302(db2agent (FOUNTAIN))   Appid:*LOCAL.crawl.03103014420  
database_utilities  sqlubMWResponse   Probe:10   Database:FOUNTAIN
                                                                 
DiagData                                                          
17f8 ffff                                     ....                
                                                                 
                                                                 
2003-10-30-09.58.04.954810   Instance:crawl   Node:000            
PID:16302(db2agent (FOUNTAIN))   Appid:*LOCAL.crawl.03103014420  
database_utilities  sqlubcka   Probe:0   Database:FOUNTAIN        
                                                                 
Backup terminated.                                                

Any suggestions on what I migth try? We've done this on AIX before,
but never on Linux, so I'm worried that backups to NFS on Linux simply
aren't supported.

Thanks,
Ember
susanwlm@starhawk.torolab.ibm.com - 30 Oct 2003 19:49 GMT
>I'm trying to take an offline backup on Linux to an NFS mounted
>filesystem. I have no trouble creating files or directories manually
[quoted text clipped - 11 lines]
>                                                                
>errno: 2500 0000                                     %...      

That's an ENOLCK (errno = 37, or 25 hex).  It means that DB2 is trying
to lock a file but can't.  I suspect your nfs mounting options are not
allowing locking over nfs.

WW
Signature

Susan Williams
Technical Lead, DB2 on Linux
susanwlm@vnet.ibm.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.