After skripting jdbc and j2ee on WebSphere i was interested to fasten the DB2 configuration after a Connections installation.
There are two ways to get valid source xml-Files for automatic maintenance in DB2. I use automatic maintenance, because i can set a maximum backup time and how many dumps of one database should be stored. DB2 deletes old backups (which i have in a filebackup each night) automatically.
You can’t script this settings directly, IBM provides two system calls for this: sysproc.automaint_set_policyfile and sysproc.automaint_set_policy.
I use the file variant here, because i think it easier to handle files than blob content.
Read more →