MODIFY utility Problem

Pantazis Pantazi

MODIFY utility Problem
Hi,

I run the MODIFY utility for some time now but last weekend we had a
problem when it reached
the point to be run against the SYSCOPY tablespace when the following
message appeared.

MODIFY RECOVERY TABLESPACE DSNDB06.SYSCOPY DELETE AGE(120)
UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C90101'

I run the CHECK INDEX and no problem was reported. I run the CHECK DATA
with SCOPE ALL
and still I received the message the there is no table to be checked in
this tablespace.

I have tried the job again but still the problem is there, somewhere. We
are on DB2/390 V6.1

Any suggestions on what to do next are more than welcome?

Regards,

Pantazis Pantazi
Database Administrator

Enterprise Systems Support
Information Services Division
Laiki Group, Cyprus
Tel: +357-22812530, Fax: +357-22812583
Email: [login to unmask email]
************************************************************************************
Privileged/Confidential information may be contained in this message and
may be subject to legal privilege. Access to this e-mail by anyone other
than the intended recipient is unauthorised. If you are not the intended
recipient (or responsible for delivery of the message to such person), you
may not use, copy, distribute or deliver to anyone this message (or any
part of its contents) or take any action in reliance on it. In such case,
you should destroy this message, and notify us immediately.

If you have received this email in error, please notify us immediately by
e-mail or telephone and delete the e-mail from any computer. If you or your
employer does not consent to internet e-mail messages of this kind, please
notify us immediately.

All reasonable precautions have been taken to ensure no viruses are present
in this e-mail. As we cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments we recommend that you
subject these to your virus checking procedures prior to use.

The views, opinions, conclusions and other information expressed in this
electronic mail are not given or endorsed by Laiki Group unless otherwise
indicated by an authorised representative independent of this message.
************************************************************************************



Christopher Tee

Re: MODIFY utility Problem
(in response to Pantazis Pantazi)
Pantazis

Have a look at APAR PQ48868, it sounds like your problem.

Chris

