I have never created a database.
I want to create a database in a DB2 server running on a NT server
from either CLP or command center
with the following syntax
CREATE DATABASE CarrierDB
MANAGED BY SYSTEM USING ('d:\pcatalog')
EXTENTSIZE 16 PREFETCHSIZE 32
MANAGED BY DATABASE USING (FILE'd:\db2data\personl' 5000,
EXTENTSIZE 32 PREFETCHSIZE 64
MANAGED BY SYSTEM USING ('d:\db2temp\personl')
WITH "Carrier DB for AR"
Is this syntax correct?
can I use this syntax for database creation in Command center?
I tried using Add Database wizard of Configuration wizard but it's giving some error. So thought of using the command center.
Please tell me if anything is wrong in the syntax and from where this script should be run