Re: -TERM UTILITY

Phil Grainger

Re: -TERM UTILITY
(in response to Hamid Alvani)
Hmm

The reason code indicates that there should have been other messages as
well.

Also, it should not be possible to DROP a tablespace that is the subject of
an in-progress utility......

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]

-----Original Message-----
From: Hamid Alvani [mailto:[login to unmask email]
Sent: 06 January 2003 18:21
To: [login to unmask email]
Subject: [DB2-L] -TERM UTILITY


Hi All,
How i can terminate a RUNSTAT utility that is in STOPPED status.
-TERM UTILITY fail with reason code 00E40030 beause i guess table space is
droped.
THANKS



Christopher Tee

Re: -TERM UTILITY
(in response to Phil Grainger)
Hamid,

Have you checked to see if the tablespace has actually been dropped? If so,
somebody must have started it with ACCESS(FORCE). As far as I can remember,
the only way to get out of this is to run the step in the install job
DSNTIJID that initialises the SYSUTILX tablespace and then rebuild the
indexes. Make sure there are no other utilities (running or stopped)
before doing this.

Chris

-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: 06 January 2003 11:13
To: [login to unmask email]
Subject: Re: -TERM UTILITY


Hmm

The reason code indicates that there should have been other messages as
well.

Also, it should not be possible to DROP a tablespace that is the subject of
an in-progress utility......

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]

-----Original Message-----
From: Hamid Alvani [mailto:[login to unmask email]
Sent: 06 January 2003 18:21
To: [login to unmask email]
Subject: [DB2-L] -TERM UTILITY


Hi All,
How i can terminate a RUNSTAT utility that is in STOPPED status.
-TERM UTILITY fail with reason code 00E40030 beause i guess table space is
droped.
THANKS





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

Hamid Alvani

-TERM UTILITY
Hi All,
How i can terminate a RUNSTAT utility that is in STOPPED status.
-TERM UTILITY fail with reason code 00E40030 beause i guess table space is
droped.
THANKS


Max Scarpa

Re: -TERM UTILITY
(in response to Christopher Tee)
Hi all

yes it's possible to DROP a TS if a there's a stopped utility on it (at
least it was in V5 - I suppose you can do it even in V6 /V7).

It's not necessary to recreate SYSUTILX (it's not always so easy), you can
clean it using REPAIR.


Regards

MS