数据库迁移时,我想查看源库的创建脚本,不知道怎么才能生成,db2look -l,只能导出表空间信息,没有create database 信息,我用toad查看数据库可以看到脚本,但是我不想每次开TOAD,怎么才能获取到呢
CREATE DATABASE ALS755B
AUTOMATIC STORAGE YES
ON '/data/als' DBPATH ON '/data/als/als'
ALIAS ALS755B
USING CODESET UTF-8 TERRITORY US
COLLATE USING IDENTITY
PAGESIZE 16384
NUMSEGS 1
DFT_EXTENT_SZ 32
CATALOG TABLESPACE
MANAGED BY
AUTOMATIC STORAGE
EXTENTSIZE 4
PREFETCHSIZE -1
OVERHEAD -1
TRANSFERRATE -1
NO FILE SYSTEM CACHING
AUTORESIZE YES
INITIALSIZE 32 M
USER TABLESPACE
MANAGED BY
AUTOMATIC STORAGE
EXTENTSIZE 32
PREFETCHSIZE -1
OVERHEAD -1
TRANSFERRATE -1
NO FILE SYSTEM CACHING
AUTORESIZE YES
INITIALSIZE 32 M
TEMPORARY TABLESPACE
MANAGED BY
AUTOMATIC STORAGE
EXTENTSIZE 32
PREFETCHSIZE -1
OVERHEAD -1
TRANSFERRATE -1
FILE SYSTEM CACHING;
收起