1.指定默认数据库,否则的话数据无法并行导出db2set DB2DBDFT=EDWDB或者export DB2DBDFT=EDWDB2.数据库并行导出 db2_all "\"|| db2 \"export to /CUBEDATA/LVCUBDAT1/TBL_WEB_MCHNT_QUERY.del.## of del &nb...(more)
There is a table const_check defined with check constraint in DB test. I need to move this table and it's data to another DB newdb.db2move test export -tn const_check#export the data in const_check -tn indicates the table name that get moveddb2look -...(more)
环境:DPF 33nodes(17+16) 两台物理主机:
关于export并行导出数据:single方式:hostname/path/#time db2 "export to A.del of del select * from schema.A"SQL3104N The Export utility is beginning to export data to file "A.del". &n...(more)
load---------------------------------------------------------------------------------------------常用选项:·COPY NO(缺省):不备份,Specifies that the table space in which the table resides will be placed in backup pending state if forward recovery is enable...(more)
select 'export to C:\db2_data\'|| rtrim(tabname) || '.del of del select * from ' || rtrim(tabname) || ';' from syscat.tables where tabschema = 'DB2INST1' and type='T';会把你库里 所有模式名为DB2INST1 的表的export语句生成出来