Create a Database on DB2 on Linux -
i have instally db2 on linux machine, not able create database.
when make create database abc;
error haven't authorization create it...how can authorization?
when install db2, use root user of linux server. in installing phase, provide user have sysadm , dbadm rights. means db2 creates user has rights on database(database admin).
so, after installation, have switch user have rights create new database. depending on version installed, username might changed. db2 uses db2inst1 default administrator user.
check /home directory. see new user(most db2inst1). switch user with:
su - db2inst1
then issue:
db2 create database abc
let me know if have problem, please provide /home directory , error message get.
Comments
Post a Comment