PSTATE

$system.zgcsc

TACL>run pstate [pid]

원본 위치 : http://www.asyste.com/utilities.html

NONSTOP TCP/IP TELNET 테스트

1)TCP/IP DEFINE 정의
ADD DEFINE =TCPIP^PROCESS^NAME     ,FILE  $ZB01B

2)상대측 서버로 TELNET 접속 수행
TELNET IP명 포트명

NONSTOP Debugging

1)파일코드 100일 경우
rund 100파일명

2)INSPECT

TSM ALARM

1)알람메세지 내용확인
run RDALARM ZZAL0069


2)장애조취


3)TSM 알람은 super 권한으로 로그인 후 삭제 함
1-SCF> Abort process $zzkrn.#tsm-srm

2-TACL> Rename $system.zservice.persist, $system.zservice.persold
3-SCF> Start process $zzkrn.#tsm-srm


[참고]saveabend 를 on 하기 위한 절차
1. tacl>scf abort process $zzkrn.#tsm-srm
*** TACL> Rename $system.zservice.persist, $system.zservice.persold --->아래내용 참조
2. tacl> NLD -change saveabend on $SYSTEM.SYS.SRM
3. tacl>noft
noft>file $system.sysnn.srm
noft>la
......
Highpin : Yes
Saveabend : Yes <------ 확인
Priv or Callable : No
.........
noft> exit
4. tacl> scf start process $zzkrn.#tsm-srm

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)

LOCATE Command

locate /cpu 3,pr 5/ +E +Q 찾을구문(문장,단어) 찾고자하는 볼륨/서브볼륨

+E 에디터파일만(101)
+Q 찾은 구문만 화면에 출력

EMS 관련 명령어

1)emscinfo
TACL> emscinfo


EMSCINFO - T9631G06 - (20JAN01)
Collector = $0, Priority = 201
Primary CPU = 1, Backup CPU = 0
Disk Logging Active
Current Log File = $SYSTEM.ZLOG01.ZZEV0119
Current Record = 0200.060006
Default Log File = $SYSTEM.ZLOG01.ZZEV0119
Primary Extent = 500, Secondary Extent = 500
ROTATEFILES = ON, MAXFILE = 20
REFRESH = ON, BUFFERED = ON
SECURITY = AOOO, BLOCKING = ON
Events Received = 4988433, Events Logged = 4988653
Events Discarded = 17
OPENS Received = 8523, CLOSES Received = 8517
FILE Switches = 118, Unrcv Disk Errors = 0
Invalid Events = 17, Buffer Failures = 0
SUPPRESS = OFF, FILTER = OFF
Current event bursts = 0
Compatibility Distributor ($Z0)
Printing Mode = CRITICAL-ONLY
Primary CPU = 0, Backup CPU = 1
Console Name = $YMIOP.#CNSL
Console Error Code = 140
Default Console Name = $YMIOP.#CNSL


[TIP]PAK 하는 방법
pak imsi,zzsv0075,listall,open
pak imsi,$SYSTEM.ZLOG01.ZZEV0119,listall,open

2) 한글을 보고 싶을때

SET
Sets the specified parameter to a new value.
Enter 'HELP PARAMETERS for information on parameters
that you may alter.
* SET CONVERT UNPRINTABLES: OFF
로그중 한글이 깨져 보일때는 (?????? 표시) 위의 명령을 수행
SHOW * 로 현재의 EMSPERUS 상태를 알수 있음.

TMFCOM 주요명령어

1.Audit dump 확인
info dumps, type auditdump, sort byserial


2.Online dump 확인
info dumps, type onlinedump, serial 85


3.Audit trail 파일 확인
status audittrail, detail


4.Transaction 처리 상황 확인
status transaction


5.ALTER TAPEMEDIA Command
Changes the configured attribute values of tape volumes.Security: super user group member.
ALTER TAPEMEDIA TMF330,STATUS ASSIGNED
ALTER TAPEMEDIA TMF330,STATUS BAD
ALTER TAPEMEDIA TMF330,STATUS RELEASED
ALTER TAPEMEDIA TMF330,STATUS SCRATCH


6.INFO TAPELABEL Command
info tapelabel ,tapedrive $t0150 ,unload off


7.bad난 tapemedia delete 후 초기화 작업

DELETE TAPEMEDIA TMF019
DELETE TAPEMEDIA TMF032
DELETE TAPEMEDIA TMF042
DELETE TAPEMEDIA TMF061
DELETE TAPEMEDIA TMF062
DELETE TAPEMEDIA TMF064
DELETE TAPEMEDIA TMF072
DELETE TAPEMEDIA TMF091
DELETE TAPEMEDIA TMF225
DELETE TAPEMEDIA TMF241
DELETE TAPEMEDIA TMF249
DELETE TAPEMEDIA TMF255
DELETE TAPEMEDIA TMF285

ADD TAPEMEDIA (TMF019, TMF032, TMF042, TMF061, TMF062, TMF064), &
LABEL ON!, DRIVE $T0150

ADD TAPEMEDIA (TMF072, TMF091, TMF225, TMF241, TMF249, TMF255), &
LABEL ON!, DRIVE $T0150

ADD TAPEMEDIA (TMF285, TMF331, TMF332, TMF333, TMF334, TMF335), &
LABEL ON!, DRIVE $T0150

MEDIACOM 주요명령어

STATUS TAPEDRIVE,DETAIL 

DAP 자격증 관련 교재 LIST

[기본 교재]
1.데이터아키텍처 전문가 가이드 2010 Edition
2.데이터아키텍처 전문가 자격검정시험대비 실전문제 362
3.5장 : 데이터 아키텍처 솔루션 1/이화식/엔코아컨설팅(강추)
4.6장 : 오라클 성능 고도화 원리와 해법 I,II/조시형/(주)비투엔컨설팅

[추가 교재]

1.대용량 데이터베이스솔루션 I,II / 새로 쓴 대용량데이터베이스솔루션 1

[동영상 강의]
1.실전데이터 모델링 동영상 강의(이화식)
2.대용량데이터베이스 동영상 강의(조광원)