DB2 backups as with most database backups are not deleted by directly by *SM. us
the DB2 utility db2adutl to delete the backups and log archives.
Gerhard Wolkerstorfer wrote:
> Hi *SMer,
> one of our customers is making a backup of his DB2/2 V6.1 database once a day
> and his files (One Backup
tes the backups.
James Thompson
>From: Gerhard Wolkerstorfer <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: DB2/2 Backup and Policy
>Date: Mon, 5 Feb 2001 15:56:44 +0100
>
>Hi *SMer,
>one o
Gerhard,
The filesystem information isn't always correct. Another thing you should
notice (I do with the AIX client) is that there is no Last Backup
information for the filespace, either. The filesystem size hasn't changed,
just the data held for it has. If you do a "query occupancy" (q occ)
a
ay from happy." - Snoopy (Charles Schulz)
[EMAIL PROTECTED] (Gerhard Wolkerstorfer) on 02/06/2001
03:28:17 AM
To: Nicholas Cassimatis/Raleigh/IBM@IBMUS
cc:
Subject: Antwort: Re: DB2/2 Backup and Policy
Hello Nick,
Thanks for your advices.
First - Indeed, our DB2 Admin isn't
(Charles Schulz)
[EMAIL PROTECTED] (Gerhard Wolkerstorfer) on 02/06/2001
03:28:17 AM
To: Nicholas Cassimatis/Raleigh/IBM@IBMUS
cc:
Subject: Antwort: Re: DB2/2 Backup and Policy
Hello Nick,
Thanks for your advices.
First - Indeed, our DB2 Admin isn't running a DELETE Command. Please, cou
Two things, the first one being the biggie - the DB2 Admin HAS to run the
commands to have the backups expire - otherwise they stay active forever.
If you do a "show versions NODENAME /DATABASENAME" you can see all the
versions of the backups. If they all show Active, then the DBA isn't
running t
Hello,
our Db2 admin guy does specify the MGMT_class to use in the DB2 backup
command,
regards,
> -Original Message-
> From: Gerhard Wolkerstorfer [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 3:57 PM
> To: [EMAIL PROTECTED]
> Subject: DB2/2 Ba
Hi *SMer,
one of our customers is making a backup of his DB2/2 V6.1 database once a day
and his files (One Backup = One File in the Database-Filespace!) are stored in a
filespace where the name of the filespace is the same as the DB2-Database-Name.
His Commands are:
1) to define the managementclas