Re: Deploying DB2 Table Changes

Hi Richard:
If you don't want package software to do this the logical means does seem to either do it manually or code something.   If logic can be put to it for sure you can code it.   If this is a need that happens often enough it likely would be worth writing code.  
Happy Thanksgiving.
Regards,Laura


Laura Ubelhor

President

Consultech Services, Inc.

Office: (248) 628-6800 

ubelhor@xxxxxxxxxxxxx | www.consultechservicesinc.com


On Wednesday, November 24, 2021, 11:58:36 AM EST, Richard Schoen <richard@xxxxxxxxxxxxxxxxx> wrote:

Thanks for the note Karl.

I already told them there are commercial packages for getting the change control/object deployment thing done, but they are already invested in GitHub for other platforms and are implementing Git using my iForGit client (http://www.iforgit.com) to manage capturing the IBM i source changes to GitHub.

The managing source to GitHub piece works fine, but now they really want to manage the object deployment process but don't want to invest in a full blown solution.

Their overall dev process is pretty simple. It's just coming up with a way to manage a few of the gaps like object deployment and making sure all objects that might be affected are identified. DSPPGMREF seems to do a good job of illuminating some of that info.

If at some point they decide to go another direction I will certainly let you know. But for the time being it's homegrown object deployment.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx


------------------------------

message: 4
date: Wed, 24 Nov 2021 16:23:41 +0000
from: Karl Haggart <karl.haggart@xxxxxxxxxxxxxxxxxx>
subject: RE: Deploying DB2 Table Changes

Hi Richard,

Have you and the team considered a change control solution to manage all of the complexity?

It does free up a lot of time for the development team and resolves all of the issues you mentioned with copying data and recompiling related objects, alongside the distribution of the changes to the test and production machines.

Very cost effective too.

Thanks,
Karl.

? ????????????