You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
db2 connect to $DBNAME user $USERNAME using $PASSWD
echo "テーブルのステータスを確認する"
db2 "select varchar(tabname,30) as tabname,status from SYSCAT.TABLES where tabschema="$USERNAME" order by tabname"
echo "トリガーのステータスを確認する"
db2 "select varchar(trigname,30) as trigname,varchar(tabname,30) as tabname,valid from SYSCAT.TRIGGERS where trigschema="$USERNAME" order by trigname"
echo "ストアド系のステータスを確認する"
db2 "select varchar(routinemodulename,30) as routinemodulename,varchar(routinename,30) as routinename,valid,create_time,alter_time from SYSCAT.ROUTINES where routineschema="$USERNAME" and dialect='PL/SQL' order by routinemodulename,routinename"