DB2下数据转移任务操作实例(1)(2)

C:\>db2 "UPDATE DBM CFG USING FEDERATED YES"
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
SQL1362W One or more of the parameters submitted for immediate modification
were not changed dynamically. Client changes will not be effective until the
next time the application is started or the TERMINATE command has been issued.
Server changes will not be effective until the next DB2START command.
C:\>db2stop
2008-09-22 14.55.36 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
C:\>db2start
2008-09-22 14.55.53 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
C:\>db2 "CREATE DATABASE MYSAMPLE"
DB20000I The CREATE DATABASE command completed successfully.

C:\>db2look -d sample -e -z fechner -t sales -o sales.ddl
-- USER is: FECHNER

-- Specified SCHEMA is: FECHNER

-- The db2look utility will consider only the specified tables

-- Creating DDL for table(s)

-- Schema name is ignored for the Federated Section

-- Output is sent to file: sales.ddl

-- Binding package automatically ...

-- Bind is successful

-- Binding package automatically ...

-- Bind is successful

-- This CLP file was created using DB2LOOK Version 9.5

-- Timestamp: 23.09.2008 07:35:10

-- Database Name: SAMPLE

-- Database Manager Version: DB2/NT Version 9.5.2

-- Database Codepage: 1208

-- Database Collating Sequence is: IDENTITY

CONNECT TO SAMPLE;
------------------------------------------------

-- DDL Statements for table "FECHNER "."SALES"

------------------------------------------------

CREATE TABLE "FECHNER "."SALES" (
"SALES_DATE" DATE ,
"SALES_PERSON" VARCHAR(15) ,
"REGION" VARCHAR(15) ,
"SALES" INTEGER )
IN "IBMDB2SAMPLEREL" ;
COMMIT WORK;
CONNECT RESET;
TERMINATE;

CONNECT TO SAMPLE; -> CONNECT TO MYSAMPLE;
IN "IBMDB2SAMPLEREL" ; -> IN "USERSPACE1";

C:\>db2 -tf sales.ddl
Database Connection Information
Database server = DB2/NT 9.5.2
SQL authorization ID = FECHNER
Local database alias = MYSAMPLE
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The TERMINATE command completed successfully.

C:\>db2 "CATALOG TCPIP NODE SRCNODE REMOTE localhost SERVER 50000"
DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is
refreshed.
C:\>db2 "CATALOG DATABASE SAMPLE AS SRCDB AT NODE SRCNODE AUTHENTICATION SERVER"
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is
refreshed.
C:\>db2 "TERMINATE"
DB20000I The TERMINATE command completed successfully.

C:\>db2 "CONNECT TO MYSAMPLE"
Database Connection Information
Database server = DB2/NT 9.5.2
SQL authorization ID = FECHNER
Local database alias = MYSAMPLE
C:\>db2 "CREATE WRAPPER DRDA"
DB20000I The SQL command completed successfully.
C:\>db2 "CREATE SERVER SRCSRV TYPE DB2/UDB VERSION 9.5 WRAPPER DRDA AUTHORIZATION
\"fechner\" PASSWORD \"password\" OPTIONS (DBNAME 'SRCDB')"
DB20000I The SQL command completed successfully.
C:\>db2 "CREATE USER MAPPING FOR fechner SERVER SRCSRV OPTIONS (REMOTE_AUTHID 'fechner',
REMOTE_PASSWORD 'password')"
DB20000I The SQL command completed successfully.
C:\>db2 "CREATE NICKNAME FECHNER.SRCTAB FOR SRCSRV.FECHNER.SALES"
DB20000I The SQL command completed successfully.

C:\>db2 "DECLARE C1 CURSOR FOR SELECT * FROM FECHNER.SRCTAB"
DB20000I The SQL command completed successfully.
C:\>db2 "LOAD FROM C1 OF CURSOR MESSAGES C:\load_sales.msg INSERT INTO FECHNER.SALES
NONRECOVERABLE"
Number of rows read = 41
Number of rows skipped = 0
Number of rows loaded = 41
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 41
C:\>db2 "TERMINATE"
DB20000I The TERMINATE command completed successfully.