The following describes how to create a DB2 tablespace in windows. If you are interested in creating a DB2 tablespace, take a look.
- db2set db2codepage=819
- db2 create database test03
- db2 connect to test03 user db2amdin using 1
- db2 CREATE Bufferpool USER8 SIZE 100000 PAGESIZE 8K
- db2 CREATE Bufferpool USER16 SIZE 1000 PAGESIZE 16 K
- db2 CREATE Bufferpool USER32 SIZE 1000 PAGESIZE 32 K
- db2stop force
- db2start
- db2 connect to test03 user easymis using easymis
- db2 "CREATE REGULAR TABLESPACE TS_USER8 PAGESIZE 8K MANAGED BY SYSTEM USING ('FSMS_8K_1') BUFFERPOOL USER8"
- db2 "CREATE REGULAR TABLESPACE TS_USER16 PAGESIZE 16K MANAGED BY SYSTEM USING ('FSMS_16K_1') BUFFERPOOL USER16"
- db2 "CREATE REGULAR TABLESPACE TS_USER32 PAGESIZE 32K MANAGED BY SYSTEM USING ('FSMS_32K_1') BUFFERPOOL USER32"
- db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT ON DATABASE TO USER EASYMIS
- db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT,LOAD ON DATABASE TO USER EASYMIS
- db2 connect to test03 user easymis using easymis
- db2 -f dbstruct.sql >kk.log
Use the configuration assistant to add odbc and cli commands and configure the user password.
Use odbctool to load data to the database at a time.
Configure jdbc connection
You can use jcc directly.
- <property name="dialect">org.hibernate.dialect.DB2Dialect</property>
- <property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
- <property name="connection.username">easymis</property>
- <property name="connection.password">1</property>
- <property name="connection.url">jdbc:db2://192.168.20.249:50000/test03</property>
If the app format is used, modify db2java.zip to db2java. jar.
- db2jdbcbind -url jdbc:db2://192.168.20.249:50000/test03 -user easymis -password 1
- <property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
- <property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
- <property name="connection.username">easymis</property>
- <property name="connection.password">1</property>
- <property name="connection.url">jdbc:db2:test03</property>
The preceding section describes how to create a DB2 tablespace in windows.
DB2 tablespace Classification
Implementation of DB2 string connection
DB2 update statements for records in the same table
How to expand the tablespace and Field Length in db2
DB2 strings in DB2 Databases