Change Control

Philip Sevetson

Change Control
General question about code and object management:

Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I'm interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**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.**
Attachments

  • image001.png (3.3k)

Phil Grainger

Change Control
(in response to Philip Sevetson)
Very timely question for me

Spent three days at a DevOps event last week, so to add to Philips question

"How do you handle repeatedly frequent database change requests in an agile'ly development world?"

Phil Grainger
Principal Enablement Manager

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

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: Sevetson, Phil <[login to unmask email]>
Sent: 01 July 2019 14:29
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - Change Control

General question about code and object management:

Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I'm interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**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.**
________________________________
Attachment Links: image001.png (3 k) https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D10231&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=gQswuLkHE_v0S8JRz4CdLkefIWlW90e8y9UL7VqyMAo&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_st_-3Fpost-3D189486-26anc-3Dp189486-23p189486&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=bzcXoPbHSZir2SGleDkmCz4xSbVKY8yZu75TuFq7tyE&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=rv4D91Jj6q79jww2ooFvBFmA_FZBqJn57kaoglNczDE&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_us_to_&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=PPSeKen-NNNkH87U8ct-k9uDmpfLtXW4dVNNzjc9upo&e=

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ESAIGroup.com_idug&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=XFHHtxbvNhCC55afopRsc2bFoS-dlhXuEFbKg2HK5i4&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMCAg&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=hBGemFx6Ou6c3cc-7swpJEHmzfTZ1ps6mAMR2r33amA&s=n2sr_NqcZgefTeEC32XiP4VmFsRZfi5Mn1HD243ZENo&e=

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

Roy Boxwell

Change Control
(in response to Phil Grainger)
From what I have seen: push to prod and prey. Also called tripleP


Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

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

> On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]> wrote:
>
> Very timely question for me
>
> Spent three days at a DevOps event last week, so to add to Philips question
>
> “How do you handle repeatedly frequent database change requests in an agile’ly development world?”
>
> 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
>
>
>
> From: Sevetson, Phil <[login to unmask email]>
> Sent: 01 July 2019 14:29
> To: [login to unmask email]
> Subject: [EXTERNAL] [DB2-L] - Change Control
>
> General question about code and object management:
>
> Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)
>
> Philip Sevetson
> Computer Systems Manager
> FISA-OPA
> 5 Manhattan West
> New York, NY 10001
> [login to unmask email]
> 212-857-1688 w
> 917-991-7052 m
> 212-857-1659 f
>
>
> **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.**
> -----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.
> Attachment Links: image001.jpg (51 k) image002.png (7 k) image003.png (4 k) image004.png (1 k)
> 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]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> 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
>
Attachments

  • smime.p7s (3.9k)

Renu Sharma

Change Control
(in response to Roy Boxwell)
Hi guys

In my case we have created different scripts to get the ddl changes from repository and apply to database . Those scripts are done or none, meaning if not successful I rollback. The app does database create , update processes from a database created in DB2. Weekly I create graphs and report from the homegrown database. It’s pretty nice and working process. Although I would say I have done for DB2 LUW.
There are controls at different phases where different managers and authorize the processes.
The same process can be followed for other flavors of DB2

Thanks

Sent from my iPhone
Renu Sharma



> On Jul 1, 2019, at 11:49 AM, Boxwell, Roy <[login to unmask email]> wrote:
>
> From what I have seen: push to prod and prey. Also called tripleP
>
>
> Roy Boxwell
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
> -Product Development-
> Heinrichstrasse 83-85
> 40239 Düsseldorf/Germany
> Tel. +49 (0)211 96149-675
> Fax +49 (0)211 96149-32
> Email: [login to unmask email]
> http://www.seg.de
> Link zur Datenschutzerklärung
>
> Software Engineering GmbH
> Amtsgericht Düsseldorf, HRB 37894
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
>> On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]> wrote:
>>
>> Very timely question for me
>>
>> Spent three days at a DevOps event last week, so to add to Philips question
>>
>> “How do you handle repeatedly frequent database change requests in an agile’ly development world?”
>>
>> 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
>>
>>
>>
>> From: Sevetson, Phil <[login to unmask email]>
>> Sent: 01 July 2019 14:29
>> To: [login to unmask email]
>> Subject: [EXTERNAL] [DB2-L] - Change Control
>>
>> General question about code and object management:
>>
>> Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)
>>
>> Philip Sevetson
>> Computer Systems Manager
>> FISA-OPA
>> 5 Manhattan West
>> New York, NY 10001
>> [login to unmask email]
>> 212-857-1688 w
>> 917-991-7052 m
>> 212-857-1659 f
>>
>>
>> **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.**
>> -----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.
>> Attachment Links: image001.jpg (51 k) image002.png (7 k) image003.png (4 k) image004.png (1 k)
>> 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]
>> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
>> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
>> 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
>>

Roy Boxwell

Change Control
(in response to Roy Boxwell)
Gotta love auto correct.... pray is better!

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

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

> On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email]> wrote:
>
> From what I have seen: push to prod and prey. Also called tripleP
>
>
> Roy Boxwell
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
> -Product Development-
> Heinrichstrasse 83-85
> 40239 Düsseldorf/Germany
> Tel. +49 (0)211 96149-675
> Fax +49 (0)211 96149-32
> Email: [login to unmask email]
> http://www.seg.de
> Link zur Datenschutzerklärung
>
> Software Engineering GmbH
> Amtsgericht Düsseldorf, HRB 37894
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
>> On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]> wrote:
>>
>> Very timely question for me
>>
>> Spent three days at a DevOps event last week, so to add to Philips question
>>
>> “How do you handle repeatedly frequent database change requests in an agile’ly development world?”
>>
>> 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
>>
>>
>>
>> From: Sevetson, Phil <[login to unmask email]>
>> Sent: 01 July 2019 14:29
>> To: [login to unmask email]
>> Subject: [EXTERNAL] [DB2-L] - Change Control
>>
>> General question about code and object management:
>>
>> Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)
>>
>> Philip Sevetson
>> Computer Systems Manager
>> FISA-OPA
>> 5 Manhattan West
>> New York, NY 10001
>> [login to unmask email]
>> 212-857-1688 w
>> 917-991-7052 m
>> 212-857-1659 f
>>
>>
>> **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.**
>> -----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.
>> Attachment Links: image001.jpg (51 k) image002.png (7 k) image003.png (4 k) image004.png (1 k)
>> 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]
>> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
>> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
>> 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
>>
Attachments

  • smime.p7s (3.9k)

Philip Sevetson

Change Control
(in response to Roy Boxwell)
Roy,

Well.

The term “discouraging” seems to have been made for this situation. How did we manage to miss being included in project development disciplines? You know: code repositories; comparison checks; code walkthroughs, all that stuff which is supposed to improve the quality of product…

-phil (sevetson)

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Monday, July 01, 2019 12:25 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control

Gotta love auto correct.... pray is better!
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

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

On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email]<mailto:[login to unmask email]>> wrote:
From what I have seen: push to prod and prey. Also called tripleP

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

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

On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Very timely question for me

Spent three days at a DevOps event last week, so to add to Philips question

“How do you handle repeatedly frequent database change requests in an agile’ly development world?”

