C:\Documents and Settings\Administrator>db2 ? import
IMPORT FROM filename OF {IXF | ASC | DEL | WSF}
[LOBS FROM lob-path [ {,lob-path} ... ] ]
[XML FROM xml-path [ {,xml-path} ... ] ][MODIFIED BY filetype-mod ...]
[METHOD {L ( col-start col-end [ {,col-start col-end} ... ] )
[NULL INDICATORS (col-position [ {,col-position} ... ] )] |
N ( col-name [ {,col-name} ... ] ) |
P ( col-position  [ {,col-position} ... ] )}]
[XMLPARSE {STRIP | PRESERVE} WHITESPACE]
[XMLVALIDATE USING {XDS [DEFAULT schema-sqlid]
[IGNORE (schema-sqlid [ {,schema-sqlid} ... ])]
[MAP ((schema-sqlid,schema-sqlid) [ {(schema-sqlid,schema-sqlid)} ... ])] |
SCHEMA schema-sqlid | SCHEMALOCATION HINTS }]
[ALLOW {NO | WRITE} ACCESS]
[COMMITCOUNT {n | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} n]
[ROWCOUNT n] [WARNINGCOUNT n] [NOTIMEOUT] [MESSAGES message-file]
{{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE}
INTO {table-name [( insert-column , ... )] | hierarchy-description}
| CREATE INTO {table-name [( insert-column , ... )] |
hierarchy-description {AS ROOT TABLE | UNDER sub-table-name}
[IN tablespace-name [INDEX IN tablespace-name] [LONG IN tablespace-name]]}
  filetype-mod:
    COMPOUND=x, INDEXSCHEMA=schema, FORCEIN, INDEXIXF, IMPLIEDDECIMAL,
    NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=x, RECLEN=x, STRIPTBLANKS,
    STRIPTNULLS, NO_TYPE_ID, NODOUBLEDEL, LOBSINFILE, USEDEFAULTS,
    CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO,
    DELPRIORITYCHAR, IDENTITYMISSING, IDENTITYIGNORE,
    GENERATEDMISSING, GENERATEDIGNORE, DATEFORMAT=x, TIMEFORMAT=x,
    TIMESTAMPFORMAT=x, KEEPBLANKS, CODEPAGE=x, NOROWWARNINGS,
    NOCHARDEL, NODEFAULTS, USEGRAPHICCODEPAGE, FORCECREATE, XMLCHAR,
    XMLGRAPHIC, SECLABELCHAR, SECLABELNAME
  hierarchy-description:
    {ALL TABLES | (sub-table-name [(insert-column, ...)], ...)} [IN]
    HIERARCHY {STARTING sub-table-name | (sub-table-name, ...)}

NOTE: From the operating system prompt, prefix commands with 'db2'.
      Special characters MAY require an escape sequence (\), for example:
      db2 \? change database
      db2 ? change database xxx comment with \"text\"

C:\Documents and Settings\Administrator>db2 ? export
EXPORT TO filename OF {IXF | DEL | WSF}
[LOBS TO lob-path [ {,lob-path} ... ] ][LOBFILE lob-file [ {,lob-file} ... ] ]
[XML TO xml-path [ {,xml-path} ... ] ][XMLFILE filename [ {,filename} ... ] ]
[MODIFIED BY {filetype-mod ...}][XMLSAVESCHEMA]
[METHOD N ( column-name [ {,column-name} ... ] )] [MESSAGES message-file]
{select-statement | XQUERY xquery-statement |
 HIERARCHY {STARTING sub-table-name |
(sub-table-name [{, sub-table-name} ...])} [WHERE ...] }
  filetype-mod:
    NODOUBLEDEL, LOBSINFILE, CHARDELx, COLDELx, DECPLUSBLANK
    DECPTx, DATESISO, 1, 2, 3, 4, CODEPAGE=x, STRIPLZEROS, NOCHARDEL,
    LOBSINSEPFILES, XMLINSEPFILES, XMLCHAR, XMLGRAPHIC, XMLNODECLARATION,
    TIMESTAMPFORMAT=x

NOTE: From the operating system prompt, prefix commands with 'db2'.
      Special characters MAY require an escape sequence (\), for example:
      db2 \? change database
      db2 ? change database xxx comment with \"text\"

C:\Documents and Settings\Administrator>db2 ? load
LOAD QUERY TABLE table-name [TO local-message-file]
[NOSUMMARY | SUMMARYONLY] [SHOWDELTA]

LOAD [CLIENT] FROM file/pipe/dev/cursor_name [ {,file/pipe/dev} ... ]
OF {ASC | DEL | IXF | CURSOR}
[LOBS FROM lob-path [ {,lob-path} ... ] ]
[XML FROM xml-path [ {,xml-path} ... ] ]
[MODIFIED BY filetype-mod [ {filetype-mod} ... ] ]]
[METHOD {L ( col-start col-end [ {,col-start col-end} ... ] )
           [NULL INDICATORS (col-position [ {,col-position} ... ] )]
       | N ( col-name [ {,col-name} ... ] )
       | P ( col-position  [ {,col-position} ... ] )}]
