Administration Guide.pdf - IBM InfoSphere Information Server Version 8 Release 5 Administration Guide SC18-9929-04 IBM InfoSphere Information Server

Administration Guide.pdf - IBM InfoSphere Information...

This preview shows page 1 out of 289 pages.

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture