Error: SQL0913 - Row or Object in Use

Issue

The following DBMS error appears:

SQL0913 - Row or object <table> in <schema> type *FILE in use

Environment

Connector: High-Volume Agent Db2 for i

Resolution

To resolve this issue, identify and release any locks held on the affected table by other jobs on the IBM i system. After the lock is released, either manually trigger a sync or wait for the next scheduled sync. To learn how to view locks using system commands, see the IBM documentation on displaying lock states for objects.

Cause

This issue occurs when another job holds a lock on the table or one of its records. While the lock is active, Fivetran can't read from the table, and syncs fail.