[XMLPARSE {STRIP | PRESERVE} WHITESPACE]
[XMLVALIDATE USING {XDS [DEFAULT schema-sqlid]
[IGNORE (schema-sqlid [ {,schema-sqlid} ... ])]
[MAP ((schema-sqlid,schema-sqlid) [ {(schema-sqlid,schema-sqlid)} ... ])] |
SCHEMA schema-sqlid | SCHEMALOCATION HINTS }]
[SAVECOUNT n]
[ROWCOUNT n] [WARNINGCOUNT n] [MESSAGES msg-file]
[TEMPFILES PATH pathname]
{INSERT | REPLACE [{KEEPDICTIONARY | RESETDICTIONARY}] | RESTART | TERMINATE}
INTO table-name [( insert-column [ {,insert-column} ... ] )]
[FOR EXCEPTION table-name [NOUNIQUEEXC NORANGEEXC]]
[STATISTICS {NO | USE PROFILE}]
[{COPY {NO | YES { USE TSM [OPEN num-sess SESSIONS]
                 | TO dir/dev [ {,dir/dev} ... ]
                  | LOAD lib-name [OPEN num-sess SESSIONS]}}
 | NONRECOVERABLE} ]
[HOLD QUIESCE] [WITHOUT PROMPTING] [DATA BUFFER buffer-size]
[SORT BUFFER buffer-size] [CPU_PARALLELISM n] [DISK_PARALLELISM n]
[FETCH_PARALLELISM {YES | NO}
[INDEXING MODE {AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED}]
[ALLOW NO ACCESS | ALLOW READ ACCESS [USE tblspace-name]]
[SET INTEGRITY PENDING CASCADE {DEFERRED | IMMEDIATE}] [LOCK WITH FORCE]
[SOURCEUSEREXIT executable [REDIRECT {[INPUT FROM {[BUFFER input-buffer] |
                      [FILE input-file]} [OUTPUT TO FILE output-file]]
                      [OUTPUT TO FILE output-file]] [PARALLELIZE]]
[[PARTITIONED DB CONFIG] partitioned-db-option [{partitioned-db-option}...]]
  filetype-mod:
    NOROWWARNINGS, ANYORDER, BINARYNUMERICS, CODEPAGE=x,
    DUMPFILE=x, FASTPARSE, NOHEADER, TOTALFREESPACE=x,
    INDEXFREESPACE=x, PAGEFREESPACE=x, FORCEIN, IMPLIEDDECIMAL,
    PACKEDDECIMAL, NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=x,
    RECLEN=x, STRIPTBLANKS, STRIPTNULLS, NODOUBLEDEL, LOBSINFILE,
    CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO,
    DELPRIORITYCHAR, USEDEFAULTS, DATEFORMAT=x, TIMEFORMAT=x,
    TIMESTAMPFORMAT=x, ZONEDDECIMAL, KEEPBLANKS, IDENTITYMISSING,
    IDENTITYIGNORE, IDENTITYOVERRIDE, GENERATEDMISSING,
    GENERATEDIGNORE, GENERATEDOVERRIDE, USEGRAPHICCODEPAGE,
    SECLABELCHAR, SECLABELNAME, XMLCHAR, XMLGRAPHIC, NOCHARDEL
  partitioned-db-option:
    PART_FILE_LOCATION x, OUTPUT_DBPARTNUMS x,
    PARTITIONING_DBPARTNUMS x, MODE x, MAX_NUM_PART_AGENTS x, OMIT_HEADER,
    ISOLATE_PART_ERRS x, STATUS_INTERVAL x, PORT_RANGE x, CHECK_TRUNCATION,
    MAP_FILE_INPUT x, MAP_FILE_OUTPUT x, TRACE x, NEWLINE, DISTFILE x

NOTE: From the operating system prompt, prefix commands with 'db2'.
      Special characters MAY require an escape sequence (\), for example:
      db2 \? change database
      db2 ? change database xxx comment with \"text\"

C:\Documents and Settings\Administrator>db2move -h

Application code page not determined, using ANSI codepage 1386

--------db2move - database movement tool--------

 Usage: "db2move [options]"

  is the name of the database.

  is one of:
     EXPORT - Export all tables that meet the filtering criteria in [options]
              (If no [options] specified, export all tables).
              Internal staging information is stored in file 'db2move.lst'.
              Messages are stored in 'EXPORT.msg'.

     IMPORT - Import all tables listed in the staging file 'db2move.lst'.
              Messages are stored in 'IMPORT.msg'..
              Use the -io option for IMPORT specific actions.

     LOAD   - Load all tables listed in the staging file 'db2move.lst'.
              Messages are stored in 'LOAD.msg'.
              Use the -lo option for LOAD specific actions.

     COPY   - Duplicate a schema(s) into a target database.
              Use the -sn option to specify one or more schemas.
              See the -co option for COPY specific options.
              Use the -tn or -tf option to filter tables in LOAD_ONLY mode.
              Messages are stored in 'COPY..msg'
              Error only messages in 'COPY..err'
              Load messages in 'LOADTABLE..msg'
              List of tables that failed Load in 'LOADTABLE..err'


  [options] are one or more of:

    Option      Description                  Use for   Notes
                                             Action
  ------------------------------------------------------------------------
  -tc   Table Definers. Filter on     EXPORT   Comma seperated list,
                SYSCAT.TABLES.DEFINER                 Wildcard (*) allowed.

  -tn   Table Names. Filter on        EXPORT   Comma seperated list,
                SYSCAT.TABLES.TABNAME        COPY     Wildcard (*) allowed for
                                                      EXPORT (not COPY).

  -sn   Schema Names. Filter on       EXPORT,  Comma seperated list,
                SYSCAT.TABLES.TABSCHEMA      COPY     Wildcard (*) allowed for
                                                      EXPORT (not COPY).

  -ts   Tablespace Names. Filter on   EXPORT   Comma seperated list,
                SYSCAT.TABLES.TBSPACE                 Wildcard (*) allowed.

  -tf    Fully qualified list of       EXPORT   one table per line,like:
                table names in         COPY      "MYSCHEMA1"."TAB1"
                                                       "MY SCHEMA2"."TAB2"

  -aw          Allow warnings                EXPORT   Don't disclude tables
                                                      that encounter warnings.

  -io   IMPORT specific actions.      IMPORT   One of: INSERT,
               Default is REPLACE_CREATE               INSERT_UPDATE, REPLACE,
               (see docs for limitations               CREATE, REPLACE_CREATE
                of Import create function)

  -lo   LOAD specific options.        LOAD     One of: INSERT,
                Default is INSERT                      REPLACE

  -l     Path to lobfiles.             EXPORT,  Comma seperated list,
                Default is cwd               IMPORT,  no space characters
                                             LOAD

  -u    Userid to connect to db.      ALL
                Default is current user

  -p    Password to connect to db.    ALL

  -co     COPY specific options.        COPY     See options listed below.

      TARGET_DB [USER [USING ]
         This mandatory option specifies the target database (and optional
         user/passwd) where the schema(s) will be created. (Default
         user/passwd are current user/passwd).
      MODE
         The mode is one of DDL_AND_LOAD (default), DDL_ONLY, or LOAD_ONLY.
      SCHEMA_MAP
         To rename the schema on the target db. For example, to rename schema
         'srcsch1' to 'tgtsch1', and schema 'srcsch2' to 'tgtsch2', use:
         "((srcsch1,tgtsch1), (scrsch2,tgtsch2))".
      TABLESPACE_MAP
         To override tablespaces on the target db. For example, to
         recreate all tables that reside in TS1 on the source db, into TS2 on
         the target db, and all other tablespaces to use the default tablespace
         on the target, use: "((TS1,TS2), SYS_ANY)".
      NONRECOVERABLE
         To override the default Load recoverability action COPY-NO, to
         NONRECOVERABLE.
      OWNER
         To override the owner of each new object created on the target db.


Examples:
  1) Use db2move to Export all tables:
      >db2move dbname EXPORT
  2) Use db2move to Export all tables, filtering on table-name with 'mytab*'
     and table-definer with 'USER1', and lobs in /bigfs/mydir/:
      >db2move dbname EXPORT -tn mytab* -tc USER1 -l /bigfs/mydir/
  3) Use db2move to Import (recreate and repopulate) all previously exported
     tables:
      >db2move dbname IMPORT
  4) Use db2move to Load (repopulate) all previously exported tables:
      >db2move dbname LOAD
  5) Use db2move to Load (append) all previously exported tables, where
     lobfiles reside in /bigfs/mydir:
      >db2move dbname LOAD -lo INSERT -l /bigfs/mydir
  6) Use db2move to duplicate schema 'schema1' from source database 'dbsrc'
     to target database 'dbtgt':
      >db2move dbsrc COPY -sn schema1 -co TARGET_DB dbtgt
        USER myuser1 USING mypass1
  7) Use db2move to duplicate schema 'schema1' from source database 'dbsrc'
     to target database 'dbtgt', rename the schema to 'newschema1' on the
     target, and map source tablespace 'ts1' to 'ts2' on the target:
      >db2move dbsrc COPY -sn schema1 -co TARGET_DB dbtgt
        USER myuser1 USING mypass1 SCHEMA_MAP ((schema1,newschema1))
        TABLESPACE_MAP ((ts1,ts2), SYS_ANY))

For more information, please see the DB2 documentation.



End time:  Mon Oct 25 14:50:42 2010

C:\Documents and Settings\Administrator>