[Db2 z/OS] Autorebind problem

Walter Janißen

[Db2 z/OS] Autorebind problem
Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Attachments

  • image001.png (2.6k)

Marcus Davage

[Db2 z/OS] Autorebind problem
(in response to Walter Janißen)
What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [cid:[login to unmask email]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.
Attachments

  • image001.png (2.6k)

Tushar Jha

RE: [Db2 z/OS] Autorebind problem
(in response to Walter Janißen)

Walter,

In my limited experience with DB2 , I have seen Autobinds fail almost always due to contention on things from Directory tablespaces to Explain tables.If at all the Autobind did fail with contention, the message must have been generated in MSTR, with the Autobind process indicated as autobnd or something.

Thank you. 

 

Walter Jani&#223;en

AW: [Db2 z/OS] Autorebind problem
(in response to Marcus Davage)
That's the problem. There is no message. We only get the message that the package is inoperative, but the explicit rebind works fine. So the question is: Why failed the autobind?

BTW: What's the D&R-manual? Desaster-Recovery-Manual?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 12:56
An: [login to unmask email]
Betreff: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

  • image001.png (2.6k)

Raymond Bell

[Db2 z/OS] Autorebind problem
(in response to Walter Janißen)
Hi Walter,

Are you data sharing? Do your members have different values for DESCSTAT? Are your packages that are failing an auto-rebind but succeeding when manually rebound a) dependent on the setting of DESCSTAT and b) being auto-rebound on a member with an 'incompatible' DESCSTAT setting? Ask me how I know if this might cause a problem. :o)

Worth looking into...

Cheers,


Raymond

Raymond Bell
Db2
Hosting Services, Technology
Royal Bank of Scotland Group
3rd Floor Regents House
40-42 Islington High Street
London N1 8XL
Mob: +44 (0) 7894 608214
Email: [login to unmask email]<mailto:[login to unmask email]>

