Are you DB2LOOKing at me ?

One of my friends pointed out an easy way to extract the underlying design etc. of a DB2 database schema.

I'd previously suggested that he use db2 describe select * from … but he rightly pointed out that db2look is far more useful.

As an example, this is the command as used for a Property Extension database underlying WebSphere Portal v7

$ db2look -d PROPEXT -e -t LABLOBPROP  > /tmp/petables/LABLOBPROP.txt

For further information on DB2LOOK, check out the Information Centre here: -

db2look - DB2 statistics and DDL extraction tool command