Shulou(Shulou.com)06/01 Report--

View tablespace location

Db2 connect to sample---- connection database

Db2 list tablespaces

Database Connection Information

Database server = DB2/LINUXX8664 10.5.5

SQL authorization ID = DB2INST1

Local database alias = SAMPLE

[db2inst1@107-sqlcheck ~] $db2 list tablespaces

Tablespaces for Current Database

Tablespace ID = 0

Name = SYSCATSPACE

Type = Database managed space

Contents = All permanent data. Regular table space.

State = 0x0000

Detailed explanation:

Normal

List tablespace containers for tablespaceID (tablespace id number) show detail

List tablespace containers for 0 show detail

[db2inst1@107-sqlcheck ~] $db2 list tablespace containers for 0 show detail

Tablespace Containers for Tablespace 0

Container ID = 0

Name = / home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000000/C0000000.CAT

Type = File

Total pages = 20480

Useable pages = 20476

Accessible = Yes

Create buffer pool

Db2 create BUFFERPOOL bigbuffer SIZE 4000 PAGESIZE 32K (4k Magi 8K Magi 16K)

Create a tablespace

Db2 "create tablespace newtbs04 pagesize 32k managed by system using ('/ home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000001/test.TMP') BUFFERPOOL bigbuffer"

Newtbs04---- stands for tablespace name

Pagesize 32k 32 can be specified as 8k 16k 32k

Bigbuffer--- stands for tablespace name

Authorization

Db2 grant use of tablespace newtbs04 to user db2dpmon

Modify table EXPLAIN.DDL file

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.