-----Original Message-----
From: Pantazis Pantazi [mailto:[login to unmask email]
Sent: 16 January 2003 10:41
To: [login to unmask email]
Subject: MODIFY utility Problem


Hi,

I run the MODIFY utility for some time now but last weekend we had a
problem when it reached
the point to be run against the SYSCOPY tablespace when the following
message appeared.

MODIFY RECOVERY TABLESPACE DSNDB06.SYSCOPY DELETE AGE(120)
UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C90101'

I run the CHECK INDEX and no problem was reported. I run the CHECK DATA
with SCOPE ALL
and still I received the message the there is no table to be checked in
this tablespace.

I have tried the job again but still the problem is there, somewhere. We
are on DB2/390 V6.1

Any suggestions on what to do next are more than welcome?

Regards,

Pantazis Pantazi
Database Administrator

Enterprise Systems Support
Information Services Division
Laiki Group, Cyprus
Tel: +357-22812530, Fax: +357-22812583
Email: [login to unmask email]
****************************************************************************
********
Privileged/Confidential information may be contained in this message and
may be subject to legal privilege. Access to this e-mail by anyone other
than the intended recipient is unauthorised. If you are not the intended
recipient (or responsible for delivery of the message to such person), you
may not use, copy, distribute or deliver to anyone this message (or any
part of its contents) or take any action in reliance on it. In such case,
you should destroy this message, and notify us immediately.

If you have received this email in error, please notify us immediately by
e-mail or telephone and delete the e-mail from any computer. If you or your
employer does not consent to internet e-mail messages of this kind, please
notify us immediately.

All reasonable precautions have been taken to ensure no viruses are present
in this e-mail. As we cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments we recommend that you
subject these to your virus checking procedures prior to use.

The views, opinions, conclusions and other information expressed in this
electronic mail are not given or endorsed by Laiki Group unless otherwise
indicated by an authorised representative independent of this message.
****************************************************************************
********







-----------------------------------------------------------------------------------------------------------------------
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.
-----------------------------------------------------------------------------------------------------------------------

Pantazis Pantazi

Re: MODIFY utility Problem
(in response to Christopher Tee)
Thanks for the help.

I will check it later since I am in a hurry now. Leaving for holidays.

I need a break in order to recharge my batteries.

Regards,

Pantazis Pantazi
Database Administrator

Enterprise Systems Support
Information Services Division
Laiki Group, Cyprus
Tel: +357-22812530, Fax: +357-22812583
Email: [login to unmask email]


|---------+---------------------------------->
| | "Tee, Christopher" |
| | <[login to unmask email]|
| | TSB.CO.UK> |
| | Sent by: DB2 Data Base |
| | Discussion List |
| | <[login to unmask email]|
| | .COM> |
| | 16/01/2003 13:55 |
| | Please respond to DB2 |
| | Data Base Discussion |
| | List |
| | |
| | |
|---------+---------------------------------->
>---------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| bcc: |
| Subject: Re: MODIFY utility Problem |
| |
>---------------------------------------------------------------------------------------------------------|




Pantazis


Have a look at APAR PQ48868, it sounds like your problem.


Chris


-----Original Message-----
From: Pantazis Pantazi [mailto:[login to unmask email]
Sent: 16 January 2003 10:41
To: [login to unmask email]
Subject: MODIFY utility Problem





Hi,


I run the MODIFY utility for some time now but last weekend we had a
problem when it reached
the point to be run against the SYSCOPY tablespace when the following
message appeared.


MODIFY RECOVERY TABLESPACE DSNDB06.SYSCOPY DELETE AGE(120)
UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C90101'


I run the CHECK INDEX and no problem was reported. I run the CHECK DATA
with SCOPE ALL
and still I received the message the there is no table to be checked in
this tablespace.


I have tried the job again but still the problem is there, somewhere. We
are on DB2/390 V6.1


Any suggestions on what to do next are more than welcome?


Regards,


Pantazis Pantazi
Database Administrator


Enterprise Systems Support
Information Services Division
Laiki Group, Cyprus
Tel: +357-22812530, Fax: +357-22812583
Email: [login to unmask email]
************************************************************************************

Privileged/Confidential information may be contained in this message and
may be subject to legal privilege. Access to this e-mail by anyone other
than the intended recipient is unauthorised. If you are not the intended
recipient (or responsible for delivery of the message to such person), you

may not use, copy, distribute or deliver to anyone this message (or any
part of its contents) or take any action in reliance on it. In such case,
you should destroy this message, and notify us immediately.


If you have received this email in error, please notify us immediately by
e-mail or telephone and delete the e-mail from any computer. If you or your

employer does not consent to internet e-mail messages of this kind, please
notify us immediately.


All reasonable precautions have been taken to ensure no viruses are present

in this e-mail. As we cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments we recommend that you
subject these to your virus checking procedures prior to use.


The views, opinions, conclusions and other information expressed in this
electronic mail are not given or endorsed by Laiki Group unless otherwise
indicated by an authorised representative independent of this message.
************************************************************************************





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can




-----------------------------------------------------------------------------------------------------------------------

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.
-----------------------------------------------------------------------------------------------------------------------






********************************************************************************************
Privileged/Confidential information may be contained in this message and
may be subject to legal privilege. Access to this e-mail by anyone other
than the intended recipient is unauthorised. If you are not the intended
recipient (or responsible for delivery of the message to such person), you
may not use, copy, distribute or deliver to anyone this message (or any
part of its contents) or take any action in reliance on it. In such case,
you should destroy this message, and notify us immediately.

If you have received this email in error, please notify us immediately by
e-mail or telephone and delete the e-mail from any computer. If you or your
employer does not consent to internet e-mail messages of this kind, please
notify us immediately.

All reasonable precautions have been taken to ensure no viruses are present
in this e-mail. As we cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments we recommend that you
subject these to your virus checking procedures prior to use.

The views, opinions, conclusions and other information expressed in this
electronic mail are not given or endorsed by Laiki Group unless otherwise
indicated by an authorised representative independent of this message.
********************************************************************************************