on 2014 May 02 8:37 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Len
Kindly refer the IBM link IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
and also refer the SAP note for reorg 975352 - DB6: Configuring DB2 Auto Reorg for Space Reclamation and Index Cleanup
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.