Monday, October 21, 2013

Create DB2 database in AIX

Posted on 11:48 AM by Kalum Umesh

Following the steps create new DB2 database in AIX on new file system

mkvg -y dbdatavg hdisk8

mkdir /dbdata

crfs -v jfs2 -g dbdatavg -a size=5G -m /dbdata

chown db2inst1:db2iadm1 /dbdata

After that you need to login as DBA user

db2 create db testdb on /dbdata

If you need you can change log like following :

db2 update db cfg for testdb using newlogpath /dblog

(You need to create new file system for dblog before changing newlogpath)

No Response to "Create DB2 database in AIX"

Leave A Reply

 
Free Website Hosting