|
Problem IT38669
|
Status: Closed |
MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
The MON_GET_AUTO_MAINT_QUEUE table function returns information
about all automatic maintenance jobs that are currently queued
for execution by the autonomic computing daemon (db2acd).
Execution of this table function may fail in rare scenarios
because an automatic maintenance job in the queue was
inadvertently created with an invalid time related value. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Local Fix: |
Deactivating and reactivating the database will reinitialize the
automatic maintenance job queue, however the problem may occur
again, so consider upgrading to a fixpack inclusive of this APAR
fix. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.10.2021
21.11.2021
21.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
