Query for all backups - Informix

Query for all backups - Informix

LOG1="/tmp/sso_1234_$(whoami)_pode_deletar_1234_1.log"
LOG2="/tmp/sso_1234_$(whoami)_pode_deletar_1234_2.log"

dbaccess sysutils > /dev/null <<+

unload to $LOG1

SELECT act_aid AS backup_id,
    DECODE(act_type,
            1, 'Backup',
            2, 'Restore',
            3, 'Imported Restore',
            4, 'Fake Backup',
            5, 'Whole-System Backup',
            6, 'Whole-System Restore',
            7, 'Expired Backup',
            8, 'External Restore',
            act_type::varchar(20)
    ) AS act_type,
    DECODE(obj_type,
            'L', 'Logical log', 'Dbspace'
    ) AS obj_type,
    SUBSTR(obj_name,1, 8) AS object_name,
    act_start AS start_of_backup,
    act_end AS end_of_backup,
    act_end - act_start AS duration_of_backup,
    ins_verify_date AS verify_date
    FROM sysutils:bar_action a, sysutils:bar_instance i, sysutils:bar_object o
    WHERE   
            a.act_aid = i.ins_aid AND
                a.act_oid = o.obj_oid AND
                a.act_oid = i.ins_oid AND
                o.obj_type in ('R', 'CD', 'ND', 'L')
    ORDER BY act_start desc, backup_id
+
cat $LOG1 | awk -F "|" '{

   t_iso=$1
if ($1 == "|")
{ t_iso=" " }

printf("| %-10s | %-20s | %-15s | %-15s | %-19s | %-19s | %-15s | %-11d |\n",$1,$2,$3,$4,$5,$6,$7,$8)}' >> $LOG2


clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo 
echo


echo "+------------+----------------------+-----------------+-----------------+---------------------+---------------------+--------------------+-------------+"
echo "|backup_id   | act_type             | obj_type        | object_name     | start_of_backup     | end_of_backup       | duration_of_backup | verify_date |"
echo "+------------+----------------------+-----------------+-----------------+---------------------+---------------------+--------------------+-------------+"
cat $LOG2
echo "+------------+----------------------+-----------------+-----------------+---------------------+---------------------+--------------------+-------------+"
echo
rm $LOG1
rm $LOG2

echo