IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

Make logprimary and logfilsiz online configurable

If workload increases on system, it might be necessary to adjust (typically increase) the available active log space. System downtime is not acceptable in our days. It is sufficient if the log files get resized before re-use and the amount of log files adjust on next log file reclaim. Nevertheless the available disk space should be checked when the config change request gets performed.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 3 2019
  • Delivered
Idea Priority Medium
Customer Name IBM
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    5 May 09:05pm

    Hi Michael,
    good that we have increased the upper limit to 4096 now. this should help!

    But, I still see a need, for this.. specially for LOGFILSZ.

    Most of dbs out there are deployed using standard values.. New APP, new DB, nobody know what will be the transaction volume.. You need to tune that , later..
    So, just allowing us to increase LOGSECOND to a big value (more than 255 now) , helps, but its not enough to fully and best tune them...
    Keeping logfile sizes smaller can bring issues, like too much archive logs being generated, etc.. so increasing the logfile size is needed..

    Or vice-versa..
    shared db hosting several different applications, but few of them changed or has been decommissioned, and the workload has decreased.. no need to keep huge, big transaction logs anymore.. so a need to reduce the logfilesize is again required..

  • Admin
    Michael Roecken commented
    5 May 08:48pm

    Although we have not made LOGPRIAMRY nor LOGFILSIZ online configurable in 11.5.0.0 we have increased LOGPRIMARY and LOGSECOND to 4096 each. So a dynamic LOGSECOND update can be done to address this immediate concern.

    Also, a tech preview in 11.5.0.0 and pending support coming soon, Advanced Log Space Management (https://www.ibm.com/support/pages/db2-version-115-advanced-log-space-management-tech-preview) will address transaction log full problems for OLTP type workloads.

    We would like customers to try these two new features and then provide feedback if there is still a need for both LOGPRIMARY and LOGFILSIZ to become online configurable.

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions