Different db2 retention periods

Hello all,

I've a question regarding db2 backups and different retention periods.
Until now we've backed up db2 via api interface to tsm and delete
backups older than 14 days (via db2adutl delete backup older than 14
days).

But the new request is:
-make daily db2 backups and hold them for 2 weeks (the same request
until today)
in addtion
-monthly backups (one backup per month - I think on the last day of a
month) should be hold for 12 month
-yearly backups should be hold for 10 years

But how can I do this with tsm and db2adutl.

with kind regards,
Boris

Is this, as a 'driver' considered to be under the hardware support group? , since the only actual use of the Atape driver I'm aware of is to tie TSM to IBM tape libraries and drives, is this a part of TSM?

I just moved TSM from a P5-550 to a dedicated LPAR on a P6-550. In the process we went from AIX 5.3-06 to AIX 5.3-07. We did a fresh install of TSM 5.5.0.0 and installed the most current Atape driver (11 something whatever's on the download site). After the migration we enabled alternate pathing on our drives with no problems.

Then we tried to set alternate pathing on the library (smc) devices and got the message that "Alternate Pathing Feature is not supported by Library". Well, it bloody well worked several hours earlier on the same library. We dropped back to the previous version of Atape, used in the other system - 107.3.0 - and get the same error message.

According to ALMS, "Path Failover" is enabled (a TS-3500). We have four control points defined in the library.

I opened a PMR with Tivoli -- and I've gotten a call from entitlements, indicating they can find no record of us having support for Atape . . .

Thus the question.

We do have support for TSM Enterprise Edition (and that showed up in the entitlement database).

Do I need to route the PMR to hardware?

do I need to teach Tivoli support about their product?

TIA

Tom Kauffman
NIBC, Inc
CNFIDENTIALITY NTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.

Thursday 26 June 2008, Kauffman, Tom wrote:
Is this, as a 'driver' considered to be under the hardware support group?
, since the only actual use of the Atape driver I'm aware of is to tie
TSM to IBM tape libraries and drives, is this a part of TSM?
>
I just moved TSM from a P5-550 to a dedicated LPAR on a P6-550. In the
process we went from AIX 5.3-06 to AIX 5.3-07. We did a fresh install of
TSM 5.5.0.0 and installed the most current Atape driver (11 something
whatever's on the download site). After the migration we enabled alternate
pathing on our drives with no problems.
>
Then we tried to set alternate pathing on the library (smc) devices and got
the message that "Alternate Pathing Feature is not supported by Library".
Well, it bloody well worked several hours earlier on the same library. We
dropped back to the previous version of Atape, used in the other system -
10.7.3.0 - and get the same error message.
>
According to ALMS, "Path Failover" is enabled (a TS-3500). We have four
control points defined in the library.
We had the same problem with a new library.
I don't remember the solution, but I think the alternate path for the rmt
devices had to be entered on the AIX with dpf_keys and the alternate path for
the smc devices on the library. vice versa.

Also, if you set SANdiscovery to on, TSM will see that some devices has the
same serial number and will switch to another path if needed. I never tried
this, but in theory it should work.


Stef

Jun 26, 2008, at 3:01 PM, Kauffman, Tom wrote:

Is this, as a 'driver' considered to be under the hardware support
group? , since the only actual use of the Atape driver I'm aware
of is to tie TSM to IBM tape libraries and drives, is this a part of
TSM?

Atape is the AIX, pSeries tape and medium changer device driver. From
all that I've seen, device drivers are maintained by programmers in
IBM's hardware subdivision. (ADSM was originally a software product
engineered by the hardware division, then moved to Tivoli to more
appropriately be on the software side.) Atape is largely known for
its use by TSM, but it obviously provides native access to IBM tape
products by anything running in AIX.

Richard Sims