BMC Opertune and removing active logs

Tom Glaser

BMC Opertune and removing active logs

Hi,

We are in the process of testing BMC's Opertune to remove active logs from Db2 V12.  Is there anyone using Opertune today, to perform this function?  Have you had any problems with stand alone subsystems as well as data sharing?  Thanks for any information you can share. 

Thanks, Tom

Russell Peters

RE: BMC Opertune and removing active logs
(in response to Tom Glaser)

Hi Tom. We have BMC software and have Opertune but I've never used it and nobody here in our shop has ever used it. I'm curious what you are doing. Why are you removing active logs?

Chad Walmer

BMC Opertune and removing active logs
(in response to Tom Glaser)
We used it many years ago to manipulate the active logs while DB2 was active in order to increase the active log size and to add new ones. Worked very well for us in both stand-alone systems and data-sharing. However, that was probably under Db2 8 so hopefully you have a sandbox system you can play with before trying it out in production.

Chad Walmer

From: Tom Glaser [mailto:[login to unmask email]
Sent: Monday, June 29, 2020 11:29 AM
To: [login to unmask email]
Subject: [DB2-L] - BMC Opertune and removing active logs


Hi,

We are in the process of testing BMC's Opertune to remove active logs from Db2 V12. Is there anyone using Opertune today, to perform this function? Have you had any problems with stand alone subsystems as well as data sharing? Thanks for any information you can share.

Thanks, Tom

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

Jeff Jerry

BMC Opertune and removing active logs
(in response to Chad Walmer)
Check it out in a sandbox. We currently have an open issue with BMC as this function is not working for us.
It is one of the more useful features.

From: Chad A. Walmer <[login to unmask email]>
Sent: Tuesday, June 30, 2020 7:59 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: BMC Opertune and removing active logs

We used it many years ago to manipulate the active logs while DB2 was active in order to increase the active log size and to add new ones. Worked very well for us in both stand-alone systems and data-sharing. However, that was probably under Db2 8 so hopefully you have a sandbox system you can play with before trying it out in production.

Chad Walmer

From: Tom Glaser [mailto:[login to unmask email]
Sent: Monday, June 29, 2020 11:29 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - BMC Opertune and removing active logs


Hi,

We are in the process of testing BMC's Opertune to remove active logs from Db2 V12. Is there anyone using Opertune today, to perform this function? Have you had any problems with stand alone subsystems as well as data sharing? Thanks for any information you can share.

Thanks, Tom

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

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

Tom Glaser

RE: BMC Opertune and removing active logs
(in response to Russell Peters)

Hi Russell,

Sorry for the delay in answering your question.  We are in the process of encrypting db2 application data (IBM Pervasive encryption).  Since db2 logs contain PCI data, we need to encrypt them.  As an example, we can add 10 new logs that are defined as encrypted and when Db2 rotates the logs and starts to use the new ones, the active logs will be encrypted.  But you can't encrypt the active logs while db2 is up and there is no way to delete them; drop them from the bsds.  This is a true 7 x 24 environment.  We cannot take an outage.  We have Opertune and but never used this feature, so I was reaching out to the other companies to see about their experiences. 

Thanks, Tom