echo "실행쿼리 보기 : db2 get snapshot for dynamic sql on pfmutf8 > temp.out "
echo "lock 보기 : db2 list applications for database pfmutf8 show detail "
echo "lock 풀기 : db2 force application all "
echo "lock 보자 : db2 get snapshot for locks on pfmutf8 > locks.out"
echo "db2pd -db pfmutf8 -locks showlocks wait"
echo "db2pd -db pfmutf8 -transaction tran=57"
echo "db2pd -db pfmutf8 -applications application=119"
echo "db2pd -db pfmutf8 -dyn"
echo "db2 get snapshot for application agentid 3788"
'DB' 카테고리의 다른 글
| PL/SQL 기본 (0) | 2010.07.30 |
|---|---|
| AUDIT - 감사 (0) | 2010.07.30 |
| SQL99 - Insert All, MERGE, IS NAN, INTERVAL (0) | 2010.07.30 |
| Index-Organized Table(IOT), Partitioned Table & Index (0) | 2010.07.30 |
| Oracle Character set 변경 (3) | 2009.02.12 |
| Oracle 실행된 쿼리 보기 (0) | 2009.02.12 |
| Oracle Version 확인 (0) | 2009.02.12 |
| user/tablespace sql & export/import (0) | 2009.02.12 |