The content of this email is confidential unless stated otherwise.
[cid:[login to unmask email]

From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 12:46
To: [login to unmask email]
Subject: [DB2-L] - AW: [Db2 z/OS] Autorebind problem


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

That's the problem. There is no message. We only get the message that the package is inoperative, but the explicit rebind works fine. So the question is: Why failed the autobind?

BTW: What's the D&R-manual? Desaster-Recovery-Manual?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 12:56
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image002.png (6.7k)
  • image003.png (2.6k)

Marcus Davage

[Db2 z/OS] Autorebind problem
(in response to Walter Janißen)
Sorry, typo - Diagnosis Guide and Reference Manual.

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 12:46
To: [login to unmask email]
Subject: [DB2-L] - AW: [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

That's the problem. There is no message. We only get the message that the package is inoperative, but the explicit rebind works fine. So the question is: Why failed the autobind?

BTW: What's the D&R-manual? Desaster-Recovery-Manual?

Kind regards
Walter Janißen [cid:[login to unmask email]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 12:56
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [cid:[login to unmask email]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.
Attachments

  • image001.png (2.6k)

Ray Janes

[Db2 z/OS] Autorebind problem
(in response to Marcus Davage)
Could there be a security issue? I've had that.....security changed since it was bound last (could be years....), so Autobind fails....but if you then (perhaps sysadm?) issue the bind, you have the access.

From: Davage, Marcus (ITS Database Services - DB2) <[login to unmask email]>
Sent: Friday, April 6, 2018 9:13 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

Sorry, typo - Diagnosis Guide and Reference Manual.

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 12:46
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - AW: [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

That's the problem. There is no message. We only get the message that the package is inoperative, but the explicit rebind works fine. So the question is: Why failed the autobind?

BTW: What's the D&R-manual? Desaster-Recovery-Manual?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 12:56
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

Walter Jani&#223;en

AW: [Db2 z/OS] Autorebind problem
(in response to Walter Janißen)
Hi

Sorry, but we didn't look carefully enough. There were TIMEOUT-messages for the internal thread 020.AUTBNDnn. The culprit was a job, which wanted to delete entries in PLAN_TABLE.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Walter Janißen [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 13:46
An: [login to unmask email]
Betreff: [DB2-L] - AW: [Db2 z/OS] Autorebind problem

That's the problem. There is no message. We only get the message that the package is inoperative, but the explicit rebind works fine. So the question is: Why failed the autobind?

BTW: What's the D&R-manual? Desaster-Recovery-Manual?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Gesendet: Freitag, 6. April 2018 12:56
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: [Db2 z/OS] Autorebind problem

What's the message? Have you checked the D&R manual?

Regards,
Marcus Davage CEng CITP MBCS
IBM Certified DB2 Database Administrator
LinkedIn http://uk.linkedin.com/in/marcusdavage | IDUG http://www.idug.org/p/us/sn/uid=24500 | Twitter http://twitter.com/spufidoo | About.me http://about.me/spufidoo
From: Walter Janißen [mailto:[login to unmask email]
Sent: 06 April 2018 08:50
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [Db2 z/OS] Autorebind problem

-- This email has reached the Bank via an external source --

Hi

Is there any chance to figure out why an autobind fails? If I bind the package afterwards all is fine. The package gets invalid, because an alias is dropped and recreated and we are pretty sure that the package is not executed between the drop and the create.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996


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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0207 626 1500.

Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207 626 1500.

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 0207 626 1500.

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

Halifax is a division of Bank of Scotland plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

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

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

  • image001.png (2.6k)

Michael Hannan

RE: AW: [Db2 z/OS] Autorebind problem
(in response to Walter Janißen)

In Reply to Walter Janißen:

Sorry, but we didn't look carefully enough. There were TIMEOUT-messages for the internal thread 020.AUTBNDnn. The culprit was a job, which wanted to delete entries in PLAN_TABLE.

Just a couple of comments:

* Some sites would guard against Auto REBINDs by trying to generate Explicit REBINDs, after any operations that Invalidate Packages.

* PLAN_TABLE obviously needs high availability for update. So any cleanup job needs to commit frequently, or run at a quiet time (without BIND/REBIND activity). This means very careful design of cleanup SQLs, to limit number of rows deleted in one hit, and to limit time between COMMIT, and to have suitable Indexes, most likely including one by EXPLAIN_TIME to aid finding old rows promptly. 

* No need to clean-up too frequently. It is useful to have PLAN_TABLE history to enable past performance problems to be understood better, and to know which access path was better. Personally I would keep all BIND/REBIND access paths for a minimum of 6 months. That presupposes site does not REBIND too often. If a very heavy REBIND site, could consider removal of duplicate access paths, especially if REBIND occurs many times on same day of same Package. Sometimes a site removes all access paths other than latest (IBM run production shops also). That is quite unwise, when trying to understand past performance changes. Same applies to some of the extended Explain tables. There is Extended Package Management which can get back some recent access paths using EXPLAIN PACKAGE. There is not a big requirement to have a very small PLAN_TABLE, provided it has 2 or 3 good indexes.  

* Queries against PLAN_TABLE and others should always use WITH UR, for best concurrency.

* I suppose it is possible to REBIND EXPLAIN(NO) and later each day Explain Packages rebound that day. I have yet to check if this approach has any major advantages for improving REBIND semi-outage time. Has anyone tried it?

My main purpose is to encourage the collection of EXPLAIN output, and not to delete it in a big hurry. This data matters for tuning, and reviewing performance. In fact I would love to implement History tables for EXPLAIN, if a site insists on cleaning up the data to soon.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Patrick Bossman

RE: AW: [Db2 z/OS] Autorebind problem
(in response to Michael Hannan)

The explain records stored with a package / stabilized SQL are a subset of explain yes.  It is not the full complement you'd get if you are using data studio and all the explain tables.


In Reply to Michael Hannan:

In Reply to Walter Janißen:

Sorry, but we didn't look carefully enough. There were TIMEOUT-messages for the internal thread 020.AUTBNDnn. The culprit was a job, which wanted to delete entries in PLAN_TABLE.

Just a couple of comments:

* Some sites would guard against Auto REBINDs by trying to generate Explicit REBINDs, after any operations that Invalidate Packages.

* PLAN_TABLE obviously needs high availability for update. So any cleanup job needs to commit frequently, or run at a quiet time (without BIND/REBIND activity). This means very careful design of cleanup SQLs, to limit number of rows deleted in one hit, and to limit time between COMMIT, and to have suitable Indexes, most likely including one by EXPLAIN_TIME to aid finding old rows promptly. 

* No need to clean-up too frequently. It is useful to have PLAN_TABLE history to enable past performance problems to be understood better, and to know which access path was better. Personally I would keep all BIND/REBIND access paths for a minimum of 6 months. That presupposes site does not REBIND too often. If a very heavy REBIND site, could consider removal of duplicate access paths, especially if REBIND occurs many times on same day of same Package. Sometimes a site removes all access paths other than latest (IBM run production shops also). That is quite unwise, when trying to understand past performance changes. Same applies to some of the extended Explain tables. There is Extended Package Management which can get back some recent access paths using EXPLAIN PACKAGE. There is not a big requirement to have a very small PLAN_TABLE, provided it has 2 or 3 good indexes.  

* Queries against PLAN_TABLE and others should always use WITH UR, for best concurrency.

* I suppose it is possible to REBIND EXPLAIN(NO) and later each day Explain Packages rebound that day. I have yet to check if this approach has any major advantages for improving REBIND semi-outage time. Has anyone tried it?

My main purpose is to encourage the collection of EXPLAIN output, and not to delete it in a big hurry. This data matters for tuning, and reviewing performance. In fact I would love to implement History tables for EXPLAIN, if a site insists on cleaning up the data to soon.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Michael Hannan

RE: AW: [Db2 z/OS] Autorebind problem
(in response to Patrick Bossman)

In Reply to Patrick Bossman:

The explain records stored with a package / stabilized SQL are a subset of explain yes.  It is not the full complement you'd get if you are using data studio and all the explain tables.

Thanks for that. I guess I will get an Explain Package done soon, to find out what is included and what is missing. Normally at sites that don't capture Explain info for long enough, I don't have Authority to do Explain Package anyway. That unfortunately requires higher than EXPLAIN Auth, which is slightly annoying.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Phil Grainger

AW: [Db2 z/OS] Autorebind problem
(in response to Michael Hannan)
While we’re on this subject, I’d love to know if anyone has a GOOD REASON for binding in a production environment with EXPLAIN NO? To me it’s always seemed like a really bad idea to not have a record of EVERY production SQL access path

As Patrick says, Explain Package does give SOME relief, but it’s not a complete replacement for EXPLAIN YES

Anyone?
________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Michael Hannan [mailto:[login to unmask email]
Sent: 11 April 2018 04:21
To: [login to unmask email]
Subject: [DB2-L] - RE: AW: [Db2 z/OS] Autorebind problem


In Reply to Patrick Bossman:

The explain records stored with a package / stabilized SQL are a subset of explain yes. It is not the full complement you'd get if you are using data studio and all the explain tables.

Thanks for that. I guess I will get an Explain Package done soon, to find out what is included and what is missing. Normally at sites that don't capture Explain info for long enough, I don't have Authority to do Explain Package anyway. That unfortunately requires higher than EXPLAIN Auth, which is slightly annoying.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 (8k)
  • image002.png (5.9k)

Philip Sevetson

AW: [Db2 z/OS] Autorebind problem
(in response to Phil Grainger)
I know of _bad_ reasons… :-(

From: Grainger, Phil [mailto:[login to unmask email]
Sent: Wednesday, April 11, 2018 6:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: AW: [Db2 z/OS] Autorebind problem

While we’re on this subject, I’d love to know if anyone has a GOOD REASON for binding in a production environment with EXPLAIN NO? To me it’s always seemed like a really bad idea to not have a record of EVERY production SQL access path

As Patrick says, Explain Package does give SOME relief, but it’s not a complete replacement for EXPLAIN YES

Anyone?
-----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.
-----End Original Message-----


**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Walter Jani&#223;en

AW: AW: [Db2 z/OS] Autorebind problem
(in response to Patrick Bossman)
Hi Pat

In the meantime we know, why the autobind failed, but beneath the timeout-message it would be great, if the package, which the rebind failed for, would also be named.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Patrick Bossman <[login to unmask email]>
Gesendet: Dienstag, 10. April 2018 18:20
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: [Db2 z/OS] Autorebind problem


The explain records stored with a package / stabilized SQL are a subset of explain yes. It is not the full complement you'd get if you are using data studio and all the explain tables.

In Reply to Michael Hannan:

In Reply to Walter Janißen:
Sorry, but we didn't look carefully enough. There were TIMEOUT-messages for the internal thread 020.AUTBNDnn. The culprit was a job, which wanted to delete entries in PLAN_TABLE.

Just a couple of comments:

* Some sites would guard against Auto REBINDs by trying to generate Explicit REBINDs, after any operations that Invalidate Packages.

* PLAN_TABLE obviously needs high availability for update. So any cleanup job needs to commit frequently, or run at a quiet time (without BIND/REBIND activity). This means very careful design of cleanup SQLs, to limit number of rows deleted in one hit, and to limit time between COMMIT, and to have suitable Indexes, most likely including one by EXPLAIN_TIME to aid finding old rows promptly.

* No need to clean-up too frequently. It is useful to have PLAN_TABLE history to enable past performance problems to be understood better, and to know which access path was better. Personally I would keep all BIND/REBIND access paths for a minimum of 6 months. That presupposes site does not REBIND too often. If a very heavy REBIND site, could consider removal of duplicate access paths, especially if REBIND occurs many times on same day of same Package. Sometimes a site removes all access paths other than latest (IBM run production shops also). That is quite unwise, when trying to understand past performance changes. Same applies to some of the extended Explain tables. There is Extended Package Management which can get back some recent access paths using EXPLAIN PACKAGE. There is not a big requirement to have a very small PLAN_TABLE, provided it has 2 or 3 good indexes.

* Queries against PLAN_TABLE and others should always use WITH UR, for best concurrency.

* I suppose it is possible to REBIND EXPLAIN(NO) and later each day Explain Packages rebound that day. I have yet to check if this approach has any major advantages for improving REBIND semi-outage time. Has anyone tried it?

My main purpose is to encourage the collection of EXPLAIN output, and not to delete it in a big hurry. This data matters for tuning, and reviewing performance. In fact I would love to implement History tables for EXPLAIN, if a site insists on cleaning up the data to soon.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

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

  • image001.png (2.6k)