|
Problem IC64762
|
Status: Closed |
IN TASK CENTER,'SCHEDULE ENABLED' COLUMN CHANGES TO 'NO' WHEN A NON-TASK OWNER TRIES TO DIABLE TASK AFTER RECEIVING 'SQL22287N' |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In task center, 'SCHEDULE ENABLED' column changes to 'NO' when a
non-task owner tries to disable the task after receiving error
'SQL22287N' as expected.
When a non-task owner tries to disable a task as expected they
receive a 'SQL22287N : User <userid> does not have permission to
execute Task <taskid.suffix>' and the task is not disabled as
per design. But the descrepency from the ideal behaviour is that
the 'SCHEDULE ENABLED' column for that task in Taskcenter
changes to 'NO' |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* In task center, 'SCHEDULE ENABLED' column changes to 'NO' *
* when a *
* non-task owner tries to disable the task after receiving *
* error *
* 'SQL22287N' as expected. *
* *
* *
* *
* When a non-task owner tries to disable a task as expected *
* they *
* receive a 'SQL22287N : User <userid> does not have *
* permission to *
* execute Task <taskid.suffix>' and the task is not disabled *
* as *
* per design. But the descrepency from the ideal behaviour is *
* that *
* the 'SCHEDULE ENABLED' column for that task in Taskcenter *
* *
* changes to 'NO' *
****************************************************************
* RECOMMENDATION: *
* Upgrade to ESE DB2 V97 FIXPACK 1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 |
DB2 V97 FIX PACK 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.11.2009
08.03.2010
08.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
