To create a connection to the
core warehouse database, you must create a connection profile
with the database connection information.
Before you begin
Before you create a connection to the core warehouse
database, you must first complete
the following tasks:
- You can find the database connection information in the installation
report provided with the system during delivery. Contact your system
administrator to gather the following database connection information:
- Database
- The name of the core warehouse database. The default database
name is BCUDB.
- Host
- The host name or IP address of the server that provides access
to the core warehouse database.
- Port number
- The port number. The default port number is 50000.
- User name
- The name of the user that you want to connect to the core warehouse
database. The default user name on the system is bcuaix.
- Password
- The password of the user name.
- The user name and password that you use to connect to the core
warehouse database must have the following privileges:
- Database administrators must have the following database privileges:
- DBADM
- CREATE_NOT_FENCED
- LOAD
- CREATE_EXTERNAL_ROUTINE
- Database users must have the following database privileges:
- CREATETAB
- BINDADD
- CONNECT
- IMPLICIT_SCHEMA
Procedure
- In the Data Studio client, switch to the perspective that is appropriate for your
role:
- Select .
- In the Open Perspective dialog box, select one of the following
perspectives:
- For application development, select Database Development.
- For database administration, select Database Administration.
- Go to the Data Source Explorer view
in the Database Development perspective or the Administration
Explorer view in the Database Administration perspective.
Note: If the view is not visible, open it from the
Windows menu:
- To display the Data Source Explorer, click .
- To display the Administration Explorer, click .
- Start the New Connection wizard:
- In the Data Source Explorer, click New Connection Profile.
- In the Administration Explorer, click .
- Complete the fields in the wizard:
- In the Local tab, select the DB2® for Linux, UNIX, and Windows database manager.
- Use the default JDBC driver.
- In the General tab
of the Properties section, specify the values of the database connection
information that correspond to the appropriate fields. To create a connection to the core warehouse
database, you would specify the following information in the fields
in the New Connection wizard:
- Database
- BCUDB
- Host
- hostname_or_service_ip
- Port number
- 50000
- User name
- bcuaix
- Password
- bcuaix_password
- Optional: Click Test Connection to
ensure that you can connect to the database.
- Click Finish.
Results
The connection is displayed in the
Database Connections folder
in the
Data Source Explorer view or in the
All
Databases folder in the
Administration Explorer.
What to do next
For information about the known restrictions and workarounds for the client, see
Known Restrictions.
For information about the tasks that you
can complete by using the client, see the IBM Data Studio Information Center.