– linux下创建db2数据库
root用户下: (su root)
–新增用户
useradd spusr
–修改用户密码
passwd spusr
实例用户下: (su - db2inst1)
– 创建数据库
db2 create database db_sp - - 输出: DB200001 The CREATE DATABASE command complet
– 连接数据库
db2 connect to db_sp
–为新建用户赋权
db2 grant connect on database to user spusr
– 测试连接
db2 connect to db_sp user spusr using 123456