STOPP Status

ISDC Chennai Mohamed Arif

STOPP Status

Hi,

When I tried to copy production tablespaces to test tablespaces using
DSN1COPY, it gave "CONTENTION WITH DB2DDBM1". So I issued the STOP
DATABASE command for that test database. But it is in STOPP status. when
I tried of -DIS DATABASE USE ,it shows

DSNT360I -DB2D ***********************************
DSNT361I -DB2D * DISPLAY DATABASE SUMMARY
* GLOBAL USE
DSNT360I -DB2D ***********************************
DSNT362I -DB2D DATABASE = IKHDB05 STATUS = STOPP
DBD LENGTH = 92864
DSNT397I -DB2D
NAME TYPE PART STATUS CONNID CORRID USERID
-------- ---- ---- ------------------ -------- ------------ --------
IKHTS01 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS02 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS03 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100
IKHTS05A TS RW
IKHTS09 TS RW
IKHTS10 TS 001 RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100

I am getting this for last 3 hours.

Will the status become STOP automatically once above process is over ?
Any way it is not urgent to run DSN1COPY.
Pls suggest

Thanks,
Arif



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: STOPP Status
(in response to ISDC Chennai Mohamed Arif)
Once all cqw32.exe instances releases their resource (do a COMMIT), the
STOPP should be converted into a STOP. However, in the meantime, all other
threads trying to access the TS will get a "resource unavailable". Having
some experience with the way that servers are programmed, I predict that
those two threads will never go away on their own. So you can a) kill the
threads, or b) cancel your STOP command. That's easy if you've issued it
from a batch, it just takes a long time. If you've issued it
interactively, it will take a very long time.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] STOPP Status





"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 10:19



Hi,
When I tried to copy production tablespaces to test tablespaces using
DSN1COPY, it gave "CONTENTION WITH DB2DDBM1". So I issued the STOP
DATABASE command for that test database. But it is in STOPP status. when I
tried of -DIS DATABASE USE ,it shows
DSNT360I -DB2D ***********************************
DSNT361I -DB2D * DISPLAY DATABASE SUMMARY
* GLOBAL USE
DSNT360I -DB2D ***********************************
DSNT362I -DB2D DATABASE = IKHDB05 STATUS = STOPP
DBD LENGTH = 92864
DSNT397I -DB2D
NAME TYPE PART STATUS CONNID CORRID USERID
-------- ---- ---- ------------------ -------- ------------ --------
IKHTS01 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS02 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS03 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100
IKHTS05A TS RW
IKHTS09 TS RW
IKHTS10 TS 001 RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100
I am getting this for last 3 hours.
Will the status become STOP automatically once above process is over ? Any
way it is not urgent to run DSN1COPY.
Pls suggest
Thanks,
Arif

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ivan L

Re: STOPP Status
(in response to Michael Ebert)

Hi,

The DB2 command timeout is 10 times IRLMWAIT (using default this will be 10 min.) DB2 will retry to stop the object 15 times (every 10 min.) If cannot stop the object(cause of the locks) within this time (default 2h30m) the obejct will remain in STOPP status although cqw32.exe instances releases their resources.

When an object is in stopp and have no locks, u could do STOP or START to get the object to the desired state.



________________________________