Phil Grainger
Principal Enablement Manager


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

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]<mailto:[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: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: 01 July 2019 14:29
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Change Control

General question about code and object management:

Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

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

carol goldberg

Change Control
(in response to Marcus Davage)
Here is a question that has been looming for a while. We use Endevor for
source control. We would like to start the usage of SQLPL procedures. We do
not own the DB2 version of Endevor.
There are 2 ways I see our developers to use SQLPL, one would be logged
into TSO , doing development the other would be via Data Studio.
Has anyone integrated either of these development methods with Using
Endevor for source control.

We do not want to give create authority directly, but maybe via Endevor (
check in / check out and also using deploy.

How are others accomplishing the development of SQLPL procedures via Source
Control?


Hope this makes sense, we are are DB2 v12 z/os,

Thanks, Carol


On Tue, Jul 2, 2019 at 9:00 AM Davage, Marcus <[login to unmask email]> wrote:

> We at BMC are currently developing a Z-based DevOps orchestration and
> deployment solution that include DDL migration (using Change Manager), DDL
> site standards adherence, SQL (DML) performance assurance and validation,
> and data provisioning. Watch this space.
>
>
>
> Regards,
>
> *Marcus Davage*
>
> Lead Product Developer
>
> AMI-DevOps for Db2 – SQL Performance
>
> *Direct*
>
> +44 118 921 8517
>
>
>
> *Mobile*
>
> +44 7840 023 560
>
>
>
> *Email*
>
> [login to unmask email]
>
>
>
>
>
>
>
> *From:* Sevetson, Phil <[login to unmask email]>
> *Sent:* 02 July 2019 14:17
> *To:* '[login to unmask email]' <[login to unmask email]>
> *Subject:* [EXTERNAL] [DB2-L] - RE: Change Control
>
>
>
> All,
>
>
>
> I also need to branch the conversation a bit. I’m used to set procedures
> for backing up current and initiating changes in database structures.
>
>
>
> What I am _*not*_ seeing, is DBA areas using change management processes
> (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB
> utilities. Is that P-3, too? Or are people actually using line-compare and
> testing scenarios and so forth?
>
>
>
> How do you test explicit code like a REORG with the tablespace specified?
> Do you use the same schemas and dbnames in a test environment, as in prod?
> Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there
> standards applied?
>
>
>
> I’m in a zero-tolerance-for-error environment. I need a well-developed
> control process to rigorously test and examine production changes. I don’t
> have one, and my choices are pretty much limited to “build your own.” So
> recommendations are welcome.
>
>
>
> -phil
>
>
>
> *From:* Jørn Thyssen [mailto:[login to unmask email] <[login to unmask email]>]
> *Sent:* Tuesday, July 02, 2019 9:01 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: Change Control
>
>
>
> Hi Ludovic,
>
> One important note is that the open source tools you mention keeps "delta
> scripts" under version control.This is the so-called "migration based"
> approach. In general, it's up to the developer to understand Db2 for z/OS
> features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what
> about removing a column or adding a column to the middle of a table?
> Handling dependent views and stored procedures is also difficult in this
> approach. The migrated based approach does have a number of advantages.
>
> The alternative is the "state based" approach where the developer have the
> full DDL under version control and you use a compare engine to figure out
> the best way to deploy the change. Such tools normally also handle
> dependent views and stored procedures, re-stablish authorizations, run the
> appropriate utilities such as REORG and REBIND, etc.
>
> The two approaches have their advantages and disadvantages, and I have
> seen both in use at customers. The tools you mention are frequently used
> because the database devops discipline often starts on the customer's
> distributed databases and then spread to Db2 for z/OS. In some cases they
> prefer to use the same tools in order to leverage existing pipelines.
>
> If you google "migration based vs state based" you will find that the
> state based method is often recommended for projects with
>
> - large monolithic databases
> - large teams
> - large number of changes
> - stored procedures
> - prototyping applications
>
> Sounds familiar? :)
> In Reply to Ludovic Janssens:
>
> Hi,
>
> DevOps for Db2 has been one of my passions; unfortunately I haven't been
> working with Db2 more recently anymore. I could provide you with some
> experiences I had:
>
> One of the things I have seen is that there are several options to
> integrate Db2 changes with standard Maven/Jenkins deployments.
>
> One of them could be Datical that allows you to do changes starting from a
> logical data model and incorporates an object compare that is supporting
> Db2 for z/os: https://www.datical.com/liquibase/
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=0ewie7Ii2nhtdtWqlKb-BHETwG8QQqsJn5r2MS7M6rI&e=
> [
> https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png]
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_wp-2Dcontent_uploads_cropped-2DDatical-2DTransparent-2DGreen-2Dand-2DBlack-2DLogo.png-255d&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=3JPYsCBIBrGBrFHSZmRQFRjoknTczQeZnvBQ-j9y3PE&e=
> https://www.datical.com/liquibase
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
> Liquibase vs. Datical | Datical https://www.datical.com/liquibase
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
> Find out when it's best to use Liquibase vs. when you should use Datical
> for database schema changes and automated database deployments.
> www.datical.com
>
> FlywayDB could work too, but as it is SQL based, it is less Agile, because
> it doesn't support different target technologies.
>
> If you are looking into the integration of e.g. Changeman, you should be
> looking whether the vendor doesn't offer you an integration with a
> distributed DevOps tools. Often these allow you to integrate the deployment
> of your mainframe packages from a distributed platform and even integrate
> you components in GIT or SVN.
>
> Once you are in a standard DevOps tool, you can also initiate code
> validation with Unit Tests and visualize the results with eg. SonarQube.
> Obviously, you could also trigger different processes on the mainframe from
> the DevOps tool with an appropriate action that can trigger a job on the
> mainframe.
>
> Finally, if I remember well, Infosphere Optim Query Workload Tuner allows
> you to capture the results of a performance test and map it onto your
> application processes in a part of Data Studio. Things can have changed
> meanwhile.
>
> Hope this helps ��
>
>
> Ludovic Janssens
> Senior Consultant
> [Twitter] https://twitter.com/ae_nv
> https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ae-5Fnv&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=h_8nYjoAlPZiCY73KMZxCBTC2EEAovbYJ9Jn_MmRvo0&e=
> [LinkedIn] https://be.linkedin.com/company/ae-nv-sa
>
> ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=DnEfnIcRO3im2zuDZs1rdUylALg-sCGFCgJhXsLe5-E&e=
>
> Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
> Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303
>
> [AE] http://www.ae.be/ae-email-banner-redirect
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be_ae-2Demail-2Dbanner-2Dredirect&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=AghcsdB8qZdotIol5YY1qcUp9C_VQ0eMY7cG3ztFctU&e=
>
> ________________________________
> From: william giannelli
> Sent: Tuesday, July 2, 2019 11:43
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Change Control
>
>
> Great question! Especially with the big push for Agile and Dev/Ops. In our
> shop we use Change Man which handles the binds during turnover. And we also
> use BMC Change Manager for DDL changes. What I would like to see is a
> product for SQL and Access Path checking that would integrate with Change
> Man so that we could incorporate it into our turnover process for
> Production. And also, we have a need (again due to Agile, Dev/Ops) for easy
> repeatable testing within development before production.
>
> Bill
>
> -----End Original Message-----
>
>
> AE-Disclaimer:
>
> Dit bericht is vertrouwelijk en exclusief bestemd voor de geadresseerde
> ervan. Behoudens andersluidende expliciete afspraak is publicatie, gebruik
> of verspreiding ervan niet toegelaten. Gelieve de afzender onmiddellijk te
> verwittigen in geval van foutieve adressering of ontvangst en verwijder het
> bericht. Visies en opinies uitgedrukt in dit bericht zijn persoonlijk van
> de afzender tenzij aangegeven als zijnde van AE of verbonden ondernemingen.
>
> This communication is intended for the addressee only and is privileged
> and confidential. Any unauthorized disclosure, copying, distribution or use
> is prohibited. If you have received this communication in error, please
> notify the sender immediately and destroy the original communication. Views
> and opinions are those of the sender unless clearly stated as being those
> of AE NV, its subsidiaries and/or associated companies.
>
>
>
>
>
> Best regards,
>
> Jørn Thyssen
>
> Rocket Software
> 77 Fourth Avenue • Waltham, MA • 02451 • USA
> E: [login to unmask email] • W: www.rocketsoftware.com
>
> 2019 IBM Champion.
>
> Views are personal.
>
>
>
> -----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.**
> -----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-----
>
Attachments

  • image001.png (12.9k)

Roy Boxwell

Change Control
(in response to Philip Sevetson)
I think it is just the times they are a changin’

A few years ago code had to be human coded, checked, tested, unit tested, system tested and then staged. That just takes far too long these days! Must places I work at these days are staging multiple applications multiple times on a daily basis... Think smartphone – How many updates do you get per day??? Basically we are all beta testers these days...



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: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


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



From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, July 1, 2019 7:21 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: Change Control



Roy,



Well.



The term “discouraging” seems to have been made for this situation. How did we manage to miss being included in project development disciplines? You know: code repositories; comparison checks; code walkthroughs, all that stuff which is supposed to improve the quality of product…



-phil (sevetson)



From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Monday, July 01, 2019 12:25 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Change Control



Gotta love auto correct.... pray is better!

Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.

-Product Development-

Heinrichstrasse 83-85

40239 Düsseldorf/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

Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz



Software Engineering GmbH

Amtsgericht Düsseldorf, HRB 37894

Geschäftsführung: Gerhard Schubert, Ulf Heinrich


On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email] <mailto:[login to unmask email]> > wrote:

From what I have seen: push to prod and prey. Also called tripleP



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.

-Product Development-

Heinrichstrasse 83-85

40239 Düsseldorf/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

Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz



Software Engineering GmbH

Amtsgericht Düsseldorf, HRB 37894

Geschäftsführung: Gerhard Schubert, Ulf Heinrich


On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email] <mailto:[login to unmask email]> > wrote:

Very timely question for me



Spent three days at a DevOps event last week, so to add to Philips question



“How do you handle repeatedly frequent database change requests in an agile’ly development world?”




Phil Grainger
Principal Enablement Manager

https://www.bmc.com/ami


Direct

+44 1189 218 000


Mobile

+44 7808 643 479


Email

[login to unmask email] <mailto:[login to unmask email]>


E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS







From: Sevetson, Phil <[login to unmask email] <mailto:[login to unmask email]> >
Sent: 01 July 2019 14:29
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Change Control



General question about code and object management:



Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)



Philip Sevetson

Computer Systems Manager

FISA-OPA

5 Manhattan West

New York, NY 10001

[login to unmask email] <mailto:[login to unmask email]>

212-857-1688 w

917-991-7052 m

212-857-1659 f





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

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

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

Attachments

  • smime.p7s (5.1k)

Raymond Bell

Change Control
(in response to Roy Boxwell)
Triple P. Nice. I had a good chuckle about that. It does seem, as Phil S alluded to, that software ‘development’ involves throwing it over the Prod wall as fast as possible, taking a leaf out of the Duke of Wellington’s book and being quite happy to, ‘publish and be damned’.

I had a chuckle yesterday too, when a UK ‘challenger bank’ emailed me to say their mobile banking app would be down for maintenance from 11pm this Saturday to 7pm Sunday. WTAF? If anyone at any major UK bank tried to present that implementation plan at review they’d be laughed out the room – and marched out the building. Seems speed to market is all with some folks; so what if it doesn’t quite work as it should?

As a colleague said to me, the last time a UK bank had such a long down time it didn’t go well. I’m looking at you, TSB.

Doing it properly is dead. Long live (Fr)Agile.

Cheers,


Raymond
PS: Although a quick Google search suggests Triple P is the Positive Parenting Program. Funny, as that’s what a lot of off-host developers (and some on-host ones too) need sometimes; lots of hand holding and comforting words from their Mums & Dads. And occasionally a good talking to with a big stick.

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: 01 July 2019 17:25
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control

Gotta love auto correct.... pray is better!
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

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

On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email]<mailto:[login to unmask email]>> wrote:
From what I have seen: push to prod and prey. Also called tripleP

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

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

On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Very timely question for me

Spent three days at a DevOps event last week, so to add to Philips question

“How do you handle repeatedly frequent database change requests in an agile’ly development world?”

