sql error 7008

[DaleJanus]

we are journaling a file.

we get this error:

delete from lsifiles.lsitsmord;

produces error:
SQL State: 55019
Vendor Code: -7008
Message: [SQL7008] LSITSMORD in LSIFILES not valid for operation. Cause . . . . . : The reason code is 3.
3 -- LSITSMORD not journaled, no authority to the journal, or the journal state is *STANDBY. Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal.

the journals and receivers are not in library LSILIB, but inQGPL.

It seems the problem could be with commit.

any suggestions?

[andreas.prouza]

The location of the journal and receivers doesn't matter.
Have you checked the error message?
Are you working with commitment control but the file is not journaled?
Are there any foreign keys depending on that file?

[B.Hauser]

You are running your job under commitment Control, but your table is not registered in a journal.
So, your delete can neither be rolled back nor commited and you get this error.
You either have to register your table in a journal or you have to add WITH NC (=with no commit) at the end of your delete statement to run the delete without commitment control.