Tuesday, 9 August 2011
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: -