Forgot your password?
Document Actions
Check parameter value from all your db´s
This script allows you to check what are the current and delayed values of a single database configuration parameter. Just supply the name of the parameter when you run the script.
#!/bin/bash
(printf "DBNAME CURRENT DELAYED\n";
for db in $(db2 list db directory | grep -s alias | awk {'print $4'}); do
db2 connect to $db > /dev/null
db2 get db config show detail | grep -i $1 | awk -F= '$15=dbname {print $15 $2}' dbname=$db
db2 connect reset > /dev/null
done| sed 1d) | column -t
Hacker Rangers - Gamification for CyberSecurity