Hi thanks in advance


I enabled automatic maintenance to my database by enabling the db parametrs

GET DB CONFIG
...
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 statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = ON

and i set the AUTOMAINT_SET_POLICYFILE for the automatic backup by calling the stored procedure by issuing the below command

db2 "call syspoc.automaint_set_policyfile('auto_backup','db2 autobackup.xml')"
its working properly


now am trying to set the policy files to runstats and reorg but those are not working properly
my runstats xml file and command are given below

db2 "call syspoc.automaint_set_policyfile('auto_runstats',BL OB('db2runstats.xml'))[U]"

db2runstats.xml file:
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<DB2AutoRunstatsPolicy xmlns=\"http://www.ibm.com/xmlns/prod/db2/autonomic/config\">
<RunstatsTableScope><FilterCondition/></RunstatsTableScope>
</DB2AutoRunstatsPolicy>

its giving some <name> of the file is not a XML file content and no parameter found in procedure and sqlcode1447N error

i tried to set that policy with this command also
db2 "CALL SYSPROC.AUTOMAINT_SET_POLICY
( 'AUTO_RUNSTATS',
BLOB(' <?xml version=\"1.0\" encoding=\"UTF-8\"?>
<DB2AutoRunstatsPolicy xmlns=\"http://www.ibm.com/xmlns/prod/db2/autonomic/config\">
<RunstatsTableScope><FilterCondition/></RunstatsTableScope>
</DB2AutoRunstatsPolicy>')
)"

in this case also am getting the same error code

IBM DB2 9.7 for Linux, UNIX and Windows Information Center
pls check this link from this link only i got examples




pls can you guide me how to call the stored procedure for runstats and reorg pls provide example XML files


Thanks and Regards

Siddhu