User Tools

Site Tools


database:db2:create-database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

database:db2:create-database [2021/02/18 13:09] (current)
odefta created
Line 1: Line 1:
 +====== Create a new DB2 database ======
 +
 +Open DB2 Command line processor:
 +
 +{{:database:db2:pasted:20210218-130048.png}}
 +
 +  CREATE DATABASE PMJ AUTOMATIC STORAGE YES
 +
 +  DB20000I  The CREATE DATABASE command completed successfully.
 +
 +Next, activate the database:
 +
 +  ACTIVATE DATABASE PMJ
 +  
 +  DB20000I  The ACTIVATE DATABASE command completed successfully.
 +
 +Connect to the database using IBM Data Studio:
 +
 +{{:database:db2:pasted:20210218-130847.png}}
 +
 +{{:database:db2:pasted:20210218-130939.png}}
 +
 +
 +
  
database/db2/create-database.txt ยท Last modified: 2021/02/18 13:09 by odefta