Security for Data warehousing in Db2 is
controlled by WebSphere® Application
Server.
If you installed WebSphere Application
Server with
the warehouse product, you already configured security during the
installation. However, if you chose instead to use an existing copy
of WebSphere Application
Server,
you need to configure security after the installation.
Before you begin
Log
in to
WebSphere Application
Server.
For example:
- On Windows: From the Start menu,
click .
- From a Web browser, type: http://host_name:9060/ibm/console
Tip: If port number 9060 is already taken, you can
find the default port number in the portdef.props file
in the following location: WebSphere\AppServer\profiles\AppSrv01\properties.
The default port number for WebSphere Application
Server is
specified by the WC_adminhost property.
If
security is already enabled, you must log in with administrator authority
for WebSphere Application
Server.
Otherwise, you can log in without administrator authority and without
a password.
About this task
In
this task you select the local operating system as the security realm,
and then you configure and enable global security.
Procedure
To
configure security for WebSphere Application
Server and
its applications:
- Configure the user account repository to use the local
operating system as the security realm.
- Open the Global Security page,
click
- From the Available realm definition menu,
select Local operating system, and then click Configure.
- In the Primary administrative user name field,
type a user name to be assigned administrative privileges for WebSphere Application
Server.
The user name must be one that is defined in the operating system
where WebSphere Application
Server is
installed.
- Click OK.
- Click Set as current, and then
click Apply to validate the changes.
- On the Global Security panel, configure
and enable global security.
- Select the Enable administrative security check
box.
- Select the Enable application security check
box.
- Clear the Use Java 2 security to restrict
application access to local resources check box.
- Click Apply.
- Save the configuration settings for the server to use when
it is restarted.
- Click Save to save directly to
the master configuration.
- Restart WebSphere Application
Server,
and then log back in.
What to do next
Security
is now configured for
WebSphere Application
Server and
its applications. If for any reason you stop
WebSphere Application
Server,
you must specify an administrative user name and password by running
the following command:
- On Linux and UNIX: opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/stopServer.sh
server1 -user user_name -password password
- On Windows: ISWarehouse\appServer\profiles\AppSrv01\bin\stopServer.bat
server1 -user user_name -password password
Alternatively, you can open the
soap.client.props file
in the
profile_root/properties directory and
edit the
com.ibm.SOAP.loginUserid and
com.ibm.SOAP.loginPassword properties.
You
are ready to configure user access to the Warehouse Administration
Console.
Configuring user access with WebSphere Application Server
