Re: DB2/2 Backup and Policy

2001-02-09 Thread Ray Pratts
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

Re: DB2/2 Backup and Policy

2001-02-09 Thread James Thompson
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

Re: Antwort: Re: Antwort: Re: DB2/2 Backup and Policy

2001-02-08 Thread Nicholas Cassimatis
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

Antwort: Re: Antwort: Re: DB2/2 Backup and Policy

2001-02-08 Thread Gerhard Wolkerstorfer
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

Re: Antwort: Re: DB2/2 Backup and Policy

2001-02-06 Thread Nicholas Cassimatis
(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

Re: DB2/2 Backup and Policy

2001-02-05 Thread Nicholas Cassimatis
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

Re: DB2/2 Backup and Policy

2001-02-05 Thread Lambelet,Rene,VEVEY,FC-SIL/INF.
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

DB2/2 Backup and Policy

2001-02-05 Thread Gerhard Wolkerstorfer
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