DB2编程基础要点(4)

C:\PROGRA~1\TRENDP~1\PCSCAN.EXE C:\ C:\WINDOWS\COMMAND\ /NS /WIN95  
rem C:\WINDOWS\COMMAND.COM /E:32768 
REM [Header] 
REM [CD-ROM Drive] 
REM [Miscellaneous] 
REM [Display] 
set PATH=%PATH%;C:\MSSQL\BINN;C:\PROGRA~1\SQLLIB\BIN;
   C:\PROGRA~1\SQLLIB\FUNCTION;C:\PROGRA~1\SQLLIB\SAMPLES\REPL;
      C:\PROGRA~1\SQLLIB\HELP 
IF EXIST C:\PROGRA~1\IBM\IMNNQ\IMQENV.BAT CALL 
      C:\PROGRA~1\IBM\IMNNQ\IMQENV.BAT 
IF EXIST C:\PROGRA~1\IBM\IMNNQ\IMNENV.BAT CALL 
      C:\PROGRA~1\IBM\IMNNQ\IMNENV.BAT 
set DB2INSTANCE=DB2 
set CLASSPATH=.;C:\PROGRA~1\SQLLIB\java\db2java.zip;
   C:\PROGRA~1\SQLLIB\java\runtime.zip;C:\PROGRA~1\SQLLIB\java\sqlj.zip;
       C:\PROGRA~1\SQLLIB\bin 
set MDIS_PROFILE=C:\PROGRA~1\SQLLIB\METADATA\PROFILES 
set LC_ALL=ZH_CN 
set INCLUDE=C:\PROGRA~1\SQLLIB\INCLUDE;C:\PROGRA~1\SQLLIB\LIB;
    C:\PROGRA~1\SQLLIB\TEMPLATES\INCLUDE 
set LIB=C:\PROGRA~1\SQLLIB\LIB 
set DB2PATH=C:\PROGRA~1\SQLLIB 
set DB2TEMPDIR=C:\PROGRA~1\SQLLIB 
set VWS_TEMPLATES=C:\PROGRA~1\SQLLIB\TEMPLATES 
set VWS_LOGGING=C:\PROGRA~1\SQLLIB\LOGGING 
set VWSPATH=C:\PROGRA~1\SQLLIB 
set VWS_FOLDER=IBM DB2 
set ICM_FOLDER=信息目录管理器

create database head using codeset IBM-eucCN territory CN;

db2  catalog tcpip  node   node1  remote   172.28.200.200 server  50000 
db2  catalog db    head   as     test1 at  node   node1

db2 connect to test1  user …  using …

db2start 
db2stop (force)