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 |
|