Unanswered: how do you clean up old db2 backups on aix?
does anyone have a shell script that will clean up db2 backups that are older than X months old? I'm trying to write one but I don't know enough about aix shell scripts to do it. Also, in a shell script command, you can run a db2 command like:
var1='select current date from sysibm.sysdummy1'
and this will put the current date into variable var1
what delimeter do I use to build a literal within the db2 script? the " doesn't work, but if you look at the following script, you'll see what I want to do:
var1=' select "today is: " concat select current date from sysibm.sysdummy1'