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
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Lu Ann Mezera
Sent: Monday, September 18, 2000 1:03 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack
I am looking there when I am in the dsm GUI. The folder is there but when I
try to expand it, it is empty. Is there another way to look at it in the
dsm GUI or should I use a different ADSM tool? Thanks for your help.
Lu Ann Mezera
Data Center Supervisor
Lab Safety Supply
(608) 757-4909 voice
(608) 757-4652 fax
[EMAIL PROTECTED]
-----Original Message-----
From: Fluker, Tom R [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 18, 2000 12:02 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack
look at "/BACKTRACK:oracatalog" your backups are there
Tom Fluker
Viasystems Technologies
> -----Original Message-----
> From: Lu Ann Mezera [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:18 PM
> To: [EMAIL PROTECTED]
> Subject: ADSM and SQL-Backtrack
>
> We have ADSM 3.2.1 and are in the processing of implementing SQL
> Backtrack
> to backup up our Oracle databases on AIX and SQL Server 7.0 databases on
> NT.
> We know that Backtrack is pushing the backups to ADSM because when our
> Information Architect goes into Backtrack to do a database restore, she is
> successful. Also, the amount of scratch tapes in our MagStar are rapidly
> depleting. When we do a QUERY OCCUPANCY * * command in dsmadmc, we see
> two
> (2) names for our Database AIX node where the Oracle databases are
> installed
> called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog. I can see
> there are 30,000+ files and 240+ gig worth of data.
>
> This is my question. When I go into the ADSM gui, I see the high level
> file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail. Why is this?