De: DB2 Data Base Discussion List [mailto:[login to unmask email] En nombre de Mohamed Arif (HCL Financial Services)
Enviado el: miércoles, 22 de noviembre de 2006 10:20
Para: [login to unmask email]
Asunto: [DB2-L] STOPP Status




Hi,

When I tried to copy production tablespaces to test tablespaces using DSN1COPY, it gave "CONTENTION WITH DB2DDBM1". So I issued the STOP DATABASE command for that test database. But it is in STOPP status. when I tried of -DIS DATABASE USE ,it shows

DSNT360I -DB2D ***********************************
DSNT361I -DB2D * DISPLAY DATABASE SUMMARY
* GLOBAL USE
DSNT360I -DB2D ***********************************
DSNT362I -DB2D DATABASE = IKHDB05 STATUS = STOPP
DBD LENGTH = 92864
DSNT397I -DB2D
NAME TYPE PART STATUS CONNID CORRID USERID
-------- ---- ---- ------------------ -------- ------------ --------
IKHTS01 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS02 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS03 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100
IKHTS05A TS RW
IKHTS09 TS RW
IKHTS10 TS 001 RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100

I am getting this for last 3 hours.

Will the status become STOP automatically once above process is over ? Any way it is not urgent to run DSN1COPY.
Pls suggest

Thanks,
Arif


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


Banco de España - Aviso legal

Este mensaje, su contenido y cualquier fichero transmitido
con él está dirigido únicamente a su destinatario y es
confidencial. Por ello, se informa a quien lo reciba por error o
tenga conocimiento del mismo sin ser su destinatario, que la
información contenida en él es reservada y su uso no
autorizado, por lo que en tal caso le rogamos nos lo comunique
por la misma vía o por teléfono (+ 34 91 338 66 66), así como
que se abstenga de reproducir el mensaje mediante cualquier
medio o remitirlo o entregarlo a otra persona, procediendo a su
borrado de manera inmediata.

El Banco de España se reserva las acciones legales que le
correspondan contra todo tercero que acceda de forma
ilegítima al contenido de cualquier mensaje externo procedente
del mismo.

Para informacion y consultas visite nuestra web
http://www.bde.es


Banco de España - Disclaimer
This message, its content and any file attached thereto is for
the intended recipient only and is confidential. If you have
received this e-mail in error or had access to it, you should
note that the information in it is private and any use thereof
is unauthorised. In such an event please notify us by e-mail or
by telephone (+ 34 91 338 66 66). Any reproduction of this
e-mail by whatsoever means and any transmission or dissemination
thereof to other persons is prohibited. It should be deleted
immediately from your system.

The Banco de España reserves the right to take legal action
against any persons unlawfully gaining access to the content of
any external message it has emitted.

For additional information, please visit our website
http://www.bde.es

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

ISDC Chennai Mohamed Arif

Re: STOPP Status
(in response to Ivan L)
Hi,

How can I cancel the STOP command..? When I issued -START DATABASE
(dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Michael Ebert
Sent: Wednesday, November 22, 2006 3:21 PM
To: [login to unmask email]
Subject: Re: [DB2-L] STOPP Status



Once all cqw32.exe instances releases their resource (do a COMMIT), the
STOPP should be converted into a STOP. However, in the meantime, all
other threads trying to access the TS will get a "resource unavailable".
Having some experience with the way that servers are programmed, I
predict that those two threads will never go away on their own. So you
can a) kill the threads, or b) cancel your STOP command. That's easy if
you've issued it from a batch, it just takes a long time. If you've
issued it interactively, it will take a very long time.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>


To
[login to unmask email]

cc

bcc

Subject
[DB2-L] STOPP Status



"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>


Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 10:19




Hi,


When I tried to copy production tablespaces to test tablespaces using
DSN1COPY, it gave "CONTENTION WITH DB2DDBM1". So I issued the STOP
DATABASE command for that test database. But it is in STOPP status. when
I tried of -DIS DATABASE USE ,it shows


DSNT360I -DB2D ***********************************
DSNT361I -DB2D * DISPLAY DATABASE SUMMARY
* GLOBAL USE
DSNT360I -DB2D ***********************************
DSNT362I -DB2D DATABASE = IKHDB05 STATUS = STOPP
DBD LENGTH = 92864
DSNT397I -DB2D
NAME TYPE PART STATUS CONNID CORRID USERID
-------- ---- ---- ------------------ -------- ------------ --------
IKHTS01 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS02 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS03 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW DB2D 020.STOPDB09 SYSOPR
IKHTS04 TS RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100
IKHTS05A TS RW
IKHTS09 TS RW
IKHTS10 TS 001 RW SERVER cqw32.exe T37CT44
A19F7464.M209.061120213624=807 ACCESSING DATA FOR 161.159.116.100


I am getting this for last 3 hours.


Will the status become STOP automatically once above process is over ?
Any way it is not urgent to run DSN1COPY.
Pls suggest


Thanks,
Arif



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: STOPP Status
(in response to ISDC Chennai Mohamed Arif)
Hi,

