Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    32

    Unanswered: Urgent problem In production

    Dear Friends

    I enabled " online backup " for 2 db's EAIBDB5P/EAIBDB6P to be archived to VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64

    But I get critical problem which is: DB2 archive log without issuing online backup see 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] until log become full how i can stop this?

    For Information i have to 2 databases on this instance.

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

    I am waiting you help friends please,
    Last edited by nasali; 08-28-10 at 09:03.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You are confusing online backup and log archiving. While log archiving is a prerequisite for online backups, it will be happening once enabled, whether you do the backup or not.

    You will need to work with your storage administrator to figure out what NetBackup error code 11 means and why it refuses to archive DB2 logs.

    On the Symantec web site you will find a manual explaining DB2 configuration for your version of NetBackup.

  3. #3
    Join Date
    Apr 2008
    Posts
    32
    Dear n i ,

    Thanks Very Much for your help.

    Regarding symentic manual i already followed it , also i do the same in test enviroment but it didn't do same "automatic archive" I am confused why it 's issuing this.

    what do you mean "log archiving is a prerequisite for online backups, it will be happening once enabled, whether you do the backup or not.
    "

    If thats right ,Do this archive happens all time or not and why it's happening wthout ask to archive.


    Best Regards,
    Nasser
    Last edited by nasali; 08-28-10 at 11:18.

  4. #4
    Join Date
    Dec 2008
    Posts
    44
    try:
    what do you have for LOGARCHMETH1? check whether it is up & working properly..

  5. #5
    Join Date
    Apr 2008
    Posts
    32
    Dear rajaraja_cholan



    LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64

    How to I know it's working probley , Because I disable policy in netbackup to avoid thousands of automated log archive!

    My Q is why DB2 try to archive automatically , this causing thousands of archive for two databases , this why i disabled backup policy on Netbackup Server.

    Same configration i made it to test and it's fine. it's archive only once i take online backup.

    Thanks & Regards.
    Nasser
    Last edited by nasali; 08-28-10 at 14:15.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •