db2 for z/OS R11 NFM: maintenance mode?

Chris Hoelscher

db2 for z/OS R11 NFM: maintenance mode?
I have read the manuals - the answer seems to be NO, but I will ask here anyhow:

Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

Paul Ogborne

db2 for z/OS R11 NFM: maintenance mode?
(in response to Chris Hoelscher)
Hi Chris,
I agree with your answer as I cannot think of a way.
Perhaps a RFE ?
Regards,
Paul Ogborne

> On 6 Feb 2019, at 15:01, Chris Hoelscher <[login to unmask email]> wrote:
>
> I have read the manuals – the answer seems to be NO, but I will ask here anyhow:
>
> Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??
>
> Chris Hoelscher
> Technology Architect, Database Infrastructure Services
> Technology Solution Services
> Humana Inc.
> 123 East Main Street
> Louisville, KY 40202
> Humana.com
> (502) 476-2538 or 407-7266
>
>
> The information transmitted is intended only for the person or entity to which it is addressed
> and may contain CONFIDENTIAL material. If you receive this material/information in error,
> please contact the sender and delete or destroy the material/information.
>
> Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
> do not discriminate on the basis of race, color, national origin, age, disability, sex,
> sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
> exclude people or treat them differently because of race, color, national origin, age,
> disability, sex, sexual orientation, gender identity, or religion.
>
> English: ATTENTION: If you do not speak English, language assistance services, free
> of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).
>
> Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
> gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).
>
> 繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
> 服務。請致電 1‐877‐320‐1235 (TTY: 711)。
>
> Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
> pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).
>
> Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
> pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).
>
> 한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
> 이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Phil Grainger

db2 for z/OS R11 NFM: maintenance mode?
(in response to Paul Ogborne)
Indeed – the only way to change the “mode” of Db2, is to shutdown and restart

________________________________





[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Phil Grainger
Principal Enablement Manager

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]










































From: Paul Ogborne [mailto:[login to unmask email]
Sent: 06 February 2019 18:58
To: [login to unmask email]
Subject: [DB2-L] - RE: db2 for z/OS R11 NFM: maintenance mode?

Hi Chris,
I agree with your answer as I cannot think of a way.
Perhaps a RFE ?
Regards,
Paul Ogborne

On 6 Feb 2019, at 15:01, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:
I have read the manuals – the answer seems to be NO, but I will ask here anyhow:

Is there a way to move a db2 subsystem in and out of maintenance mode WITHOUT stopping/starting the started tasks ??

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com https://urldefense.proofpoint.com/v2/url?u=http-3A__Humana.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=syXAUsH1Pp0qdUugxNZ2YrZNtSO6QIQuCqG1dFkXhzk&s=m_qS7gvD68fXZvnvLqLcdyKzfXhAq7xYdWSNhqmvKSM&e=
(502) 476-2538 or 407-7266


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.png (3.7k)
  • image004.png (<1k)

Javier Estrada Benavides

RE: db2 for z/OS R11 NFM: maintenance mode?
(in response to Phil Grainger)

Hi

  mmm.... ok, I agree that there's no way to do it while it's already running, but I can't quite think of why someone would want to go into MAINT without restarting Db2. If I wanted to do it while it's up and running I would have to force DDF and all threads, resolve indoubts if there are, maybe even stopping a few objects intentionally, or is that what you want it to do in automatic?

Or maybe just avoiding triggering any trap that catches the Db2 termination message? I believe most automation tools let you set MSTR into passive mode so that you can restart peacefully with no side effects.

 

Regards,

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS