IBM DB2 LUW DBA Tutorial -- db2look

/**

声明：此随笔为在youtube上学习‘ IBM DB2 LUW/UDB DBA Tutorial for Beginners' 课程笔记.

YouTube视频连接：https://www.youtube.com/watch?v=Pjvwm4rC5Ok&list=PLCNIKwM6iuv7g1hDWDcNkc66vZuVJmvZg

**/

Export:

　　db2 "export to /tmp/tep1/student.del of del select * from db2inst1.studentd"

　　cat /tmp/tmp1/student.del  --lookup student export information

db2look

　　db2look -d utils -z db2inst2 -t student -e -o student_ddl.sql  --check DDL of table

　　db2look -d utils -z db2inst2 -v v_student -e -o v_student_ddl.sql  --check DDL of view

　　db2look -d DBNAME -z SCHEMA -t TABNAME -e -o output_filename.sql