Creating the DB2MALL Database

It is assumed that DB2 UDB Version 8 is installed on your system, DB2 started, and an instance is created. Follow the steps below to create the DB2MALL database:

Windows Platforms

  • Create a user ID called 'mall' with password 'mall'.
  • Logon to the Windows operating system using the 'mall' user ID.
  • Open a DOS window and type 
    Db2cmd
  • From the new DB2 CLP window which opened, change directory to the one where DB2 UDB v8 was installed. Usually this directory is \Program Files\SQLLIB.
  • Copy the file DB2MALL.DDL from the \DB2MALL directory on the CD that is provided with this book, to the DB2 installation directory.
  • Create the DB2MALL database by typing 
    Db2 create database db2mall on c: alias db2mall
  • Once the database creation ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial