Topic
1 reply Latest Post - ‏2014-05-03T13:39:28Z by sanyock
sanyock
sanyock
5 Posts
ACCEPTED ANSWER

Pinned topic Does anybody need a tool to run SQL on a group of databases may be on different servers

‏2014-05-03T13:19:53Z |

Dear DB2 Admins,

There is a freeware tool which is able to define groups of DB2 and MSSQL databases may be on several servers and then

run your custom SQL commands  and DB2CMD commands on defined groups of databases or a specific database just by a single click or from a command line.

You are welcome to download the program at: http://aulix.com/adbm

If someone interested just e-mail your suggestions which features you would like to add

 

 

  • sanyock
    sanyock
    5 Posts
    ACCEPTED ANSWER

    Re: Does anybody need a tool to run SQL on a group of databases may be on different servers

    ‏2014-05-03T13:39:28Z  in response to sanyock

    The program can create full backups and clean them according to an agile schedule like following:
    /Period1=30,1 - keep everyday backups made during last 30 days
    /Period2=90,3 - keep backup for every 3rd day during last 90 days
    /Period3=120,15 - keep backup for every 15-th day during last 120 days
    You can specify several periods simultaniously and then they will be define a matrix of days on which backups shall be kept, backups on other days will be deleted.
    You can apply additional filters to processes only backups created during a period of /FromDate=xxx till /ToDate=xxx       or /DuringLastDays=xxx