473,854 Members | 1,836 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2 netbackup issues... Please advise/discuss

7 New Member
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(v endor 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_S000000 1.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 1692

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

Similar topics

0
3168
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 written by bpbackup or read by bprestore. We are transitioning to Veritas from an older and very different tape management system. If anyone has excerpts of export/import scripts that they may share that show how to do this it would be greatly...
6
1951
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 break in, research was done which resulted in the consensus that MSDE applications were also vulnerable. Any thoughts one this? Does anyone know if running if at home could cause an open door to exist through which others might "make themselves at...
4
5793
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 images to tape using Veritas netbackup, and then restore those images and try to restore them to the database, we get "The backup image is corrupt". If we run db2ckbkp against that image we get "Unable to decompress image from different platform"....
0
1396
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 I need to worry about those logs? Why those S0000000.LOG and S0000002.LOG are still there? 28 -rw------- 1 28672 Oct 23 16:31 S0000000.LOG 12 -rw------- 1 12288 Oct 23 16:47 S0000002.LOG 48008 -rw------- 1 49160192 Oct 25 13:29 S0000021.LOG
0
1512
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 have created policy for Oracle and try to take manual backup.But It's failed with status code 6. Please help me to troubleshoot this error Now I want to backup Oracle Database.Can you send me script for backup.And also tell me where to save this file....
1
5890
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 FP14 Instance width: 32-bit Netbackup client: NetBackup-DB2-AIX5 5.1MP5 Does anyone have any suggestion or solution?
1
12482
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 image would be restored successfully. Restore with all the other images would get SQL2025N An I/O error "515" occurred on media "VENDOR". readCommFile: ERR - timed out after 900 seconds while reading from /...
0
3200
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 database connection. Tried connecting to the database before the set tablespace command but could not because a restore was in progress. Netbackup support has no answers and says this is an IBM issue. When using TSM to restore this database the...
2
3325
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 to netbackup. Both ServerA and ServerB are configured to backup to same NetBackup Host.
0
9901
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
11031
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10684
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10763
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10371
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7082
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5942
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4159
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3188
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.