ADSM-L

Re: ADSM and SQL-Backtrack

2000-09-18 15:10:08
Subject: Re: ADSM and SQL-Backtrack
From: "Mark A. Adams" <mark_adams AT CSGSYSTEMS DOT COM>
Date: Mon, 18 Sep 2000 14:09:52 -0500
BackTrack had a problem with expiring it's own data.
Here are some scripts that we used to find more info
about the particular files. Hope this will help you.

Mark Adams
(402) 963-8237

/* This will show all files for a particular node */
select * from contents where node_name='SQL_BACKTRACK'

/* This script is designed to pull the files    */
/* for SQL_BACKTRACK node given a certain month */
/* for the year 2000                            */
select filespace_name, hl_name, -
ll_name from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='2000-$1'

/* This script is designed to pull the files    */
/* for SQL_BACKTRACK node given a certain month */
/* for the year 1999                            */
select node_name, filespace_name, hl_name, -
ll_name, backup_date from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='1999-$1' -
order by backup_date

/* This script obtains all nodes and their      */
/* total amount of occupancy                    */
select node_name "NODE", type, sum(num_files) -
 "# FILES", sum(physical_mb) "PHY(MB)", -
 sum(logical_mb) "LOG(MB)" from occupancy -
 group by node_name, type order by type


<Prev in Thread] Current Thread [Next in Thread>