Sorry, I should have mentioned that. We are using the API, and
db2adutl. The files go to the backup pool, not archive I believe.
Andy Carlson |\ _,,,---,,_
andyc AT andyc.carenet DOT org ZZZzz /,`.-'`' -. ;-;;,_
BJC Health System |,4- ) )-,_. ,\ ( `'-'
St. Louis, Missouri '---''(_/--' `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html
On Fri, 7 Apr 2000, Cook, Dwight E wrote:
> How are you backing up your DB2 files ?
> OK, I should probably say "You are archiving the db2 files rather than have
> nightly incremental processing deal with them."
> The archive command allows you to specify a managemet class to bind the data
> to...
> -archmc=some_management_class
> used like
> dsmc archive -archmc=30dayarc -pass=blah /d101/DB2/mydb2file
>
> So what every you are using to back it up... basically you have two
> choices...
> 1) bring down the DB
> save all the data files (archive them away)
> 2) put the DB (or table space at a time) in backup mode (or what every
> for which flavor of DBblah you have
> save the DB files (or the files associated with the table space)
>
> either way it makes sense to "save the data" via an adsm archive and use the
> -archmc option... (that way when the boss says "We have to keep tonight's
> DB archives for 10 years !" it is really really easy to do...
>
> Dwight
>
>
> > ----------
> > From: Andy Carlson[SMTP:andyc AT ANDYC.CARENET DOT ORG]
> > Reply To: ADSM: Dist Stor Manager
> > Sent: Friday, April 07, 2000 8:41 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: DB2 Management Class
> >
> > I looked back in the archives, and found a thread that mentioned that
> > DB2 data could be put in it's own management class. How is this done?
> > I have experimented with making the default management class the one I
> > want for DB2, and setting the filespaces in inclexcl to a different
> > management class, but the results are mixed. I don't see the rebinding
> > occurring, and even some new test files don't seem to go to that
> > management class. Thanks for any help.
> >
> > Andy Carlson |\ _,,,---,,_
> > andyc AT andyc.carenet DOT org ZZZzz /,`.-'`' -. ;-;;,_
> > BJC Health System |,4- ) )-,_. ,\ ( `'-'
> > St. Louis, Missouri '---''(_/--' `-'\_)
> > Cat Pics: http://andyc.dyndns.org/animal.html
> >
>
|