List DB2 table columns and unique constraints

How can I list the DB2 table columns and unique constraints?

 To list DB2 table columns and constraints  use one of these methods – using syscat.columns , describe or db2look

--Method 1 – query syscat.columns
select colname from syscat.columns where tabname='ADDRESS'

--Method 2 – use the describe command
describe table dbo.address

--Method 3 –use db2look 
db2look  -e –d dbname –t tablename

Read More

DB2 - Collecting data for database performance problems - DBA DB2

DB2 – COPY a table - DBA DB2

DB2 Tuning Toolkit – DB2 Design advisor - Ddb2advis - DBA DB2