Unanswered: db2 export and db2look and Oracle full database export
Oracle full database export generates 'dmp' file that carries all objects and content in database. (May be used for database recovery, tablespace recovery, object recovery, or data recovery, in some extent.
Or recreate database)
What are the command, utilities and or functions (excluding db2 backup) in db2 that provide equivalent mechanism like Oracle’s full database export?
Db2look does not regenerate foreign key constraint, and seems it does not generate script to create tablespace and syscat related information.
"Db2 export" exports tables' data and structure.