I see under the AIX prevention the only DB prevention policy for MySQl. Is there a best practice or template for DB2? We are trying to set up prevention for an AIX 7.2 server running IBM DB2. We have a policy in place for the OS – but want one geared toward the Data Base.
This document (7022986) is provided subject to the disclaimer at the end of this document.
SUSE Linux Enterprise Server 11 Service Pack 4 (SLES 11 SP4)
FUNCTION: DB2 UDB, database utilities, sqluBufInUse, probe:1453
MESSAGE : SQL2044N An error occurred while accessing a message queue."
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented “AS IS” WITHOUT WARRANTY OF ANY KIND.
Eventually, the Unix/Linux server was rebooted. This seemed to solve the issue. The load process greatly improved (took under 20 minutes compared to 4 hours when we were facing the issue).
Staring last week, the long load issue is back. We cant convince the Unix teams reboot the server on regular basis – they wont buy that. No one seems to know exactly what the issue is. The record count remains about the same. The data structure remain the same. No changes in the jobs design.