cancel
Showing results for 
Search instead for 
Did you mean: 

Need to set auto maint policy from command line

former_member283840
Participant
0 Kudos
363

Wise DB2 Wizards:

I am unable to set my auto_maint policy for anything (backup, runstats, reorgs, etc. from the DB6COCKPIT.  When I first go into the DB6COCKPIT and click on the Automatic Maintenance settings I receive a  '   !  PRD    Backup policy corrupted!   No <AC_Policy> found.'    I am then unable to change/update the policy in the DB6COCKPIT because it wants an entry in the  Automatic Backup tab.  I can fill it in but the  'Backup Operation Type'  does not have anything in it even though there is a drop down.  If I try to go to the Auto Runstats or Auto Reorg Tabs they are not open.  The message at the bottom of the window is,  " !  Fill in all required fields"   Meaning the  Backup Operation Type'.   Now this may be OK as this system is managed by the SOLMAN system.  So when I log onto my SOLMAN system and select the  'PRD'  system it does not have the 'modify' button.  It is greyed out.

So what I want to do is turn on Auto_Reorg.  I already have the policy created for it.  I need to update the autobackup policy (is none now even though the message indicates that it is corrupted) but I am not sure about what to put since I don't want to enable the autobackup (we do snapshots using a 3rd party tool) so this won't work.  I see the sample entry in db2/db2prd/sqllib/samples/DB2AutoBackupPolicySample.xml  but don't know where to start with it.  All my systems use the 'snapshot' practice and it works well so I know it isn't that.

What is the syntax for the command line to update the policy for autobackup?

Thanks to all who have helped out.

Len.

Accepted Solutions (0)

Answers (2)

Answers (2)

s_yuksektepe
Explorer
0 Kudos

Hi Leonard

Kindly refer to http://www.ibm.com/developerworks/data/library/techarticle/dm-0801ganesan/, which is a pretty good description on how-to-auto_reorg. An example with customized automatic backup policy and how to implemented is described. Please study this material.

     <?xml version="1.0" encoding="UTF-8"?>

<DB2AutoBackupPolicy

xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config" >

<BackupOptions mode="Online" >

  <BackupTarget>

  <DiskBackupTarget>

  <PathName>/TMP/mydb1/backupimages/</PathName>

  </DiskBackupTarget>

  </BackupTarget>

</BackupOptions>

<BackupCriteria

  numberOfFullBackups="1"

  timeSinceLastBackup="336"

  logSpaceConsumedSinceLastBackup="1000" />

</DB2AutoBackupPolicy>


COMMAND LINE to SETUP:

db2 "call sysproc.automaint_set_policyfile('AUTO_BACKUP','mydb/backup.xml');"

db2 commit


If not done yet, perform a Self-Monitoring in DBA Cockpit, which will point you to the master Note.

For SAP Basis Release 7.02 / 7.30 / 7.31 you can implement note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31

Hope this helps

Regards

Sem

S_Sriram
Active Contributor
0 Kudos
former_member283840
Participant
0 Kudos


SS;

Thanks for the reply but I thought I pointed out in my description that I HAVE the policy for auto_reorg.  I need to have the policy for autobackup....which makes no sense since I don't want to enable that policy anyway.  NO AUTOBACKUP.....that is what is stopping me from configuring it in the DB6COCKPIT.

I need to have the policy for 'AUTOBACKUP' even though I am not enabling it.  I guess it would contain the AUTOBACKUP = NO somehow in it.

Len.

former_member196032
Participant
0 Kudos

Hi Len,  did you ever get this resolved?  I just setup the auto_reorg policy per SAP and I have the same issue.

Anke

former_member283840
Participant
0 Kudos


Anke;

No this never did get resolved.  I have just switched off the feature for now.

Maybe someone will see this and help out.

Thanks,

Len.