DB2 How To get View definition

Question: Given a view name , how can you get the definition of a View in DB2?

Answer: Query the SYSCAT.VIEWS and return the TEXT column. An alternative is to use the db2look utility

Syntax using SYSCAT.VIEWS

 
SELECT TEXT
 FROM SYSCAT.VIEWS
 WHERE VIEWNAME = 'myview' and viewschema = 'myschema'

Method 2 using db2look

Db2look –d  mydatabase  -t   myView

Read More

Create a DDL on an existing DB2 table

Deciding to reorg DB2 tables with overflow value

Commands to check for read only Linux file system

SQL Parser

Compare DDL of 2 databases in DB2

Linux top greater than 100 percent - CPU