IISReset 유틸리티는 net start/stop 명령과 비슷하지만, IIS 프로세스를 좀더 다양한 옵션으로 리셋트할 수 있는 것이 다릅니다. 물론 W3SVC, SMTPSVC, MSFTPSVC, IISAdmin 등 인터넷 서비스를 한꺼번에 다룰 수 있습니다. ( 참고 )
IISRESET.EXE (c) Microsoft Corp. 1998-1999
사용법:
iisreset [컴퓨터 이름]
/RESTART 모든 인터넷 서비스를 중지한 다음 다시 시작합니다.
/START 모든 인터넷 서비스를 시작합니다.
/STOP 인터넷 서비스를 중지합니다.
/REBOOT 컴퓨터를 다시 부팅합니다.
/REBOOTONERROR 인터넷 서비스를 시작할 때, 중지할 때 또는 다시 시작할 때,
오류가 생기면 컴퓨터를 다시 부팅합니다.
/NOFORCE 인터넷 서비스를 성공적으로 중지하지 못하는 경우,
인터넷 서비스를 강제로 종료하지 않습니다.
/TIMEOUT:val 인터넷 서비스를 성공적으로 중지하기 위해 필요한
대기 시간 제한 값(초)을 지정합니다. 이 시간 제한이
만료되면, /REBOOTONERROR 매개 변수가 지정된 경우에는
컴퓨터를 다시 부팅할 수 있습니다.
기본값은 다시 시작하는데 20초, 중지하는데 60초,
다시 부팅하는데 0초입니다.
/STATUS 모든 인터넷 서비스의 상태를 표시합니다.
/ENABLE 로컬 시스템에서 인터넷 서비스를 다시 시작할 수 있습니다.
/DISABLE 로컬 시스템에서 인터넷 서비스를 다시 시작할 수 없습니다.
Examples:
The following command will attempt to restart all running Web services and reboot the computer if the command is not successful for any reason:
IIS의 로그에서 방문한 페이지 목록을 뽑을 일이 생겼다.
중복된 페이지는 제거하고 페이지 목록만을 뽑기 위해,
아래와 같은 과정을 진행하였다.
$ awk '{print $8}' *.log |sort|uniq|grep -v ".[jpg|gif|css|js]"|grep
"user_mgmt"
결과는 아래와 같이 나왔다.
/user_mgmt/...
/user_mgmt/...
...
...
Editor's Note: This article has been updated by its author. Thank you, Pat.
Have you ever wanted to change the names of many files at once? Or, have you ever needed to use a default value for a variable that has no value? These and many other options are available to you when you use string operators in bash and other Bourne-derived shells.
String operators allow you to manipulate the contents of a variable without having to write your own shell functions to do so. They are provided through "curly brace" syntax. Any variable can be displayed as ${foo} without changing its meaning. This functionality often is used to protect a variable name from surrounding characters.
$ export foo=foo
$ echo ${foo}bar # foo exists so this works as expected
foobar
$ echo $foobar # foobar doesn't exist, so this doesn't
$
By the end of this article, you'll be able to use it for a whole lot more.
Three kinds of variable substitution are available for use: pattern matching, substitution and command substitution. I talk about the first two variables here and leave command substitution for another time.
In pattern matching, you can match from the left or from the right. The operators, along with their functions and examples, are shown below:
Operator: ${foo#t*is}
Function: deletes the shortest possible match from the left
Example:
$ export foo="this is a test"
$ echo ${foo#t*is}
is a test
$
Operator: ${foo##t*is}
Function: deletes the longest possible match from the left
Example:
$ export foo="this is a test"
$ echo ${foo##t*is}
a test
$
Operator: ${foo%t*st}
Function: deletes the shortest possible match from the right
Example:
$ export foo="this is a test"
$ echo ${foo%t*st}
this is a
$
Operator: ${foo%%t*st}
Function: deletes the longest possible match from the right
Example:
$ export foo="this is a test"
$ echo ${foo%%t*st}
$
Although the # and % identifiers may not seem obvious, they have a convenient mnemonic. The # key is on the left side of the $ key and operates from the left. The % key is on the right of the $ key and operates from the right. (This is true, at least, for US qwerty keyboards.)
The operators listed above can be used to do a variety of things. For example, the following script changes the extension of all .html files so they now are .htm files.
#!/bin/bash
# quickly convert html filenames for use on a dossy system
# only handles file extensions, not file names
for i in *.html; do
if [ -f ${i%l} ]; then
echo "${i%l} already exists"
else
mv $i ${i%l}
fi
done
Another kind of variable mangling you might want to employ is substitution. Four substitution operators are used in Bash, and they are shown below:
Operator: ${foo:-bar}
Function: If $foo exists and is not null, return $foo. If it doesn't exist or is null, return bar.
Example:
$ export foo=""
$ echo ${foo:-one}
one
$ echo $foo
$
Operator: ${foo:=bar}
Function: If $foo exists and is not null, return $foo. If it doesn't exist or is null, set $foo to bar and return bar.
Example:
$ export foo=""
$ echo ${foo:=one}
one
$ echo $foo
one
$
Operator: ${foo:+bar}
Function: If $foo exists and is not null, return bar. If it doesn't exist or is null, return a null.
Example:
$ export foo="this is a test"
$ echo ${foo:+bar}
bar
$
Operator: ${foo:?"error message"}
Function: If $foo exists and isn't null, return its value. If it doesn't exist or is null, print the error message. If no error message is given, it prints parameter null or not set. In a non-interactive shell, this aborts the current script. In an interactive shell, this simply prints the error message.
Example:
$ export foo="one"
$ for i in foo bar baz; do
> eval echo \${$i:?}
> done
one
bash: bar: parameter null or not set
bash: baz: parameter null or not set
$
The : in the above operators can be omitted. Doing so changes the behavior of the operator so that it simply tests for the existence of the variable. This, in turn, causes the creation of a variable, for example:
$ export foo="this is a test"
$ echo $bar
$ echo ${foo=bar}
this is a test
$ echo ${bar=bar}
bar
$ echo $bar
bar
$
These operators can be used in a variety of ways. A good example would be, in the case when no arguments are given, to give a default value to a variable normally read from command-line arguments. This example is demonstrated in the following script:
#!/bin/bash
export INFILE=${1-"infile"}
export OUTFILE=${2-"outfile"}
cat $INFILE > $OUTFILE
Copyright (c) 2005, 2000 by Pat Eyler. Originally published in Linux Gazette issue 57. Copyright (c) 2000, Specialized Systems Consultants, Inc. The material in this article may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later.
SET TEMPORARY OPTION Temp_Extract_Name1 ='../../../../../../../../u/users/ukira1/backup/output.smkim';
SET TEMPORARY OPTION Temp_Extract_Name2 ='';
SELECT TOP 100 * FROM dba.employee;
SET TEMPORARY OPTION Temp_Extract_Name1 = '';
이렇게 하시면 되겠다~LOAD TABLE dba.employee_2
(
컬럼1,
컬럼2,
...
)
FROM '/u/users/ukira1/backup/output.smkim'
QUOTES OFF
ESCAPES OFF
FORMAT 'ascii'
DELIMITED BY ','
ROW DELIMITED BY 'n'
total commander와 cygwin을 사용하다보면, 현재 폴더에서 cygwin을 실행하고 싶은 때가 있다.
cygwin을 실행하면 현재 폴더가 c:/cygwin/home/<user> 폴더로 옮겨지기 때문에 꽤 불편하다.
그래서 현재 폴더로 이동하게 하는 방법을 생각해봤는데..
일단, c:/cygwin/cygwin.bat를 편집한다.
SET CUR_DIR=%CD%
위 한줄을 추가해주고...
c:/cygwin/home/<user>/.bashrc
를 편집한다.
CUR_DIR=${CUR_DIR//\///} # 변수내의 문자를 /로 바꿔준다.
CUR_DIR=${CUR_DIR//"/} #변수내의 "문자를 없앤다.
CUR_DIR="/cygdrive/${CUR_DIR//:/}" #변수내의 : 문자를 없애고 맨 앞에 /cygdrive/를 붙여준다.
cd "$CUR_DIR"
select top 100 *
from 테이블명
># c:output.txt
로 하면 select 결과 뿐 아니라, 결과 메시지까지 파일에 생성된다.select top 100 *
from 테이블명
>& c:output.txt
