inside the manage server and you might install every of the central data warehouse, data mart or proxy web-sites on the Windows program, complete the following actions to set up DB2 Universal Database:
use provided with all the Tivoli Information Warehouse The DB2 installation media. This guarantees you get the correct edition.
to a person with adequate permissions to log on towards the computer. In Windows techniques, the account you use to log on to:
locally outlined, belongs for the nearby Administrators group.
has the following superior user rights:
◆ to manipulate the operating system;
◆ develop a token object;
◆ quotas;
◆ Switch a method stage token.
the DB2 installation media into the CD-ROM drive. If you ever insert the DB2 installation CD, doesn't start off automatically, the foundation of the CD program to run setup.exe. Click on Set up, and then when you are prompted to give the following data:
◆ Choose DB2 Enterprise Edition merchandise.
◆ select the Standard installation.
You can actually change the default vacation destination folder. DB2 set up directory name can't include spaces,
Microsoft Office 2007 Standard, to ensure that the future without having using option approaches to right the challenge. For that remaining goods, make sure you acknowledge the default value.
for your DB2 person name, specify a not yet exist in your program users. When the DB2 Setup Wizard if you make a consumer, it guarantees the consumer has the right roles and privileges. In the event the consumer currently exists, please look at deleting it, and then allow the DB2 set up process to re-create it.
user names have to follow the DB2 user identify, user ID, group title and instance title naming rules explained in the DB2 naming conventions.
Please take all of the DB2 consumer identify and password to set the choice to use the same value.
your DB2 set up as specified by every DB2 user identify and password recorded inside a safe location. DB2 user information you need to install Tivoli Data Warehouse.
inside a distributed installation,
Microsoft Office Standard, there's no require for each and every DB2 Universal Database installation makes use of the same user identify and password. Choose not to set up the OLAP Starter Kit. Tivoli Information Warehouse with out employing OLAP Starter Kit.
by finishing the subsequent steps to check the connection:
via the command prompt, enter the subsequent command to begin the
to list the local database, enter the following command: db2 record database directory.
In most circumstances, the command listing a minimum of one database, even when the identical is true in the new installation.
if your command is not listed in any database, use the subsequent command to make a database: db2 generate database name. Variable name is your choice of title for the new database.
To test the nearby connection, enter the following command: db2 link to name consumer userName employing passWord.
variable identify is db2 record database directory command returns the local database name or even the title from the database you created. Variables userName plus the password is specified inside the DB2 installation method the person title and password.
If this command is successful, then set up the IBM DB2 Universal Database Enterprise Edition, and it truly is ready for remote connections. In case the command fails, begin to see the DB2 Universal Database publications outlined within the DB2 documentation for troubleshooting facts.
When you have a Light-weight Directory Access Protocol (LDAP), be certain it can be for your DB2 instance is disabled.
in the DB2 command window,
Office Standard 2007, run the subsequent command: db2set-all | even more.
examine DB2_ENABLE_LDAP worth. If this value is outlined, and it's set to Certainly, the DB2 command window by running the following command to disable LDAP and restart the DB2 server:
db2set db2_enable_ldap = NO
db2stop power
db2start
If this value is not detailed or set to