Informix - Problem description
Problem IT06430 | Status: Closed |
ONCHECK -CC FAILS WITH ERROR: NO TABLE FOUND FOR SYSAMS RECORD | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When checking a database, oncheck -cc errors with the following messages: Validating sysams for database test ERROR: No table found for sysams record. ISAM error: no record found. Tabid 100 Secondary access method bts ERROR: No table found for sysams record. ISAM error: no record found. Tabid 101 Secondary access method bts_info The problem can happen whether or not the table(s) with BTS indices exist. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 * **************************************************************** | |
Local Fix: | |
Workarounds: 1. If BTS is no longer needed in the database, drop all BTS indices and then unregister the BTS blade from the database. 2. If BTS indices are still required, a reorg of the DB may be needed in order to create and maintain two tables with the same tabid as the am_id for the bts* access methods in the sysams table. | |
Solution | |
Problem Fixed In IBM Informix Server 12.10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.01.2015 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.0 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |