데이터베이스17 LOG파일 확인 및 제거 [Current Log File Number] db2 list history backup all for db [DB명] [DB2 Log File 확인] db2 get db cfg for [DB명] | grep -i log Number of primary log files (LOGPRIMARY) = 3 Number of secondary log files (LOGSECOND) = 2 Path to log files = /home/db2jih/db2jih/NODE0000/SQL00003/SQLOGDIR/ primary log files + secondary log files 수를 제외하고 제거 2013. 7. 30. DB2 관련 명령어 [DB2 Version 확인] db2level -s [Sample DB 생성] db2sampl -xml -sql -name [DB명] [DB2 시작] db2start [DB2 종료] db2stop [조회 관련] db2ilist //DB2 Instance 조회 db2 get instance //현재 사용중인 Instance 확인 db2 list db directory //DB 목록 조회 [DB 접속] db2 connect to [DB명] [DB2 Session 확인] db2 list applications [DB2 Session Kill] db2 "force applications all" db2 "force application (30)" 2013. 7. 25. TKPROF 사용하기 setting.sql set linesize 1000 set pagesize 1000 set timing on alter session set "_rowsource_execution_statistics"=true; alter session set timed_statistics=true; alter session set max_dump_file_size=unlimited; alter session set tracefile_identifier='memoryvirus'; alter session set events '10046 trace name context forever, level 12'; query.sql 쿼리 tkprof.sh tkprof $1.trc $1.prf sys=no explain=syste.. 2013. 5. 14. 컬럼 변경 ============================================================ CREATE TABLE [dbo].[Table_1]( [col1] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL, [col2] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL, [col3] [varchar](32) COLLATE Korean_Wansung_CI_AS NULL, ) ON [PRIMARY] ============================================================ [컬럼 추가] ALTER TABLE [dbo].[Table_1] ADD [col4] [varchar](50) CO.. 2013. 3. 6. 이전 1 2 3 4 5 다음