View Single Post

   
  #8 (permalink)  
Old 02-26-2008, 06:06 PM
Mark A
 
Posts: n/a
Default Re: OS390 2.10 DB2 7.1.0 ARCHLOG management HELP!??

> >I don't know what manuals you are looking at, but they don't sound like
the
> >right ones. Here is the link to manuals. They are the best manuals in the

IT
> >business, by a long shot.
> >http://www-306.ibm.com/software/data...0/v7books.html
> >
> >Image copies are in the Utility Reference Manual. Image copies are

extremely
> >important. You must image copy the catalog tablespaces on a regular

basis.
> >There may be example JCL supplied for the catalog image copies with the
> >install libraries. Backup of user tablespaces is recommended also, but

not
> >quite as critical for a development environment. But if don't do image
> >copies and there is a disk failure, you could loose the database. Image
> >copies can be run with share level reference with the system up.
> >
> >I have never heard of a modern MVS system without an automated tape

library
> >(usually cartridge). But yes, you can delete the archive log files if you
> >have image copies for all tablespaces and they were made after the

archive
> >log file. I would try to keep the archive logs for a month if possible

and
> >do image copies of everything once a week.
> >
> >DB2 for OS/390 is not for people who have no education or experience on

that
> >product. I suggest you get some professional help, even if on a part time
> >temporary basis.
> >

> Yes, friends, the box from IBM for Partnerworld has one tape drive,
> and you are told not to use it for backups(?)
>
> Second note: Yea, I keep telling them a part time DBA would be a good
> idea... like yelling at a stone
>

I don't consider archiving the logs to tape to be a "backup." It's a
necessity for making DB2 work.


Reply With Quote