|
Problem IC66708
|
Status: Closed |
SYSPROC.AUTOMAINT_GET_POLICY AND CC INCONSITENT REGARDING "INCLUDE LAST DAY OF MONTH" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If setting "Include last day of month" with Control Center
AUTOMAINT_GET_POLICY returns "-31" in <DaysOfMonth>
According to DB2MaintenanceWindowPolicySample.xml from
samples/automaintcfg the last day of month should be returned as
"-1".
Same behavior seen also on DB2 9.7.
****************
In version 9.7, this APAR also addresses the issue of SQL1131N
returned from sysproc.automaint_set_policyfile procedure. User
will see following entries in the db2diag.log:
2010-04-23-10.38.35.023645-240 I2484A1095 LEVEL: Severe
PID : XXXXXX TID : XXXX PROC : db2fmp (C) 0
INSTANCE: XXXXXX NODE : 000
EDUID : 1029 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10
DATA #1 : String, 158 bytes
NON-FATAL ASSERTION FAILED!!!
ASSERTION EXPRESSION: Invalid block eye-catcher (0xEBE1FFF8)
found at:
SOURCE FILENAME: sqlpiPolicyValidate.C
LINE NUMBER: 1589
CALLSTCK:
[0] 0x090000001445E2E0 pdLog + 0xA8
[1] 0x0900000014423A28 sqlzAssertFailedValist + 0x1B0
[2] 0x0900000013E21A78 ossAssertFailureAction + 0x138
[3] 0x0900000013E430D8 _ossMemAllocCheck + 0x718
[4] 0x0900000013E431B8 _ossMemFree + 0x58
[5] 0x09000000092F417C
sqlpiValidateAutomaintPolicy__FPcN21P5sqlca + 0
[6] 0x09000000092E7AF4
sqlpiAutomaintSetPolicySpCommon__FPcT1P13sqludf
[7] 0x09000000092E9094 db2AutomaintSetPolicyFileSpLocal +
0x774
[8] 0x0900000014C633AC sqloInvokeFnArgs + 0x54
[9] 0x0900000014C6325C
@76@sqlerRunRoutine__FP13sqleInvokerCBPi +0x154 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* autmaint_get_policy stored procedure *
****************************************************************
* PROBLEM DESCRIPTION: *
* SYSPROC.AUTOMAINT_GET_POLICY AND CC INCONSITENT REGARDING *
* "INCLUDE LAST DAY OF MONTH" *
****************************************************************
* RECOMMENDATION: *
* install fixpack v97fp2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
After the code fix, the CC and AUTOMAINT_GET_POLICY are
consistent with each other. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.02.2010
05.04.2010
04.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
