To generate DDL for all archive databases, use the extended filter option “OA.”
ddlgen -Uroy -Proy123 -SHARBAR:1955 -TDB -N% -XOA
To generate DDL for a single archive database, use the syntax for normal databases. This example creates DDL for the archive database archivedb:
ddlgen -Uroy -Proy123 -SHARBAR:1955 -TDB -Narchivedb