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 ONLY
497800cookie-checkiSeries: File in use / Locking (AS400)