You probably need to set your SQL not to use commitment control.
On 12/6/2012 4:32 PM, Stone, Joel wrote:
I am receiving the following error when running an SQL stmt.
Does the file need to be journalled?
Additional Message Information
Message ID . . . . . . : SQL7008
Date sent . . . . . . : 12/12/06 Time sent . . . . . . : 16:30:25
Message . . . . : MISCCHG2 in QTEMP not valid for operation.
Cause . . . . . : The reason code is 3. Reason codes are:
1 -- MISCCHG2 has no members.
2 -- MISCCHG2 has been saved with storage free.
3 -- MISCCHG2 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.
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com