본문 바로가기

IT/각종컴퓨터팁

[DB2]트랜잭션 로그 꽉 찼을때 해결방법

728x90
반응형
db2 alter table tabname activate not logged initially with empty table
commit;
ALTER TABLE ldp.master_file_tmp ACTIVATE NOT LOGGED INITIALLY;
delete from ldp.master_file_tmp;
commit;
728x90
반응형