ADSM-L

Re: DB2 backup RC=157

2002-05-15 11:59:07
Subject: Re: DB2 backup RC=157
From: Dave Canan <ddcanan AT ATTGLOBAL DOT NET>
Date: Wed, 15 May 2002 09:00:08 -0700
        Check to see if the activity log contains any error messages. I
have seen these errors before when TSM is trying to mount a volume for the
DB2 backup that has been marked read-only. Also, what is your DB2 fixpack
level? Your TSM level?

At 04:43 PM 5/15/2002 +0100, you wrote:
*SMers,

Our DBAs are having a few problems backing up a DB2 database to a TSM 3590
tape pool via LANfree. There are no errors in the dsmerror.log on the
client, nor any indicated errors in the server actlog, nor any errors in the
NT Event Viewer that could be related.
The storage agent is running fine and not prodg any errors.
When our DBAs run

        db2=> backup db dbtest use TSM open 2 sessions

they get an error message in the DB2 logs:

        SQL2025N An I/O error '157' occurred on media 'TSM'

In the API messages it merely states that the transaction will be aborted:

In dsmrc.h
        #define DSM_RC_WILL_ABORT          157 /* Transaction will be
aborted       */

Which doesn't really indicate what cause the abort. Any ideas/suggestions
appreciated?

Ta,
Matt

LTSB Storage Support
* internal.        7-430-3213
*   external.       020-7922-3213
* fax                020-7922-3302
* e-mail            Matthew.Thomas AT Lloydstsb.co DOT uk







-----------------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee.  It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it.  If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS.  Registered in
England, number 2065.  Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH.  Registered in Scotland, number 95237.  Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Financial Services Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.

Signatories to the Banking Codes.
-----------------------------------------------------------------------------------------------------------------------


Money is not the root of all evil - full backups are.
<Prev in Thread] Current Thread [Next in Thread>