cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 Backups Failing

SF_Chewy
Level 4

Hi guys,

I'm attempting to do DB2 backups and they are failing with the following errors:

  • "E0000430 - The Database script returned an error. Refer to the Database script output section in job logs for more details."

For each of the DB2 selections I get the following DB2 output when I click on the selections that failed (I can attach a screenshot if this isn't clear):

  • Note: Resource: "resource name" is not snappable. Attempting to back up directly from the source volume.
  • DB2 Output: Files\Symantec\Backup was unexpected at this time.
  • Devices acquired: 1
  • Data streams used: 0

I configured the following things:

  • I have configured the appropriate access information via the Resource Credentials on the BE Server
  • On the BE server the DB2 server does show up with the appropriate DB2 selections
  • On the DB2 server I have installed the remote agent and configured the DB2 credentials via the DB2 tab on the remote.
  • Instance name I just left as DB2
  • User Name and PW is the DB2 credentials
  • Media Server is the IP of the Media Server
  • Job Template, I have put as the name of the job in BE
  • Archive Log Template I left as Default
  • In the Database Access Tab I have Enable media server authentication for Oracle and DB2 operations and I utilized the DB2 login credentials once again
  • I also have Use the full computer name or IP address of Oracle and DB2 operations and I entered in the IP address of the DB2 server.
  • On the Media Server I have attempted both online and offline backups of DB2 with and without the quiesce option selected

Everything else that does not require DB2 successfully completes to the server.

Current setup is as follows:

Media Server

  • BE 12.5 with latest SPs
  • Windows 2003 R2 x64
  • DB2 Agent is installed

DB2 Server

  • Windows 2003 Standard Edition SP2 32-bit
  • Remote Agent installed

I would appreciate any help that enables me to properly configure this thing and get'er going. Thanks

- Chris

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

There should be a built-in facility in DB2 to back the database to flat files.  Use this facility to backup the databases to flat files and then back these up with BE.  To restore, restore the flat files first and then use the built-in DB2 facility to restore the database.

View solution in original post

5 REPLIES 5

itsmeaffinity
Level 6

Hi

 

What is version Db2

 

Thank You

SF_Chewy
Level 4

Whoops forgot about that here it is from the server

============================================================
About System - KRAMER
============================================================
DB2 Administration Server (DAS) level:
Product identifier           SQL08010
Level identifier             01010106
Level                        DB2 v8.1.0.36
Build level                  s021023
PTF                          
============================================================
Operating system:
Product                      WIN32_NT
Version                      5.2 Service Pack 2
============================================================

pkh
Moderator
Moderator
   VIP    Certified

DB2 8.1 is not supported by BE 12.5, only 8.2 onwards.  See the SCL below

http://www.symantec.com/business/support/index?page=content&id=TECH62301&actp=search&viewlocale=en_U...

SF_Chewy
Level 4

Well that sucks.

 

Any suggested work arounds? I need this database to be backed up.

pkh
Moderator
Moderator
   VIP    Certified

There should be a built-in facility in DB2 to back the database to flat files.  Use this facility to backup the databases to flat files and then back these up with BE.  To restore, restore the flat files first and then use the built-in DB2 facility to restore the database.