Jeff,

have you checked in the summary table about the statistics of DB2 backups ?
Do you get the number of bytes tranferred, compression  data ?

                René LAMBELET
                NESTEC  SA
                GLOBE - Global Business Excellence
                Central Support Center
                Information Technology
                Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
                tél +41 (0)21 924 35 43   fax +41 (0)21 703 30 17   local
K4-404
                mailto:rene.lambelet AT nestle DOT com


-----Original Message-----
From: Jeff White [mailto:jeff.white AT CIS.CO DOT UK]
Sent: Monday,23. June 2003 13:55
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Questions Regarding Backup Of UDB (DB/2) Databases


Hi,

I have started testing backup of DB2 databases on one of our NT servers and
as a result i have two small problems.

Firstly, i can run an ONLINE backup via the DB2 Control Center GUI ok and
when i run a 'show version' via the TSM server, i can see the object as
having being backed up. However, when i issue the backup command from the
command line (DB2 BACKUP DATABASE dbname ONLINE USE TSM) the backup appears
to 'hang'. From the TSM server i can see the session in RECVW state, but it
never changes the number of bytes sent and i end up cancelling the session.
As i say, this works fine from the control center.

Secondly, with normal TSM backups, SQL and Lotus Domino backups, i always
see some stats on the TSM server showing total bytes transferred, backup
duration etc. This information is also sent back to the client in the
dsmsched.log. But these DB2 backups don't show any stats on the TSM server
or the DB2 client. In the DB2 control center, i can see that the backup
worked successfully via the JOURNALS tab. But only that it worked, not much
to say exactly what was backed up. We normally run scripts against the TSM
server actlog looking for messages indicating failed backups, but the lack
of DB2 info does'nt help me here. I want to avoid someone having to do a
manual check via the DB2 control center that the backup worked.

Any thoughts?




*************************************************************************

This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are not
the intended recipient(s) please notify us immediately so that we can make
arrangements for its return: you should not disclose the contents of this
e-mail to any other person, or take any copies. Unless stated otherwise by
an authorised individual, nothing contained in this e-mail is intended to
create binding legal obligations between us and opinions expressed are those
of the individual author.

The CIS marketing group, which is regulated for Investment Business by the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  -
for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone
0161-832-8686   Internet  http://www.cis.co.uk   E-mail cis AT cis.co DOT uk

CIS Deposit and Instant Access Savings Accounts are held with The
Co-operative Bank p.l.c., registered in England and Wales number 990937,
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS
Policyholder Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

****************************************************************************
****