Informix - Problem description
Problem IT31174 | Status: Closed |
The onstat -l command does not show whether a log has been included or is in the process of being included in an archive. | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The onstat -l command shows the following flag details ... Position 0: U: log file in use ¦ or ... A: newly added log ¦ or ¦ F: Log file free Position 2: B: log file has been backed up Position 4: C: log file current Position 6: L: last checkpoint in logical log address number flags uniqid begin size used %used 700000020501f88 1 U---C-L 25 1:6513 2000 1996 99.80 70000002031ef68 2 U-B---- 18 1:8513 2000 2000 100.00 It would be useful if we could also show if a logical log is included on a archive or in the process of being included in an archive. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. The 'R' and 'X' flags were added in the second position to indicate whether a log file has been archived, or is in the process of being archived, respectively. The term "archived" refers to a level 0 archive, not a log backup, which is denoted with the B flag in the third position. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.12.2019 27.02.2020 27.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |