APAR status
Closed as program error.
Error description
When the schema name is prepended to the table name for the
Scheduler table, the following error is thrown:
[4/25/05 16:15:00:927 MST] 6fa0ed86 SchedulerImpl E SCHD0046E:
The table JCH.JCHTESTTREG in datasource jdbc/scheddb1 used by
scheduler resource Scheduler (sched/jchtest) is missing or is
not accessible.
Using just the table name doesn't cause the problem.
Local fix
Use just the table name without the schema name:
i.e. use SCHTEST not SCH.SCHTEST
Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server users *
* of Scheduler. *
****************************************************************
* PROBLEM DESCRIPTION: Users may see SCHD0046E: The table *
* XXX.YYYYTREG in datasource *
* jdbc/scheddb1 used by scheduler *
* resource Scheduler (sched/jchtest) *
* is missing or is not accessible. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
When the schema name is prepended to the table name for the
Scheduler table, the following error is thrown:
[4/25/05 16:15:00:927 MST] 6fa0ed86 SchedulerImpl E SCHD0046E:
The table XXX.YYYTREG in datasource jdbc/scheddb1 used by
scheduler resource Scheduler (sched/jchtest) is missing or is
not accessible.
Problem conclusion
We added support for XXX.YYY.TTTT format for table names where
XXX=Catalog, YYY=Schema, and TTTT=tablename in the table prefix.
Temporary fix Comments
APAR information |
APAR number |
PK05162 |
Reported component name |
WAS ENTERPRISE |
Reported component ID |
5630A3700 |
Reported release |
00I |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2005-05-02 |
Closed date |
2005-06-17 |
Last modified date |
2005-06-17 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
|
Fix information |
Fixed component name |
WAS ENTERPRISE |
Fixed component ID |
5630A3700 |
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|