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)
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)
Subscribe to:
Post Comments (Atom)
No Response to "Create DB2 database in AIX"
Leave A Reply