DB2 Export DDL

2. Syntax: db2look-d DBname [-e] [-xs] [-xdir Path] [-u Creator] [-Z Schema]

4. [-t Tname1 Tname2 ... Tnamen] [-TW tname] [-h]

6. [-O Fname] [-A] [-M] [-c] [-R] [-l] [-X] [-xd] [-F]

8. [-FD] [-td x] [-noview] [-I UserID] [-W Password]

10. [-V Vname1 Vname2 ... Vnamen] [-DP] [-CT]

12. [-wrapper Wrappername] [-server ServerName] [-nofed]

14. [-WLM] [-ap] [-mod] [-cor]

18. [-wrapper Wrappername] [-server ServerName] [-fedonly]

20. [-nofed]

24. Db2look [-h]

28. -D: Database name: This must specify

32. -E: Extracting the DDL files required to replicate the database

34. -XS: Exporting XSR objects and generating scripts that contain DDL statements

36. -xdir: Pathname: The directory that will be used to place the XSR object

38. -U: Create program ID: if both-u and-A are not specified, the $USER will be used

40. -Z: Mode name: If both-Z and-A are specified, the-Z is ignored

42. -T: Generate statistics for the specified table

44. -TW: DDL is generated for tables that match the schema condition (wildcard) of the name with the table name

46. -ap: Generating a AUDIT USING statement

48. -WLM: Generating WLM-specific DDL statements

50. -mod: Generating DDL statements for a module

52. -cor: Using the Create OR REPLACE clause to generate the DDL

54. -H: More detailed help message

56. -o: Redirect output to the given file name

58. -A: Generate statistics for all creation programs

60. -M: Running the Db2look utility in analog mode

62. -C: Do not generate a mock COMMIT statement

64. -r: Do not generate a simulated RUNSTATS statement

66. -L: Generate Database layout: Database partition group, buffer pool, and table space.

68. -X: The "Authorization" statement of the original definition program that generated the Exclude object DDL

70. -XD: Generate an "authorization" statement DDL that includes the original definition program of the object

72. -F: Extracting configuration parameters and environment variables

74. -TD: Specifies x as the statement delimiter (the default delimiter is a semicolon (;))

76. -I: User ID used when logging on to the server where the database resides

78. -W: the password used to log on to the server where the database resides

80. -noview: Do not generate create VIEW DDL statement

82. -wrapper: Generating DDL for federated objects that apply to this wrapper

84. -server: Generating DDL for federated objects that apply to this server

86. -fedonly: Only federated DDL Statements were created

88. -nofed: Do not generate federated DDL

90. -FD: Generate db2fopt for Opt_buffpage and Opt_sortheap and other configuration and environment parameters

92. Statement.

94. -V: DDL is generated for the view only, this option is ignored when-T is specified

96. -DP: Generate a DROP statement before the CREATE statement

98. -CT: Generating DDL Statements by object creation time

DB2 Export DDL