|
|
- @echo off
- setlocal EnableDelayedExpansion
- for /f %%d in ('db2 list db directory ^| awk "{a[NR]=$0}END{for (j=1;j<=NR;j++) if (a[j]~/间接/) print a[j-4]}" ^| awk "{print $3}"') do (
- db2 connect to %%d >D:\monitor\frult.txt
- for /f %%a in ('type D:\monitor\frult.txt ^| grep "本地数据库别名" ^| grep %%d ^| wc -l') do (set among=%%a)
- if !among! equ 1 (
- @echo @@d
- @echo === Inf:DB ===
- @echo === 成功连接到 %%d 数据库 [[[
- @echo =================================&@echo.
- @echo do my work
- @echo === Inf:DB ==="
- @echo === 断开 %%d 数据库连接 ]]]
- @db2 connect reset > null
- @echo =================================&@echo.
- @db2 reset MONITOR for db %%d > null
- ) else (
- @echo === Inf:DB ===
- @echo *** %%d 数据库连接失败! ***
- @echo =================================&@echo.
- )
- )
- )
复制代码 第9行期待结果:=== 成功连接到 SAMPLE 数据库 [[[
实际结果为: 数据库 [[[ 到 SAMPLE
第15行期待结果:=== 断开 SAMPLE 数据库连接 ]]]
实际结果为: 数据库连接 ]]]
1、为什么?
2、如何解决? |
|