Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2010
    Posts
    36

    Unanswered: Is it possible to create a new scheduled backup task using the DB2 CLP?

    Hi folks,

    Is it possible to create a task right from the DB2 CLP instead of using the IBM Task Center (GUI) ?

    DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
    DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

    Thank you and have a great day!
    Charles M.
    DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
    DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

  2. #2
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    You can use sysproc.admin_task_add procedure to add new task. Check IBM info center for other details


    link: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


    Satya...

  3. #3
    Join Date
    Jun 2010
    Posts
    36

    Thumbs up

    Interesting...!

    Thanks for the information
    Charles M.
    DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
    DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

  4. #4
    Join Date
    Jun 2010
    Posts
    36
    Tasks added with that stored procedure don't show up in the Task Center itself... Is there a difference between the two? What I would like to do is adding a backup task schedule command at the end of my database creation script, so I couldn't forget to set the backup schedule.
    Charles M.
    DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
    DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

  5. #5
    Join Date
    Jun 2010
    Posts
    36
    Just had another idea...

    Would it be possible to create a kind of cursor that would loop
    through all databases in an instance and then issue the BACKUP
    command?


    That way my problem would be solved with one single dynamic task.
    Charles M.
    DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
    DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

Tags for this Thread

Posting Permissions

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