SQL/MP 관련 명령어

1.통계정보 갱신
SQLCIMAC / CPU 해당볼륨CPU, PRI 5/
UPDATE ALL STATISTICS FOR TABLE 테이블명 NO RECOMPILE PROBABILISTIC;

질문)UPDATE STATISTICS 는 수행 주체???2.병렬처리
CONTROL EXECUTOR PARALLEL EXECUTION ON
OUT_REPORT IMSI;
SELECT문


3.테이블 LOAD
1)실행 OBEY 구성
TACL> TYPE STARTOBY
SQLCIMAC /IN IN1,OUT OIN1,NOWAIT,CPU 0,PRI 5/
SQLCIMAC /IN IN2,OUT OIN2,NOWAIT,CPU 1,PRI 5/
SQLCIMAC /IN IN3,OUT OIN3,NOWAIT,CPU 2,PRI 5/
SQLCIMAC /IN IN4,OUT OIN4,NOWAIT,CPU 3,PRI 5/
SQLCIMAC /IN IN5,OUT OIN5,NOWAIT,CPU 0,PRI 5/
SQLCIMAC /IN IN6,OUT OIN6,NOWAIT,CPU 1,PRI 5/
SQLCIMAC /IN IN7,OUT OIN7,NOWAIT,CPU 2,PRI 5/
SQLCIMAC /IN IN8,OUT OIN8,NOWAIT,CPU 3,PRI 5/
SQLCIMAC /IN IN9,OUT OIN9,NOWAIT,CPU 0,PRI 5/
SQLCIMAC /IN IN10,OUT OIN10,NOWAIT,CPU 0,PRI 5/
SQLCIMAC /IN IN11,OUT OIN11,NOWAIT,CPU 1,PRI 5/
SQLCIMAC /IN IN12,OUT OIN12,NOWAIT,CPU 2,PRI 5/
SQLCIMAC /IN IN13,OUT OIN13,NOWAIT,CPU 3,PRI 5/
SQLCIMAC /IN IN14,OUT OIN14,NOWAIT,CPU 2,PRI 5/
2) 각 IN FILE 구성
TACL> TYPE IN1
LOAD $DATA01.LPRODDAT.TBAUTH , $DATA08.ZTESTDAT.TBAUTH, SHARE,SORTED,SLACK 5,PARTONLY;
3)OBEY 수행
TACL>START STARTOBY

4)REPORTING
sqlci
out_report outfile;
set style headings off;
set layout page_length all;
select 명령어


5)validity 관련 내용
=>추후 작성 요망 (similarity check)