How to Create a tablespace in DB2 in windows

Creating tablespaces in DB2 is a required step in learning the DB2 database. The following describes how to create tablespaces in DB2 in windows, we hope this will help you learn how to create tablespaces in DB2.

 
 

  
  
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  
 
 

The preceding figure shows how to create a tablespace in DB2 in windows.

How to delete tables with large data volumes in DB2

DB2 index design guidelines

Visualize DB2 Spatial Data

DB2 database lock table Problems

B2 common functions