- 论坛徽章:
- 1
|
如下是a.sh
echo "*********************************"
echo "# uname -a"
uname -a
echo "*********************************"
echo "su db2inst1"
su - db2inst1 <<EOF
echo "*********************************"
echo "$ db2 list db directory"
db2 list db directory | grep 'Database name'
echo "*********************************"
for DBN in `db2 list db directory | awk '/Database name/{print $NF}'`
do
echo "$ db2 connect to " $DBN
db2 connect to $DBN
echo "*********************************"
echo "$ db2 \"SELECT BPNAME, NPAGES, PAGESIZE FROM SYSCAT.BUFFERPOOLS\""
db2 "SELECT BPNAME, NPAGES , PAGESIZE FROM SYSCAT.BUFFERPOOLS"
echo "*********************************"
done
EOF
如下中sh -x a.sh的结果
$ sh -x a.sh
+ echo *********************************
*********************************
+ echo # uname -a
# uname -a
+ uname -a
AIX DEP23 1 6 00CAD6564C00
+ echo *********************************
*********************************
+ echo su db2inst1
su db2inst1
+ su - db2inst1
+ 0<<
echo "*********************************"
echo "$ db2 list db directory"
db2 list db directory | grep 'Database name'
echo "*********************************"
for DBN in + db2 list db directory
+ db2 list db directory
+ awk /Database name/{print $NF}
+ awk /Database name/{print $NF}
GBATCH
GBATCH
CARDP
do
echo "$ db2 connect to "
db2 connect to
echo "*********************************"
echo "$ db2 "SELECT BPNAME, NPAGES, PAGESIZE FROM SYSCAT.BUFFERPOOLS""
db2 "SELECT BPNAME, NPAGES , PAGESIZE FROM SYSCAT.BUFFERPOOLS"
echo "*********************************"
done
db2inst1's Password:
*********************************
$ db2 list db directory
Database name = GBATCH
Database name = GBATCH
Database name = CARDP
*********************************
ksh[5]: 0403-057 Syntax error at line 7 : `GBATCH' is not expected. |
|