We are on DB2 V11, z/OS. I am curious how other companies are handling the process of moving DB2 Stored procedures from a staging library to a Prod library, within the same DB2 system. We have a current process, which is an in-house job, that is very complicated and has many issues. Our current process starts with the developer/dba moving the stored procedure to a "staging" library. We have scheduled jobs that run throughout the day that copy that stored procedure to production library(within same DB2 system), along with deleting it from the staging library, refreshing WLM, STOP/START the DB2 Proc, along with some other behind the scenes steps. This entire process is written in SAS, C, and REXX. We are thinking there must be other, less complicated options for doing this process. Do you have an in-house process for this also? Are there any purchased software options that you are using to complete this task? Any purchased software options that maybe aren't sold for this purpose, but can be used to complete this process? We are looking at our options at this point.
Anne Leonard[Organization Members] @ Oct 09, 2019 - 01:02 PM (America/Central)
Anne Leonard[Organization Members] @ Oct 10, 2019 - 11:23 AM (America/Central)