Phil Grainger
Principal Enablement Manager


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

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]<mailto:[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: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: 01 July 2019 14:29
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Change Control

General question about code and object management:

Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**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.**
-----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-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. 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

Phil Grainger

Change Control
(in response to Raymond Bell)
BUT

I quite expected said UK bank to be out of business by now – and they aren’t

Maybe expectations are being lowered as fast as everything else?

Phil Grainger
Principal Enablement Manager

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

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: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
Sent: 02 July 2019 08:50
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: Change Control

Triple P. Nice. I had a good chuckle about that. It does seem, as Phil S alluded to, that software ‘development’ involves throwing it over the Prod wall as fast as possible, taking a leaf out of the Duke of Wellington’s book and being quite happy to, ‘publish and be damned’.

I had a chuckle yesterday too, when a UK ‘challenger bank’ emailed me to say their mobile banking app would be down for maintenance from 11pm this Saturday to 7pm Sunday. WTAF? If anyone at any major UK bank tried to present that implementation plan at review they’d be laughed out the room – and marched out the building. Seems speed to market is all with some folks; so what if it doesn’t quite work as it should?

As a colleague said to me, the last time a UK bank had such a long down time it didn’t go well. I’m looking at you, TSB.

Doing it properly is dead. Long live (Fr)Agile.

Cheers,


Raymond
PS: Although a quick Google search suggests Triple P is the Positive Parenting Program. Funny, as that’s what a lot of off-host developers (and some on-host ones too) need sometimes; lots of hand holding and comforting words from their Mums & Dads. And occasionally a good talking to with a big stick.

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: 01 July 2019 17:25
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Change Control

Gotta love auto correct.... pray is better!
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=1q1Tlo9MYy_WEvXSdGmlH9pKeTBaFKFGL9QKWN5YT-w&s=-iJNlq4AgehBpkdrdSyR2GuJkoOb-jKqBFeoxjFvqFY&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=1q1Tlo9MYy_WEvXSdGmlH9pKeTBaFKFGL9QKWN5YT-w&s=vjsEPrigik-YW2UXHD400y9iYOxlYUmyX4CNHX3DHXc&e=

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

On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email]<mailto:[login to unmask email]>> wrote:
From what I have seen: push to prod and prey. Also called tripleP

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=1q1Tlo9MYy_WEvXSdGmlH9pKeTBaFKFGL9QKWN5YT-w&s=-iJNlq4AgehBpkdrdSyR2GuJkoOb-jKqBFeoxjFvqFY&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=1q1Tlo9MYy_WEvXSdGmlH9pKeTBaFKFGL9QKWN5YT-w&s=vjsEPrigik-YW2UXHD400y9iYOxlYUmyX4CNHX3DHXc&e=

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

On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Very timely question for me

Spent three days at a DevOps event last week, so to add to Philips question

“How do you handle repeatedly frequent database change requests in an agile’ly development world?”

