Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
DB2 integrated cluster environment deployment guide [[electronic resource] /] / Whei-Jen Chen ... [et al.]
| DB2 integrated cluster environment deployment guide [[electronic resource] /] / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : International Technical Support Organization, c2004 |
| Descrizione fisica | 408 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910449861403321 |
| [San Jose, Calif.], : International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 integrated cluster environment deployment guide [[electronic resource] /] / Whei-Jen Chen ... [et al.]
| DB2 integrated cluster environment deployment guide [[electronic resource] /] / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : International Technical Support Organization, c2004 |
| Descrizione fisica | 408 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783527903321 |
| [San Jose, Calif.], : International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 integrated cluster environment deployment guide / / Whei-Jen Chen ... [et al.]
| DB2 integrated cluster environment deployment guide / / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : International Technical Support Organization, c2004 |
| Descrizione fisica | 408 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Acknowledgement -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Why DB2 on Linux -- 1.1.1 DB2 + Linux = Versatility -- 1.1.2 Versatility + eServers = Value -- 1.2 What is a cluster -- 1.2.1 Cluster types -- 1.2.2 DB2 partitioned databases -- 1.3 The DB2 Integrated Cluster Environment solution -- 1.3.1 The ingredients for success -- 1.4 Benefits of DB2 Integrated Cluster Environment -- 1.4.1 Scalability pays great returns -- 1.4.2 Proven performance at a low cost -- 1.4.3 High levels of availability -- 1.4.4 Easily managed -- 1.4.5 Seamless interoperability -- 1.5 DB2 Architecture -- 1.5.1 DB2 database access -- 1.6 Summary -- Chapter 2. Selecting your cluster -- 2.1 Platform -- 2.1.1 IA32 (and x86) -- 2.1.2 AMD64 (and x86-64) -- 2.1.3 Platform selection -- 2.2 Server types and models -- 2.2.1 1U "Pizza-box" - x335 -- 2.2.2 AMD64 "Pizza-box" - e325 -- 2.2.3 2U 2P - x345 -- 2.2.4 4P - x365 -- 2.2.5 HS20 (2-way -- 14 Blades in a 7U unit) -- 2.2.6 Server selection -- 2.3 Storage -- 2.3.1 Localized vs. centralized storage topologies -- 2.3.2 Enterprise Storage Servers (ESSs) -- 2.3.3 DS4000 series -- 2.3.4 Direct Attached Fibre Storage (EXP) -- 2.3.5 Direct-attached SCSI storage (ServeRAID™) -- 2.3.6 Network Attached Storage (NAS) -- 2.3.7 Storage selection -- 2.4 Network interconnect -- 2.4.1 InfiniBand option -- 2.4.2 Network selection -- 2.5 Linux distribution -- 2.5.1 Validated enterprise-class Linux distributions -- 2.5.2 Linux distribution selection -- 2.6 Sample configurations -- 2.6.1 A 32-bit configuration -- 2.6.2 A Scaled-out 32-bit configuration -- 2.6.3 A 64-bit benchmark configuration -- 2.6.4 A 4-way building block -- 2.7 Summary -- Chapter 3. Planning and design.
3.1 Steps for building a large partitioned database -- 3.2 Disk considerations -- 3.2.1 Summary of the most popular RAID levels -- 3.2.2 Data placement -- 3.2.3 Log placement -- 3.2.4 Data availability and performance -- 3.2.5 General storage performance recommendations -- 3.3 Database design considerations -- 3.3.1 Understand data partitioning -- 3.3.2 Define the number of database partitions -- 3.3.3 Define database partition groups -- 3.3.4 Design the table spaces -- 3.3.5 Understand partitioning map -- 3.3.6 Choose the partitioning key -- 3.3.7 Size the tables -- 3.3.8 Size for MDC utilization -- 3.3.9 Size for MQT utilization -- 3.3.10 Configure DB2 UDB -- 3.3.11 Recommended parameters for performance -- 3.3.12 Naming conventions -- Chapter 4. Implementation -- 4.1 Lab environment -- 4.1.1 Hardware environment -- 4.1.2 Software environment -- 4.1.3 Topology of the lab environments -- 4.2 Prepare your Linux OS for DB2 Integrated Cluster Environment -- 4.2.1 Basic requirements -- 4.2.2 Installation planning and preparation -- 4.3 DB2 partitioned database setup -- 4.3.1 Considerations on DB2 installation -- 4.3.2 Preparations for DB2 UDB product installation -- 4.3.3 DB2 UDB product installation -- 4.3.4 Preparation for instance creation -- 4.3.5 Instance creation -- 4.3.6 Node configuration -- 4.3.7 Preparation for database directory (optional) -- 4.3.8 Database creation -- 4.3.9 Data loading -- 4.4 Post installation tasks - Initial tuning -- 4.4.1 Tuning your DB2 through Configuration Advisor GUI tool -- 4.4.2 Tuning your DB2 by using the autoconfigure command -- 4.4.3 Important DB2 registry and environment variables -- 4.4.4 Validating logical database design with the DB2 Design advisor -- Chapter 5. Operations and administration -- 5.1 Manageability enhancements -- 5.1.1 Health Center enhancements -- 5.1.2 Automated log file management. 5.1.3 Self-tuning for backup and restore -- 5.1.4 Recover database -- 5.1.5 Automatic setting of prefetch size -- 5.2 Monitoring -- 5.2.1 DB2 instruments -- 5.2.2 Linux tools -- Chapter 6. High availability -- 6.1 Introduction -- 6.1.1 What is high availability -- 6.1.2 Types of high availability -- 6.1.3 High availability in clusters -- 6.1.4 Failover in a highly available cluster -- 6.1.5 High-availability clustering configurations -- 6.1.6 High-availability software solutions -- 6.1.7 Automatic Client Reroute -- 6.2 TSA implementation -- 6.2.1 TSA fundamentals -- 6.2.2 TSA installation -- 6.2.3 TSA resource planning for an HA DB2 cluster -- 6.2.4 Basic implementation with the regdb2salin script -- 6.2.5 Advanced implementation -- 6.2.6 Scaling out your HA DB2 clusters -- 6.2.7 Notes on Logical Volume Manager -- Chapter 7. Scaling -- 7.1 Introduction to scalability -- 7.1.1 Scale-up vs. scale-out -- 7.1.2 Scalability dimensions -- 7.2 Scaling up -- 7.2.1 Adding additional processors -- 7.2.2 Taking advantage of greater parallelism -- 7.2.3 Adding additional memory -- 7.3 Scaling out -- 7.3.1 Preparing the new servers -- 7.3.2 Moving database partitions without data redistribution -- 7.3.3 Adding database partitions -- 7.3.4 Data redistribution via REDISTRIBUTE command -- 7.3.5 Alternate methods of data redistribution -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910823612103321 |
| [San Jose, Calif.], : International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB exploitation of the Windows environment [[electronic resource] /] / Whei-Jen Chen ... [et al.]
| DB2 UDB exploitation of the Windows environment [[electronic resource] /] / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xxiv, 540 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana |
IBM redbooks
DB2 information management software |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450150103321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB exploitation of the Windows environment [[electronic resource] /] / Whei-Jen Chen ... [et al.]
| DB2 UDB exploitation of the Windows environment [[electronic resource] /] / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xxiv, 540 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana |
IBM redbooks
DB2 information management software |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783104503321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB exploitation of the Windows environment / / Whei-Jen Chen ... [et al.]
| DB2 UDB exploitation of the Windows environment / / Whei-Jen Chen ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xxiv, 540 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana |
IBM redbooks
DB2 information management software |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 DB2 UDB overview -- 1.1.1 DB2 family -- 1.1.2 DB2 UDB for Windows, UNIX, and Linux -- 1.2 DB2 UDB products on Windows -- 1.2.1 Product descriptions -- 1.2.2 Try and buy product availability -- 1.3 Planning considerations -- 1.3.1 Product selection guidelines -- 1.3.2 Sample scenarios -- 1.4 DB2 UDB Version 8 highlights -- 1.5 DB2 UDB integration with Microsoft Windows -- 1.5.1 Built for the Windows environment -- Chapter 2. Installation and deployment -- 2.1 Installation preparation and considerations -- 2.1.1 Installation overview for DB2 servers on Windows -- 2.1.2 Installation requirements -- 2.1.3 Authorization considerations -- 2.1.4 FixPak considerations -- 2.1.5 Migration considerations -- 2.2 Installation wizard (single installation) -- 2.2.1 Server installation -- 2.2.2 Client installation -- 2.3 Installation profile -- 2.3.1 Server installation -- 2.3.2 Client installation -- 2.4 Enterprise deployment with Microsoft SMS -- 2.4.1 Creating DB2 UDB packages -- 2.5 Active Directory Services -- 2.5.1 Active Directory Overview -- 2.5.2 Extending the Active Directory -- 2.5.3 Installing the MMC Snap-In Extension -- 2.5.4 Enabling DB2 Active Directory support -- 2.5.5 Managing the Active Directory -- Chapter 3. Post-installation tasks -- 3.1 Introduction -- 3.2 Using the Control Center -- 3.3 Database creation -- 3.4 Configuration advisor -- 3.5 Populating your database -- 3.5.1 Table creation -- 3.5.2 Loading data -- 3.5.3 Moving data -- 3.6 Design Advisor Wizard -- 3.6.1 Using the Design Advisor Wizard -- Chapter 4. Security -- 4.1 Understanding Windows security -- 4.1.1 Basic security concepts -- 4.1.2 Windows 2000 domains.
4.2 System level security -- 4.2.1 DB2 service accounts -- 4.2.2 DB2 user authentication -- 4.2.3 DB2 group enumeration -- 4.3 Instance level security -- 4.3.1 Default instance security -- 4.3.2 DAS Administrator Authority (DASADM) -- 4.3.3 DB2 System Administrators Authority (SYSADM) -- 4.3.4 DB2 System Control Authority (SYSCTRL) -- 4.3.5 DB2 System Maintenance Authority (SYSMAINT) -- 4.3.6 DB2 directory security -- 4.4 Database level security -- 4.4.1 Database authorities -- 4.4.2 Database privileges -- 4.4.3 Data encryption -- 4.4.4 Auditing database transactions -- Chapter 5. Performance -- 5.1 Performance tuning overview -- 5.1.1 Measuring system performance -- 5.1.2 Determining when system tuning will be cost-effective -- 5.1.3 Causes of performance problems -- 5.1.4 Deciding when to tune the system -- 5.1.5 Planning performance tuning -- 5.2 Primary Windows performance factors -- 5.2.1 System hardware -- 5.2.2 Operating system software -- 5.3 Primary DB2 performance factors -- 5.3.1 Configuration parameter introduction -- 5.3.2 Memory -- 5.3.3 Processor -- 5.3.4 Storage -- 5.3.5 Network -- 5.3.6 Other performance factors -- 5.4 System optimization -- 5.4.1 Windows system optimization -- 5.4.2 DB2 system optimization -- Chapter 6. Monitoring and management -- 6.1 General system monitoring considerations -- 6.1.1 Introduction -- 6.1.2 Things that you should consider when monitoring -- 6.1.3 Monitor types -- 6.1.4 Obtaining the data from the monitors or monitor interfaces -- 6.1.5 Information generation -- 6.2 Common resources to monitor -- 6.2.1 Memory -- 6.2.2 Disk -- 6.2.3 Network -- 6.2.4 Security -- 6.3 Windows system monitoring and tools -- 6.3.1 Task Manager -- 6.3.2 Performance Monitor and alert -- 6.3.3 Event viewer -- 6.4 DB2 monitoring capability -- 6.4.1 Log files -- 6.4.2 Health Center and Memory Visualizer. 6.4.3 DB2 Event Monitor -- 6.4.4 DB2 Governor -- Chapter 7. High availability -- 7.1 Database features for high availability -- 7.1.1 Buffer pool management -- 7.1.2 Tablespace management -- 7.1.3 Configuration parameters -- 7.1.4 Loading data -- 7.1.5 Reorganizing data -- 7.1.6 Database recovery -- 7.1.7 Application processing -- 7.2 Monitoring instances for high availability -- 7.2.1 Services Recovery -- 7.3 Standby servers for high availability -- 7.3.1 Online Split Mirror Images -- 7.4 Clustered servers for high availability -- 7.4.1 Overview of Microsoft Cluster Service -- 7.4.2 Before installing Microsoft Cluster Service -- 7.4.3 Installing Microsoft Cluster Service -- 7.4.4 After installing Microsoft Cluster Service -- 7.4.5 Before enabling DB2 MSCS support -- 7.4.6 Enabling DB2 MSCS support -- 7.4.7 After enabling DB2 MSCS support -- 7.5 Windows Datacenter Program for high availability -- Chapter 8. Application development -- 8.1 DB2 developer tools -- 8.1.1 Development Center -- 8.1.2 Project Deployment Tool -- 8.1.3 Command Center -- 8.1.4 SQL Assist -- 8.1.5 Visual Explain -- 8.1.6 Command-line Explain tools -- 8.2 Language support -- 8.2.1 Visual Basic -- 8.2.2 Visual C++ -- 8.2.3 Java -- 8.2.4 COBOL -- 8.3 Migration Toolkit (MTK) -- 8.4 Application development tips -- 8.4.1 Tips to write better SQL statements -- 8.4.2 Minimizing data movement between applications and database -- 8.4.3 Considerations for embedded SQL programs -- 8.4.4 Considerations for Call Level Interface and ODBC -- Chapter 9. Windows scripting -- 9.1 Introduction -- 9.1.1 Designing DBA scripts -- 9.1.2 Choosing which DBA tasks to include in scripts -- 9.2 Windows shell scripting (Wshell) -- 9.2.1 DB2 CLP scripting -- 9.3 Windows Script Host (WSH) -- 9.3.1 VBScript scripting -- 9.3.2 JScript scripting -- 9.3.3 Perl scripting -- 9.3.4 Object REXX. 9.4 Scripting with DB2's WMI providers -- 9.4.1 Windows Management Instrumentation (WMI) -- 9.5 Scripting with ADSI -- 9.6 Scheduling and managing scripts -- Appendix A. Advanced scripting -- Leveraging COM -- Active Data Object (ADO) -- Active Server Pages (ASP) -- Sample code -- List data dictionary (tables and columns definitions) -- Listing all DB2 objects -- List all tables, owners, schema and table creation date -- List all tables and table owners -- List table and tablespace size definitions -- List all userids in DB2 database -- Start the DB2 database service on a server -- Stop DB2 database service on a server -- Reporting tool through an interactive Web server form -- Running SQL from a batch file -- Running any SQL from a command prompt -- Running a report (static query) -- User account managment -- Appendix B. Sample REXX programs -- dbrxbackup.rexx -- dbrxbackup.wsf -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover. |
| Record Nr. | UNINA-9910818499403321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB V8 and WebSphere V5 performance tuning and operation guide [[electronic resource] /] / [Whei-Jen Chen ... et al.]
| DB2 UDB V8 and WebSphere V5 performance tuning and operation guide [[electronic resource] /] / [Whei-Jen Chen ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xvi, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910449924003321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB V8 and WebSphere V5 performance tuning and operation guide [[electronic resource] /] / [Whei-Jen Chen ... et al.]
| DB2 UDB V8 and WebSphere V5 performance tuning and operation guide [[electronic resource] /] / [Whei-Jen Chen ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xvi, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783102203321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB V8 and WebSphere V5 performance tuning and operation guide / / [Whei-Jen Chen ... et al.]
| DB2 UDB V8 and WebSphere V5 performance tuning and operation guide / / [Whei-Jen Chen ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xvi, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 IBM On Demand era -- 1.1.1 The IBM On Demand operating environment -- 1.2 Why DB2 UDB and WebSphere -- 1.3 Key areas of performance -- 1.3.1 Hardware -- 1.3.2 Operating system -- 1.3.3 Application Server and WebServer -- 1.3.4 Database manager -- 1.3.5 Application programs -- 1.4 Performance tuning guidelines -- 1.4.1 Initial efforts always pay -- 1.4.2 Tune the identified constraints -- 1.4.3 Change one parameter at a time -- 1.4.4 Consider the entire system -- 1.4.5 Hardware upgradation -- 1.4.6 Follow performance tuning process and proper documentation -- 1.5 Process of performance tuning -- 1.5.1 Developing a performance-improvement process -- 1.5.2 Performance-tuning limits -- Chapter 2. Overview of WebSphere Application Server V5 -- 2.1 Java 2 Enterprise Edition (J2EE) overview -- 2.1.1 J2EE platform roles -- 2.1.2 J2EE benefits -- 2.1.3 Application components and their containers -- 2.1.4 Standard services -- 2.1.5 J2EE packaging -- 2.2 WebSphere Application Server V5 product family -- 2.3 WebSphere Application Server runtime architecture -- 2.3.1 WAS Version 5 base runtime architecture -- 2.3.2 WAS Version 5 Network Deployment runtime architecture -- 2.3.3 Architectural features -- 2.4 WebSphere Application Server V5 tools -- 2.4.1 Tools for installing, upgrading, and migrating -- 2.4.2 Tools for assembling applications -- 2.4.3 Tools for deploying and administering -- 2.4.4 Tools for monitoring and tuning -- 2.4.5 Tools for troubleshooting -- 2.5 WAS V5.0.2 and Supported J2EE APIs -- 2.5.1 What is new in WebSphere Application Server V5.0.2 -- 2.5.2 Supported J2EE APIs in WAS 5.0.2 -- Chapter 3. Overview of DB2 UDB V8 -- 3.1 DB2 UDB product family.
3.1.1 DB2 Everyplace® -- 3.1.2 DB2 Express -- 3.1.3 DB2 UDB Personal Edition (PE) -- 3.1.4 DB2 UDB Workgroup Server Edition (WSE) -- 3.1.5 DB2 UDB Enterprise Server Edition (ESE) -- 3.2 DB2 architecture overview -- 3.2.1 Process model -- 3.2.2 Memory model -- 3.2.3 Storage model -- 3.2.4 Key performance-related areas -- 3.3 Tools -- 3.3.1 IBM DB2 UDB Performance Expert for Multiplatforms -- 3.3.2 IBM DB2 UDB Recovery Expert for Multiplatforms -- 3.3.3 IBM DB2 High Performance Unload for Multiplatforms -- 3.3.4 IBM DB2 UDB Table Editor for Multiplatforms -- 3.3.5 IBM DB2 UDB Web Query Tool for Multiplatforms -- Chapter 4. DB2 UDB V8 and WAS V5 integrated environment -- 4.1 WebSphere session manager -- 4.1.1 HttpSession interface -- 4.2 Enterprise JavaBeans -- 4.2.1 EJB overview -- 4.3 Typical application flow -- 4.4 Topology selection -- 4.4.1 Selection criteria -- 4.4.2 Performance and scalability -- 4.4.3 Single machine topology -- 4.4.4 Separating the HTTP server -- 4.4.5 Separating the DB2 UDB server -- 4.4.6 Separating the Web container and the EJB container -- 4.4.7 Vertical scaling -- 4.4.8 Horizontal scaling with clusters -- 4.4.9 Session persistence considerations -- 4.4.10 Topology selection summary -- 4.5 How WebSphere Application Server works with DB2 UDB Server -- 4.5.1 J2EE Connector architecture -- 4.5.2 JDBC resources -- 4.5.3 DB2 JDBC providers -- 4.6 DB2 connectivity to z/OS and S/390® -- 4.6.1 Type 2 connectivity from a non-z/OS platform -- 4.6.2 Type 4 connectivity from a non-z/OS platform -- 4.6.3 DB2 UDB for z/OS and OS/390 as a DRDA application requester -- 4.6.4 Application on z/OS connecting DB2 UDB for Multiplatforms -- Chapter 5. Operational setup -- 5.1 Environment setup -- 5.1.1 Installation planning -- 5.1.2 Products' installation briefing -- 5.1.3 Using DB2 for z/OS and OS/390 as the Data Source for WAS. 5.1.4 Installation troubleshooting -- 5.2 Creating and configuring DB2 JDBC Provider -- 5.2.1 The steps to create and configure DB2 JDBC Providers -- 5.3 Creating and configuring DB2 Data Source -- 5.3.1 The steps to create and configure DB2 Data Source -- 5.4 DB2 EJB sample application setup -- 5.4.1 DB2 Enterprise JavaBean (EJB) sample application -- 5.4.2 Application installation & -- resource configuration -- 5.4.3 Using DB2 for z/OS as the Data Source -- Chapter 6. WebSphere Application Server V5 performance tuning -- 6.1 Performance Monitoring Infrastructure -- 6.1.1 Performance data organization -- 6.1.2 Performance data classification -- 6.1.3 Enabling PMI service -- 6.2 Performance monitoring and analysis tools -- 6.2.1 Tivoli Performance Viewer -- 6.2.2 Enabling JVMI facility -- 6.2.3 Monitoring an application -- 6.2.4 PMI request metrics -- 6.2.5 Log Analyzer -- 6.2.6 Other monitoring facilities -- 6.2.7 Developing your own monitoring applications -- 6.3 WebSphere Application Server tuning -- 6.3.1 WebSphere Queuing Network -- 6.3.2 Configuring WebSphere Application Server queues -- 6.3.3 Using Performance Advisors -- 6.3.4 JVM memory tuning -- 6.3.5 Application assembly considerations -- 6.3.6 Other considerations -- 6.3.7 Application best practice for performance -- Chapter 7. Monitoring and tuning of DB2 UDB V8 -- 7.1 Tools for monitoring and tuning -- 7.1.1 Snapshot monitor -- 7.1.2 Event monitor -- 7.1.3 Explain utilities -- 7.1.4 DB2 Diagnostic Log (DB2DIAG.LOG) -- 7.1.5 Health Center/Memory Visualizer -- 7.1.6 Design Advisor -- 7.1.7 Configuration Advisor -- 7.2 Application tuning -- 7.2.1 Database design -- 7.2.2 SQL tuning -- 7.2.3 Stored procedures -- 7.2.4 Declared global temporary tables -- 7.2.5 Concurrency -- 7.3 System tuning -- 7.3.1 Tuning the buffer pools -- 7.3.2 Table management -- 7.3.3 Index management. 7.3.4 Prefetcher -- 7.3.5 Cleaner -- 7.3.6 Sort heap -- 7.3.7 Locking -- 7.3.8 Logging -- 7.3.9 Tablespace -- Chapter 8. DB2 UDB V8 and WAS V5 integrated performance -- 8.1 WebSphere data sources -- 8.1.1 Connection pooling -- 8.1.2 Prepared statement cache -- 8.1.3 Monitoring WebSphere application on DB2 UDB server -- 8.1.4 Tuning WebSphere DataSources -- 8.1.5 Best practices -- 8.2 Persistent session -- 8.2.1 Enable database persistence -- 8.2.2 Session management tuning -- 8.2.3 Using larger DB2 page size for database persistence -- 8.2.4 Single vs. multi-row schemas in database persistence -- 8.2.5 What is written to the persistent session database -- 8.2.6 Invalidating sessions -- 8.2.7 Session performance best practices -- 8.3 Enterprise JavaBeans -- 8.3.1 EJB performance considerations -- 8.4 Application considerations for performance in database access -- Chapter 9. Integrated troubleshooting -- 9.1 Problem determination methodology -- 9.2 Diagnostic information collection and analysis -- 9.2.1 DB2 UDB V8 diagnostic information collection and analysis -- 9.2.2 WAS V5 diagnostic information collection and analysis -- 9.3 Problem determination scenarios -- 9.3.1 Connectivity scenario -- 9.3.2 Concurrency scenario -- 9.3.3 High I/O consumption scenario -- 9.3.4 High CPU utilization scenario -- Appendix A. Trade3 application -- Introduction -- Trade3 application deployment -- Web Performance Tool -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910828469003321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB V8.2 on the Windows environment [[electronic resource] /] / [Whei-Jen Chen ... et al.]
| DB2 UDB V8.2 on the Windows environment [[electronic resource] /] / [Whei-Jen Chen ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2004 |
| Descrizione fisica | xii, 344 p. : ill |
| Disciplina | 005.74 |
| Altri autori (Persone) | ChenWhei-Jen |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450158003321 |
| [S.l.], : IBM, International Technical Support Organization, 2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
