728x90

목록database (62)

DBILITY

oracle ORA-01591: lock held by in-doubt distributed transaction

[Error] Execution (1: 12): ORA-01591: lock held by in-doubt distributed transaction 4.22.20358 이러한 경우는 XA Transaction중 비정상적인 상황에서 commit 또는 rollback이 이루어지지 않아 발생한다. select * from DBA_2PC_PENDING 확인하고, 커밋 및 롤백은 공식메뉴얼을 참고하세요.
database/oracle 2016. 9. 26. 22:07
microsoft SQLServer XA설정시 Recovery권한 설정

sqlserver의 Binn에 sqljdbc_xa.dll 복사하고,xa_install.sql 실행 https://msdn.microsoft.com/en-us/library/aa342335.aspx
database/mssql 2016. 9. 23. 22:06
CCSID (Coded Character Set IDentifiers)

https://www-01.ibm.com/software/globalization/ccsid/ccsid_registered.html CCSID(decimal) CCSID(hex) Name 833 0341 KOREAN EBCDIC 933 03A5 KOREAN MIX EBCDIC 0418에러 중 한글조회가 안 될 경우 입력파라메터의 CCSID를 바꿔보세요.예) CAST ( ? AS VARCHAR(20) CCSID 933 )
database/db2 for iseries 2016. 9. 18. 21:01
Methods for Loading Tables

http://docs.oracle.com/cd/E18283_01/server.112/e17120/tables004.htm
database/oracle 2016. 9. 7. 22:35
oracle insert into시 subquery factoring 사용 가능

INSERT INTO TARGET_T WITH X AS ( SELECT~ ) SELECT COLS~ FROM SOURCE_T,X
database/oracle 2016. 9. 7. 20:04
Prev 1 ··· 8 9 10 11 12 13 Next
728x90