iSeries: File in use / Locking (AS400)

Date: 2021-04-20
SQL0913 - Row or object GSPCARTT in PDBPRODLIB type *FILE in use.

=> Scheduled task for DATA synchronisation was queued / locking the table
SELECT
    OBJECT_SCHEMA,
    OBJECT_NAME,
    OBJECT_TYPE,
    MEMBER_LOCK_TYPE,
    LOCK_STATE,
    LOCK_SCOPE,
    JOB_NAME,
    SUBSTR(JOB_NAME, 8, LOCATE_IN_STRING(JOB_NAME, '/', 8) -8) AS "User",
    L.*
FROM
    QSYS2.OBJECT_LOCK_INFO L
WHERE
    OBJECT_SCHEMA = CURRENT_SCHEMA
    AND OBJECT_NAME = 'GSPCARTT'
    AND OBJECT_TYPE = '*FILE'
49780cookie-checkiSeries: File in use / Locking (AS400)