![]() ![]() GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE TO USER USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 32768 (For example, create db.sql and modify the database name, path, and user variables to match your installation):ĬREATE DATABASE AUTOMATIC STORAGE YES ON '/Databases/' For example, db2inst1.Ĭreate a file with the following DB2 commands. Log in with DB2 instance owner credentials. ![]() Useradd -d /home/csuser -m -p welcome1 csuser For example, to create a user named csuser on Linux: To create a new DB2 database using a SQL scriptĬreate a user for the new database. For instructions, see Section 2.2.2, "Creating a New DB2 Database Using the 'db2cc' Utility." If you installed IBM DB2 version 9.7, you have the option of creating a new DB2 database using the db2cc utility. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |