Installing DB2 Universal Database Windows Enterpr
in the manage server and you will install each of the central information warehouse, information mart or proxy internet sites on the Windows program, complete the subsequent actions to set up DB2 Universal Database:
use provided using the Tivoli Information Warehouse The DB2 set up media. This assures you get the right version.
to a user with sufficient permissions to log on towards the personal computer. In Windows methods, the account you employ to log on to:
locally defined, belongs for the nearby Administrators group.
has the following advanced user rights:
◆ to manipulate the operating system;
◆ make a token object;
◆ quotas;
◆ Swap a method degree token.
the DB2 set up media into the CD-ROM drive. When you insert the DB2 set up CD, does not begin instantly, the basis of the CD plan to run setup.exe. Click on Install, after which when you're prompted to present the subsequent information and facts:
◆ Select DB2 Enterprise Edition merchandise.
◆ pick the Typical set up.
It is easy to alter the default location folder. DB2 set up directory name can't include spaces, so that the future with out the use of option approaches to correct the problem. For that remaining goods, please acknowledge the default value.
for that DB2 consumer title, specify a not however exist within your program customers. Once the DB2 Setup Wizard if you make a user, it guarantees the consumer has the correct roles and privileges. Should the person currently exists, make sure you look at deleting it, after which let the DB2 installation process to re-create it.
person names have to follow the DB2 consumer title, user ID, group name and instance name naming rules explained in the DB2 naming conventions.
Please accept all of the DB2 user name and password to set the choice to make use of the identical value.
your DB2 set up as specified by each DB2 consumer identify and password recorded inside a safe location. DB2 person data you have to install Tivoli Information Warehouse.
inside a distributed set up, there's no need to have for every DB2 Universal Database installation uses the identical consumer title and password. Choose not to set up the OLAP Starter Kit. Tivoli Information Warehouse without making use of OLAP Starter Kit.
by finishing the subsequent steps to test the connection:
by means of the command prompt, enter the subsequent command to begin the
to checklist the local database, enter the following command: db2 listing database directory.
In most cases, the command listing at least one database, even when the very same is accurate in the new installation.
when the command is not listed in any database, use the following command to generate a database: db2 develop database name. Variable title is your selection of title for that new database.
To check the nearby connection, enter the subsequent command: db2 connect to identify user userName employing passWord.
variable identify is db2 checklist database directory command returns the local database title or even the name with the database you developed. Variables userName and also the password is specified within the DB2 installation method the person name and password.
If this command is profitable, then set up the IBM DB2 Universal Database Enterprise Edition, and it truly is ready for remote connections. When the command fails, begin to see the DB2 Universal Database publications detailed inside the DB2 documentation for troubleshooting facts.
When you have a Lightweight Directory Access Protocol (LDAP), ensure that it can be for that DB2 instance is disabled.
inside the DB2 command window, run the subsequent command: db2set-all | far more.
check DB2_ENABLE_LDAP value. If this worth is outlined, and it's set to Sure, the DB2 command window by operating the subsequent command to disable LDAP and restart the DB2 server:
db2set db2_enable_ldap = NO
db2stop power
db2start
If this worth isn't detailed or set to
|