For Db2 maintenance are rebinds required

william giannelli

For Db2 maintenance are rebinds required

I am applying v11 maintenance. Almost a year's worth RSU1905 (I know that is too long). Many APARs state it might be necessary to rebind all static applications. Should I rebind all static applications? As a general strategy should I rebind all applications when doing maintenance? or only for migrations (v11 to v12)?

thanks

Bill

Chris Hoelscher

For Db2 maintenance are rebinds required
(in response to william giannelli)
Well ………………….. the answer is YES, we rebind all static every maintenance run (2/year)

We rebind all static first pass with the option not to bind if the path changes
We then capture a list of those who didn’t bind – go off to research them, but we do go and then bind those on the 2nd pass that were stopped on the 1st pass (we can always pull them back, but at least we have a list to work from)

Thank You,
Chris Hoelscher| ITI • DB Services • Mainframe Database | Humana Inc.| T 502.476.2538 or 502.407.7266

From: william giannelli <[login to unmask email]>
Sent: Sunday, June 30, 2019 10:05 AM
To: [login to unmask email]
Subject: [DB2-L] - For Db2 maintenance are rebinds required


I am applying v11 maintenance. Almost a year's worth RSU1905 (I know that is too long). Many APARs state it might be necessary to rebind all static applications. Should I rebind all static applications? As a general strategy should I rebind all applications when doing maintenance? or only for migrations (v11 to v12)?

thanks

Bill

-----End Original Message-----

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)번으로 전화해 주십시오.

william giannelli

RE: For Db2 maintenance are rebinds required
(in response to Chris Hoelscher)

Thanks Chris!

what option do you use to stop the binds if the access path changes?

thanks

Bill

william giannelli

RE: For Db2 maintenance are rebinds required
(in response to william giannelli)

are you using the APCOMPARE and APREUSE options?

thanks

Bill

Chris Hoelscher

For Db2 maintenance are rebinds required
(in response to william giannelli)
I use

APCOMPARE ( ERROR )

The first time thru

And look for literal

STATEMENTS WHERE COMPARISON IS NOT SUCCESSFUL

To report upon and reprocess for rebind

Thank You,
Chris Hoelscher| ITI • DB Services • Mainframe Database | Humana Inc.| T 502.476.2538 or 502.407.7266

From: william giannelli <[login to unmask email]>
Sent: Sunday, June 30, 2019 10:57 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: For Db2 maintenance are rebinds required


Thanks Chris!

what option do you use to stop the binds if the access path changes?

thanks

Bill

-----End Original Message-----

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)번으로 전화해 주십시오.

Chris Hoelscher

For Db2 maintenance are rebinds required
(in response to william giannelli)
But I never force a reuse of an old path – I just want to detect which packages have path changes

Thank You,
Chris Hoelscher| ITI • DB Services • Mainframe Database | Humana Inc.| T 502.476.2538 or 502.407.7266

From: william giannelli <[login to unmask email]>
Sent: Sunday, June 30, 2019 1:07 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: For Db2 maintenance are rebinds required


are you using the APCOMPARE and APREUSE options?

thanks

Bill

-----End Original Message-----

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)번으로 전화해 주십시오.