db2中create database命令怎么用

小编给大家分享一下db2中create database命令怎么用，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

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;

看完了这篇文章，相信你对“db2中create database命令怎么用”有了一定的了解，如果想了解更多相关知识，欢迎关注行业资讯频道，感谢各位的阅读！