DB2

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesDB2

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old August 28th, 2010, 02:40 PM
naessa naessa is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jul 2010
Posts: 2 naessa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 56 m 54 sec
Reputation Power: 0
Enable online backup using vendor method

Dears

Dear Friends

I followed symetic manual to enable online backup for test and it's fine.

But after I applied same steps for production EAIBDB5P/EAIBDB6P databases to be archived to

LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64
issue:
DB2 try to automated archive log without issuing any online backup , it reach hundered in one day .

sample of db2duiag.log

2010-08-28-13.20.19.605709+180 E190598A685 LEVEL: Error
PID : 1908846 TID : 1 PROC : db2logmgr (EAIBDB6P) 0
INSTANCE: wmbprd NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpInitVendorDevice, probe:1030
MESSAGE : Init failed! Vendor rc info:
DATA #1 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000000B=11 -- see DB2 API Guide for meaning.
DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFFCCA0 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0FFFFFFFFFFFCCB0 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0FFFFFFFFFFFCCC0 : 6400 0000 0868 3420 0000 0000 0000 0000 d....h4 ........

2010-08-28-13.20.19.605836+180 I191284A292 LEVEL: Error
PID : 1908846 TID : 1 PROC : db2logmgr (EAIBDB6P) 0
INSTANCE: wmbprd NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogVendor, probe:1820
RETCODE : ZRC=0x0000000B=11

2010-08-28-13.20.19.606148+180 E191577A418 LEVEL: Warning
PID : 1908846 TID : 1 PROC : db2logmgr (EAIBDB6P) 0
INSTANCE: wmbprd NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed archive for log file "S0000000.LOG" to "VENDOR chain
0" from "/var/mqsi/wmbprd/wmbprd/NODE0000/SQL00002/SQLOGDIR/".

2010-08-28-13.20.19.606296+180 I191996A412 LEVEL: Error
PID : 1908846 TID : 1 PROC : db2logmgr (EAIBDB6P) 0
INSTANCE: wmbprd NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to VENDOR chain 0 from
/var/mqsi/wmbprd/wmbprd/NODE0000/SQL00002/SQLOGDIR/ with rc = 11.

2010-08-28-13.20.19.606403+180 I192409A417 LEVEL: Warning
PID : 1908846 TID : 1 PROC : db2logmgr (EAIBDB6P) 0
INSTANCE: wmbprd NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 0 due to rc 11 for LOGARCHMETH1



This message keep repeating for both [EAIBDB5P/EAIBDB6P]: databases until db2diag.log become full how i can stop this?

For Information i have to 2 databases on this instance.
instance :wmbprd

I didn't isue any online backup it seems there is "DB2 automatic log archiving" How i can disable this.




My Question why its start archive log to vendor and keep repeating without any command issued from me.


I disable netbackup policy because it reaches thousands of jobs execution ?

I am confused what's happening.


your help will be apreacted friends.

Regards,
Nasser

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB2 > Enable online backup using vendor method


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap