Fixes are available
APAR status
Closed as program error.
Error description
Environment: All platforms that TEMS supports Problem Description: Attempt to access an IB table which has an associated file, but the file for that table is not defined. The following is example of the RAS1 trace messages that will be issued when attempting to reference a table w/o the corresponding file: (4B0D457C.0001-1A:kglisopn.c,598,"I_dfopen") Unable to open data file QA1DRNKG.DB (4B0D457C.0002-1A:kglisopn.c,361,"iopen_db") Unable to open data file QA1DRNKG.DB for database QA1DRNKG (4B0D457C.0003-1A:kglkycbt.c,463,"kglky1of") iopen_db failed. errno = 10, file = QA1DRNKG (4B0D457C.0004-1A:kglkyof.c,243,"OpenKeyedFile") Open failed for QA1DRNKG , status = 5 (4B0D457C.0005-1A:kfastcsr.c,243,"KO4IB_SetupRequest") Open failed on QA1DRNKG , status = 5, reason = 28 (4B0D457C.0006-1A:kfastini.c,364,"InitiateShutdown") Issuing shutdown command (4B0D457C.0007-1A:kdsmacmd.c,1377,"ShutdownCommand") Default Shutdown requested (Warm) Detailed Recreation Procedure: Reference an IB table that has a file definition but the file for the table does not exist. In this case the QA1DNKG.* files which are associated with the TRANKGRP table. File definitions were removed but the associated TEMS table definitions were not. This is causing the shutdown problem reported here. Related Files and Output: N/A Approver: HT
Local fix
Problem summary
Submitting a query against the obsolete tables results in a shutdown of the management server "SQL error 202, 209"
Problem conclusion
The following obsolete tables have been removed from the management server: - TRANKGRP - TRANKENT - TOMCONFG - TPHOSTSS - TPLATFORM - TPROBESET The fix for this APAR is included in the following maintenance vehicle: | fix pack | 6.2.1-TIV-ITM-FP0003
Temporary fix
Queries should not be submitted against obsolete tables.
Comments
APAR Information
APAR number
IZ70401
Reported component name
TEMS
Reported component ID
5724C04MS
Reported release
621
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-16
Closed date
2010-05-14
Last modified date
2010-07-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TEMS
Fixed component ID
5724C04MS
Applicable component levels
R621 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTFXA","label":"Tivoli Monitoring"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"621"}]
Document Information
Modified date:
30 December 2022