创建测试用的DB2数据库

渡人自渡

<style type="text/css"><!--@page { margin: 2cm }P { margin-bottom: 0.21cm }A:link { so-language: zxx }--></style>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