Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable db2 log rotatation #331

Open
marde16 opened this issue Feb 5, 2024 · 1 comment
Open

Enable db2 log rotatation #331

marde16 opened this issue Feb 5, 2024 · 1 comment

Comments

@marde16
Copy link
Contributor

marde16 commented Feb 5, 2024

In the db2 tuning tasks there is a setting for db2 log rotation missing.

with_items:
- "db2set DB2_MINIMIZE_LISTPREFETCH=YES"
- "db2set DB2_SELECTIVITY=YES"
- "db2 update dbm cfg using MON_HEAP_SZ {{ __db2_instance_heap_size }}"
- "db2stop force"
- "db2start"
when:
- db2_tunings_already_applied.stat.exists == false

It must be activated for better control of the log size.

https://www.ibm.com/support/pages/db2-how-rotate-db2-diagnostic-file-db2diaglog

Please add db2 update dbm cfg using DIAGSIZE {{ __db2_instance_diag_size }} in the tuning file.

@pln-git4011
Copy link
Collaborator

Hi Martin, thank you for the feedback. Please submit a PR for this change and it will be merged into the Connections-Automation repository. Thanks again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants