473,385 Members | 1,275 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

db2 netbackup issues... Please advise/discuss

7
Hi Team,
I have netbackup for db2 is configured for backup and log archiving of the db2 logs on the tape device through the netbackup. I have configured the log archiving of the db2 through the LOAGARHCMETH1(vendor method) parameter. Not i have noticed couple of the thing which are strange and make me think about the Netbackup's Stability when there is a issue of restore of the database and performance.

1.When logs are archived to the tape device and when i query the content on the storage server through the bplist, the file name of the log is converted. Eg. S0000001.LOG ==> C000000_S0000001.LOG. The new name is not in the db2 naming standard. Is this log files are usable when there is a issue of restoring the database through the logs?
2. I also noticed that Sometime netbackup archive some logs many times(5 times) on the storage server. How db2 identifies which one is the right one to use during the restore/rollforward process?
3. This is completely weird behaviour. To stop the db2 instance after closing all the application connections, when i issue deactivate db command or any db2 commands it just hung. I have looked into the db2diag log file at the same time that db2 is archiving the logs which are just cut off from the LOG BUFFER and ready to archive to the storage media. Any db2 command is not returned until the log archving process is finished.This has beeen identified several time. Why log archiving process through the netbackup puts all other db2 commands on the wait mode until the process is done??



Any help will be greatly appreciated as this all thing matter on the Production database and recovery is a key issue.

Thanks
dave
Feb 7 '07 #1
0 1661

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Dave Irick | last post by:
We are looking for assistance in setting up export/import jobs that will use DLT tapes managed by Netbackup. The issue seems to be how to specify the "file" parameter of export/import so that it is...
6
by: jmev7 | last post by:
I have heard of security issues with IIS while on a T1 line or on a cable modem, etc. I learned of a "break in" at a state office, and it was traced to an "open door" while using IIS. Due to that...
4
by: africantract | last post by:
Hi There, We have an issue on our db2 restores. We do database dumps every night, and restore them to development servers every morning. This works fine with no errors. However if we backup those...
0
by: dave | last post by:
Hi All, I have configured the Netbackup to archive the logs and backup to the tape device and it working fine it is actually starting archiving logs to the tape but few logs are still there. do...
0
by: murtuja | last post by:
Hii I have Veritas Netbackup server on Windows 2003 and Oracle is on solaris 10.I have created oracle repository on another database. I have generated template file using Backup wizard.then I...
1
by: edmundleungs | last post by:
After setting the netbackup, it is found that there is below error. SQL2062N An error occurred while accessing media "/usr/openv/netbackup/bin/nbdb2.sl". Reason code: "513" DB version: v8...
1
by: edmundleungs | last post by:
In our veritas netbackup for DB2 on AIX, the backup could be done successfully and the backup image would be listed using bplist on the AIX client. I have made several backup image, but only one...
0
by: mccuenpat | last post by:
Currently trying to perform a redirected restore of DB2 database using Netbackup in AIX environment. The restore command completes successfully but the set tablespace commands fail due to no...
2
by: Asphalt Blazer | last post by:
I am running DB2 UDB v8.1 FP 14 on AIX 5.3 I have two servers ServerA and ServerB. ServerA has instance InstA ServerB has instance InstB InstA has database DB1. DB1 is being backed up daily...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.