DB2CC Generate Database's DDL

最新推荐文章于 2025-12-03 12:11:38 发布

原创最新推荐文章于 2025-12-03 12:11:38 发布 · 1.1k 阅读

CC 4.0 BY-SA版权

文章标签：

22 篇文章

订阅专栏

本文详细介绍了数据库的DDL文件生成、数据文件生成、数据文件还原以及数据库创建等关键步骤，涉及DB2数据库的管理和使用。

1. Generate database's DDL file

Linux-ha27@linux-ha27:/opt/ibm/db2/V9.7/bin # su db2inst1
db2inst1@linux-ha27:/opt/ibm/db2/V9.7/bin> db2look -d oxfamadm -e -l -x -o /home/db2inst1/oxfam-2.sql
-- No userid was specified, db2look tries to use Environment variable USER
-- USER is: DB2INST1
-- Creating DDL for table(s)
-- Output is sent to file: /home/db2inst1/oxfam-2.sql

2. Generate database's data files:

Linux-ha27@linux-ha27:/opt/ibm/db2/V9.7/bin # su db2inst1
db2inst1@linux-ha27:/opt/ibm/db2/V9.7/bin> db2move $databasename export
(data files named tab*.ixf,tab*.msg.Those files will be generated where the db2move used)

3.Restore data files which generate by db2move command:
- linux-opvb:/opt/systemBackupData/oxfamInstallation/opencms-datamove/opencms # ./db2move opencms import -u db2inst1 -p admin >1.txt
       Binding package automatically ... /home/db2inst1/sqllib/bnd/db2common.bnd ... successful!

       Binding package automatically ... /home/db2inst1/sqllib/bnd/db2move.bnd ... successful!
       linux-opvb:/opt/systemBackupData/oxfamInstallation/opencms-datamove/opencms # Last login: Tue Mar 23 12:52:40 2010 from 119.130.255.128
       ces@linux-opvb:~> more resssssssLast login: Tue Mar 23 13:36:17 2010 from 119.130.255.128

All tab* files under the folder /opt/systemBackupData/oxfamInstallation/opencms-datamove/opencms

4.Make database :
- db2 => conect to POS
Database Connection Information

Database server        = DB2/LINUXX8664 9.5.0
SQL authorization ID   = DB2INST1
Local database alias   = POS
- db2 => backup database pos to /home/db2inst1/db2inst1
Backup successful. The timestamp for this backup image is : 20090909171129
- db2 => connect reset