Managing PeopleSoft with Tivoli

Part 1. PeopleSoft, BEA TUXEDO, and Tivoli overviews......Page 21
1.1 What is PeopleSoft?......Page 23
1.2 What is BEA TUXEDO?......Page 24
1.2.2 BEA TUXEDO features......Page 25
1.3 Challenges in managing PeopleSoft......Page 27
1.4 Tivoli Enterprise Solutions......Page 28
1.4.1 Tivoli Framework......Page 29
1.4.4 Tivoli Distributed Monitoring......Page 30
1.4.6 Tivoli Global Enterprise Manager (GEM)......Page 31
1.4.7 Tivoli Decision Support......Page 32
1.4.9 Tivoli Storage Manager......Page 33
1.4.12 Tivoli Service Desk......Page 34
1.4.14 Tivoli Managers for databases......Page 35
1.4.15 Tivoli Manager for PeopleSoft......Page 36
1.4.16 Tivoli Manager for BEA TUXEDO......Page 38
1.5 Selecting the necessary Tivoli components......Page 40
1.6 Summary......Page 42
2.1.2 The two-tier model......Page 43
2.1.3 The three-tier model......Page 44
2.2.1.1 The BEA TUXEDO basic servers......Page 45
2.2.1.3 The PeopleSoft extension servers to BEA TUXEDO......Page 46
2.3.3 The Process Server Agent......Page 47
2.4 Tivoli naming convention for the PeopleSoft resources......Page 48
2.5.1 Configuration files for the Application Server......Page 50
2.6 PeopleSoft log files......Page 52
2.6.2 Process Scheduler log files......Page 53
2.7 PeopleSoft administration......Page 54
2.7.1 The team......Page 55
2.7.2.2 PSADMIN......Page 56
2.7.3.1 Monitoring Database components......Page 58
2.7.3.3 Monitoring the Process Scheduler......Page 59
2.7.3.7 Summary......Page 60
2.7.4.1 The network......Page 61
2.8 Summary......Page 62
3.1.2 Communication techniques for distributed applications......Page 63
3.1.2.2 Transaction......Page 64
3.2.1 Domain, machine, server group, server, service......Page 65
3.2.2 Basic administrative services......Page 68
3.2.3 Advanced BEA TUXEDO services......Page 69
3.3 BEA TUXEDO configuration file......Page 70
3.4 BEA TUXEDO log files......Page 72
3.5.1.1 Using tmadmin......Page 73
3.5.2 Troubleshooting BEA TUXEDO......Page 75
3.6 Summary......Page 76
Part 2. Tivoli Manager for BEA TUXEDO......Page 79
4.1 Our BEA TUXEDO environment......Page 81
4.1.1 Configuration of BEA TUXEDO required by the Tivoli Manager......Page 82
4.1.1.2 How to modify the subscriptions file?......Page 83
4.2 Our Tivoli environment without Tivoli Manager for BEA TUXEDO......Page 84
4.3.1 How to back up the Tivoli databases?......Page 90
4.3.2 How to restore the Tivoli databases?......Page 92
4.4.1.1 Manual upgrade......Page 94
4.4.1.2 Automatic upgrade......Page 96
4.4.2 Installing patches......Page 97
4.4.3 Installing the application proxy......Page 99
4.4.4 Installing the Tivoli Manager for BEA TUXEDO......Page 103
4.5 Resources created by the Tivoli Manager for BEA TUXEDO......Page 105
4.6 Our Tivoli environment with Tivoli Manager for BEA TUXEDO......Page 109
4.7 Uninstalling Tivoli Manager for BEA TUXEDO......Page 113
4.8 Configuring the Tivoli Manager for BEA TUXEDO......Page 115
4.8.2 Configuring the TEC event server for BEA TUXEDO......Page 118
4.8.3 Configuring a TEC console for BEA TUXEDO......Page 123
4.8.4 Modifying some parameters of the TEC event server......Page 125
4.8.5.1 What is the Tuxedo Discovery?......Page 126
4.8.5.3 What are the requirements for the Tuxedo discovery to run?......Page 127
4.8.5.5 Tuxedo Discovery process flow......Page 128
4.8.5.6 Tuxedo Discovery audit trails......Page 131
4.8.5.7 How to run the Tuxedo Discovery from the desktop?......Page 132
4.8.5.8 How to run the Tuxedo Discovery from the command line?......Page 135
4.8.6 Configuring the Tuxedo log file adapter......Page 136
4.8.6.2 Configuring the TUXEDO log file adapter: Behind the scenes......Page 137
4.8.6.3 Listing the log file adapter’s configuration files......Page 139
4.8.6.4 Uninstalling the log file adapter......Page 141
4.8.6.5 How to customize the log file adapter for BEA TUXEDO......Page 142
4.8.7 Creating a new Tuxedo policy region......Page 147
4.9 Object hierarchy for Tivoli Manager for BEA TUXEDO......Page 149
4.10 Configuring GEM for BEA TUXEDO......Page 151
4.10.1 Having the tuxedo_gem rule set loaded......Page 152
4.10.2 Installing the GEM instrumentation for BEA TUXEDO......Page 155
4.10.3 Loading the BEA TUXEDO AMP file......Page 156
4.10.4 Discovering the BEA TUXEDO resources in GEM......Page 158
4.10.5 GEM aggregation considerations......Page 162
4.11 Installing the Decision Support guide for BEA TUXEDO......Page 163
4.11.1 Prerequisite software......Page 164
4.11.3 Installing the BEA TUXEDO guide......Page 165
Scripts for MS SQL Server......Page 166
4.11.5 Setting up an ODBC connection......Page 167
4.11.5.2 Ensuring proper ODBC driver installation and setup......Page 168
4.11.6 Importing the BEA TUXEDO guide......Page 170
4.11.7 Adding the data source......Page 173
4.11.8 Assigning the data source......Page 175
4.11.9 Building BEA TUXEDO cubes......Page 176
4.11.9.1 Manual build process......Page 177
4.11.9.2 Automated build process......Page 178
4.12 Summary......Page 181
5.1 Available interfaces to perform BEA TUXEDO operations......Page 183
5.2 Process flow when performing BEA TUXEDO operations......Page 186
5.3 Discovering BEA TUXEDO objects after the initial Discovery......Page 188
5.3.1 How to schedule a Tuxedo discovery?......Page 189
5.4 Booting or shutting down BEA TUXEDO components......Page 192
5.5 Checking the status of BEA TUXEDO components......Page 196
5.7 Archiving and purging log files......Page 199
5.8 Displaying and cleaning the IPC resources......Page 201
5.9 Performing a shutdown and cleaning the IPC resources......Page 205
5.10 Issuing getmib or setmib commands......Page 208
5.11 Issuing a tmadmin command......Page 211
5.12 Displaying and changing the status of the tlisten process......Page 213
5.13.1 Archiving log files in a path specified by the administrator......Page 215
5.13.2 Turning a trace on or off on a service......Page 220
5.13.3 Advertising or unadvertising a service......Page 222
5.13.4 Finding all the queue spaces in a BEA TUXEDO domain......Page 225
5.13.5 Getting information about queues in a queue space......Page 227
5.13.6 Getting information about messages in a queue......Page 229
5.14.1 The Tuxedo Additional Tasks task library......Page 231
5.14.2.1 Scripts for the TUXEDO_Archive_Log task......Page 233
5.14.2.2 Scripts for the TUXEDO_Application_Trace task......Page 234
5.14.2.5 Scripts for the TUXEDO_Query_QSpace task......Page 235
5.14.3 The Task Library Language definition file (*.tll file)......Page 236
5.15 Summary......Page 237
6.1 Availability process flow for the BEA TUXEDO resources......Page 239
6.2.1 How to start the log file adapter......Page 241
6.2.3 Default settings for some Tuxedo monitors......Page 244
6.2.4 How to set a Tuxedo monitor......Page 246
6.2.5 How to activate the Tuxedo monitors?......Page 250
6.2.6 Additional and custom monitors......Page 251
6.2.6.3 Checking the number of messages in the error queue of /Q......Page 252
6.2.7.1 Script to check the number of open transactions......Page 253
6.2.7.3 Create a monitoring collection with MCSL......Page 255
6.3 Event processing......Page 260
6.3.1 Process Status event from the discovery......Page 261
6.3.2 Monitor events......Page 262
6.3.3 Log file adapter events......Page 263
6.3.4 General rules......Page 264
6.3.5.1 Server rules......Page 266
6.3.5.2 Domain rules......Page 269
6.4 Event presentation in GEM......Page 273
6.4.1 GEM information flow......Page 274
6.4.2 GEM Server operation......Page 275
6.4.2.1 Start or stop the GEM server in UNIX......Page 276
6.4.2.3 Clean up the GEM database......Page 278
6.4.3 GEM Console navigation......Page 279
6.4.4 GEM Console operation......Page 285
6.4.5 Advanced GEM customization......Page 287
6.4.5.1 Adding a task to a Tuxedo Domain object in GEM......Page 288
6.4.5.2 Adding a monitor to a Tuxedo Machine object in GEM......Page 294
6.5.1 Topics and views......Page 298
6.5.2 View the data with the Tivoli Discovery Interface......Page 299
6.5.3 Sample views......Page 300
6.6 Summary......Page 307
Part 3. Managing PeopleSoft......Page 309
7.1.1 Installation......Page 311
7.1.2 Resources added by Tivoli Manager for Oracle - Framework......Page 312
7.1.3 Oracle database managed resource......Page 313
7.1.4 Manipulating an Oracle Instance......Page 319
7.2.1 Resources added by Tivoli Manager for Oracle - DM......Page 323
7.2.2 Oracle monitors for PeopleSoft......Page 324
Settings of Extents monitor......Page 325
Usage of Maximum Extents monitor......Page 326
7.2.2.3 PeopleSoft Temporary Extents monitor......Page 327
7.2.2.4 PeopleSoft Free Space Deficit monitor......Page 328
Settings of Free Space Deficit monitor......Page 329
Settings of Free Space Fragmentation monitor......Page 330
Settings of Free TableSpace monitor......Page 331
7.2.3 Activating the Monitors for Oracle......Page 332
7.2.4.1 A new rule base including Oracle and Tuxedo......Page 334
7.2.4.2 Creating an event group for Oracle......Page 337
7.3.1 Resources added......Page 340
7.3.2 Using Tivoli Manager for Oracle - User Management......Page 341
7.3.2.1 Creating User Management Profiles......Page 342
Populating a Database User Profile......Page 344
Editing Database User Records......Page 346
Distributing a User Database Profile......Page 347
7.3.2.3 Manipulating Database Roles Profiles......Page 348
7.4 Summary......Page 350
8.1 Overview of our PeopleSoft environment......Page 351
8.1.1 Configuration of PeopleSoft required by the Tivoli Manager......Page 352
8.1.1.3 How to modify the subscriptions file?......Page 353
8.1.1.5 Modification in the psprcs.cfg file......Page 354
8.1.1.7 Activating the new settings for the Application Server......Page 355
8.2 Our Tivoli environment without any Managers......Page 356
8.3 Installation steps......Page 361
8.3.1 Installation of the Tivoli Manager for BEA TUXEDO......Page 362
8.3.2 Installation of the Tivoli Manager for Oracle......Page 363
8.3.3 Installation of the Tivoli Manager for PeopleSoft......Page 364
8.4 Resources created by the Tivoli Manager for PeopleSoft......Page 365
8.5 Overview of our environment with the Managers......Page 372
8.6 Uninstalling the Tivoli Managers......Page 375
8.6.1 Uninstalling Tivoli Manager for PeopleSoft......Page 376
8.7 Configuring Tivoli Manager for PeopleSoft......Page 377
8.7.1 Administration roles......Page 380
8.7.2 Configuring the TEC event server for PeopleSoft......Page 381
8.7.3 Configuring a TEC console for PeopleSoft......Page 386
8.7.5 Running the PeopleSoft Discovery......Page 389
8.7.5.2 Why and when to run the PeopleSoft Discovery?......Page 390
8.7.5.3 Requirements for running the PeopleSoft Discovery......Page 391
8.7.5.4 PeopleSoft Discovery behind the scenes......Page 392
8.7.5.5 PeopleSoft Discovery process flow......Page 393
8.7.5.6 PeopleSoft Discovery audit trails......Page 395
8.7.5.7 How to run the PeopleSoft Discovery from the desktop......Page 396
8.7.5.8 How to run the PeopleSoft Discovery from the command line......Page 400
8.7.6.1 What are the PeopleSoft log file adapters?......Page 401
8.7.6.2 Behind the scene of the PeopleSoft log file adapters......Page 402
8.7.6.4 Log file adapter for the Tuxedo log files......Page 404
8.7.6.5 Log file adapter for the Process Server Agent......Page 405
8.7.6.6 Listing the log file adapter’s configuration files......Page 406
8.7.6.7 Uninstalling the log file adapter......Page 408
8.8 Object hierarchy for Tivoli Manager for PeopleSoft......Page 410
8.9 Configuring GEM for PeopleSoft......Page 412
8.9.1 Installing the GEM instrumentation for PeopleSoft......Page 413
8.9.2 Loading the PeopleSoft AMP file......Page 414
8.9.3 Discovering the PeopleSoft resources in GEM......Page 416
8.9.4 GEM aggregation considerations......Page 420
8.10 Installing the Decision Support guide for PeopleSoft......Page 421
8.10.1 Prerequisite software......Page 422
8.10.4 Customizing the TEC database......Page 423
Scripts for Oracle......Page 424
8.10.5.1 Ensuring database client/server connectivity......Page 425
8.10.5.2 Ensuring proper ODBC driver installation and setup......Page 426
8.10.6 Importing the PeopleSoft guide......Page 428
8.10.7 Adding the data source......Page 431
8.10.8 Assigning the data source......Page 433
8.10.9 Building the PeopleSoft cubes......Page 434
8.10.9.1 Manual build process......Page 435
8.10.9.2 Automated build process......Page 436
8.10.10 Summary......Page 439
9.1 Available interfaces to perform PeopleSoft operations......Page 441
9.2 Process flow when performing PeopleSoft operations......Page 444
9.3 Discovering PeopleSoft objects after the initial discovery......Page 446
9.3.1 How to schedule a PeopleSoft discovery......Page 447
9.4 Booting or shutting down PeopleSoft components......Page 451
9.5 Checking the status of PeopleSoft components......Page 455
9.7 Archiving and purging log files......Page 456
9.8 Tuxedo operation tasks......Page 460
9.9 Summary......Page 461
10.1 Availability process flow for the PeopleSoft components......Page 463
10.2.1 How to start the log file adapter......Page 465
10.2.2 The PeopleSoft monitors collection......Page 468
10.2.4 Default settings for some PeopleSoft monitors......Page 469
10.2.5 How to activate PeopleSoft monitors......Page 472
10.2.6 Database Status monitor for PeopleSoft......Page 473
10.3 Event processing......Page 482
10.3.1 Process Status event from the discovery......Page 484
10.3.2 Monitors events......Page 486
10.3.3 Log file adapter events......Page 487
10.3.4 General rules......Page 489
10.3.5.1 Tuxedo Server rules......Page 491
10.3.5.2 Process Server Agent Rule......Page 494
10.3.5.3 Application Server rules......Page 496
10.3.5.4 PeopleSoft Instance rules......Page 500
10.3.5.5 PeopleSoft System rules......Page 504
10.4 Event presentation in GEM......Page 507
10.4.1 GEM Console navigation......Page 508
10.4.2 GEM Console operation......Page 515
10.5.1 Topics and Views of the PeopleSoft cubes......Page 517
10.5.2 View the data with the Tivoli Discovery Interface......Page 519
10.5.3 Sample views......Page 520
10.6 Summary......Page 526
11.1.2 Transaction simulation......Page 527
11.1.3 An integrated system management solution......Page 528
11.1.4 Performance management process......Page 529
11.2.1 TAPM prerequisites......Page 531
11.2.2.1 Database setup......Page 532
11.2.3 TAPM installation......Page 533
11.2.3.2 Installing on the endpoint......Page 534
11.2.5 Creating the RIM object......Page 535
11.3 Sample script creation using WinRunner......Page 536
11.3.1 Recording a business process......Page 537
11.3.2 Saving GUI map......Page 540
11.3.3 Verifying script execution......Page 541
11.3.4 Preparing a script for TAPM......Page 543
11.4.1 Registering virtual user scripts......Page 547
11.4.3 Simulated transaction settings......Page 548
11.4.4 Profile distribution......Page 551
11.5 Performance data collection......Page 552
11.5.1 The aggregation and uploading process......Page 553
11.6 Reporting performance data......Page 554
11.6.1 Building the cubes......Page 555
11.6.2 Using the guide......Page 556
11.6.3 Sample views......Page 557
11.7.2 Editing the profile......Page 559
11.7.3 Distributing the profile......Page 561
11.8 Summary......Page 562
12.1 What is TWS Extended Agent for PeopleSoft?......Page 563
12.3 TWS PeopleSoft Extended Agent software requirements......Page 564
12.4 Workload Scheduler integrated with PeopleSoft......Page 565
12.5.2 Installation of TWS PeopleSoft Extended Agent......Page 566
12.5.3 Setting up the PeopleSoft environment......Page 569
12.5.3.1 Recompiling PTPUPRCS.exe......Page 570
12.5.3.2 Running the data mover script......Page 571
12.5.3.3 Defining a PeopleSoft Extended Agent workstation......Page 573
12.5.4 Defining PeopleSoft jobs in TWS......Page 576
12.6 Summary......Page 580
Part 4. Appendixes......Page 581
A.1.1 Configuration file for the multiple machine domain domlabq......Page 583
A.1.2 Configuration file for the single machine domain sdombrewster......Page 584
A.1.3 Configuration file for the single machine domain singdomnt......Page 585
A.2 The command interpreter tmadmin......Page 586
A.3 ULOG file......Page 588
A.4 ULog.fmt file for the log file adapter......Page 590
A.5 Tuxedo event classes hierarchy......Page 599
A.6.2 Checking the number of messages in the reliable queue /Q......Page 601
A.6.3 Checking the number of messages in the error queue of /Q......Page 602
A.6.4 Generic monitor script......Page 603
A.7.1 TLL Definition file......Page 604
A.7.2 Shell script for the TUXEDO_Archive_Log task......Page 607
A.7.3 Shell script for the TUX4009_Archive_Log_X task......Page 609
A.7.4 Shell script for the TUXEDO_Application_Trace task......Page 613
A.7.5 Shell script for the TUXEDO_Advertise_Service task......Page 614
A.7.6 Shell script for the TUXEDO_Unadvertise_Service task......Page 615
A.7.7 Shell script for the TUX4009_Query_QSpace_X task......Page 616
A.7.9 Shell script for the TUX4009_Query_Queue_X task......Page 617
A.7.10 Shell script for the TUXEDO_Query_Queue_Messages task......Page 618
A.7.11 Shell script for the TUX4009_Query_Q_Msg_X task......Page 619
B.1.2 TuxLog.fmt file for the Tuxedo Domain......Page 621
B.1.4 Log.fmt file for the Process Server Agent......Page 632
B.2 PeopleSoft event classes hierarchy......Page 633
Appendix C. Special notices......Page 635
D.1 Using the CD-ROM......Page 639
D.2 Locating the additional material on the Internet......Page 640
E.3 Other resources......Page 643
E.4 Referenced Web sites......Page 644