DB2 Database Configuration

Step 1 Step 2 Step 3 Step 4 Step 5


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:
    1. 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
    2. 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:
      1. CONNECT TO SAMPLE
      2. GRANT CONNECT, CREATETAB ON DATABASE TO USER wsdemo

Please see DB2 documentation for more information on GUI or command line options.


Take Note!
  • 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.