아래 명령어를 실행했습니다.
시스템은 Solaris 입니다.
물런 no logging mode로 변경하기 위해서이지요.
왜 변경할려고 했냐면 ...
File로 DATA를 받아 왔는데 ...
load from으로 하니까 .. transaction 에러가 발생하더라구요.
그래서 게시판을 뒤지다 보니 ... no logging mode로 하면 된다길래.
시도 하였으나 ... 아래와 같은 에러만 뜹니다 ㅠ.ㅠ
[실행 명령어 및 결과]
www:/informix/data/hsdata> ontape -s -N hs_sale
Error changing logging status - 'hs_sale'. iserrno 107.
Program over.
그리고 107 에러를 찾아봤다니 아래와 같습니다.
www:/informix>finderr 107
-107 ISAM error: record is locked.
Another user request has locked the record that you requested or the
file (table) that contains it. This condition is normally transient. A
program can recover by rolling back the current transaction, waiting a
short time, and re-executing the operation. For interactive SQL, redo
the operation. For C-ISAM programs, review the program logic and make
sure that it can handle this case, which is a normal event in
multiprogramming systems. You can obtain exclusive access to a table by
passing the ISEXCLLOCK flag to isopen. For SQL programs, review the
program logic and make sure that it can handle this case, which is a
normal event in multiprogramming systems. The simplest way to handle
this error is to use the statement SET LOCK MODE TO WAIT. For bulk
updates, see the LOCK TABLE statement and the EXCLUSIVE clause of the
DATABASE statement.
어떻게 풀어야 하나요 ?
저에게 구원에 손길을 부탁드립니다.
감사합니다.
|