terminate utility equivalent on open systems ?

Bruce Lightsey

terminate utility equivalent on open systems ?
DB2 v9.5 fp1 on AIX 5.3 64-bit

had a hangup over the weekend where Friday night's backup ( online, include
logs ) was hung up waiting on ........ something. Saturday's backup was
stalled , waiting on Friday's to finish.

When I went to stop Saturday's, I could not find anywhere on control center
to stop it, could not find any command to terminate a particular utility
from the command line, and no real help on how to whack an AWOL backup (
some days I really, really prefer z/OS ! ).

I found a process that thought is was still active from Friday AM - but
seemed to be an orphan - that was holding a lock ( long past what should
have been the timeout ). Killed it and the backup for Friday finished
immediately - guess it was waiting on that last log but nothing indicated
such - and Saturday's started and finished without problems.

Nothing in the db2diag.log to indicate a problem - until the second backup
started and the health monitor indicated that several tablespaces were
already in backup status.

Any thoughts on how to diagnose this - and, any chance that there is the
equivalent of the DB2 for Z -term for utilities available under some
disguise in DB2 for LUW ?

Thanks,
Bruce

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Gregory Palgrave

Re: terminate utility equivalent on open systems ?
(in response to Bruce Lightsey)
Sadly, they still haven't ported the excellent z/os utility handling to the LUW platform.

On LUW you've got a mix of db2 command line options:

LIST APPLICATIONS [SHOW DETAIL]
LIST UTILITIES [SHOW DETAIL]

FORCE APPLICATION (...) - to kill the db2 thread you identified.
Kill -9 from the *nix OS side if you know the pid it is running under.

Some utilities have a friendlier method:

LOAD...TERMINATE
REORG...STOP
RESTORE...ABORT

That's the main ones I can think of...hth.

You may want to check the DAS error log as well.

Cheers,

Greg


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Bruce Lightsey
Sent: Tuesday, 9 December 2008 1:59 AM
To: [login to unmask email]
Subject: [DB2-L] terminate utility equivalent on open systems ?

DB2 v9.5 fp1 on AIX 5.3 64-bit

had a hangup over the weekend where Friday night's backup ( online, include
logs ) was hung up waiting on ........ something. Saturday's backup was
stalled , waiting on Friday's to finish.

When I went to stop Saturday's, I could not find anywhere on control center
to stop it, could not find any command to terminate a particular utility
from the command line, and no real help on how to whack an AWOL backup (
some days I really, really prefer z/OS ! ).

I found a process that thought is was still active from Friday AM - but
seemed to be an orphan - that was holding a lock ( long past what should
have been the timeout ). Killed it and the backup for Friday finished
immediately - guess it was waiting on that last log but nothing indicated
such - and Saturday's started and finished without problems.

Nothing in the db2diag.log to indicate a problem - until the second backup
started and the health monitor indicated that several tablespaces were
already in backup status.

Any thoughts on how to diagnose this - and, any chance that there is the
equivalent of the DB2 for Z -term for utilities available under some
disguise in DB2 for LUW ?

Thanks,
Bruce

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Ian Bjorhovde

Re: terminate utility equivalent on open systems ?
(in response to Gregory Palgrave)
If you're backing up to disk, force application will usually work.
However, if you're backing up to storage manager (TSM, NetBackup, etc)
you will generally have to ask the storage admin to kill the session
from their admin console.

*Do not `kill -9' a DB2 engine process* -- this will take the whole
instance down.



On Mon, Dec 8, 2008 at 6:22 PM, Gregory Palgrave
<[login to unmask email]> wrote:
> Sadly, they still haven't ported the excellent z/os utility handling to the LUW platform.
>
> On LUW you've got a mix of db2 command line options:
>
> LIST APPLICATIONS [SHOW DETAIL]
> LIST UTILITIES [SHOW DETAIL]
>
> FORCE APPLICATION (...) - to kill the db2 thread you identified.
> Kill -9 from the *nix OS side if you know the pid it is running under.
>
> Some utilities have a friendlier method:
>
> LOAD...TERMINATE
> REORG...STOP
> RESTORE...ABORT
>
> That's the main ones I can think of...hth.
>
> You may want to check the DAS error log as well.
>
> Cheers,
>
> Greg
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Bruce Lightsey
> Sent: Tuesday, 9 December 2008 1:59 AM
> To: [login to unmask email]
> Subject: [DB2-L] terminate utility equivalent on open systems ?
>
> DB2 v9.5 fp1 on AIX 5.3 64-bit
>
> had a hangup over the weekend where Friday night's backup ( online, include
> logs ) was hung up waiting on ........ something. Saturday's backup was
> stalled , waiting on Friday's to finish.
>
> When I went to stop Saturday's, I could not find anywhere on control center
> to stop it, could not find any command to terminate a particular utility
> from the command line, and no real help on how to whack an AWOL backup (
> some days I really, really prefer z/OS ! ).
>
> I found a process that thought is was still active from Friday AM - but
> seemed to be an orphan - that was holding a lock ( long past what should
> have been the timeout ). Killed it and the backup for Friday finished
> immediately - guess it was waiting on that last log but nothing indicated
> such - and Saturday's started and finished without problems.
>
> Nothing in the db2diag.log to indicate a problem - until the second backup
> started and the health monitor indicated that several tablespaces were
> already in backup status.
>
> Any thoughts on how to diagnose this - and, any chance that there is the
> equivalent of the DB2 for Z -term for utilities available under some
> disguise in DB2 for LUW ?
>
> Thanks,
> Bruce
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms