db2.conf schedule entry not picked up by backup job
Hello, I'm having problem with DB2 backup in which the schedule defined in db2.conf is not picked up by backup activity. Even if the schedule for database backup is defined in db2.conf and policy schedule, the backup is still running using shchedule defined for archive log backup. The following is the entry in the db2.conf: # The following settings are used by NetBackup to backup/restore a DB2 database. # # Reminders: # 1) The specified policy must have a type of "DB2". # 2) The specified schedule must be defined for this policy. # 3) The DB2 database host must be entered as a client for this policy. # DATABASE MCT OBJECTTYPE DATABASE POLICY MRNWINDB2_DB2 SCHEDULE Mrnwindb2-Application-Backup ENDOPER # -------------------------------------------------------------- # LOGARCHMETH1 = "VENDOR.." parameter for versions 8.2 and above # Policy is of type DB2. # -------------------------------------------------------------- # # Comment the above DB2 User Exit section when using LOGARCHMETH1 = "VENDOR.." # DATABASE MCT OBJECTTYPE ARCHIVE POLICY MRNWINDB2_DB2 SCHEDULE Log-Application-Backup ENDOPER Since the backup is using Log-Application-Backup as the schedule, the retention for database backup is having a shorter retention than it's supposed to be. Appreciate if someone could help me on this. Thank you
Backup failing in Db2 11.5.4 on RedHat 8.2
I want to perform a backup in Db2, to store it in Netbackup, but it fails. It used to work before the migration to these recent versions. Db2: 11.5.4 RedHat: 8.2 db2.conf in the Db2 instance home: DATABASE sample OBJECTTYPE DATABASE POLICY BD_DB2_DEV SCHEDULE Default-Application-Backup ENDOPER When executing the following command: $ db2 BACKUP DATABASE testconn LOAD /usr/openv/netbackup/bin/nbdb2.so64 SQL2079N An error was reported by the shared library "/usr/openv/netbackup/bin/nbdb2.so64". Return code: "30". The only Netbackup log generated under/usr/openv/netbackup/logs/bpdb2/db2inst1.100520_00001.log contains: 15:06:53.007 [2131215] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set. 15:07:38.198 [2131515] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set. 15:09:28.080 [2132336] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set. 15:21:08.837 [2135496] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set. 15:42:54.874 [2137047] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set. And the db2diag.log contains: 2020-10-05-15.42.54.783252-300 I1485538E3968 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloReadVendorRC, probe:30 MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. DATA #1 : Codepath, 8 bytes 19 DATA #2 : Hexdump, 1 bytes 0x00007F65AEFFC740 : 00 . DATA #3 : unsigned integer, 8 bytes 0 DATA #4 : Hexdump, 624 bytes 0x00007F654F0CC060 : C0CD 0C4F 657F 0000 60DC FFAE 657F 0000 ...Oe...`...e... 0x00007F654F0CC070 : 005E A74A 657F 0000 CD9B 2000 0000 0000 .^.Je..... ..... 0x00007F654F0CC080 : 2100 0000 0200 0000 0010 0000 0000 0000 !............... 0x00007F654F0CC090 : 0000 0000 0000 0000 2F64 6232 2F69 6E73 ......../db2/ins 0x00007F654F0CC0A0 : 7461 6E63 6961 732F 6465 7361 7272 6F6C stances/db2inst1 0x00007F654F0CC0B0 : 2F73 716C 6C69 622F 746D 702F 4442 3256 /sqllib/tmp/DB2V 0x00007F654F0CC0C0 : 454E 442E 5354 4449 4E2E 302E 3732 2E31 END.STDIN.0.72.1 0x00007F654F0CC0D0 : 3630 3139 3330 3537 3231 3837 3139 3400 601930572187194. 0x00007F654F0CC0E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC0F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC100 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC110 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC120 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC130 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC140 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC150 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC160 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC170 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC180 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC190 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC1A0 : 2200 0000 0100 0000 0010 0000 0000 0000 "............... 0x00007F654F0CC1B0 : 0000 0000 0000 0000 2F64 6232 2F69 6E73 ......../db2/ins 0x00007F654F0CC1C0 : 7461 6E63 6961 732F 6465 7361 7272 6F6C stances/db2inst1 0x00007F654F0CC1D0 : 2F73 716C 6C69 622F 746D 702F 4442 3256 /sqllib/tmp/DB2V 0x00007F654F0CC1E0 : 454E 442E 5354 444F 5554 2E30 2E37 322E END.STDOUT.0.72. 0x00007F654F0CC1F0 : 3136 3031 3933 3035 3732 3138 3731 3934 1601930572187194 0x00007F654F0CC200 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC210 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC220 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC230 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC240 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC250 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC260 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC270 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC280 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC290 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC2A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC2B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CC2C0 : 0000 0000 0100 0000 0100 0000 0000 0000 ................ DATA #5 : signed integer, 4 bytes 0 2020-10-05-15.42.54.783545-300 I1489507E571 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloInvokeVendorFunction, probe:30 MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown" DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes 0x800F00AF 2020-10-05-15.42.54.784481-300 I1490079E1371 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluVendorCallWrapper, probe:337 MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown" DATA #1 : String, 19 bytes Signal encountered. DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes Vendor RC=0x0000001E=30 -- see DB2 API Guide for meaning. CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F65CC209A34 _Z21sqluVendorCallWrapperP18SQLO_VENDOR_HANDLEP23sqluFencedVendorCommBufjP28sqluFencedVendorProcessStateiP12SQLU_BAGT_CB + 0x204 [1] 0x00007F65CC161E5B _Z20sqluInitVendorDeviceP13SQLUMC_IBLK_T + 0x7B [2] 0x00007F65CC151BD2 _Z18sqluMCInitBackupMCP13SQLUMC_IBLK_T + 0xD2 [3] 0x00007F65CC153CF8 _Z25sqluMCProcessBackupStatesP13SQLUMC_IBLK_T + 0x438 [4] 0x00007F65CC15445D _Z32sqluMCStartBackupMediaControllerPcj + 0x2ED [5] 0x00007F65CDCEC396 sqloEDUEntry + 0x2A6 [6] 0x00007F65D41B72DE /lib64/libpthread.so.0 + 0x82DE [7] 0x00007F65C311AE83 clone + 0x43 2020-10-05-15.42.54.790986-300 I1491451E898 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:687 DATA #1 : String, 135 bytes Vendor error: rc = 30 returned from function sqluvint. Return_code structure from vendor library /usr/openv/netbackup/bin/nbdb2.so64: DATA #2 : Hexdump, 48 bytes 0x00007F654F0CCD70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CCD80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007F654F0CCD90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2020-10-05-15.42.54.791083-300 E1492350E500 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880 MESSAGE : Media controller -- Generic error 2020-10-05-15.42.54.791140-300 E1492851E553 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880 MESSAGE : SQL2079N An error was reported by the shared library "". Return code: "". 2020-10-05-15.42.54.791233-300 E1493405E522 LEVEL: Error PID : 2135289 TID : 140074704430848 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 72 EDUNAME: db2med.47.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880 DATA #1 : String, 38 bytes /usr/openv/netbackup/bin/nbdb2.so64.30 2020-10-05-15.42.54.791334-300 E1493928E768 LEVEL: Severe PID : 2135289 TID : 140074809288448 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 47 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1137 DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes -2079 DATA #2 : Hexdump, 43 bytes 0x00007F65501ADC68 : E1F7 FFFF 2F75 7372 2F6F 7065 6E76 2F6E ..../usr/openv/n 0x00007F65501ADC78 : 6574 6261 636B 7570 2F62 696E 2F6E 6264 etbackup/bin/nbd 0x00007F65501ADC88 : 6232 2E73 6F36 34FF 3330 00 b2.so64.30. 2020-10-05-15.42.54.791455-300 E1494697E1007 LEVEL: Severe PID : 2135289 TID : 140074809288448 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 47 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1137 MESSAGE : SQL2079N An error was reported by the shared library "". Return code: "". DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2079 sqlerrml: 38 sqlerrmc: /usr/openv/netbackup/bin/nbdb2.so64 30 sqlerrp : sqlubMWR sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2020-10-05-15.42.54.791592-300 E1495705E585 LEVEL: Error PID : 2135289 TID : 140074809288448 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 47 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1139 MESSAGE : SQL2079N An error was reported by the shared library "/usr/openv/netbackup/bin/nbdb2.so64". Return code: "30". 2020-10-05-15.42.54.783425-300 E1496291E442 LEVEL: Error PID : 2135287 TID : 140157621626624 PROC : db2wdog 0 [db2inst1] INSTANCE: db2inst1 NODE : 000 HOSTNAME: db2server EDUID : 2 EDUNAME: db2wdog 0 [db2inst1] FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:9180 DATA #1 : <preformatted> Beginning cleanup of Process id: 2137037, OSS term code: 0x101, signal: 11 2020-10-05-15.42.54.833714-300 E1496734E468 LEVEL: Error PID : 2135287 TID : 140157621626624 PROC : db2wdog 0 [db2inst1] INSTANCE: db2inst1 NODE : 000 HOSTNAME: db2server EDUID : 2 EDUNAME: db2wdog 0 [db2inst1] FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:9352 DATA #1 : <preformatted> A fenced vendor process crashed. Process id: 2137037, OSS term code: 0x101, signal: 11, bringDown: 0 2020-10-05-15.42.54.833845-300 I1497203E802 LEVEL: Event PID : 2135287 TID : 140157621626624 PROC : db2wdog 0 [db2inst1] INSTANCE: db2inst1 NODE : 000 HOSTNAME: db2server EDUID : 2 EDUNAME: db2wdog 0 [db2inst1] FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10 MESSAGE : Sending SIGKILL to the following process id DATA #1 : signed integer, 4 bytes 2137037 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F79226B85DA sqlossig + 0x7A [1] 0x00000000004173FA _Z12sqleWatchDogm + 0xA6A [2] 0x00000000004199A4 DB2main + 0x1374 [3] 0x00007F79227F11C2 sqloEDUEntry + 0xD2 [4] 0x00007F7928CBC2DE /lib64/libpthread.so.0 + 0x82DE [5] 0x00007F7917C1FE83 clone + 0x43 2020-10-05-15.42.54.874812-300 I1498006E986 LEVEL: Error PID : 2135289 TID : 140074809288448 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 47 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:618 MESSAGE : SQL2062N An error occurred while accessing media "". Reason code: "". DATA #1 : String, 27 bytes Error returned by sqluvdel. DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes Vendor RC=0x0000001A=26 -- see DB2 API Guide for meaning. DATA #3 : Hexdump, 48 bytes 0x00007F654F0C1B10 : F901 0000 4E65 7442 6163 6B75 7020 4442 ....NetBackup DB 0x00007F654F0C1B20 : 3220 496E 7075 7420 496E 7661 6C69 6400 2 Input Invalid. 0x00007F654F0C1B30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2020-10-05-15.42.54.875598-300 E1498993E644 LEVEL: Error PID : 2135289 TID : 140074809288448 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-12 APPID: *LOCAL.db2inst1.201005204251 AUTHID : DB2INST1 HOSTNAME: db2server EDUID : 47 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:768 MESSAGE : SQL2062N An error occurred while accessing media "". Reason code: "". DATA #1 : String, 63 bytes Could not delete partial backup image created on vendor device. Ports are open, file system backup can be performed. What can be wrong? Is Veritas Netbackup supported in RedHat 8.2 and Db2 11.5.4?
Db2 alternet restore
Hi, I want to restore DB2 database from PRD to SBX. I am stuck in roll forward activity as theguide which shared by Veritas technician said that log backup should takes via User Exit program. While I am checking I found that logs are backed up via Vendor Method. So which command I should enter to restore database without roll forward. db2 without rolling forward restore db PRD load /usr/openv/netbackup/bin/nbdb2.so ON '/db2/SBX/sapdata1','/db2/SBX/sapdata2','/db2/SBX/sapdata3','/db2/SBX/sapdata4' DBPATH ON '/db2/SBX/' into SBX redirect DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "without rolling forward restore db PRD loa" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<values>". SQLSTATE=42601
DB2 backups are failing with error code 6 ,25, 13
Hi All, Another mind bending issue I am struggling with. The issue is the clietn servers are AIX and we dont have access thus not able to directly check anything on the client. I have cross verified the host files and they seem OK. Though I can cross check again. BPCD is successful. Any ideas which logs I should be referring to on Client and master in order to get a hold of the error messsage please? our environemtn details: Master and media are same running on NBu appliance 5200 v 2.5 OS: SUSE LINUX 7.1 Client AIX. Thanks, AnishNetbackup 7.5 for VMware and DB2 backup.
Hi Guys.... After long time I am creating this thread in NBU forum........... We have the following:- 1. IBM Lotus 8.5 on RHEL 5 (64bit). 2. IBM Content Manager using DB2 9.7 on RHEL 5 (64 bit) used for Lotus Mail Archive. Websphare is used in this software bundle. 3. Two IBM TSM server(In VM ) were used to take Lotus mail backup and DB2 backup respectively. 4. VMware server. 5. A DELL storage server is used for all the VM (VMware datastore) and its in HA mode. Current situation:- 1. There is a IBM TSM (In a VM) taking backup of Lotus mail on to disk. (Disk Based backup). 2. Another IBM TSM (In VM) taking the DB2 backup (Lotus Archive Mail). Now, we were planning to take DB2, Lotus Mail and VMs backup using NBU 7.5. My query:- 1. Can we replace both IBM TSM backup server which was used for taking Lotus mail and DB2 backup. 2. I am not sure that the NBU 7.5 can be used to take DB2 backup and is this DB2 backup will have the entire archive mail. In other word does DB2 backup will backup the Archive mail done by "IBM Content Manager". 3. Is there any restoration issue of this DB2 (Archive mail) on to the IBM Content Manager. What are the pros and cons of replacement of IBM TSM, as this came bundled with IBM Content Manager. Any best practice for this.... Thanks.
Netbackup 7.5 Media Server Cluster in an AIX HACMP environment
Hello all, I have a few questions about a medi server cluster we configured recently. When we move the apllication (DB2/SAP in HACMP cluster) from one node to the other node, it takes NetBackup up to 40 minutes to register that the application moved and to update the media server. I can see that in/usr/openv/volmgr/debug/daemon application switch was at 15:05 node1, now inactive noticed the switch at 15:18 <snip> 15:13:46.321 [8323148] <2> parsePatchVersionString: theRest = >< 15:13:46.327 [8323148] <4> UpdateClusterActiveNode: node1 is not part of a cluster 15:13:46.347 [8323148] <2> SetApplicationClusterStatus: Started 15:13:46.381 [8323148] <4> SetApplicationClusterStatus: application cluster <clsuter> is active on <node1> 15:13:46.395 [8323148] <2> SetApplicationClusterStatus: Done 15:18:46.499 [8323148] <2> mm_getnodename: (0) hostname node1 (from cached_hostname) 15:18:46.827 [8323148] <2> retrieveLocalPatchVersion: Reading from /usr/openv/netbackup/version 15:18:46.827 [8323148] <2> parsePatchVersionString: parsing = >7.5.0.3 < 15:18:46.827 [8323148] <2> parsePatchVersionString: theRest = >< 15:18:46.827 [8323148] <4> UpdateClusterActiveNode: node1 is not part of a cluster 15:18:46.827 [8323148] <2> SetApplicationClusterStatus: Started 15:18:46.974 [8323148] <4> SetApplicationClusterStatus: application cluster <cluster> is NOT active on <node1> 15:18:46.983 [8323148] <2> SetApplicationClusterStatus: Done 15:23:47.180 [8323148] <2> mm_getnodename: (0) hostname node1 (from cached_hostname) 15:23:47.208 [8323148] <2> retrieveLocalPatchVersion: Reading from /usr/openv/netbackup/version 15:23:47.212 [8323148] <2> parsePatchVersionString: parsing = >7.5.0.3 <snip> node2, now active noticed the switch at 15:45 15:40:45.941 [8716342] <2> parsePatchVersionString: theRest = >< 15:40:45.941 [8716342] <4> UpdateClusterActiveNode: node2 is not part of a cluster 15:40:45.941 [8716342] <2> SetApplicationClusterStatus: Started 15:40:45.963 [8716342] <4> SetApplicationClusterStatus: application cluster <cluster> is NOT active on <node2> 15:40:45.974 [8716342] <2> SetApplicationClusterStatus: Done 15:45:46.068 [8716342] <2> mm_getnodename: (0) hostname node2 (from cached_hostname) 15:45:46.068 [8716342] <2> retrieveLocalPatchVersion: Reading from /usr/openv/netbackup/version 15:45:46.068 [8716342] <2> parsePatchVersionString: parsing = >7.5.0.3 < 15:45:46.068 [8716342] <2> parsePatchVersionString: theRest = >< 15:45:46.068 [8716342] <4> UpdateClusterActiveNode: node2 is not part of a cluster 15:45:46.068 [8716342] <2> SetApplicationClusterStatus: Started 15:45:46.149 [8716342] <4> SetApplicationClusterStatus: application cluster <cluster> is active on <node2> 15:45:46.202 [8716342] <2> SetApplicationClusterStatus: Done 15:50:46.292 [8716342] <2> mm_getnodename: (0) hostname node2 (from cached_hostname) 15:50:46.292 [8716342] <2> retrieveLocalPatchVersion: Reading from /usr/openv/netbackup/version 15:50:46.292 [8716342] <2> parsePatchVersionString: parsing = >7.5.0.3 So it took NetBackup 40 minutes torecognise the switch. That seems a little bit to long? Or is that normal behavior? What criteria does netbackup use to determine if the cluster is active on one node? In addition to that I get a error message in this logs right after the switch: <8> file_to_cache_item: [vnet_addrinfo.c:6555] fopen() failed ERRNO=112 FILE=/usr/openv/var/host_cache/073/73053c73+0,1,41,0,1,0+10.1.30.190.txt <8> file_to_cache_item: [vnet_addrinfo.c:6555] fopen() failed ERRNO=112 FILE=/usr/openv/var/host_cache/0a8/747370a8+0,1,41,0,1,0+10.10.30.190.txt Is this something to worrry about? The IP adress 10.1.30.190 is the cluster IP, that switched with the cluster app. Maybe there is a way to include the NetBackup UpdateClusterActiveNode Commands into the scripts that run during the switch, to speed up things? Thanks in advance Volker
db2 backup with difference retention
Hi, We are facing an issue with db2 monthly backup thru NBU 7.1. Our client server is AIX and db2 version is 9.7. We are using “user exit” method to backup the db. We managed to configure the daily backup & daily transaction logs backup and it work fine. Restoration of the DB2 is also works perfectly. Our problem starts when we want to configure different retention level between our daily and monthly backup policy. Based on our understanding to configure different retention level between Daily (2 weeks) & Monthly Backup (1 year) we need to configure separate policy for each retention. But when we add in a Monthly Policy (separate script), the Montly Full backup was running as expected but somehow it took the Daily logs policy backup instead of the monthly logs backup. We did tried adding this parameters in the scrips(OPTIONS "DB2_POLICY=policy_name:DB2_SCHED=Schedule_name) but it did not help to solve this issue. Our plan is to configure policies as below : Daily Policies (retention 2 weeks): Daily_DB2 <at the end of this policy it will call Daily_Transaction_Logs policy> Daily_Transaction_Logs Monthly Policies (retention 1 year): Monthly_DB2 <at the end of this policy it will call Monthly_Transaction_Logs policy> Monthly_Transaction_Logs Need NBU gurus to advice on how to make the Monthly db backup trigger the monthly transaction logs instead of the daily transaction policy. Any help would be appreciated.
Slow DB2 DB Backups / Fast Log Backups
Hi, i've a question regarding DB2 Backups. We have DB2 on AIX and the problem are slow DB2 database Backups, the Log Backups on the other hand are running very well. DB Backups are done to SAN connected LTO5 drives and I get 50-70 MB/s. This is way to slow for the storage and the tape drives. Log backups are network backups to a media server with DSSU connected. The logs are to small to give reliable speed counters. I found a huge difference between the two backups regarding buffers, but first these are the buffers setting on the client: NUMBER_DATA_BUFFERS: 256 SIZE_DATA_BUFFERS: 262144 I have never tweaked NET_SZ_BUFFER or any other buffer setting. The BACKUP DB command from the script NetBackup starts for DB2 Backups is not tweaked either, except the OPEN 8 SESSION and INCLUDE LOGS statement. But I see a weired behavior in the backups itself. This is from a DB Backup: Info bpbkar(pid=59572348) dbclient(pid=59572348) wrote first buffer(size=4096) This is form a log backup Info bphdb(pid=65536066) dbclient(pid=65536066) wrote first buffer(size=131072) Why is the DB backups using bpkar and a 4096k buffer and the log backup is unsing bphdb and 131072k buffer? This would explain the slow data transfer to the tape drives. Can someone explain this a litte further? And how can I increase this bpkar/dbclient buffer. Volker