|
Step 3: Create a DB2 Database User for SAMPLE
- Create an operating system user named wsdemo with a password of wsdemo1.
wsdemo does not have to have special privileges.
For DB2 on AIX:
On the client machine, use DB2's command-line processor and type:
- CONNECT TO SAMPLE USER <server_db2_admin_userid> USING <server_db2_admin_password>
where:
- <server_db2_admin_userid> is the database adminstrator's userid on the server
- <server_db2_admin_password> is the database adminstrator's password on the server
- GRANT CONNECT, CREATETAB ON DATABASE TO USER wsdemo
For all other operating systems:
- You can use the DB2 GUI or, on the command line interface, type:
- CONNECT TO SAMPLE
- GRANT CONNECT, CREATETAB ON DATABASE TO USER wsdemo
Please see DB2 documentation for more information on GUI or command line options.
 
- Be sure you use all lower case letters when creating the wsdemo user.
- Specify the "connect" and "createtab" authorities for the DB2 wsdemo user. Others are optional.
|