if you issued it interactively, you can try to cancel it through a monitor
product, like Omegamon. I don't remember whether this actually worked; if
yes, you'll still have to wait for up to 10 times the IRLM timeout value
(in batch, you'd only have to wait for at most one IRLM timeout value). If
this doesn't work, I think your only option is to wait for the command to
time out, which takes 150 times the IRLM timeout value.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
Re: [DB2-L] STOPP Status





"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 12:46


Hi,

How can I cancel the STOP command..? When I issued -START DATABASE
(dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Raymond Bell

Re: STOPP Status
(in response to Michael Ebert)
Guys,

Pretty sure there's no way out, other than to kill the tasks holding the
locks stopping your -STO command from executing. So if it's CICS
transactions (release(deallocate)?) they'll need to be cancelled from within
CICS first.

Sorry.


Raymond Bell
Database Administrator

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Michael Ebert
Sent: 22 November 2006 12:04
To: [login to unmask email]
Subject: Re: [DB2-L] STOPP Status



Hi,

if you issued it interactively, you can try to cancel it through a monitor
product, like Omegamon. I don't remember whether this actually worked; if
yes, you'll still have to wait for up to 10 times the IRLM timeout value (in
batch, you'd only have to wait for at most one IRLM timeout value). If this
doesn't work, I think your only option is to wait for the command to time
out, which takes 150 times the IRLM timeout value.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>


To
[login to unmask email]

cc

bcc

Subject
Re: [DB2-L] STOPP Status



"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>


Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 12:46




Hi,

How can I cancel the STOP command..? When I issued -START DATABASE
(dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm



This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General Group Plc which are authorised and regulated by the Financial Services Authority for advising and arranging the products shown: Legal & General Partnership Services Limited (insurance and mortgages), Legal & General Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust Managers Limited and Legal & General Portfolio Management Services Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General Assurance Society Limited: 166055 Legal & General (Unit Trust Managers) Limited: 1009418 Legal & General (Portfolio Management Services) Limited: 2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General Assurance Society Limited: 117659 Legal & General (Unit Trust Managers) Limited: 119273 Legal & General (Portfolio Management Services) Limited: 146786 Legal & General Insurance Limited: 202050


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Hugh Lapham

Re: STOPP Status
(in response to Raymond Bell)
Hi all,

We have been experiencing this recently. My observations indicate that a thread may start up and process a few SQL statements and then sit there doing nothing at all (sometimes for hours?) before finally terminatiing. The first question I have is
Is there a legitimate reason for servers to leave things hanging in this manner -- particularly considering that locks seem to be retained?
Assuming that there is no legitimate reason (or no GOOD reason ;-), I would like to make an attempt to prevent this situation in our production environments. Manually killing threads hardly seems appropriate as standard operational procedures. This leads to my second question:
Is there any convenient work-around that would enable termination of clearly inactive threads (at least, it is clear to a human observer ;-) that are simply hanging around ... ?
Or maybe this is just another of the challenges we must face in managing workloads that originate from foreign (apparently very foreign!) environments.
>>> Michael Ebert <[login to unmask email]> 2006-11-22 07:03:42 >>>

Hi,

if you issued it interactively, you can try to cancel it through a monitor product, like Omegamon. I don't remember whether this actually worked; if yes, you'll still have to wait for up to 10 times the IRLM timeout value (in batch, you'd only have to wait for at most one IRLM timeout value). If this doesn't work, I think your only option is to wait for the command to time out, which takes 150 times the IRLM timeout value.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]> To
[login to unmask email] cc
bcc
Subject
Re: [DB2-L] STOPP Status

"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 12:46


Hi,

How can I cancel the STOP command..? When I issued -START DATABASE (dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Kenny Fogarty

Re: STOPP Status
(in response to Hugh Lapham)
Doesn't the CTHREAD DSNZPARM control how long these inactive threads hang
about in a system? I recently worked at a site where CTHREAD wasn't active,
and we had instances of distributed threads that were hanging about, and
caused a few batch failures because jobs couldn't get locks on the objects.
We ended up cancelling the threads and restarting the batch jobs, which ran
to completion shortly afterwards.

Sadly my contract wasn't extended, so I don't know if my plan to activate
DB2 monitoring of inactive threads ever came to fruition.

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Hugh Lapham
Sent: 22 November 2006 15:00
To: [login to unmask email]
Subject: Re: [DB2-L] STOPP Status


Hi all,

We have been experiencing this recently. My observations indicate that a
thread may start up and process a few SQL statements and then sit there
doing nothing at all (sometimes for hours?) before finally terminatiing.
The first question I have is

Is there a legitimate reason for servers to leave things hanging in this
manner -- particularly considering that locks seem to be retained?

Assuming that there is no legitimate reason (or no GOOD reason ;-), I would
like to make an attempt to prevent this situation in our production
environments. Manually killing threads hardly seems appropriate as
standard operational procedures. This leads to my second question:

Is there any convenient work-around that would enable termination of clearly
inactive threads (at least, it is clear to a human observer ;-) that are
simply hanging around ... ?

Or maybe this is just another of the challenges we must face in managing
workloads that originate from foreign (apparently very foreign!)
environments.
>>> Michael Ebert <[login to unmask email]> 2006-11-22 07:03:42 >>>

Hi,

if you issued it interactively, you can try to cancel it through a monitor
product, like Omegamon. I don't remember whether this actually worked; if
yes, you'll still have to wait for up to 10 times the IRLM timeout value (in
batch, you'd only have to wait for at most one IRLM timeout value). If this
doesn't work, I think your only option is to wait for the command to time
out, which takes 150 times the IRLM timeout value.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>


To
[login to unmask email]

cc

bcc

Subject
Re: [DB2-L] STOPP Status



"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>


Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 12:46




Hi,

How can I cancel the STOP command..? When I issued -START DATABASE
(dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Kenny Fogarty

Re: STOPP Status
(in response to Kenny Fogarty)
Sorry folks,

For CTHREAD replace with IDTHTOIN! I'm tired.

_____

From: Kenny Fogarty [mailto:[login to unmask email]
Sent: 22 November 2006 21:21
To: 'DB2 Database Discussion list at IDUG'
Subject: RE: [DB2-L] STOPP Status


Doesn't the CTHREAD DSNZPARM control how long these inactive threads hang
about in a system? I recently worked at a site where CTHREAD wasn't active,
and we had instances of distributed threads that were hanging about, and
caused a few batch failures because jobs couldn't get locks on the objects.
We ended up cancelling the threads and restarting the batch jobs, which ran
to completion shortly afterwards.

Sadly my contract wasn't extended, so I don't know if my plan to activate
DB2 monitoring of inactive threads ever came to fruition.

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Hugh Lapham
Sent: 22 November 2006 15:00
To: [login to unmask email]
Subject: Re: [DB2-L] STOPP Status


Hi all,

We have been experiencing this recently. My observations indicate that a
thread may start up and process a few SQL statements and then sit there
doing nothing at all (sometimes for hours?) before finally terminatiing.
The first question I have is

Is there a legitimate reason for servers to leave things hanging in this
manner -- particularly considering that locks seem to be retained?

Assuming that there is no legitimate reason (or no GOOD reason ;-), I would
like to make an attempt to prevent this situation in our production
environments. Manually killing threads hardly seems appropriate as
standard operational procedures. This leads to my second question:

Is there any convenient work-around that would enable termination of clearly
inactive threads (at least, it is clear to a human observer ;-) that are
simply hanging around ... ?

Or maybe this is just another of the challenges we must face in managing
workloads that originate from foreign (apparently very foreign!)
environments.
>>> Michael Ebert <[login to unmask email]> 2006-11-22 07:03:42 >>>

Hi,

if you issued it interactively, you can try to cancel it through a monitor
product, like Omegamon. I don't remember whether this actually worked; if
yes, you'll still have to wait for up to 10 times the IRLM timeout value (in
batch, you'd only have to wait for at most one IRLM timeout value). If this
doesn't work, I think your only option is to wait for the command to time
out, which takes 150 times the IRLM timeout value.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>


To
[login to unmask email]

cc

bcc

Subject
Re: [DB2-L] STOPP Status



"Mohamed Arif (HCL Financial Services)" <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>


Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-11-06 12:46




Hi,

How can I cancel the STOP command..? When I issued -START DATABASE
(dbname) ACCESS (RW), I got the message
DSN9023I -DB2D DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION

Pls suggest.

Thanks,
Arif

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.14/547 - Release Date: 22/11/2006
17:41


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm