for TABELA in `db2 connect to DBALIAS > /dev/null; db2 list tables for all | grep LOCK | awk '{print $1}'`;do db2 drop table $TABELA; done db2 "select tabname from syscat.tables where tabname like '%N1%'" | sed "s/ *$/ /g"