Informix Error -43017: A Point in Log restore is permitted only during a Full restore.

Reasons / Common Causes

-43017 fires when a point-in-log restore is attempted while the database server is online — per the official guidance.

1. A point-in-log restore attempted while the server is online, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Do a cold restore instead, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond attempting a point-in-log restore while online.

Diagnostic Checks

1. Check whether the server is online, and perform a cold restore for a point-in-log restore.

Related Errors / Related Topics

• -43016 — "Invalid Point In Time value specified: ." A related point-in-time restore error, on an invalid value rather than an online-server restriction.
• -43018 — "A point-in-time restore is permitted only during a full restore." A related restriction, on requiring all spaces to be restored rather than an offline server.

A point-in-log restore was attempted online — perform a cold restore instead.