binds while CICS region is up

william giannelli

binds while CICS region is up

What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill

Olle Brostrom

binds while CICS region is up
(in response to william giannelli)
Bind plan is a one time time procedure being done before the first time use.
Bind package can be a problem together with unversioned packages.
Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.

Best Regards

Olle Broström

From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]
Subject: [DB2-L] - binds while CICS region is up


What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill

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

Larry Jardine

binds while CICS region is up
(in response to Olle Brostrom)
BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.

Larry Jardine
Aetna Employee

From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up

Bind plan is a one time time procedure being done before the first time use.
Bind package can be a problem together with unversioned packages.
Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.

Best Regards

Olle Broström

From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - binds while CICS region is up


What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill

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

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

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

Suresh Sane

binds while CICS region is up
(in response to Larry Jardine)
Larry,


Doesn't everyone use collid.* as the packlist? Shouldn't you?


Most accounting is now at the package level, so I don't see any reason for using explicit packlist any more - at least for CICS.


Thx

Suresh


________________________________
From: Jardine, Lawrence J <[login to unmask email]>
Sent: Thursday, December 14, 2017 12:06 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up


BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.



Larry Jardine
Aetna Employee



From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up



Bind plan is a one time time procedure being done before the first time use.

Bind package can be a problem together with unversioned packages.

Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - binds while CICS region is up



What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill



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



-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

Larry Jardine

binds while CICS region is up
(in response to Suresh Sane)
Yes, but we occasionally add a new collection:

i.e. collid.* newcollid.* anothernewcollid.*


Larry Jardine
Aetna Employee

