Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2011
    Posts
    3

    Unanswered: Steps for automatic backup

    How to schedule automatic backup to run on daily at 11pm?

    I have tried using DB2 Health Monitor. Its asks me to specify the start time and duration.

    I have mentioned start time as 11 PM and duration 1 hour.

    Still, the backup is not created in the location specified?

    What are the steps for scheduling automatic backup ?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I would suggest using OS tools that are available on your platform.

  3. #3
    Join Date
    Jun 2011
    Posts
    3
    I want to use DB2 tools for automatic backup.
    Please provide the steps for achieving the same.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by xyza View Post
    I want to use DB2 tools for automatic backup.
    Please provide the steps for achieving the same.
    Keep in mind that Health Monitor has been deprecated (may be removed in some future release).
    What's new in DB2 V9.7: Health monitor has been deprecated

    IBM is in the process of developing some replacement tools, some free and some for extra fee, to replace Health Monitor.

    Automatic maintenance has not been deprecated, but it seems to be intertwined with the Health Monitor. Most DB2 DBA's have learned by experience that cron jobs on UNIX or Linux are a better option.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by xyza View Post
    I want to use DB2 tools for automatic backup.
    If you still want to use DB2 tools (I would go with cron as Marcus suggested), take a look at another option of scheduling online backups:

    Use the SQL-based Administrative Task Scheduler in DB2 9.5 for Linux, UNIX, and Windows

Posting Permissions

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