DB2 Installation Notes
Warning: I am not a DB2
expert. This web page contains my notes trying to get DB2 installed from a
developers view point and not for PRODUCTION.
- Win 2000 Professional (DB2 UD v7.2 EE and DE
Product: DB2 UD EE v7.2 (UD=Universal Database, EE=Enterprise Edition)
Product: DB2 UD Personal Developer's Edition 7.2
- Login to the Computer as the "Administrator" (Windows).
- Warning: If you don't have another user who has administrator rights
go ahead and create one for safety reasons. I have had memory
dumps occur when you login as the person who installed DB2. I then
had to sign in as another administrator and uninstall DB2, then run a
registry cleaner like Norton. May have just been a problem with my
environment.
- Modules
- DB2 Enterprise Edition (install) - DB2 server. Also has a admin tool.
- DB2 Application Development Environment (install)- client tools for the
developer.
- DB2 Administrative Client - graphical tools that allow an
administrator to access multiple DB2 servers from a single
workstation.
- Default install directory: c:\program files\sqllib
- Space required: 646 MB
- If DB2 has been installed on your machine, you may want to do a full
Uninstall of DB2. I have notes at the bottom.
- db2admin User - Next the install looks for the user "db2admin" - this may
take some time.
Note: DB2 will create the user if it doesn't exist.
Note: If you are having problems with the install, you may want to create the user "db2admin", place
him in the "Administrators" group, and Grant him "full
control" to the
"C" drive prior to installing DB2. At least make sure
that "Administrators" group has "full control" of
the "C" drive.
- Permissions - Make sure that the group "Administrators" (not
"Administrator") has "full control" permissions of "C:\" drive.
- Right click on "C" drive, Properties, Security
- If the group "Administrators" (not Administrator) is
not listed, then Add them.
- Make sure the
group "Administrators" has "Full
Control" for the permissions.
- Also, make sure that the owner is "Administrator"
(not Administrators).
Click "Advanced", "Permissions" Tab, select
"Administrators", click "Owner" Tab, make
sure that the owner is "Administrator" (not
Administrators).
- Make sure that the password does not expire!!!
Your DB2 system will crash and the errors don't point to an
expired password.
- Reboot your machine.
- Errors I've encountered with permissions problems.
- During install: Severe: Creation of the SATCTLDB database failed.
- Create Sample Database: Can't access "c:\"
- Error about user doesn't have rights etc......
- DB2 Admin's Username & Password
Default username used by Control Center Server to login: db2admin
For learning purposes, the common password is: db2admin
During install, DB2 will help create this user for you if it doesn't
exist.
- Reboot machine after DB2 install.
- First Steps (DB2 Install): Create the Sample Databases
- Next click "Create Sample Datbases".
- Errors I've encountered.
- The database alias "SAMPLE" already exists in either the local database directory or system database directory.
SQL1013N The database alias name or database name "SAMPLE" could not be found. SQLSTATE=42705
- Solution: Follow the "Complete Uninstall of
DB2" listed below. Then re-install DB2.
(Note: One of my readers said he still had the problem until
he droped the DB.)
Just go to a command window and run the
following commands:
db2cmd
db2 catalog db sample
db2 drop db sample
exit
- First Steps (DB2 Install): Works With Sample Databases
- Click down the tree to see the Sample Database. Ex:
Computer Name, Instances, DB2, Databases. Then you should see
SAMPLE.
- Control Center - GUI to manage Databases and Tables
- Command Center - GUI to execute SQL scripts and commands.
Complete Uninstall of DB2
- Control Panel, Add/Remove Programs.
- Choose "Yes" to allow the Wizard to shut down the services.
- Delete the directory: "c:\Program files\SQLLIB"
- Make sure directories in "c:\" that start with DB2 have been
removed.
- Now, Reboot.