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'
SELECT
OBJECT_SCHEMA,
OBJECT_NAME,
MEMBER_LOCK_TYPE,
LOCK_STATE,
LOCK_STATUS,
LOCK_SCOPE,
JOB_NAME,
LOCK_COUNT,
PROGRAM_LIBRARY_NAME,
PROGRAM_NAME,
MODULE_LIBRARY_NAME,
MODULE_NAME,
PROCEDURE_NAME
FROM
QSYS2.OBJECT_LOCK_INFO
WHERE
OBJECT_NAME = 'MY_TABLE'
AND OBJECT_SCHEMA = 'MY_SCHEMA'
ORDER BY JOB_NAME
FETCH FIRST
100 ROWS ONLY497800cookie-checkiSeries: File in use / Locking (AS400)