Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use the create database command in db2. I hope you will get something after reading this article. Let's discuss it together.

CREATE DATABASE PERFDB

AUTOMATIC STORAGE YES

ON'/ db2data' DBPATH ON'/ db2data/db2inst1'

ALIAS PERFDB

USING CODESET GBK TERRITORY CN

COLLATE USING SYSTEM

PAGESIZE 8192

NUMSEGS 1

DFT_EXTENT_SZ 32

CATALOG TABLESPACE

MANAGED BY

AUTOMATIC STORAGE

EXTENTSIZE 4

PREFETCHSIZE-1

OVERHEAD-1

TRANSFERRATE-1

NO FILE SYSTEM CACHING

AUTORESIZE YES

INITIALSIZE 32 M

USER TABLESPACE

MANAGED BY

AUTOMATIC STORAGE

EXTENTSIZE 32

PREFETCHSIZE-1

OVERHEAD 7.5

TRANSFERRATE 0.06

NO FILE SYSTEM CACHING

AUTORESIZE YES

INITIALSIZE 32 M

TEMPORARY TABLESPACE

MANAGED BY

AUTOMATIC STORAGE

EXTENTSIZE 32

PREFETCHSIZE-1

OVERHEAD 7.5

TRANSFERRATE 0.06

FILE SYSTEM CACHING

CREATE BUFFERPOOL BP32K

IMMEDIATE

ALL DBPARTITIONNUMS

SIZE AUTOMATIC

NUMBLOCKPAGES 0

PAGESIZE 32K

CREATE EVENT MONITOR DB2DETAILDEADLOCK

FOR DEADLOCKS WITH DETAILS

WRITE TO FILE 'db2detaildeadlock'

MAXFILES 20

MAXFILESIZE 512

BUFFERSIZE 17

BLOCKED

APPEND

AUTOSTART

ON DBPARTITIONNUM 0

GLOBAL

After reading this article, I believe you have a certain understanding of "how to use create database commands in db2". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.