DB2CC Generate Database's DDL

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