Table 11 discusses backup
scenarios for different table types. For more information about
the table types, see the chapter on data storage in the IBM Informix: Administrator's Guide.
Table 11. Backing Up Table Types
Table Type
IDS
XPS
Can You Back Up This Type of Table?
Standard
X
X
Yes.
Temp
X
X
No.
Scratch
X
No.
Operational
X
Yes.
If you use pload express mode to load an operational
table, you cannot reliably restore the data unless you have done
a level-0 backup after the load. It is not enough to just back up
the logical logs.
Raw
X
X
Yes. If you update a raw table, you cannot reliably
restore the data unless you perform a level-0 backup after the update.
Backing up only the logical logs is not enough.
Static
X
Yes.
Important:
Perform
a level-0 backup before you alter a raw, static, or operational
table to type STANDARD.