Home > database >  Questions about DB2 export statements
Questions about DB2 export statements

Time:09-22

DB2MOVE * * * * * * * * * *

Action: EXPORT

Start time: 30 13:05:09 Wed Jan 2019


Connecting to the database RUNDB... Successful! Server: DB2 Common Server V10.5.7

EXPORT: 30030 rows from the table "BSPHIS". "A_LXFS
"EXPORT: 84 rows from the table "BSPHIS". "A_XWZR
"EXPORT: 67 rows from the table "BSPHIS". "A_XWZR_JZ
"EXPORT: 65 rows from the table "BSPHIS". "A_XWZR_YW
"EXPORT: 0 rows from the table "BSPHIS". "AC007
"EXPORT: 75 rows from the table "BSPHIS". "AC008
"EXPORT: 0 rows from the table "BSPHIS". "AC009
"EXPORT: 0 rows from the table "BSPHIS". "AC010
"EXPORT: 0 rows from the table "BSPHIS". "AC011
"EXPORT: 0 rows from the table "BSPHIS". "AC012
"EXPORT: 207 rows from the table "BSPHIS". "AC013
"EXPORT: 299 rows from the table "platt,". "PF18
"EXPORT: 0 rows from the table "BSPHIS". "PF19
"EXPORT: 3 rows from the table "platt,". "PF19
"EXPORT: 0 rows from the table "BSPHIS". "PF20
"EXPORT: 18 rows from the table "platt,". "PF20
"EXPORT: 69 rows from the table "BSPHIS". "PF21
"EXPORT: 117 rows from the table "platt,". "PF21
"EXPORT: 50 rows from the table "BSPHIS". "PF22
"EXPORT: 72 rows from the table "platt,". "PF22
"EXPORT: 286 rows from the table "BSPHIS". "PF23
"EXPORT: 50 rows from the table "platt,". "PF23
"EXPORT: 16 rows from the table "BSPHIS". "PF24
"EXPORT: 16 rows from the table "platt,". "PF24
"* * Error occured - 1

Disconnecting from the database... Successful!

End time: 30 14:18:37 Wed Jan 2019


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- the above is the EXPORT log -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- the following is the DB2move LST statement -- -- -- -- -- -- -- -- -- -- -- -- -- --

!" WORKFLOW ". "A"! Tab1 ixf! Tab1 MSG!
!" BSPHIS ". "A_LXFS!" " Tab2 ixf! Tab2 MSG!
!" BSPHIS ". "A_XWZR!" " Tab3 ixf! Tab3 MSG!
!" BSPHIS ". "A_XWZR_JZ!" " Tab4, ixf! Tab4, MSG!
!" BSPHIS ". "A_XWZR_YW!" " Tab5 ixf! Tab5 MSG!
!" BSPHIS ". "AC007!" " Tab6 ixf! Tab6 MSG!
!" BSPHIS ". "AC008!" " Tab7 ixf! Tab7 MSG!
!" BSPHIS ". "AC009!" " Tab8 ixf! Tab8 MSG!
!" BSPHIS ". "AC010!" " Tab9 ixf! Tab9 MSG!
!" BSPHIS ". "AC011!" " Tab10 ixf! Tab10 MSG!
!" BSPHIS ". "AC012!" " Tab11 ixf! Tab11 MSG!
!" BSPHIS ". "AC013!" " Tab12 ixf! Tab12 MSG!
!" BSPHIS ". "AC014!" " Tab13 ixf! Tab13 MSG!
!" BSPHIS ". "AC015!" " Tab14 ixf! Tab14 MSG!
!" BSPHIS ". "AC016!" " Tab15 ixf! Tab15 MSG!
!" BSPHIS ". "AC018!" " Tab16 ixf! Tab16 MSG!
!" BSPHIS ". "AC019!" " Tab17 ixf! Tab17 MSG!
!" BSPHIS ". "AC020!" " Tab18 ixf! Tab18 MSG!
!" BSPHIS ". "AC021!" " Tab19 ixf! Tab19 MSG!
!" BSPHIS ". "AC022!" " Tab20 ixf! Tab20 MSG!
!" BSPHIS ". "AC023!" " Tab21 ixf! Tab21 MSG!


1. Could you please tell me which "BSPHIS", "platt" represents the tablespace? Log is more, the above is only part of the

2. The reduction of the data file format: db2move. LST, EXPORT. Out, tab1. Ixf, tab1, tab100. Ixf, tab100 are similar domain this

3. This is the backup data under Linux, could you tell me how to restore the Windows under the DB2 database, how to use sentence reduction

4. Thank you

CodePudding user response:

1. The schema name
3. The db2move the load
  •  Tags:  
  • DB2
  • Related