From: suresh sane [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 12:20 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up


Larry,



Doesn't everyone use collid.* as the packlist? Shouldn't you?



Most accounting is now at the package level, so I don't see any reason for using explicit packlist any more - at least for CICS.



Thx

Suresh

________________________________
From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, December 14, 2017 12:06 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up


BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.



Larry Jardine
Aetna Employee



From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up



Bind plan is a one time time procedure being done before the first time use.

Bind package can be a problem together with unversioned packages.

Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - binds while CICS region is up



What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill



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


-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

Chris Hoelscher

binds while CICS region is up
(in response to Larry Jardine)
Doesn't using a generic package name cause more searching? Could this be more noticeable in a remote package?

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Jardine, Lawrence J [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 12:39 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up

Yes, but we occasionally add a new collection:

i.e. collid.* newcollid.* anothernewcollid.*


Larry Jardine
Aetna Employee

From: suresh sane [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 12:20 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up


Larry,



Doesn't everyone use collid.* as the packlist? Shouldn't you?



Most accounting is now at the package level, so I don't see any reason for using explicit packlist any more - at least for CICS.



Thx

Suresh

________________________________
From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, December 14, 2017 12:06 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up


BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.



Larry Jardine
Aetna Employee



From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up



Bind plan is a one time time procedure being done before the first time use.

Bind package can be a problem together with unversioned packages.

Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - binds while CICS region is up



What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill



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


-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

  • image001.jpg (<1k)

Kal Sub

RE: binds while CICS region is up
(in response to Larry Jardine)

In answer to your original question, Larry, I don't think you can bind the plan without a brief outage to the application.

We had exactly the same situation, Larry. And it is not easy getting an application outage to make a change to the plan. But we have streamlined it to some extent now so we almost don't have that requirement now. We have included a generic collection (could be called GENERIC) in the plan, and if we need to add a package that exists in a collection that doesn't exist in one of the collections already in the plan, we get it bound to this GENERIC collection, so it can be picked up. And we have that GENERIC.* reasonably higher up in the order . 

And if possible, we try to set current packageset in the code as well to make search quicker.

Regards

Kals


In Reply to Larry Jardine:

Yes, but we occasionally add a new collection:

i.e. collid.* newcollid.* anothernewcollid.*


Larry Jardine
Aetna Employee

From: suresh sane [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 12:20 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up


Larry,



Doesn't everyone use collid.* as the packlist? Shouldn't you?



Most accounting is now at the package level, so I don't see any reason for using explicit packlist any more - at least for CICS.



Thx

Suresh

________________________________
From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, December 14, 2017 12:06 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up


BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.



Larry Jardine
Aetna Employee



From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up



Bind plan is a one time time procedure being done before the first time use.

Bind package can be a problem together with unversioned packages.

Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - binds while CICS region is up



What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill



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


-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

Patrick Bossman

RE: binds while CICS region is up
(in response to Kal Sub)

You may need to rebind plans during migration.  Please do it if dsntijpm tells you to, and do it before migration to avoid unsuccessful autobinds surprises in your migration window.

Marcus Davage

binds while CICS region is up
(in response to Patrick Bossman)
Classification: Public

Patrick is right. We need to schedule outages to rebind our plans for migration. It’s thoroughly inconvenient and extremely difficult to do so in a 24x7 environment.

Funny how IBM are pushing 24x7 operations with data sharing and sysplexes, and they STILL haven’t got around this problem.

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: Patrick Bossman [mailto:[login to unmask email]
Sent: 15 December 2017 02:17
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up

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


You may need to rebind plans during migration. Please do it if dsntijpm tells you to, and do it before migration to avoid unsuccessful autobinds surprises in your migration window.

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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555.

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

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 03457 801 801.

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.

Roy Boxwell

binds while CICS region is up
(in response to Marcus Davage)
Gets interesting in Db2 12 with FL levels... then these dynamic Packages must also get a rebind... fun fun fun...

Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

From: Davage, Marcus (ITS Database Services - DB2) [mailto:[login to unmask email]
Sent: Friday, December 15, 2017 10:20 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up

Classification: Public
Patrick is right. We need to schedule outages to rebind our plans for migration. It’s thoroughly inconvenient and extremely difficult to do so in a 24x7 environment.

Funny how IBM are pushing 24x7 operations with data sharing and sysplexes, and they STILL haven’t got around this problem.

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: Patrick Bossman [mailto:[login to unmask email]
Sent: 15 December 2017 02:17
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up

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


You may need to rebind plans during migration. Please do it if dsntijpm tells you to, and do it before migration to avoid unsuccessful autobinds surprises in your migration window.

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


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555.

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

Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 03457 801 801.

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-----

Chad Walmer

binds while CICS region is up
(in response to Kal Sub)
We clone the plan and change the CICS DB2 entry to point to this new plan in order to add new collections (or to do a plan bind for other reasons which are rather rare.) We either just stay on this new cloned plan or switch it back to the original after making the necessary updates to it. This requires no outage and only a little bit of work for your CICS system programmer.

Chad Walmer

From: Kal Sub [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 5:28 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: binds while CICS region is up


In answer to your original question, Larry, I don't think you can bind the plan without a brief outage to the application.

We had exactly the same situation, Larry. And it is not easy getting an application outage to make a change to the plan. But we have streamlined it to some extent now so we almost don't have that requirement now. We have included a generic collection (could be called GENERIC) in the plan, and if we need to add a package that exists in a collection that doesn't exist in one of the collections already in the plan, we get it bound to this GENERIC collection, so it can be picked up. And we have that GENERIC.* reasonably higher up in the order .

And if possible, we try to set current packageset in the code as well to make search quicker.

Regards

Kals

In Reply to Larry Jardine:
Yes, but we occasionally add a new collection:

i.e. collid.* newcollid.* anothernewcollid.*


Larry Jardine
Aetna Employee

From: suresh sane [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 12:20 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: binds while CICS region is up


Larry,



Doesn't everyone use collid.* as the packlist? Shouldn't you?



Most accounting is now at the package level, so I don't see any reason for using explicit packlist any more - at least for CICS.



Thx

Suresh

________________________________
From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>><mailto:[login to unmask email]%3e%3e>
Sent: Thursday, December 14, 2017 12:06 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: binds while CICS region is up


BIND PLAN would be required to add a new package list (collection), so it could be done after first-time use.



Larry Jardine
Aetna Employee



From: Olle Brostrom [mailto:[login to unmask email]
Sent: Thursday, December 14, 2017 4:18 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: binds while CICS region is up



Bind plan is a one time time procedure being done before the first time use.

Bind package can be a problem together with unversioned packages.

Recommend always using VERSION parameter when precompiling a DB2 program, this will always generate a new package to be used later when the new corresponding program will be executed.



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 13 december 2017 15:38
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - binds while CICS region is up



What procedure do you use to bind DB2 plans while the CICS region being accessed is up?

thanks

Bill



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


-----End Original Message-----
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

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

Jean Krasnick

RE: binds while CICS region is up
(in response to Chad Walmer)

Hi,

We've used a technique very similar to what Chad describes.  Another advantage we had is that we had the ability to route CICS traffic to (or away from) a specific region.  So we could take one region, change the plan name (I believe this can be done dynamically for temporary use, or update the RCT and recycle) to the temp plan that includes the new collection (or whatever the change was), and route some test traffic to this region and prod traffic away from the region to make sure the newly bound plan was working correctly.  If it was, we'd then phase in the temp plan to the other regions; if not, we were able to correct it without affecting production traffic.   Once all regions were running on the temp plan, we'd then be able to rebind the real plan to make whatever changes were needed.  We typically would change the regions back to the prod plan, but as Chad says, you can always leave on the secondary plan (maybe swap back and forth every time you need to bind the plan).

 

Jean