퍼옴 http://blog.naver.com/steel_cat?Redirect=Log&logNo=40097687769
1. DataStage Director 로그인하기
2. JOB -> Cleanup Resource 클릭
3. Locks 확인 후 프로세스ID 확인
4. 유닉스 서버 접속
5. cd /app/dshome/Ascential/DataStage/DSEngine
6. . ./dsenv
7. bin/uvsh
8. LOGTO KRIC (KRIC는 프로젝트명입니다.)
9. DS.TOOLS
10. 4. Administer processes/locks >> 선택
11. 4. List all locks 선택하여 Lock확인
12. 7. Clear locks held by a process 선택한후 Enter pid#= 에 lock잡힌 프로세스ID 입력후 Y입력
13. 11번을 다시선택하여 Lock확인
14. 엔터 치고 난후 Q로 빠져나온다.
15. ps -ef | grep ds 와 netstat -1 | grep ds, ps -ef |grep phantom 등으로 확인.
16. exit
******************* 아래 *******************
주) 입력하는 부분을 굵게 붉은 색으로 처리 했으며 sql과 동일한 주석기호를 사용하였습니다.
Last login: Fri May 15 14:37:46 2009 from 192.168.154.32
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.
RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.
Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.
Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
You have mail.
dsadm@dev_db:/home/dsadm> cd /app/dshome/Ascential/DataStage/DSEngine
dsadm@dev_db:/app/dshome/Ascential/DataStage/DSEngine> . ./dsenv
dsadm@dev_db:/app/dshome/Ascential/DataStage/DSEngine> bin/uvsh
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: 금요일, 5월 15, 2009 15:08
>LOGTO KRIC
>DS.TOOLS
DataStage Tools Menu
1. Report on project licenses
2. Rebuild Repository indices
3. Set up server-side tracing >>
4. Administer processes/locks >>
5. Adjust job tunable properties
Which would you like? ( 1 - 5 ) ?4
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?4
==========================Locks held by all processes==========================
Active Group Locks: Record Group Group Group
Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX
1073741828 256274 0 11 12 IN 800 1 0 0 0
1073741828 288897 0 58292 43 IN 800 4 0 0 0
Press any key to return to the menu... 4 IN 7000 1 0 0 0
1073741828 294401 0 59513 88 IN C800 1 0 0 0
Active Record Locks:
Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID.............
1073741828 256274 0 42637 12 RL 22899 dsadm KRIC&!DS.ADMIN!&
1073741828 256274 0 59768 12 RL 5768 dsadm KRIC&!DS.ADMIN!&
1073741828 256274 0 59513 12 RL 6023 dsadm KRIC&!DS.ADMIN!&
1073741828 256274 0 58292 12 RL 7244 dsadm KRIC&!DS.ADMIN!&
1073741828 288897 0 42637 43 RU 22899 dsadm 15A98CB4-62F8-4676-A4F8-00AEE7554864-ONSAEMIRO_NOTE:22899
1073741828 288897 0 59768 43 RU 5768 dsadm 735C53E7-3AD1-4169-A540-58EBF86E68CF-ONSAEMIR-D4E634:5768
1073741828 288897 0 59513 43 RU 6023 dsadm 15A98CB4-62F8-4676-A4F8-00AEE7554864-ONSAEMIRO_NOTE:6023
1073741828 288897 0 58292 43 RU 7244 dsadm 735C53E7-3AD1-4169-A540-58EBF86E68CF-ONSAEMIR-D4E634:7244
1073741828 294401 0 58292 64 RU 7244 dsadm OSSPL_DW_TOPOPLMOVSTS
1073741828 294401 0 42637 88 RU 22899 dsadm DFN_DW_TFTRPTIMPTTPRT -- 이넘이 lock 걸린넘 프로그램ID가 나타남
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?7
Enter pid#=22899
OK to clear locks held by process 22899? (N):Y
================Clearing locks for process 22899 (user# 42637)================
Clearing Record locks.
Clearing GROUP locks.
Press any key to return to the menu...
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?4
==========================Locks held by all processes==========================
Active Group Locks: Record Group Group Group
Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX
1073741828 256274 0 57953 12 IN 800 1 0 0 0
1073741828 294544 0 11 24 IN 7800 1 0 0 0
Press any key to return to the menu... 3 IN 800 2 0 0 0
Active Record Locks:
Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID.............
1073741828 256274 0 59768 12 RL 5768 dsadm KRIC&!DS.ADMIN!&
1073741828 256274 0 59513 12 RL 6023 dsadm KRIC&!DS.ADMIN!&
1073741828 256274 0 58012 12 RL 7524 dsadm KRIC&!DS.ADMIN!&
1073741828 294544 0 58012 24 RL 7524 dsadm RT_CONFIG645
1073741828 288897 0 59768 43 RU 5768 dsadm 735C53E7-3AD1-4169-A540-58EBF86E68CF-ONSAEMIR-D4E634:5768
1073741828 288897 0 59513 43 RU 6023 dsadm 15A98CB4-62F8-4676-A4F8-00AEE7554864-ONSAEMIRO_NOTE:6023
-- lock 없어진것 확인
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?Q
Press any key to return to the menu...
DataStage Tools Menu
1. Report on project licenses
2. Rebuild Repository indices
3. Set up server-side tracing >>
4. Administer processes/locks >>
5. Adjust job tunable properties
Which would you like? ( 1 - 5 ) ?
>Q
dsadm@dev_db:/app/dshome/Ascential/DataStage/DSEngine>
dsadm@dev_db:/app/dshome/Ascential/DataStage/DSEngine> exit
logout
[출처] Lock 걸린 JOB 죽이는 방법 |작성자 강철고양이
'wif LiNoUz > DATASTAGE' 카테고리의 다른 글
| 작업 스케줄러 routine 매 5분 마다 1번씩! (0) | 2013.01.14 |
|---|---|
| DATSTAGE SPECIFIC (0) | 2012.12.13 |
| ODS에서 엔터값 잘못 맥인것 (0) | 2012.11.14 |
| Informatica Client기본설정 연습 (0) | 2012.10.11 |
| Datastage 에러 내역 (0) | 2012.09.10 |
