Skip to Content
avatar image
Former Member

Backup error

Hi

Quality system automatic backup is showing error..tape drive also some problem..

i want to setup manuall back ..please where i am going to configure..

please steps

OS: Windows

DB : DB2

Edited by: Sri Sap N on Feb 16, 2010 9:34 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 16, 2010 at 08:39 AM

    Hi,

    Please give the error log also when posting any issue which will help us to help you soon. As you already said there is a problem with tape and you want to take manual backup, take the backup to a disk (based on availability of space)

    For that you need to make changes in the below parameters in init<SID>.sap file

    backup_type (online or offline)

    backup_dev_type (disk)

    backup_root_dir (path of disk where u r taking backup)

    After this you can start the backup from DB13 or from BRTOOLS

    Thanks & Regards,

    Sharath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2010 at 09:35 AM

    Hi,

    Try To This Command db2 BACKUP DATABASE IDS TO F:/backup. IDS is your SID.

    Regards,

    Pankaj

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16, 2010 at 11:08 AM

    Hi,

    You can perform Disk to Disk Backup.

    You can perform manual backup using DB13 job "Database Backup to Device", where you will have to provide full directory path of the location where you want to save Backup File, along with other required parameter values as mentioned in below command.

    At command level (DB2CLP) you can execute the following command.

    > db2 BACKUP DATABASE <DBSID> TO <directory location> WITH 2 BUFFERS BUFFER 4096 INCLUDE LOGS WITHOUT PROMPTING

    If you want to take DB Backup to remote Disk/directory location of remote host, then make sure that the User (with with the DB2 Instance processes/service are running ) should have the read/write/change access authorizations at remote location.

    Regards,

    Bhavik G. Shroff

    Add comment
    10|10000 characters needed characters exceeded