Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2011
    Posts
    43

    Unanswered: automaint.xml file creating

    Hi all,

    we are using db2 luw 9.7 on linux. We want to use automatic maintenance in our test- and acceptance-Tests-environments.

    Im looking for configuration possibilities for automatic backup,pls can you help how to enable automatic backups. I already enabled the db cfg parameters Like below
    Automatic maintenance (AUTO_MAINT) = ON
    Automatic database backup (AUTO_DB_BACKUP) = ON
    Automatic table maintenance (AUTO_TBL_MAINT) = ON
    Automatic runstats (AUTO_RUNSTATS) = ON
    Automatic statement statistics (AUTO_STMT_STATS) = OFF
    Automatic statistics profiling (AUTO_STATS_PROF) = OFF
    Automatic profile updates (AUTO_PROF_UPD) = OFF
    Automatic reorganization (AUTO_REORG) = ON
    But the automatic backup process conn’t takes place how to set that db2automaintpolicysample.xml file .


    Thanks in advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2011
    Posts
    43

    Red face Backup Restore in between two servers

    thanks to helping me
    ur posts are very hepling to me

    pls tell me how to restore a backup in a different server means

    For example I have taken a backup (with include logs option) in some server 112.1.1.5 and i have to restore it on 112.1.1.10 server both are having same confg. AIX 6.1 and db2 V9.7


    Regards
    Siddhu

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if different questions - open new entry in forum ..

    have also a look at infocenter about backup-restore and limitations and pre-req..
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Nov 2011
    Posts
    43
    i go through that Przytula
    but i didnt get those topics in that yar pls help me i have to do that to day

    and also am getting normal backup taking and restoring process in IBM info center

    but that is not my requirement na thats y am asking to help

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I can help if you have a specific question/problem
    teaching you DB2 is not my role (now.. because I could if needed)
    reading is something you have todo, to understand how db2 backup/restore operates..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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