Phil Grainger
Principal Enablement Manager

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

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]<mailto:[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: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: 01 July 2019 14:29
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Change Control

General question about code and object management:

Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**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.**
-----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-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. 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: 250 Bishopsgate, London EC2M 4AA. 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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbs.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=1q1Tlo9MYy_WEvXSdGmlH9pKeTBaFKFGL9QKWN5YT-w&s=1nekOFXFW_rLeGUuS0ZRa7ZYxtqCmO0ZptofZW34s4k&e=
-----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

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

Phil McLaren

Change Control
(in response to Raymond Bell)
Actually, one of the big 4 UK banks is having a very similar full blown
outage this coming weekend too. It must be the season...!

On Tue, 2 Jul 2019, 08:50 Bell, Raymond (Hosting Services, Technology) <
[login to unmask email] wrote:

> Triple P. Nice. I had a good chuckle about that. It does seem, as Phil
> S alluded to, that software ‘development’ involves throwing it over the
> Prod wall as fast as possible, taking a leaf out of the Duke of
> Wellington’s book and being quite happy to, ‘publish and be damned’.
>
>
>
> I had a chuckle yesterday too, when a UK ‘challenger bank’ emailed me to
> say their mobile banking app would be down for maintenance from 11pm this
> Saturday to 7pm Sunday. WTAF? If anyone at any major UK bank tried to
> present that implementation plan at review they’d be laughed out the room –
> and marched out the building. Seems speed to market is all with some
> folks; so what if it doesn’t quite work as it should?
>
>
>
> As a colleague said to me, the last time a UK bank had such a long down
> time it didn’t go well. I’m looking at you, TSB.
>
>
>
> Doing it properly is dead. Long live (Fr)Agile.
>
>
>
> Cheers,
>
>
>
>
>
> Raymond
>
> PS: Although a quick Google search suggests Triple P is the Positive
> Parenting Program. Funny, as that’s what a lot of off-host developers (and
> some on-host ones too) need sometimes; lots of hand holding and comforting
> words from their Mums & Dads. And occasionally a good talking to with a
> big stick.
>
>
>
> *From:* Boxwell, Roy [mailto:[login to unmask email]
> *Sent:* 01 July 2019 17:25
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: Change Control
>
>
>
> Gotta love auto correct.... pray is better!
>
> Roy Boxwell
>
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
>
> -Product Development-
>
> Heinrichstrasse 83-85
>
> 40239 Düsseldorf/Germany
>
> Tel. +49 (0)211 96149-675
>
> Fax +49 (0)211 96149-32
>
> Email: [login to unmask email]
>
> http://www.seg.de
>
> Link zur Datenschutzerklärung
> https://www.seg.de/corporate/rechtliche-hinweise/datenschutz
>
>
>
> Software Engineering GmbH
>
> Amtsgericht Düsseldorf, HRB 37894
>
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
>
> On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email]> wrote:
>
> From what I have seen: push to prod and prey. Also called tripleP
>
>
>
> Roy Boxwell
>
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
>
> -Product Development-
>
> Heinrichstrasse 83-85
>
> 40239 Düsseldorf/Germany
>
> Tel. +49 (0)211 96149-675
>
> Fax +49 (0)211 96149-32
>
> Email: [login to unmask email]
>
> http://www.seg.de
>
> Link zur Datenschutzerklärung
> https://www.seg.de/corporate/rechtliche-hinweise/datenschutz
>
>
>
> Software Engineering GmbH
>
> Amtsgericht Düsseldorf, HRB 37894
>
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
>
> On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email]> wrote:
>
> Very timely question for me
>
>
>
> Spent three days at a DevOps event last week, so to add to Philips question
>
>
>
> “How do you handle repeatedly frequent database change requests in an
> agile’ly development world?”
>
>
>
> *Phil Grainger*
> Principal Enablement Manager
>
> https://www.bmc.com/ami [image: BMC Exchange 2019 - Global Event Series
> - REGISTER] https://www.bmc.com/ami https://www.bmc.com/ami
>
> *Direct*
>
> +44 1189 218 000
>
> *Mobile*
>
> +44 7808 643 479
>
> *Email*
>
> [login to unmask email]
>
> E2, Eskdale Road
> Winnersh
> Berkshire
> United Kingdom
> RG41 5TS
>
> [image: image001 (002)][image:
> https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][image:
> https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]
>
>
>
>
>
> *From:* Sevetson, Phil <[login to unmask email]>
> *Sent:* 01 July 2019 14:29
> *To:* [login to unmask email]
> *Subject:* [EXTERNAL] [DB2-L] - Change Control
>
>
>
> General question about code and object management:
>
>
>
> Does anyone out there (does everyone out there) use a formal change
> control process, with code reviews, for database changes and DBA job
> changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX,
> etc) management. (Also, does anyone do surveys on this topic???)
>
>
>
> Philip Sevetson
>
> Computer Systems Manager
>
> FISA-OPA
>
> 5 Manhattan West
>
> New York, NY 10001
>
> [login to unmask email]
>
> 212-857-1688 w
>
> 917-991-7052 m
>
> 212-857-1659 f
>
> [image: cid:[login to unmask email]
>
>
>
> **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.**
>
> -----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-----
>
> The Royal Bank of Scotland plc. Registered in Scotland No 83026.
> 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: 250 Bishopsgate, London EC2M 4AA. 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
> -----End Original Message-----
>

Roy Boxwell

Change Control
(in response to Phil McLaren)
There’s also a major German bank doing a big IT migration this weekend... Looks like a fun weekend coming up!!!!



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: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


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



From: Phil McLaren [mailto:[login to unmask email]
Sent: Tuesday, July 2, 2019 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control



Actually, one of the big 4 UK banks is having a very similar full blown outage this coming weekend too. It must be the season...!



On Tue, 2 Jul 2019, 08:50 Bell, Raymond (Hosting Services, Technology) <[login to unmask email] <mailto:[login to unmask email]> wrote:

Triple P. Nice. I had a good chuckle about that. It does seem, as Phil S alluded to, that software ‘development’ involves throwing it over the Prod wall as fast as possible, taking a leaf out of the Duke of Wellington’s book and being quite happy to, ‘publish and be damned’.



I had a chuckle yesterday too, when a UK ‘challenger bank’ emailed me to say their mobile banking app would be down for maintenance from 11pm this Saturday to 7pm Sunday. WTAF? If anyone at any major UK bank tried to present that implementation plan at review they’d be laughed out the room – and marched out the building. Seems speed to market is all with some folks; so what if it doesn’t quite work as it should?



As a colleague said to me, the last time a UK bank had such a long down time it didn’t go well. I’m looking at you, TSB.



Doing it properly is dead. Long live (Fr)Agile.



Cheers,





Raymond

PS: Although a quick Google search suggests Triple P is the Positive Parenting Program. Funny, as that’s what a lot of off-host developers (and some on-host ones too) need sometimes; lots of hand holding and comforting words from their Mums & Dads. And occasionally a good talking to with a big stick.



From: Boxwell, Roy [mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: 01 July 2019 17:25
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Change Control



Gotta love auto correct.... pray is better!

Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.

-Product Development-

Heinrichstrasse 83-85

40239 Düsseldorf/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

Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz



Software Engineering GmbH

Amtsgericht Düsseldorf, HRB 37894

Geschäftsführung: Gerhard Schubert, Ulf Heinrich


On 1 Jul 2019, at 17:50, Boxwell, Roy <[login to unmask email] <mailto:[login to unmask email]> > wrote:

From what I have seen: push to prod and prey. Also called tripleP



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.

-Product Development-

Heinrichstrasse 83-85

40239 Düsseldorf/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

Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz



Software Engineering GmbH

Amtsgericht Düsseldorf, HRB 37894

Geschäftsführung: Gerhard Schubert, Ulf Heinrich


On 1 Jul 2019, at 15:45, Grainger, Phil <[login to unmask email] <mailto:[login to unmask email]> > wrote:

Very timely question for me



Spent three days at a DevOps event last week, so to add to Philips question



“How do you handle repeatedly frequent database change requests in an agile’ly development world?”




Phil Grainger
Principal Enablement Manager

https://www.bmc.com/ami https://www.bmc.com/ami https://www.bmc.com/ami


Direct

+44 1189 218 000


Mobile

+44 7808 643 479


Email

[login to unmask email] <mailto:[login to unmask email]>


E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS





From: Sevetson, Phil <[login to unmask email] <mailto:[login to unmask email]> >
Sent: 01 July 2019 14:29
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - Change Control



General question about code and object management:



Does anyone out there (does everyone out there) use a formal change control process, with code reviews, for database changes and DBA job changes? I’m interested in best-practices for code (DDL, JCL, Utils, REXX, etc) management. (Also, does anyone do surveys on this topic???)



Philip Sevetson

Computer Systems Manager

FISA-OPA

5 Manhattan West

New York, NY 10001

[login to unmask email] <mailto:[login to unmask email]>

212-857-1688 w

917-991-7052 m

212-857-1659 f





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

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


The Royal Bank of Scotland plc. Registered in Scotland No 83026. 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: 250 Bishopsgate, London EC2M 4AA. 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


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




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

Attachments

  • smime.p7s (5.1k)

william giannelli

RE: Change Control
(in response to Philip Sevetson)

Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production. 

Bill

Ludovic Janssens

Change Control
(in response to william giannelli)
Hi,

DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:

One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.

One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/
[https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://www.datical.com/liquibase
Liquibase vs. Datical | Datical https://www.datical.com/liquibase
Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
www.datical.com

FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.

If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.

Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.

Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.

Hope this helps ��


Ludovic Janssens
Senior Consultant
[Twitter] https://twitter.com/ae_nv [LinkedIn] https://be.linkedin.com/company/ae-nv-sa

ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be

Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303

[AE] http://www.ae.be/ae-email-banner-redirect

________________________________
From: william giannelli <[login to unmask email]>
Sent: Tuesday, July 2, 2019 11:43
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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


AE-Disclaimer:

Dit bericht is vertrouwelijk en exclusief bestemd voor de geadresseerde ervan. Behoudens andersluidende expliciete afspraak is publicatie, gebruik of verspreiding ervan niet toegelaten. Gelieve de afzender onmiddellijk te verwittigen in geval van foutieve adressering of ontvangst en verwijder het bericht. Visies en opinies uitgedrukt in dit bericht zijn persoonlijk van de afzender tenzij aangegeven als zijnde van AE of verbonden ondernemingen.

This communication is intended for the addressee only and is privileged and confidential. Any unauthorized disclosure, copying, distribution or use is prohibited. If you have received this communication in error, please notify the sender immediately and destroy the original communication. Views and opinions are those of the sender unless clearly stated as being those of AE NV, its subsidiaries and/or associated companies.

Ruediger Kurtz

AW: Change Control
(in response to william giannelli)
Bill and others,

we also use Change Manager that does most of the work, but do you also save the original DDL *before* you apply the changes? Whenever we go for a change in production we always maintain that there is a fallback scenario available … but that includes saving the original DDL, and we rarely save that one (I know, Change Manager can do that but do you actually go the extra mile?).
Moreover, do you save the original access paths and compare them to the new ones?
Can you prove to management that your change did nothing more than you said it would?
Do you save the output from the jobs you ran in production during the last maintenance?

Phil’s original question was also about a formalized control process; is there such a thing in your shop?

Whenever something goes really wrong we spend a lot of time collecting all evidence. In my younger days I was told that the more time I spend preparing the job the less time I might have to spend cleaning up the mess – that was not perfectly true then, and it might even be less true today.

Ruediger





Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: william giannelli [mailto:[login to unmask email]
Gesendet: Dienstag, 2. Juli 2019 11:43
An: [login to unmask email]
Betreff: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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

william giannelli

RE: AW: Change Control
(in response to Ruediger Kurtz)

agreed! To answer the question directly, NO! We have gaps in our turnover (and fall back) procedures, especially when it comes to Access Paths.

Bill

Raymond Bell

Change Control
(in response to Ruediger Kurtz)
Hi Rüdiger,

At several sites I worked at, and at several customer sites I visited back in the day, we used to (I’d recommend they) take full recovery baselines within Change Manager before a change, and maybe just a baseline after the change. That way, your backout strategy is identical regardless of where the change failed; compare where you are with where you started, and have Change Manager generate a worklist to get you from now to then.

<soap_box> This is IMHO far better and far more useful than some change management products that can only build you a backout script that assumes the whole thing worked in the first place. If your change runs out of time, or encounters some issue that means you have to undo half your Db2 changes, what’s the use of a script that only backs it all out if it first all went in? Answer: none. Better to be able to back out from whatever point in your implementation script you have to back out. </soap_box>

As long as you can undo your change, however much of it was implemented, you’re covered. Always CYA, my friend. :o)

Cheers,


Raymond
PS: ‘We don’t work in a blame culture; I just want to know who’s responsible.’

From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: 02 July 2019 11:04
To: '[login to unmask email]'
Subject: [DB2-L] - AW: Change Control


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

Bill and others,

we also use Change Manager that does most of the work, but do you also save the original DDL *before* you apply the changes? Whenever we go for a change in production we always maintain that there is a fallback scenario available … but that includes saving the original DDL, and we rarely save that one (I know, Change Manager can do that but do you actually go the extra mile?).
Moreover, do you save the original access paths and compare them to the new ones?
Can you prove to management that your change did nothing more than you said it would?
Do you save the output from the jobs you ran in production during the last maintenance?

Phil’s original question was also about a formalized control process; is there such a thing in your shop?

Whenever something goes really wrong we spend a lot of time collecting all evidence. In my younger days I was told that the more time I spend preparing the job the less time I might have to spend cleaning up the mess – that was not perfectly true then, and it might even be less true today.

Ruediger



Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]

Internet:

www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: william giannelli [mailto:[login to unmask email]
Gesendet: Dienstag, 2. Juli 2019 11:43
An: [login to unmask email]
Betreff: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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

-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. 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

Phil Grainger

Change Control
(in response to Ruediger Kurtz)
One thing this agile deployment does have in its favour (apart from more rapid delivery of function to end users) is an equally rapid deployment of CORRECTIVE action should something go pear-shaped (why pears btw?)

Once people have the tooling in place to relentlessly push application changes (including database ones) the simpler it is for them to push corrections (or even rollbacks to a prior state – IF the tooling knows how to do that)

Phil Grainger
Principal Enablement Manager

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

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: Kurtz, Rüdiger <[login to unmask email]>
Sent: 02 July 2019 11:04
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - AW: Change Control

Bill and others,

we also use Change Manager that does most of the work, but do you also save the original DDL *before* you apply the changes? Whenever we go for a change in production we always maintain that there is a fallback scenario available … but that includes saving the original DDL, and we rarely save that one (I know, Change Manager can do that but do you actually go the extra mile?).
Moreover, do you save the original access paths and compare them to the new ones?
Can you prove to management that your change did nothing more than you said it would?
Do you save the output from the jobs you ran in production during the last maintenance?

Phil’s original question was also about a formalized control process; is there such a thing in your shop?

Whenever something goes really wrong we spend a lot of time collecting all evidence. In my younger days I was told that the more time I spend preparing the job the less time I might have to spend cleaning up the mess – that was not perfectly true then, and it might even be less true today.

Ruediger



Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: william giannelli [mailto:[login to unmask email]
Gesendet: Dienstag, 2. Juli 2019 11:43
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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

Ruediger Kurtz

AW: Change Control
(in response to Raymond Bell)
Raymond,

thanks a bundle.
As I said, I know the process and can handle it, the question I’m asking myself (and others) is, however, do we really care?
When we are in the process of preparing for some major release and aren’t over-confident that everything will go the way we planned we might generate such a “golden copy” (in order to avoid too much closeness with the product itself), but in ordinary circumstances we just keep pushing forward and hope for the best.
As to access paths we also have some product in place to check whether a rebind yields a better access path or not, but that does not help in the case of a bind, because bind you must and deal with the consequences (I’m over-simplifying, I know).

The bottom line being something along … be prepared, but whatever you do may just not be good enough. You can watch out for possible stepping stones, but eventually something totally unforeseen comes along. 30+ years in the business have taught me that whatever effort you put into preparing a change, do not ever assume you’re on the safe side.

CYA (now that I know what it stands for ☺ )

Rüdiger

PS.: I like your PS, too true.



Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Bell, Raymond (Hosting Services, Technology) [mailto:[login to unmask email]
Gesendet: Dienstag, 2. Juli 2019 12:23
An: '[login to unmask email]' <[login to unmask email]>
Betreff: [DB2-L] - RE: Change Control

Hi Rüdiger,

At several sites I worked at, and at several customer sites I visited back in the day, we used to (I’d recommend they) take full recovery baselines within Change Manager before a change, and maybe just a baseline after the change. That way, your backout strategy is identical regardless of where the change failed; compare where you are with where you started, and have Change Manager generate a worklist to get you from now to then.

<soap_box> This is IMHO far better and far more useful than some change management products that can only build you a backout script that assumes the whole thing worked in the first place. If your change runs out of time, or encounters some issue that means you have to undo half your Db2 changes, what’s the use of a script that only backs it all out if it first all went in? Answer: none. Better to be able to back out from whatever point in your implementation script you have to back out. </soap_box>

As long as you can undo your change, however much of it was implemented, you’re covered. Always CYA, my friend. :o)

Cheers,


Raymond
PS: ‘We don’t work in a blame culture; I just want to know who’s responsible.’

From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: 02 July 2019 11:04
To: '[login to unmask email]'
Subject: [DB2-L] - AW: Change Control


*********************************************
" 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"
*********************************************
Bill and others,

we also use Change Manager that does most of the work, but do you also save the original DDL *before* you apply the changes? Whenever we go for a change in production we always maintain that there is a fallback scenario available … but that includes saving the original DDL, and we rarely save that one (I know, Change Manager can do that but do you actually go the extra mile?).
Moreover, do you save the original access paths and compare them to the new ones?
Can you prove to management that your change did nothing more than you said it would?
Do you save the output from the jobs you ran in production during the last maintenance?

Phil’s original question was also about a formalized control process; is there such a thing in your shop?

Whenever something goes really wrong we spend a lot of time collecting all evidence. In my younger days I was told that the more time I spend preparing the job the less time I might have to spend cleaning up the mess – that was not perfectly true then, and it might even be less true today.

Ruediger



Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: william giannelli [mailto:[login to unmask email]
Gesendet: Dienstag, 2. Juli 2019 11:43
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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

-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. 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: 250 Bishopsgate, London EC2M 4AA. 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
-----End Original Message-----

J&#248;rn Thyssen

RE: Change Control
(in response to Ludovic Janssens)

Hi Ludovic,

One important note is that the open source tools you mention keeps "delta scripts" under version control.This is the so-called "migration based" approach. In general, it's up to the developer to understand Db2 for z/OS features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what about removing a column or adding a column to the middle of a table? Handling dependent views and stored procedures is also difficult in this approach. The migrated based approach does have a number of advantages.

The alternative is the "state based" approach where the developer have the full DDL under version control and you use a compare engine to figure out the best way to deploy the change. Such tools normally also handle dependent views and stored procedures, re-stablish authorizations, run the appropriate utilities such as REORG and REBIND, etc.

The two approaches have their advantages and disadvantages, and I have seen both in use at customers. The tools you mention are frequently used because the database devops discipline often starts on the customer's distributed databases and then spread to Db2 for z/OS. In some cases they prefer to use the same tools in order to leverage existing pipelines.

If you google "migration based vs state based" you will find that the state based method is often recommended for projects with

  • large monolithic databases
  • large teams
  • large number of changes
  • stored procedures
  • prototyping applications

Sounds familiar? :)
In Reply to Ludovic Janssens:

Hi,

DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:

One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.

One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/
[https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://www.datical.com/liquibase
Liquibase vs. Datical | Datical https://www.datical.com/liquibase
Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
www.datical.com

FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.

If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.

Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.

Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.

Hope this helps ��


Ludovic Janssens
Senior Consultant
[Twitter] https://twitter.com/ae_nv [LinkedIn] https://be.linkedin.com/company/ae-nv-sa

ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be

Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303

[AE] http://www.ae.be/ae-email-banner-redirect

________________________________
From: william giannelli <[login to unmask email]>
Sent: Tuesday, July 2, 2019 11:43
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control


Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.

Bill

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


AE-Disclaimer:

Dit bericht is vertrouwelijk en exclusief bestemd voor de geadresseerde ervan. Behoudens andersluidende expliciete afspraak is publicatie, gebruik of verspreiding ervan niet toegelaten. Gelieve de afzender onmiddellijk te verwittigen in geval van foutieve adressering of ontvangst en verwijder het bericht. Visies en opinies uitgedrukt in dit bericht zijn persoonlijk van de afzender tenzij aangegeven als zijnde van AE of verbonden ondernemingen.

This communication is intended for the addressee only and is privileged and confidential. Any unauthorized disclosure, copying, distribution or use is prohibited. If you have received this communication in error, please notify the sender immediately and destroy the original communication. Views and opinions are those of the sender unless clearly stated as being those of AE NV, its subsidiaries and/or associated companies.



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

J&#248;rn Thyssen

RE: Change Control
(in response to Philip Sevetson)

Hi Phil,

I don't think we can escape it much longer :)

When I started as a developer in 2001 we had three PDS libraries: PROJECT.DEV.PLI, PROJECT.TEST.PLI and PROJECT.PROD.PLI. 5 years later we started using an SCM for the code and DDL. 

I frequently present a database devops solution and normally survey the audience: how many keep their DDL under version control. The answer is usually between 0 and 25%...so for the majority of the customers the authoritative truth today is still the production Db2 catalog.

 

A lot of customers are now starting to look into database devops for Db2 for z/OS. They either building cloud-like solutions on top of their existing Db2 tools (I've seen examples using IBM, CA and BMC Db2 tools), use open source tooling (see Ludovic' post) or new cloud tooling created for the purpose.

We've ported git to the mainframe, and it is the de-facto standard SCM today. I see more and more customers using git on USS for infrastructure definitions (SYS1.PARMLIB, MQ definitions, CICS definitions, etc.), code and now also DDL.

Feel free to reach out to me offline if you need more information about IBM's solutions in this space.

In Reply to Philip Sevetson:

Roy,

Well.

The term “discouraging” seems to have been made for this situation. How did we manage to miss being included in project development disciplines? You know: code repositories; comparison checks; code walkthroughs, all that stuff which is supposed to improve the quality of product…

-phil (sevetson)

 

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

Philip Sevetson

Change Control
(in response to Jørn Thyssen)
All,

I also need to branch the conversation a bit. I’m used to set procedures for backing up current and initiating changes in database structures.

What I am _not_ seeing, is DBA areas using change management processes (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB utilities. Is that P-3, too? Or are people actually using line-compare and testing scenarios and so forth?

How do you test explicit code like a REORG with the tablespace specified? Do you use the same schemas and dbnames in a test environment, as in prod? Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there standards applied?

I’m in a zero-tolerance-for-error environment. I need a well-developed control process to rigorously test and examine production changes. I don’t have one, and my choices are pretty much limited to “build your own.” So recommendations are welcome.

-phil

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 9:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control


Hi Ludovic,

One important note is that the open source tools you mention keeps "delta scripts" under version control.This is the so-called "migration based" approach. In general, it's up to the developer to understand Db2 for z/OS features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what about removing a column or adding a column to the middle of a table? Handling dependent views and stored procedures is also difficult in this approach. The migrated based approach does have a number of advantages.

The alternative is the "state based" approach where the developer have the full DDL under version control and you use a compare engine to figure out the best way to deploy the change. Such tools normally also handle dependent views and stored procedures, re-stablish authorizations, run the appropriate utilities such as REORG and REBIND, etc.

The two approaches have their advantages and disadvantages, and I have seen both in use at customers. The tools you mention are frequently used because the database devops discipline often starts on the customer's distributed databases and then spread to Db2 for z/OS. In some cases they prefer to use the same tools in order to leverage existing pipelines.

If you google "migration based vs state based" you will find that the state based method is often recommended for projects with

* large monolithic databases
* large teams
* large number of changes
* stored procedures
* prototyping applications

Sounds familiar? :)
In Reply to Ludovic Janssens:
Hi,

DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:

One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.

One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/
[https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png%5d https://www.datical.com/liquibase
Liquibase vs. Datical | Datical https://www.datical.com/liquibase
Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
www.datical.com

FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.

If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.

Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.

Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.

Hope this helps ��


Ludovic Janssens
Senior Consultant
[Twitter] https://twitter.com/ae_nv [LinkedIn] https://be.linkedin.com/company/ae-nv-sa

ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be

Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303

[AE] http://www.ae.be/ae-email-banner-redirect

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

Philip Sevetson

Change Control
(in response to Jørn Thyssen)
Jørn,

Ha. We just crossed in the “mail.” I’m interested, yes. More in code than in DDL.

-phil (sevetson)

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 9:17 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Change Control


Hi Phil,

I don't think we can escape it much longer :)

When I started as a developer in 2001 we had three PDS libraries: PROJECT.DEV.PLI, PROJECT.TEST.PLI and PROJECT.PROD.PLI. 5 years later we started using an SCM for the code and DDL.

I frequently present a database devops solution and normally survey the audience: how many keep their DDL under version control. The answer is usually between 0 and 25%...so for the majority of the customers the authoritative truth today is still the production Db2 catalog.



A lot of customers are now starting to look into database devops for Db2 for z/OS. They either building cloud-like solutions on top of their existing Db2 tools (I've seen examples using IBM, CA and BMC Db2 tools), use open source tooling (see Ludovic' post) or new cloud tooling created for the purpose.

We've ported git to the mainframe, and it is the de-facto standard SCM today. I see more and more customers using git on USS for infrastructure definitions (SYS1.PARMLIB, MQ definitions, CICS definitions, etc.), code and now also DDL.

Feel free to reach out to me offline if you need more information about IBM's solutions in this space.

In Reply to Philip Sevetson:
Roy,

Well.

The term “discouraging” seems to have been made for this situation. How did we manage to miss being included in project development disciplines? You know: code repositories; comparison checks; code walkthroughs, all that stuff which is supposed to improve the quality of product…

-phil (sevetson)





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com

2019 IBM Champion.

Views are personal.

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

Marcus Davage

Change Control
(in response to Philip Sevetson)
We at BMC are currently developing a Z-based DevOps orchestration and deployment solution that include DDL migration (using Change Manager), DDL site standards adherence, SQL (DML) performance assurance and validation, and data provisioning. Watch this space.

Regards,
Marcus Davage
Lead Product Developer
AMI-DevOps for Db2 – SQL Performance
Direct

+44 118 921 8517

[cid:[login to unmask email]



Mobile

+44 7840 023 560



Email

[login to unmask email]<mailto:[login to unmask email]>





From: Sevetson, Phil <[login to unmask email]>
Sent: 02 July 2019 14:17
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: Change Control

All,

I also need to branch the conversation a bit. I’m used to set procedures for backing up current and initiating changes in database structures.

What I am _not_ seeing, is DBA areas using change management processes (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB utilities. Is that P-3, too? Or are people actually using line-compare and testing scenarios and so forth?

How do you test explicit code like a REORG with the tablespace specified? Do you use the same schemas and dbnames in a test environment, as in prod? Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there standards applied?

I’m in a zero-tolerance-for-error environment. I need a well-developed control process to rigorously test and examine production changes. I don’t have one, and my choices are pretty much limited to “build your own.” So recommendations are welcome.

-phil

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 9:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Change Control


Hi Ludovic,

One important note is that the open source tools you mention keeps "delta scripts" under version control.This is the so-called "migration based" approach. In general, it's up to the developer to understand Db2 for z/OS features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what about removing a column or adding a column to the middle of a table? Handling dependent views and stored procedures is also difficult in this approach. The migrated based approach does have a number of advantages.

The alternative is the "state based" approach where the developer have the full DDL under version control and you use a compare engine to figure out the best way to deploy the change. Such tools normally also handle dependent views and stored procedures, re-stablish authorizations, run the appropriate utilities such as REORG and REBIND, etc.

The two approaches have their advantages and disadvantages, and I have seen both in use at customers. The tools you mention are frequently used because the database devops discipline often starts on the customer's distributed databases and then spread to Db2 for z/OS. In some cases they prefer to use the same tools in order to leverage existing pipelines.

If you google "migration based vs state based" you will find that the state based method is often recommended for projects with

* large monolithic databases
* large teams
* large number of changes
* stored procedures
* prototyping applications

Sounds familiar? :)
In Reply to Ludovic Janssens:
Hi,

DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:

One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.

One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/ https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=0ewie7Ii2nhtdtWqlKb-BHETwG8QQqsJn5r2MS7M6rI&e=
[https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_wp-2Dcontent_uploads_cropped-2DDatical-2DTransparent-2DGreen-2Dand-2DBlack-2DLogo.png-255d&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=3JPYsCBIBrGBrFHSZmRQFRjoknTczQeZnvBQ-j9y3PE&e= https://www.datical.com/liquibase https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
Liquibase vs. Datical | Datical https://www.datical.com/liquibase https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
www.datical.com http://www.datical.com

FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.

If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.

Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.

Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.

Hope this helps ��


Ludovic Janssens
Senior Consultant
[Twitter] https://twitter.com/ae_nv https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ae-5Fnv&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=h_8nYjoAlPZiCY73KMZxCBTC2EEAovbYJ9Jn_MmRvo0&e= [LinkedIn] https://be.linkedin.com/company/ae-nv-sa

ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be http://www.ae.be https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=DnEfnIcRO3im2zuDZs1rdUylALg-sCGFCgJhXsLe5-E&e=

Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303

[AE] http://www.ae.be/ae-email-banner-redirect https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be_ae-2Demail-2Dbanner-2Dredirect&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=AghcsdB8qZdotIol5YY1qcUp9C_VQ0eMY7cG3ztFctU&e=

-----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.png (12.9k)

J&#248;rn Thyssen

RE: Change Control
(in response to Philip Sevetson)

Hi Phil,

Everything is code, so there is not necessarily any differences in the overall development process of a REXX, Cobol or Db2 table. The tools and individual steps will obviously differ.

I think the velocity of changes decide how much you want to automate. Nirvana is a full end-to-end pipeline that covers the entire development process from requirements over development to deployment and monitoring including automatic code review, automatic testing, deployment, etc.  The question is if you want to do this for a REXX you change every second year?

I would start by putting those artifacts into git: very simplified:

  • copy member to USS dataset (e.g., copy SYS1.PARMLIB(IEASYS00) to /project/SYS1/IEASYS00.PARMLIB)
  • put it under git control (git init, git add, git commit)
  • optionally push git repo to your company git server (bitbucket, github, gitlab, ...)

Now you will have a history of changes of who did what when; be able to undo changes, etc.

Internally we have some homemade tools that add ISPF commands for git stuff to automate this process. I've also seen this the wild: https://github.com/wizardofzos/gseuk

For more critical and/or frequently changed artifacts you can set up automated regression tests. If this is a Db2 utility JCL such a test might provision a set of Db2 objects, run the updated JCL against those objects, compare the output with expected results, and finally drop the Db2 objects (or restore them to the original state). The modern way of orchestrating this would be using Jenkins or equivalent tools. I'll be presenting "Jenkins for Db2 for z/OS DBAs" at IDUG EMEA later this year, and have also submitted the same abstract for the IDUG Data Tech Summit in SVL in October. One of the examples I plan to cover in this presentation is keeping your zparms under git control and use Jenkins to automatically build and deploy to a sandbox system.


In Reply to Philip Sevetson:

All,

I also need to branch the conversation a bit. I’m used to set procedures for backing up current and initiating changes in database structures.

What I am _not_ seeing, is DBA areas using change management processes (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB utilities. Is that P-3, too? Or are people actually using line-compare and testing scenarios and so forth?

How do you test explicit code like a REORG with the tablespace specified? Do you use the same schemas and dbnames in a test environment, as in prod? Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there standards applied?

I’m in a zero-tolerance-for-error environment. I need a well-developed control process to rigorously test and examine production changes. I don’t have one, and my choices are pretty much limited to “build your own.” So recommendations are welcome.

-phil

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

Patrick Bossman

[AD] RE: Change Control
(in response to carol goldberg)

Hi Carol,

We've been working on providing integrations with a modern development stack.  If you want debugging, then you would use Data Studio. Otherwise, you could use Visual Studio Code, or any other editor, as the automation for deployment kicks in with push of changes to the SCM server.  We've used Git or RTC as SCM for our demos, but others could work.  Jenkins as the continuous integration tool, and Urban Code Deploy as the deployment tool.  Urban Code Deploy (UCD) has many plugins and templates for different types of system z artifact deployments. 

For stored procedures, we have UCD calling IBM Db2 DevOps Experience to perform the actual deployment and determine whether to create/replace, and handle any dependencies.

We have a pretty robust set of artifacts that we can deploy, and I'm interested in hearing the other top artifacts around Db2 to include in forthcoming demos and hands on labs.

- External and native stored procedures

- SQL changes using CLP

- Native REST services

- Schema changes

- You can run utilities, commands, etc.

Phil, I don't see any reason we couldn't put REXX and utility jobs into the same pipeline.

Shoot, we haven't done this yet. but I've done enough RACF, PARMLIB, PROCLIB, SMS, system parameter changes...  Artifacts that can be changed via batch interfaces and commands can typically be integrated to automated deployment pipelines.

What is the development artifact that is created/changed, what is the review process, what is the deployment process.

Best regards,

Patrick Bossman

 

In Reply to carol goldberg:

Here is a question that has been looming for a while. We use Endevor for
source control. We would like to start the usage of SQLPL procedures. We do
not own the DB2 version of Endevor.
There are 2 ways I see our developers to use SQLPL, one would be logged
into TSO , doing development the other would be via Data Studio.
Has anyone integrated either of these development methods with Using
Endevor for source control.

We do not want to give create authority directly, but maybe via Endevor (
check in / check out and also using deploy.

How are others accomplishing the development of SQLPL procedures via Source
Control?


Hope this makes sense, we are are DB2 v12 z/os,

Thanks, Carol


On Tue, Jul 2, 2019 at 9:00 AM Davage, Marcus <[login to unmask email]> wrote:

> We at BMC are currently developing a Z-based DevOps orchestration and
> deployment solution that include DDL migration (using Change Manager), DDL
> site standards adherence, SQL (DML) performance assurance and validation,
> and data provisioning. Watch this space.
>
>
>
> Regards,
>
> *Marcus Davage*
>
> Lead Product Developer
>
> AMI-DevOps for Db2 – SQL Performance
>
> *Direct*
>
> +44 118 921 8517
>
>
>
> *Mobile*
>
> +44 7840 023 560
>
>
>
> *Email*
>
> [login to unmask email]
>
>
>
>
>
>
>
> *From:* Sevetson, Phil <[login to unmask email]>
> *Sent:* 02 July 2019 14:17
> *To:* '[login to unmask email]' <[login to unmask email]>
> *Subject:* [EXTERNAL] [DB2-L] - RE: Change Control
>
>
>
> All,
>
>
>
> I also need to branch the conversation a bit. I’m used to set procedures
> for backing up current and initiating changes in database structures.
>
>
>
> What I am _*not*_ seeing, is DBA areas using change management processes
> (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB
> utilities. Is that P-3, too? Or are people actually using line-compare and
> testing scenarios and so forth?
>
>
>
> How do you test explicit code like a REORG with the tablespace specified?
> Do you use the same schemas and dbnames in a test environment, as in prod?
> Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there
> standards applied?
>
>
>
> I’m in a zero-tolerance-for-error environment. I need a well-developed
> control process to rigorously test and examine production changes. I don’t
> have one, and my choices are pretty much limited to “build your own.” So
> recommendations are welcome.
>
>
>
> -phil
>
>
>
> *From:* Jørn Thyssen [mailto:[login to unmask email] <[login to unmask email]>]
> *Sent:* Tuesday, July 02, 2019 9:01 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: Change Control
>
>
>
> Hi Ludovic,
>
> One important note is that the open source tools you mention keeps "delta
> scripts" under version control.This is the so-called "migration based"
> approach. In general, it's up to the developer to understand Db2 for z/OS
> features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what
> about removing a column or adding a column to the middle of a table?
> Handling dependent views and stored procedures is also difficult in this
> approach. The migrated based approach does have a number of advantages.
>
> The alternative is the "state based" approach where the developer have the
> full DDL under version control and you use a compare engine to figure out
> the best way to deploy the change. Such tools normally also handle
> dependent views and stored procedures, re-stablish authorizations, run the
> appropriate utilities such as REORG and REBIND, etc.
>
> The two approaches have their advantages and disadvantages, and I have
> seen both in use at customers. The tools you mention are frequently used
> because the database devops discipline often starts on the customer's
> distributed databases and then spread to Db2 for z/OS. In some cases they
> prefer to use the same tools in order to leverage existing pipelines.
>
> If you google "migration based vs state based" you will find that the
> state based method is often recommended for projects with
>
> - large monolithic databases
> - large teams
> - large number of changes
> - stored procedures
> - prototyping applications
>
> Sounds familiar? :)
> In Reply to Ludovic Janssens:
>
> Hi,
>
> DevOps for Db2 has been one of my passions; unfortunately I haven't been
> working with Db2 more recently anymore. I could provide you with some
> experiences I had:
>
> One of the things I have seen is that there are several options to
> integrate Db2 changes with standard Maven/Jenkins deployments.
>
> One of them could be Datical that allows you to do changes starting from a
> logical data model and incorporates an object compare that is supporting
> Db2 for z/os: https://www.datical.com/liquibase/
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=0ewie7Ii2nhtdtWqlKb-BHETwG8QQqsJn5r2MS7M6rI&e=
> [
> https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png]
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_wp-2Dcontent_uploads_cropped-2DDatical-2DTransparent-2DGreen-2Dand-2DBlack-2DLogo.png-255d&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=3JPYsCBIBrGBrFHSZmRQFRjoknTczQeZnvBQ-j9y3PE&e=
> https://www.datical.com/liquibase
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
> Liquibase vs. Datical | Datical https://www.datical.com/liquibase
> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
> Find out when it's best to use Liquibase vs. when you should use Datical
> for database schema changes and automated database deployments.
> www.datical.com
>
> FlywayDB could work too, but as it is SQL based, it is less Agile, because
> it doesn't support different target technologies.
>
> If you are looking into the integration of e.g. Changeman, you should be
> looking whether the vendor doesn't offer you an integration with a
> distributed DevOps tools. Often these allow you to integrate the deployment
> of your mainframe packages from a distributed platform and even integrate
> you components in GIT or SVN.
>
> Once you are in a standard DevOps tool, you can also initiate code
> validation with Unit Tests and visualize the results with eg. SonarQube.
> Obviously, you could also trigger different processes on the mainframe from
> the DevOps tool with an appropriate action that can trigger a job on the
> mainframe.
>
> Finally, if I remember well, Infosphere Optim Query Workload Tuner allows
> you to capture the results of a performance test and map it onto your
> application processes in a part of Data Studio. Things can have changed
> meanwhile.
>
> Hope this helps ��
>
>
> Ludovic Janssens
> Senior Consultant
> [Twitter] https://twitter.com/ae_nv
> https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ae-5Fnv&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=h_8nYjoAlPZiCY73KMZxCBTC2EEAovbYJ9Jn_MmRvo0&e=
> [LinkedIn] https://be.linkedin.com/company/ae-nv-sa
>
> ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=DnEfnIcRO3im2zuDZs1rdUylALg-sCGFCgJhXsLe5-E&e=
>
> Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
> Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303
>
> [AE] http://www.ae.be/ae-email-banner-redirect
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be_ae-2Demail-2Dbanner-2Dredirect&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=AghcsdB8qZdotIol5YY1qcUp9C_VQ0eMY7cG3ztFctU&e=
>
> ________________________________
> From: william giannelli
> Sent: Tuesday, July 2, 2019 11:43
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Change Control
>
>
> Great question! Especially with the big push for Agile and Dev/Ops. In our
> shop we use Change Man which handles the binds during turnover. And we also
> use BMC Change Manager for DDL changes. What I would like to see is a
> product for SQL and Access Path checking that would integrate with Change
> Man so that we could incorporate it into our turnover process for
> Production. And also, we have a need (again due to Agile, Dev/Ops) for easy
> repeatable testing within development before production.
>
> Bill
>
> -----End Original Message-----
>
>
> AE-Disclaimer:
>
> Dit bericht is vertrouwelijk en exclusief bestemd voor de geadresseerde
> ervan. Behoudens andersluidende expliciete afspraak is publicatie, gebruik
> of verspreiding ervan niet toegelaten. Gelieve de afzender onmiddellijk te
> verwittigen in geval van foutieve adressering of ontvangst en verwijder het
> bericht. Visies en opinies uitgedrukt in dit bericht zijn persoonlijk van
> de afzender tenzij aangegeven als zijnde van AE of verbonden ondernemingen.
>
> This communication is intended for the addressee only and is privileged
> and confidential. Any unauthorized disclosure, copying, distribution or use
> is prohibited. If you have received this communication in error, please
> notify the sender immediately and destroy the original communication. Views
> and opinions are those of the sender unless clearly stated as being those
> of AE NV, its subsidiaries and/or associated companies.
>
>
>
>
>
> Best regards,
>
> Jørn Thyssen
>
> Rocket Software
> 77 Fourth Avenue • Waltham, MA • 02451 • USA
> E: [login to unmask email] • W: www.rocketsoftware.com
>
> 2019 IBM Champion.
>
> Views are personal.
>
>
>
> -----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.**
> -----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-----
>
Edited By:
Patrick Bossman[Organization Members] @ Jul 03, 2019 - 07:36 AM (America/Eastern)

Bill Gallagher

[External] Change Control
(in response to carol goldberg)
Hi Carol,

My shop is using Endevor for managing our DB2 native stored procedures as well as DB2 SQL user defined functions. We also do not own the DB2 version of Endevor.

Our Endevor admin created two new Endevor types, one for NSP and the other for UDF. Source code is checked out, checked in, migrated, etc., just like any other Endevor object. The Endevor processors are written to do some validation and substitution of variables coded within the NSP or UDF source code (for schema name, table qualifiers, etc), and then perform the actual deployment across environments through Endevor packages.

We’re also starting to put together a process for one of our customer areas that would prefer to use GitHub for source control and Jenkins for deployment of NSPs and UDFs, as they would prefer to not have to use Endevor. That’s been challenging, but we’ve built something that we think works. We’re just waiting for them to test and signoff on the process.

Bill Gallagher | Senior Systems Engineer, DBA | Data Administration

From: Carol Goldberg <[login to unmask email]>
Sent: Monday, July 1, 2019 9:40 PM
To: [login to unmask email]
Subject: [External] [DB2-L] - RE: Change Control

Here is a question that has been looming for a while. We use Endevor for source control. We would like to start the usage of SQLPL procedures. We do not own the DB2 version of Endevor.
There are 2 ways I see our developers to use SQLPL, one would be logged into TSO , doing development the other would be via Data Studio.
Has anyone integrated either of these development methods with Using Endevor for source control.

We do not want to give create authority directly, but maybe via Endevor ( check in / check out and also using deploy.

How are others accomplishing the development of SQLPL procedures via Source Control?


Hope this makes sense, we are are DB2 v12 z/os,

Thanks, Carol


On Tue, Jul 2, 2019 at 9:00 AM Davage, Marcus <[login to unmask email]<mailto:[login to unmask email]>> wrote:
We at BMC are currently developing a Z-based DevOps orchestration and deployment solution that include DDL migration (using Change Manager), DDL site standards adherence, SQL (DML) performance assurance and validation, and data provisioning. Watch this space.

Regards,
Marcus Davage
Lead Product Developer
AMI-DevOps for Db2 – SQL Performance
Direct

+44 118 921 8517

[cid:16bb051e19c4cff311]



Mobile

+44 7840 023 560



Email

[login to unmask email]<mailto:[login to unmask email]>





From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: 02 July 2019 14:17
To: '[login to unmask email]<mailto:[login to unmask email]>' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [EXTERNAL] [DB2-L] - RE: Change Control

All,

I also need to branch the conversation a bit. I’m used to set procedures for backing up current and initiating changes in database structures.

What I am _not_ seeing, is DBA areas using change management processes (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB utilities. Is that P-3, too? Or are people actually using line-compare and testing scenarios and so forth?

How do you test explicit code like a REORG with the tablespace specified? Do you use the same schemas and dbnames in a test environment, as in prod? Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there standards applied?

I’m in a zero-tolerance-for-error environment. I need a well-developed control process to rigorously test and examine production changes. I don’t have one, and my choices are pretty much limited to “build your own.” So recommendations are welcome.

-phil

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 9:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Change Control


Hi Ludovic,

One important note is that the open source tools you mention keeps "delta scripts" under version control.This is the so-called "migration based" approach. In general, it's up to the developer to understand Db2 for z/OS features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what about removing a column or adding a column to the middle of a table? Handling dependent views and stored procedures is also difficult in this approach. The migrated based approach does have a number of advantages.

The alternative is the "state based" approach where the developer have the full DDL under version control and you use a compare engine to figure out the best way to deploy the change. Such tools normally also handle dependent views and stored procedures, re-stablish authorizations, run the appropriate utilities such as REORG and REBIND, etc.

The two approaches have their advantages and disadvantages, and I have seen both in use at customers. The tools you mention are frequently used because the database devops discipline often starts on the customer's distributed databases and then spread to Db2 for z/OS. In some cases they prefer to use the same tools in order to leverage existing pipelines.

If you google "migration based vs state based" you will find that the state based method is often recommended for projects with

* large monolithic databases
* large teams
* large number of changes
* stored procedures
* prototyping applications

Sounds familiar? :)
In Reply to Ludovic Janssens:
Hi,

DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:

One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.

One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/ https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=0ewie7Ii2nhtdtWqlKb-BHETwG8QQqsJn5r2MS7M6rI&e=
[https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_wp-2Dcontent_uploads_cropped-2DDatical-2DTransparent-2DGreen-2Dand-2DBlack-2DLogo.png-255d&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=3JPYsCBIBrGBrFHSZmRQFRjoknTczQeZnvBQ-j9y3PE&e= https://www.datical.com/liquibase https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
Liquibase vs. Datical | Datical https://www.datical.com/liquibase https://urldefense.proofpoint.com/v2/url?u=https-3A__www.datical.com_liquibase&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=RhDd2o4SJxh1bMhgsk70FlxdaddVWaAtmS2p22MRZFA&e=
Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
www.datical.com http://www.datical.com

FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.

If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.

Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.

Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.

Hope this helps ��


Ludovic Janssens
Senior Consultant
[Twitter] https://twitter.com/ae_nv https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ae-5Fnv&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=h_8nYjoAlPZiCY73KMZxCBTC2EEAovbYJ9Jn_MmRvo0&e= [LinkedIn] https://be.linkedin.com/company/ae-nv-sa

ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be http://www.ae.be https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=DnEfnIcRO3im2zuDZs1rdUylALg-sCGFCgJhXsLe5-E&e=

Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303

[AE] http://www.ae.be/ae-email-banner-redirect https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ae.be_ae-2Demail-2Dbanner-2Dredirect&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=WsIW7LMi0qalTC0B1hFyhBfGoIBHPBXJxm0ofC2s5Pg&s=AghcsdB8qZdotIol5YY1qcUp9C_VQ0eMY7cG3ztFctU&e=

-----End Original Message-----
________________________________
This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.

TRVDiscDefault::1201

steen rasmussen

[External] Change Control
(in response to Bill Gallagher)
Bill - have you looked into Zowe (opensource) to see what that can provide ?

Steen

Sent from my iPhone

> On Jul 3, 2019, at 7:36 AM, Gallagher,Bill R <[login to unmask email]> wrote:
>
> Hi Carol,
>
> My shop is using Endevor for managing our DB2 native stored procedures as well as DB2 SQL user defined functions. We also do not own the DB2 version of Endevor.
>
> Our Endevor admin created two new Endevor types, one for NSP and the other for UDF. Source code is checked out, checked in, migrated, etc., just like any other Endevor object. The Endevor processors are written to do some validation and substitution of variables coded within the NSP or UDF source code (for schema name, table qualifiers, etc), and then perform the actual deployment across environments through Endevor packages.
>
> We’re also starting to put together a process for one of our customer areas that would prefer to use GitHub for source control and Jenkins for deployment of NSPs and UDFs, as they would prefer to not have to use Endevor. That’s been challenging, but we’ve built something that we think works. We’re just waiting for them to test and signoff on the process.
>
> Bill Gallagher | Senior Systems Engineer, DBA | Data Administration
>
> From: Carol Goldberg <[login to unmask email]>
> Sent: Monday, July 1, 2019 9:40 PM
> To: [login to unmask email]
> Subject: [External] [DB2-L] - RE: Change Control
>
> Here is a question that has been looming for a while. We use Endevor for source control. We would like to start the usage of SQLPL procedures. We do not own the DB2 version of Endevor.
> There are 2 ways I see our developers to use SQLPL, one would be logged into TSO , doing development the other would be via Data Studio.
> Has anyone integrated either of these development methods with Using Endevor for source control.
>
> We do not want to give create authority directly, but maybe via Endevor ( check in / check out and also using deploy.
>
> How are others accomplishing the development of SQLPL procedures via Source Control?
>
>
> Hope this makes sense, we are are DB2 v12 z/os,
>
> Thanks, Carol
>
>
> On Tue, Jul 2, 2019 at 9:00 AM Davage, Marcus <[login to unmask email]> wrote:
> We at BMC are currently developing a Z-based DevOps orchestration and deployment solution that include DDL migration (using Change Manager), DDL site standards adherence, SQL (DML) performance assurance and validation, and data provisioning. Watch this space.
>
> Regards,
> Marcus Davage
> Lead Product Developer
> AMI-DevOps for Db2 – SQL Performance
> Direct
> +44 118 921 8517
>
>
> Mobile
> +44 7840 023 560
>
> Email
> [login to unmask email]
>
>
>
> From: Sevetson, Phil <[login to unmask email]>
> Sent: 02 July 2019 14:17
> To: '[login to unmask email]' <[login to unmask email]>
> Subject: [EXTERNAL] [DB2-L] - RE: Change Control
>
> All,
>
> I also need to branch the conversation a bit. I’m used to set procedures for backing up current and initiating changes in database structures.
>
> What I am _not_ seeing, is DBA areas using change management processes (and/or DevOps-Agile) for JCL, for code in REXX and SQL and DSNUTILB utilities. Is that P-3, too? Or are people actually using line-compare and testing scenarios and so forth?
>
> How do you test explicit code like a REORG with the tablespace specified? Do you use the same schemas and dbnames in a test environment, as in prod? Do you check in to Librarian, Clear-Case, Panvalet, Git? Are there standards applied?
>
> I’m in a zero-tolerance-for-error environment. I need a well-developed control process to rigorously test and examine production changes. I don’t have one, and my choices are pretty much limited to “build your own.” So recommendations are welcome.
>
> -phil
>
> From: Jørn Thyssen [mailto:[login to unmask email]
> Sent: Tuesday, July 02, 2019 9:01 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Change Control
>
> Hi Ludovic,
>
> One important note is that the open source tools you mention keeps "delta scripts" under version control.This is the so-called "migration based" approach. In general, it's up to the developer to understand Db2 for z/OS features and write good scripts. ALTER TABLE ADD COLUMN is easy, but what about removing a column or adding a column to the middle of a table? Handling dependent views and stored procedures is also difficult in this approach. The migrated based approach does have a number of advantages.
>
> The alternative is the "state based" approach where the developer have the full DDL under version control and you use a compare engine to figure out the best way to deploy the change. Such tools normally also handle dependent views and stored procedures, re-stablish authorizations, run the appropriate utilities such as REORG and REBIND, etc.
>
> The two approaches have their advantages and disadvantages, and I have seen both in use at customers. The tools you mention are frequently used because the database devops discipline often starts on the customer's distributed databases and then spread to Db2 for z/OS. In some cases they prefer to use the same tools in order to leverage existing pipelines.
>
> If you google "migration based vs state based" you will find that the state based method is often recommended for projects with
>
> large monolithic databases
> large teams
> large number of changes
> stored procedures
> prototyping applications
> Sounds familiar? :)
> In Reply to Ludovic Janssens:
>
> Hi,
>
> DevOps for Db2 has been one of my passions; unfortunately I haven't been working with Db2 more recently anymore. I could provide you with some experiences I had:
>
> One of the things I have seen is that there are several options to integrate Db2 changes with standard Maven/Jenkins deployments.
>
> One of them could be Datical that allows you to do changes starting from a logical data model and incorporates an object compare that is supporting Db2 for z/os: https://www.datical.com/liquibase/
> [https://www.datical.com/wp-content/uploads/cropped-Datical-Transparent-Green-and-Black-Logo.png] https://www.datical.com/liquibase
> Liquibase vs. Datical | Datical https://www.datical.com/liquibase
> Find out when it's best to use Liquibase vs. when you should use Datical for database schema changes and automated database deployments.
> www.datical.com
>
> FlywayDB could work too, but as it is SQL based, it is less Agile, because it doesn't support different target technologies.
>
> If you are looking into the integration of e.g. Changeman, you should be looking whether the vendor doesn't offer you an integration with a distributed DevOps tools. Often these allow you to integrate the deployment of your mainframe packages from a distributed platform and even integrate you components in GIT or SVN.
>
> Once you are in a standard DevOps tool, you can also initiate code validation with Unit Tests and visualize the results with eg. SonarQube. Obviously, you could also trigger different processes on the mainframe from the DevOps tool with an appropriate action that can trigger a job on the mainframe.
>
> Finally, if I remember well, Infosphere Optim Query Workload Tuner allows you to capture the results of a performance test and map it onto your application processes in a part of Data Studio. Things can have changed meanwhile.
>
> Hope this helps ��
>
>
> Ludovic Janssens
> Senior Consultant
> [Twitter] https://twitter.com/ae_nv [LinkedIn] https://be.linkedin.com/company/ae-nv-sa
>
> ae nv/sa • architects for business & ict • www.ae.be http://www.ae.be
>
> Interleuvenlaan 27b, Researchpark Haasrode 1250, BE-3001 Heverlee
> Tel +32 16 39 30 60, Fax +32 16 39 30 70, BTW BE0466550303
>
> [AE] http://www.ae.be/ae-email-banner-redirect
>
> ________________________________
> From: william giannelli
> Sent: Tuesday, July 2, 2019 11:43
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Change Control
>
>
> Great question! Especially with the big push for Agile and Dev/Ops. In our shop we use Change Man which handles the binds during turnover. And we also use BMC Change Manager for DDL changes. What I would like to see is a product for SQL and Access Path checking that would integrate with Change Man so that we could incorporate it into our turnover process for Production. And also, we have a need (again due to Agile, Dev/Ops) for easy repeatable testing within development before production.
>
> Bill
>
> -----End Original Message-----
>
>
> AE-Disclaimer:
>
> Dit bericht is vertrouwelijk en exclusief bestemd voor de geadresseerde ervan. Behoudens andersluidende expliciete afspraak is publicatie, gebruik of verspreiding ervan niet toegelaten. Gelieve de afzender onmiddellijk te verwittigen in geval van foutieve adressering of ontvangst en verwijder het bericht. Visies en opinies uitgedrukt in dit bericht zijn persoonlijk van de afzender tenzij aangegeven als zijnde van AE of verbonden ondernemingen.
>
> This communication is intended for the addressee only and is privileged and confidential. Any unauthorized disclosure, copying, distribution or use is prohibited. If you have received this communication in error, please notify the sender immediately and destroy the original communication. Views and opinions are those of the sender unless clearly stated as being those of AE NV, its subsidiaries and/or associated companies.
>
>
>
>
> Best regards,
>
> Jørn Thyssen
>
> Rocket Software
> 77 Fourth Avenue • Waltham, MA • 02451 • USA
> E: [login to unmask email] • W: www.rocketsoftware.com
>
> 2019 IBM Champion.
>
> Views are personal.
>
>
> -----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.**
> -----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 message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.
>
> TRVDiscDefault::1201
> 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]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> 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
>