Unformatted text preview: IBM InfoSphere Information Server
Version 8 Release 5 Administration Guide SC18-9929-04 IBM InfoSphere Information Server
Version 8 Release 5 Administration Guide SC18-9929-04 Note
Before using this information and the product that it supports, read the information in “Notices and trademarks” on page
269. © Copyright IBM Corporation 2007, 2010.
US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp. Contents
Chapter 1. Administration overview . . . 1
IBM InfoSphere DataStage administration . . .
IBM WebSphere Application Server administration . 4
. 5 Chapter 2. Opening the consoles . . . . 7
Opening the IBM InfoSphere Information Server
console . . . . . . . . . . . . . . . . 7
Opening the IBM InfoSphere Information Server web
console . . . . . . . . . . . . . . . . 8
Determining the URL for the IBM InfoSphere
Information Server Web console . . . . . . . 8
Configuring your Web browser to work with the
IBM InfoSphere Information Server Web console . 9
Navigating to the IBM InfoSphere Information
Server Web console . . . . . . . . . . . 11
Logging in to the IBM WebSphere Application
Server administrative console . . . . . . . . 11 Chapter 3. IBM InfoSphere Information
Server console overview . . . . . . . 13
Main areas of the console. . . . . . . . .
My Home workspace . . . . . . . . .
Workspace Navigator . . . . . . . . .
Project menu . . . . . . . . . . . .
Palettes . . . . . . . . . . . . . .
Project dashboard . . . . . . . . . .
Status bar . . . . . . . . . . . . .
Shortcuts . . . . . . . . . . . . .
Notes . . . . . . . . . . . . . .
Basic task flow in the workspaces . . . . . .
Select a task menu from the Workspace
Navigator . . . . . . . . . . . . .
Select the task that you want to perform from
that menu . . . . . . . . . . . . .
Select objects and a task in the workspace . .
Work in a task pane . . . . . . . . .
Reporting, scheduling, and logging in the console
Reporting . . . . . . . . . . . . .
Scheduling . . . . . . . . . . . .
Logging . . . . . . . . . . . . .
Online help . . . . . . . . . . . . . .
.
.
.
.
.
.
.
.
. 13
13
15
16
17
19
19
20
20
20 . 21
. 21
. 22
. 23
24
. 24
. 24
. 25
. 25 Chapter 4. Working with projects in the
IBM InfoSphere Information Server
console . . . . . . . . . . . . . . 27
Setting up a project in the IBM InfoSphere
Information Server console . . . . . . . .
Creating a project . . . . . . . . . .
Modifying project properties. . . . . . .
Customizing the project dashboard . . . .
Opening an existing project in the IBM InfoSphere
Information Server console . . . . . . . . Chapter 5. Customizing the consoles
© Copyright IBM Corp. 2007, 2010 .
.
.
. 27
27
27
28 . 28 29 Customizing the IBM InfoSphere Information
console . . . . . . . . . . . . .
Customizing the My Home workspace .
Modifying user preferences . . . . .
Creating shortcuts . . . . . . . .
Working with palettes . . . . . . .
Creating notes . . . . . . . . .
Refreshing an object list . . . . . .
Changing your password . . . . . .
Customizing the IBM InfoSphere Information
Web console . . . . . . . . . . .
Customizing the Home tab . . . . .
Changing your password . . . . . . Server
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
Server
. . .
. . .
. . . 29
29
29
29
30
31
31
31
32
32
32 Chapter 6. Managing security . . . . . 33
Security setup . . . . . . . . . . . . . 33
User registry configuration . . . . . . . . 34
User and group creation . . . . . . . . . 53
Assigning user roles . . . . . . . . . . 61
Engine security configuration . . . . . . . 74
Configuring WebSphere Application Server for
non-root administration (Linux, UNIX) . . . . 84
Starting IBM InfoSphere Information Server node
agents as a non-root user . . . . . . . . . 91
Audit logging configuration . . . . . . . . 93
Administrator account password changing . . . 106
Changing an IBM InfoSphere Information Server
administrator password . . . . . . . . . 106
IBM WebSphere Application Server
administrator password changing . . . . . 108
Metadata repository database owner password
changing . . . . . . . . . . . . . . 111
Changing the analysis database owner account
credentials . . . . . . . . . . . . . 113
Changing IBM DB2 passwords . . . . . . 114
Administration commands and tools . . . . . 114
AppServerAdmin command . . . . . . . 114
DirectoryAdmin tool . . . . . . . . . . 117 Chapter 7. Activating entitled IBM
InfoSphere DataStage editions and
feature packs . . . . . . . . . . . 127
Viewing a list of activated IBM InfoSphere
DataStage editions and feature packs . . .
Activating and deactivating IBM InfoSphere
DataStage editions and feature packs . . .
LicensingServiceAdmin command reference . . . 128 .
. . 129
. 131 .
.
.
.
. .
.
.
.
. Chapter 8. Managing active sessions
Viewing all active sessions
Setting session limits . .
Opening user details . .
Disconnecting all sessions
Disconnecting a session . .
.
.
.
. .
.
.
.
. .
.
.
.
. .
.
.
.
. .
.
.
.
. .
.
.
.
. .
.
.
.
. 135
135
135
136
136
136 iii Chapter 9. Managing clusters and
high availability configurations . . . . 139
Active-passive configuration administration . .
Administering an active-passive configuration
based on Tivoli System Automation for
Multiplatforms . . . . . . . . . . .
WebSphere Application Server cluster
administration . . . . . . . . . . . .
WebSphere Application Server cluster
administration tools . . . . . . . . .
Propagating the plugin-cfg.xml file to the
front-end Web server . . . . . . . . .
Adding a new cluster member . . . . .
Adding a new managed node . . . . . .
Synchronizing nodes after changing the master
repository configuration . . . . . . . .
Restarting application server processes . . .
Setting up HTTP session database persistence
IBM DB2 high availability configuration
administration . . . . . . . . . . . .
Failover in an IBM DB2 HADR configuration
Recovering from a failover in a DB2 clustered
configuration . . . . . . . . . . .
Engine tier failover recovery . . . . . . .
Recovering from an engine tier failover. . . Chapter 10. Managing logs . 139 . 139
. 139
. 139
. 141
. 143
. 143
. 145
. 146
147
. 148
148
. 150
. 150
. 151 . . . . . 155 Logging . . . . . . . . . . . . . . .
Logging components . . . . . . . . . . .
Logging configurations . . . . . . . . . .
Severity levels . . . . . . . . . . . .
Views of logged events . . . . . . . . . .
Shared and private views . . . . . . . .
Managing logging views in the console. . . . .
Creating a view of logged events in the console
Viewing logged events . . . . . . . . .
Editing a log view. . . . . . . . . . .
Copying a log view . . . . . . . . . .
Purging logged messages . . . . . . . .
Managing logging views in the IBM InfoSphere
Information Server Web console . . . . . . .
Creating a view of logged events in the IBM
InfoSphere Information Server Web console . .
Viewing log events in the IBM InfoSphere
Information Server Web console . . . . . .
Editing a log view in the IBM InfoSphere
Information Server Web console . . . . . .
Copying a log view in the IBM InfoSphere
Information Server Web console . . . . . .
Purging logged messages in the IBM InfoSphere
Information Server Web console . . . . . .
Managing logging by component . . . . . . 155
155
155
156
156
156
157
157
157
158
158
158
159
159
160
160
161
161
161 Chapter 11. Managing schedules . . . 165
Criteria for schedule views . . . . .
Shared and private views . . . . .
Creating a schedule view . . . . .
Creating a schedule view from a copy .
Viewing the schedules that are captured
schedule view . . . . . . . . . iv Administration Guide .
.
.
.
by
. .
.
.
. .
.
.
. .
.
.
. 165
166
166
166 . . . 167 a Pausing all the schedules in a view . . . . .
Resuming all the schedules in a view . . . .
Purging the history for all the schedules in a view
Working with the scheduled tasks in a view . .
Stopping a scheduled task . . . . . . .
Purging the history of a scheduled task . .
Viewing a list of completed schedules . . .
Viewing a list of running schedules . . . .
Viewing a list of upcoming scheduled tasks . . 167
. 167
168
. 168
. 168
. 168
. 169
. 169
. 169 Chapter 12. Backing up and restoring
IBM InfoSphere Information Server . . 171
Backing up IBM InfoSphere Information Server
components . . . . . . . . . . . . . . 171
File system elements and databases that require
backing up . . . . . . . . . . . . . 172
Restoring IBM InfoSphere Information Server
components . . . . . . . . . . . . . . 177 Chapter 13. Administering IBM
InfoSphere Information Server and
IBM WebSphere Application Server
services. . . . . . . . . . . . . . 179
Shutting down services (Windows) . . . . . .
Stopping IBM WebSphere Application Server
(Windows) . . . . . . . . . . . . .
Shutting down services (Linux, UNIX) . . . . .
Stopping IBM WebSphere Application Server
(Linux, UNIX) . . . . . . . . . . . .
Starting services (Windows) . . . . . . . .
Starting IBM WebSphere Application Server
(Windows) . . . . . . . . . . . . .
Starting services (Linux, UNIX) . . . . . . .
Starting IBM WebSphere Application Server
(Linux, UNIX) . . . . . . . . . . . .
IBM WebSphere Application Server process status
checking . . . . . . . . . . . . . . .
Checking the status of IBM WebSphere
Application Server (stand-alone installation) . .
Checking the status of IBM WebSphere
Application Server startup (stand-alone
installation) . . . . . . . . . . . . .
Checking the status of IBM WebSphere
Application Server startup (clustered
installation) . . . . . . . . . . . . .
Checking the status of IBM WebSphere
Application Server cluster members . . . . .
Checking the status of IBM WebSphere
Application Server node agents . . . . . .
Checking the status of the IBM WebSphere
Application Server Deployment Manager . . .
IBM WebSphere Application Server system log files 180
181
182
183
185
186
187
188
191
192 192 193
194
195
195
195 Chapter 14. Managing assets by using
the command line . . . . . . . . . 197
Using the istool command line . . . . . . . 197
Location of the istool command line . . . . . 197
Commands and common parameters for istool 198
Command modes for istool. . . . . . . . 202 Asset interchange . . . . . . . . . . . .
Common asset-interchange scenarios . . . .
InfoSphere Business Glossary assets . . . . . .
Export command for glossary assets . . . . .
Import command for glossary assets. . . . .
InfoSphere FastTrack assets . . . . . . . . .
Asset IDs . . . . . . . . . . . . . .
Export command for InfoSphere FastTrack
assets . . . . . . . . . . . . . . .
Import command for InfoSphere FastTrack
assets . . . . . . . . . . . . . . .
InfoSphere Information Analyzer assets . . . .
Export command for InfoSphere Information
Analyzer assets. . . . . . . . . . . .
Import command for InfoSphere Information
Analyzer assets. . . . . . . . . . . .
InfoSphere DataStage and QualityStage assets . .
Build package command . . . . . . . .
Deploy package command . . . . . . . .
Send package command . . . . . . . . .
Export command for InfoSphere DataStage and
QualityStage assets . . . . . . . . . .
Import command for InfoSphere DataStage and
QualityStage assets . . . . . . . . . .
Common metadata assets . . . . . . . . .
Importing and exporting common metadata
assets by using the command line . . . . . 202
205
206
206
207
208
209
210
211
214
214
215
217
217
219
221
222
227
229 Querying and deleting assets by using the
command line . . . . . . . . . .
Delete command for disconnected assets .
Reporting assets . . . . . . . . . .
Export command for reporting assets . .
Import command for reporting assets . .
Security assets . . . . . . . . . . .
Export command for security assets . . .
Import command for security assets . . . .
.
.
.
.
.
.
. .
.
.
.
.
.
.
. 237
248
249
250
252
254
255
257 Product accessibility . . . . . . . . 261
Accessing product documentation 263 Reading command-line syntax . . . . 265
Links to non-IBM Web sites . . . . . 267
Notices and trademarks . . . . . . . 269
Contacting IBM . . . . . . . . . . 273 Index . . . . . . . . . . . . . . . 275 229 Contents v vi Administration Guide Chapter 1. Administration overview
With IBM® InfoSphere™ Information Server, you can administer security,
entitlements, clusters and high availability configurations, logs, schedules, and
services, and back up data. Both the IBM InfoSphere Information Server console
and the IBM InfoSphere Information Server Web console provide administration
capabilities. Security administration
As part of InfoSphere Information Server administration, you set up and manage
suite security. Security administration includes the following tasks:
v Configuring and administering the user registry
The user registry holds user account information, such as user names and
passwords, that can be accessed during authentication. You choose a user
registry for the suite to use. You can choose the internal InfoSphere Information
Server user registry, or an external local operating system or lightweight
directory access protocol (LDAP) user registry. Depending on the registry you
choose and the topology of your installation, you might also have to map
credentials from one user registry to another.
v Controlling access
You create user accounts and groups. You assign roles to users and groups to
specify which features users can use and which projects a user can access. User
roles can be defined at several levels that build on one another.
v Auditing security-related events
Security-related events include all activities that set or modify security-related
settings and all user authentications and application access attempts. You
configure which events to log and how much information to include. You
monitor and analyze the log information to help prevent unauthorized access to
sensitive data.
v Administering account passwords
You periodically change administrator account passwords to comply with your
security policies. v Managing active user sessions
You view current active sessions, and manage session limits. If necessary, you
can force one user or all users to disconnect. Entitled IBM InfoSphere DataStage® edition and feature pack
administration
As part of InfoSphere Information Server administrator, you control activation of
InfoSphere DataStage editions and feature packs to comply with your Proof of
Entitlement from IBM. Administration includes the following tasks:
v Initial edition and feature pack activation
When you install InfoSphere DataStage, the InfoSphere Information Server
installation program prompts you to select the InfoSphere DataStage editions
and feature packs to install and activate. Select the items for which you have a
valid Proof of Entitlement from IBM. The installation program activates the
features that are associated with the items that you select. Any other editions or
feature packs are deactivated and cannot be used.
© Copyright IBM Corp. 2007, 2010 1 v Maintaining the list of activated items
If you later acquire entitlements for an additional InfoSphere DataStage edition
or feature pack, you must activate the item within InfoSphere Information
Server. If you no longer have entitlement for an item, you must deactivate it.
When you deactivate the edition or feature pack, the features within the item are
no longer available for use. Clusters and high availability configuration and administration
If a portion of your installation is set up in a clustered or high availability
configuration, you administer the cluster. Administration includes the following
tasks:
Administering an active-passive configuration administration
If one or more software tiers in your installation is set up in an active-passive
configuration, you monitor and manage the server pair. If a hardware or
network error causes a failover to the passive server, you recover projects and
restart any interrupted jobs. You can also force a failover to free the active server
for maintenance or upgrade tasks.
v Administering an application server cluster
v If the InfoSphere Information Server services tier is implemented in an IBM
WebSphere® Application Server cluster, you administer and maintain the cluster.
Tasks include adding cluster members, adding managed nodes, synchronizing
information between nodes, and restarting processes.
v Administering an IBM DB2® high availability configuration
If the metadata repository tier is implemented in a DB2 cluster or high
availability disaster recovery (HADR) configuration, you monitor the cluster. If a
failover occurs, you recover from a failover and restore service. Log administration
You can manage logs across all of the InfoSphere Information Server product
modules. Logs are stored in the metadata repository. Log administration includes
the following tasks:
v Configuring logging
You specify which logging categories and severity levels of logging events are
stored in the metadata repository. v Querying logs
You create log views in the IBM InfoSphere Information Server console and IBM
InfoSphere Information Server Web console. You use the views to retrieve and
query the logged events that are stored in the metadata repository. Scheduling administration
Many of the product modules use scheduling capabilities. For example, a report
run and an analysis job in IBM InfoSphere Information Analyzer are scheduled
tasks. Scheduling administration includes the following tasks:
v Creating, updating, and managing schedules
Schedule management is done within the product module. For example, you
create a schedule for a column analysis job to run weekly in an InfoSphere
Information Analyzer project in the console.
v 2 Administration Guide Viewing schedules You can obtain a global view of all the scheduled activities for all product
modules. With this data, you can ensure that enough resources are available to
process the schedules. You can monitor who schedules tasks and how often.
v Querying schedules
You can query all the schedules that are defined across all product modules. You
can check their status, history, and forecast. You can also do maintenance tasks
such as purging the scheduled execution history. You can stop or start existing
schedules to prevent system overload. Backup administration
To prevent the loss of data and to prepare for disaster recovery, you administer
regular backups. Backup administration includes the following tasks:
v Backing up InfoSphere Information Server components
You schedule and perform regular backups of all databases, profiles, libraries,
and other data.
v Restoring components
To recover your data in the event of a hardware failure or other disaster, you can
restore the data that you have backed up. Service administration
You administer InfoSphere Information Server services and WebSphere Application
Server services. Administration includes the following tasks:
Stopping and restarting services
Many maintenance and administration tasks require that you stop and restart
various InfoSphere Information Server services or WebSphere Application Server
services.
v Checking the status of services
You can determine the status of services for troubleshooting or other
maintenance tasks. v Asset administration
Assets include projects, templates, configuration specifications, parameter sets, and
all other information that is produced within the InfoSphere Information Server
product modules. The assets are stored in the metadata repository. Administration
includes the following tasks:
v Importing and exporting assets
To move assets from one InfoSphere Information Server installation to another,
you export the assets from one installation and import them into another. For
example, if you have a development system, a test system, and a production
system, you move assets between the systems.
v Querying and deleting assets
You can query certain assets and delete them as necessary. Administration tools
To administer InfoSphere Information Server, you use the following software tools:
v IBM InfoSphere Information Server console
The IBM InfoSphere Information Server console ("the console") ...
View
Full Document
