Restoring DB without LOGs

[Andreas Walter]

Hi,

we've got a serious problem. We are doing online backups with our DB2
Databases. The LOGs should have been backed also (seperate mechanism).
However they haven't and the machine has got a serious hdd failure.
We have only the online Backup and - of course - DB2 refuses to use the
backup without the LOGs. Actually we wouldn't have a problem with
loosing the last transactions (we can retransmit them even for days,
weeks or month) That boils it down to the question if it is possible to
"force" DB2 to "don't worry about the problems, which might occur". Any
chances? We use UDB V6.

Thanks and regards,
Andreas Walter
BBDO Interactive GmbH
Germany

Putting a valid scenario together, handable by adsm

[Andreas Walter]

Hi,

I would like to handle the following situation:

a) Some 20 clients to be backed up 24h-wise (client support verified).

b1) Server adsm1:
  primary storagepool(1): 100 GB RAID-5 for fast data handling
  secondary storagepool(2): Faststore22 for Migration from
storagepool1

Now I can backup and keep a defined number of copies of my files.
Normaly, when Faststore is running out of space (or with reaching a
defined condition), ADSM would through out older files an replace them
by new ones, which are being backed up.

I would like *not* to throw away a single file, but move/copy them to a
different system adsm2 wich has a different Tapesystem throwing out
filled tapes to move them to a secure place. How can I achieve this?
Can I handle such a thing? Or, may be there is an even better idea?
I can imagine that I'm not the first one who wants to do that ...

Regards,
Andreas.