Installingand upgrading>Database Setup>DB2 setup
>Databaseobjects for DB2
I have someedits to the command script that would make it simpler, I got thesefrom Jesse
db2 “CREATEDATABASE <database name> USING CODESET UTF-8 TERRITORY USPAGESIZE 16 K AUTOCONFIGURE USING MEM_PERCENT 20 APPLY DB ONLY
db2 “CONNECTTO <database name>”
db2 “CREATESCHEMA <schema name>”
db2 “CONNECTRESET”
//if you needto grant access to a different, non-administrator user
db2 "GRANTCREATEIN,DROPIN,ALTERIN ON SCHEMA <schema name> TO USER<username> WITH GRANT OPTION"
db2 "GRANTDBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECTON DATABASE TO USER <username>"
>DB2client drivers
Thedb2 client driver is now called “Data server client” not “db2connect client”
>DB2information needed during installation
itis important that the database, and schema names all need to be inCAPS, otherwise build forge will not be able to find thedatabase/schema
183
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
