Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Red face Unanswered: Deleting backup images no longer needed

    Hi all,

    DB2 8.1.5 on Win 2000

    How do i delete backup images no longer needed? In MS-SQL 2000 we do a maintainence plan which automatically deletes the backup images after a certain number of days. Do we have a similar feature in DB2? I did go to the task center and wrote scripts to do a backup every night. Now i want to delete those images 7 or more days old.

    Thanks in advance,

    Newbie

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi dsusendran,
    I have this problem. Any idea?

    TIA
    Abel.

  3. #3
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    Hi Abel,

    I am not still sure how to do it, but right now i delete the backup images manually (i have handful of databases only). The changes do reflect in the control center.

    Others, Any pointers?

    Thanks in Advance,
    Newbie

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Thanks for your quickly reply.
    I've searching information.
    Any news, I tell you.

    Thanks again.
    Abel.

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow db2adutl

    If your command line processor
    is up and running you can
    use the db2adutl utility

    use 'db2adutl query' to list your backup images

    use 'db2adutl delete <options>' to remove/deactivate

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  6. #6
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Hi Tank
    Thanks for your repy.
    My db2 is 8.1.5 on win2000.

    Do you know, if is need Tivoli for run this command?

    In my case I get this error:
    Unable to locate DLL:
    ... TSMAPI.DLL ...

  7. #7
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow

    Actually I don't know if it only
    works with TSM - I'm sorry
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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