Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: How is online backup scheduled in DB2 V7 ?

    I am using DB2 V7 on Solaris9. Daily online backups are taken.
    We needed to edit the backup job but my problem is that I do not know from where the backup script runs or where i can edit the job. I could not find any Task Center in DB2 V7 nor did i find any cron jobs for the user.
    So how do i edit the Online backup job ??

    Below given is from db2diag.log file (from this i think the application is run locally) but still cannot find the script related to this in the local machine...

    Instance:db2inst1
    Node:000
    PID:3757(db2agent (DB_NAME))
    Appid:*LOCAL.db2inst1.080508024501
    database_utilities sqlubcka
    Probe:0
    Database: DB_NAME

    Any help would be highly appreciated. Thanx in Advance !

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Hmm, it is either run by cron or control-m. How is it yoau re supporting a db and not know where your scripts are? There is noone will be able to tell you where that script is residing. Buy a crystal ball

    It is a crazy questions, but do you know that you are running an unsupported vesion of DB2?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    I got into this project very recently ! Nd the DBA guy who supported this project for 5yrs will not be available... I never got a chance to interact with him...

    So, it's natural i run into such crazy issues..

    Very well know it's an outdated version.. But think the company will support it untill it crashes :-)

    There are no cronjobs set (related to backups)..

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    WOW. nice. check the cron under his/her id. Check the control M. If all fails I suggest strt looking for a new job who know what kind stuff got left behind.

    Start searching directories. You are behind an eight ball for sure.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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