Thursday, May 8, 2008

db2 commands

  • get db configuration
db2 get db cfg for databasename
db2 update db cfg for dbname using screenname value
db2 get dbm cfg
  • to list all tables, filtering out views
db2 list tables show detail | grep -v ' V ' | awk '{print $1}'

No comments: