DB2 II [[electronic resource] ] : performance monitoring, tuning, and capacity planning guide / / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, CA, : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xx, 640 p. : ill |
Disciplina | 005.74 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Computer capacity - Planning |
Soggetto genere / forma | Electronic books. |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910449860603321 |
San Jose, CA, : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 II [[electronic resource] ] : performance monitoring, tuning, and capacity planning guide / / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, CA, : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xx, 640 p. : ill |
Disciplina | 005.74 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Computer capacity - Planning |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910783527603321 |
San Jose, CA, : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 II : performance monitoring, tuning, and capacity planning guide / / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, CA, : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xx, 640 p. : ill |
Disciplina | 005.74 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Computer capacity - Planning |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. DB2 Information Integrator architecture overview -- 1.1 Introduction -- 1.2 Current business trends -- 1.2.1 From on demand to grid computing -- 1.2.2 From grid computing to data federation -- 1.2.3 From data federation to information integration -- 1.3 IBM's DB2 Information Integration overview -- 1.3.1 Data consolidation or placement -- 1.3.2 Distributed access (federation) -- 1.3.3 DB2 Information Integrator products -- 1.4 DB2 Information Integrator V8.2 -- 1.4.1 DB2 II V8.2 overview -- 1.4.2 DB2 II components -- 1.4.3 Configuring the federated system -- 1.4.4 Performance considerations -- 1.5 DB2 Information Integrator topology considerations -- 1.5.1 Dedicated federated server -- 1.5.2 Collocated federated server -- Chapter 2. Introduction to performance management -- 2.1 Introduction -- 2.2 Performance management -- 2.3 Types of monitoring -- 2.3.1 Routine monitoring -- 2.3.2 Online/realtime event monitoring -- 2.3.3 Exception monitoring -- 2.4 Problem determination methodology -- Chapter 3. Key performance drivers of DB2 II V8.2 -- 3.1 Introduction -- 3.2 Compilation flow of a federated query -- 3.3 Execution flow of a federated query -- 3.4 Key performance drivers -- 3.4.1 Performance factors -- 3.4.2 Federated server considerations -- 3.4.3 Data source considerations -- 3.4.4 Efficient SQL queries -- 3.4.5 Hardware and network -- Chapter 4. Performance problem determination scenarios -- 4.1 Introduction -- 4.2 DB2 II hypotheses hierarchy -- 4.2.1 DB2 II federated database server resource constraints -- 4.2.2 DB2 II resource constraints -- 4.2.3 Federated server or remote data source -- 4.2.4 Federated server related.
4.2.5 Remote data source related -- 4.3 Monitoring best practices -- 4.3.1 Performance considerations -- 4.3.2 Best practices -- 4.4 Problem scenarios -- 4.4.1 Federated test environment -- 4.4.2 Missing or incorrect statistics/index information -- 4.4.3 Poorly tuned sort heap and buffer pools -- 4.4.4 Missing or unavailable MQTs -- 4.4.5 Incompatible data types on join columns -- 4.4.6 Pushdown problems -- 4.4.7 Default DB2_FENCED wrapper option with DPF -- Chapter 5. Capacity planning in an existing DB2 II environment -- 5.1 Introduction -- 5.2 Capacity planning assumptions -- 5.3 Capacity planning procedure -- 5.3.1 Capacity planning procedure overview -- 5.4 Capacity planning new applications -- 5.4.1 Model of different profiles of queries -- 5.4.2 Determine new application workload -- 5.4.3 Estimate capacity for the new application -- Appendix A. DB2 II V8.2 performance enhancements -- Introduction -- Fenced wrappers -- Parallelism enhancements -- Intra-partition parallelism in a non-DPF environment -- Inter-partition parallelism in a DPF environment with local data -- Inter-partition parallelism in a DPF environment without local data -- Updating nickname statistics -- Cache tables -- Informational constraints -- Snapshot monitor support -- Health Center alerts -- Appendix B. DB2 EXPLAIN facility with DB2 Information Integrator -- Brief review of the DB2 EXPLAIN facility -- db2exfmt overview -- EXPLAIN INSTANCE section -- SQL STATEMENT section -- Access plan graph -- OPERATOR DETAILS section -- Objects section -- Complete db2exfmt output -- Federated test environment -- db2exfmt examples involving DB2 II -- Join of nicknames referencing Oracle and SQL server -- INTRA_PARALLEL = YES (intra-partition enabled) -- Database Partition Feature (DPF) with FENCED = 'N' -- Database Partition Feature (DPF) with FENCED = 'Y' -- DB2_MAXIMAL_PUSHDOWN = 'N'. DB2_MAXIMAL_PUSHDOWN = 'Y' -- SQL INSERT/UPDATE/DELETE -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
Record Nr. | UNINA-9910809601603321 |
San Jose, CA, : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI [[electronic resource] /] / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xxiv, 504 p. : ill |
Disciplina | 005.75/65 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Transaction systems (Computer systems) Online data processing |
Soggetto genere / forma | Electronic books. |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910449928203321 |
[S.l.], : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI [[electronic resource] /] / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xxiv, 504 p. : ill |
Disciplina | 005.75/65 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Transaction systems (Computer systems) Online data processing |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910783400303321 |
[S.l.], : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI / / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, c2004 |
Descrizione fisica | xxiv, 504 p. : ill |
Disciplina | 005.75/65 |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Database management
Transaction systems (Computer systems) Online data processing |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction to performance management -- 1.1 Introduction -- 1.2 Performance management -- 1.3 Types of monitoring -- 1.3.1 Routine monitoring -- 1.3.2 Online/realtime event monitoring -- 1.3.3 Exception monitoring -- 1.4 Problem determination methodology -- Chapter 2. DB2 UDB architecture overview -- 2.1 Introduction -- 2.2 Main components of DB2 -- 2.2.1 High level overview of main DB2 components -- 2.2.2 High level overview of DB2 architecture and processes -- 2.2.3 Process model -- 2.2.4 Memory model -- 2.3 Single user transaction/query flow -- 2.3.1 Transaction flow with connection concentrator enabled -- 2.3.2 Transaction flow with connection concentrator disabled -- 2.4 Multi-user (concurrent) transaction/query flow -- 2.5 Key performance knobs -- 2.5.1 Configuration Advisor and AUTOCONFIGURE -- 2.5.2 Database Manager (DBM) configuration parameters -- 2.5.3 Database (DB) configuration parameters -- 2.5.4 DB2 registry and environment variables -- 2.6 Performance monitoring facilities -- 2.6.1 CLI/ODBC/JDBC trace -- 2.6.2 Database System Monitor -- 2.6.3 DB2 administration notification log -- 2.6.4 db2batch -- 2.6.5 db2diag.log -- 2.6.6 DB2 Performance Expert -- 2.6.7 Design Advisor -- 2.6.8 Explain and Visual Explain -- 2.6.9 Heath Monitor and Health Center -- 2.6.10 Memory Tracker -- 2.6.11 Memory Visualizer -- Chapter 3. Application design and system performance considerations -- 3.1 OLTP and BI characteristics -- 3.1.1 OLTP characteristics -- 3.1.2 BI characteristics -- 3.2 Key performance drivers -- 3.3 Application design considerations -- 3.3.1 Table design -- 3.3.2 MDC design considerations -- 3.3.3 MQT/AST design considerations.
3.3.4 Index design -- 3.3.5 Table space design -- 3.3.6 Writing efficient SQL -- 3.3.7 Concurrency -- 3.4 System environment considerations -- 3.4.1 I/O placement considerations -- 3.4.2 Log considerations -- 3.4.3 Monitor switch settings -- 3.4.4 Connection considerations -- 3.4.5 Buffer pool considerations -- 3.4.6 Locking considerations -- 3.4.7 Package cache considerations -- 3.4.8 Catalog cache considerations -- 3.4.9 Sort considerations -- 3.4.10 Other memory considerations -- 3.4.11 Miscellaneous considerations -- Chapter 4. Command and utility considerations -- 4.1 Introduction -- 4.2 Backup -- 4.2.1 Brief description -- 4.2.2 Performance considerations -- 4.2.3 Best practices -- 4.3 Export -- 4.3.1 Brief description -- 4.3.2 Performance considerations -- 4.3.3 Best practices -- 4.4 Import -- 4.4.1 Brief description -- 4.4.2 Performance considerations -- 4.4.3 Best practices -- 4.5 Load -- 4.5.1 Brief description -- 4.5.2 Performance considerations -- 4.5.3 Best practices -- 4.6 Reorg -- 4.6.1 Brief description -- 4.6.2 Performance considerations -- 4.6.3 Best practices -- 4.7 Restore -- 4.7.1 Brief description -- 4.7.2 Performance considerations -- 4.7.3 Best practices -- 4.8 Runstats -- 4.8.1 Brief description -- 4.8.2 Performance considerations -- 4.8.3 Best practices -- Chapter 5. Operating system considerations -- 5.1 Introduction -- 5.2 AIX platform -- 5.2.1 Operating system considerations -- 5.2.2 Memory considerations -- 5.2.3 Disk and filesystem considerations -- 5.2.4 Monitoring and problem determination tools -- 5.3 Windows platform -- 5.3.1 Operating system considerations -- 5.3.2 Memory considerations -- 5.3.3 Disk and filesystem considerations -- 5.3.4 Monitoring and problem determination tools -- Chapter 6. Problem determination scenarios -- 6.1 Introduction -- 6.2 DB2 hypotheses hierarchy. 6.2.1 DB2 database server system resource constraints -- 6.2.2 DB2 system resource constraints -- 6.3 Exception event scenarios -- 6.3.1 Lock waits due to default LOCKTIMEOUT value (OLTP) -- 6.3.2 Poor SQL performance due to missing indexes (OLTP) -- 6.3.3 Poor SQL performance due to unused MQTs (BI) -- 6.4 Routine monitoring scenarios -- 6.4.1 Deteriorating space utilization conditions (BI) -- 6.4.2 Deteriorating buffer pool hit ratios (OLTP) -- 6.5 Online/Realtime monitoring scenarios -- 6.5.1 Lock contention (OLTP) -- Appendix A. DB2 UDB ESE Version 8 performance enhancements -- A.1 Introduction -- A.2 Application-related performance enhancements -- A.2.1 Multidimensional clustering -- A.2.2 MQT enhancements -- A.2.3 Compression of NULLS and DEFAULT -- A.2.4 Load enhancements -- A.3 System-related performance enhancements -- A.3.1 Prefetching enhancements -- A.3.2 Faster page cleaners -- A.3.3 Connection concentrator -- A.3.4 Type 2 indexes -- A.3.5 Stored procedures and UDFs thread-based model -- A.3.6 DMS container enhancements -- A.3.7 RUNSTATS enhancements -- A.3.8 Logging enhancements -- A.3.9 Manageability enhancements -- A.4 DB2 UDB Version 8.1.4 -- A.4.1 Backup compression -- A.4.2 Range-clustered tables -- A.4.3 Direct I/O support on AIX -- A.4.4 Asymmetric index splitting -- A.4.5 Buffer pool memory allocation -- A.4.6 Page cleaning enhancements -- A.4.7 Lock deferral -- A.4.8 Improved sort performance -- Appendix B. Workloads used in the scenarios -- B.1 Introduction -- B.2 DTW workload -- B.3 EBIZ database -- B.4 Trade2 database and application -- B.5 WebSphere Performance Tools (WPT) -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
Record Nr. | UNINA-9910806138903321 |
[S.l.], : IBM, International Technical Support Organization, c2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB's high function business intelligence in e-business [[electronic resource] /] / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, Calif., : IBM Corp., 2002 |
Descrizione fisica | xxii, 252 p. : ill |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Electronic commerce
Business intelligence Database management |
Soggetto genere / forma | Electronic books. |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910454623503321 |
San Jose, Calif., : IBM Corp., 2002 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB's high function business intelligence in e-business [[electronic resource] /] / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, Calif., : IBM Corp., 2002 |
Descrizione fisica | xxii, 252 p. : ill |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Electronic commerce
Business intelligence Database management |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910782025303321 |
San Jose, Calif., : IBM Corp., 2002 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 UDB's high function business intelligence in e-business / / [Nagraj Alur ... et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, Calif., : IBM Corp., 2002 |
Descrizione fisica | xxii, 252 p. : ill |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Electronic commerce
Business intelligence Database management |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Notice -- Comments welcome -- Chapter 1. Business Intelligence overview -- 1.1 e-business drivers -- 1.1.1 Impact of e-business -- 1.1.2 Importance of BI -- 1.2 IBM's BI strategy and offerings -- 1.2.1 BI and analytic enhancements in DB2 UDB -- 1.2.2 Advantages of BI functionality in the database engine -- 1.3 Redbook focus -- 1.3.1 Materialized views -- 1.3.2 Statistics, analytic and OLAP functions -- Chapter 2. DB2 UDB's materialized views -- 2.1 Materialized view overview -- 2.1.1 Materialized view motivation -- 2.1.2 Materialized view concept overview -- 2.1.3 Materialized view usage considerations -- 2.1.4 Materialized view terminology -- 2.2 Materialized view CREATE considerations -- 2.2.1 Step 1: Create the materialized view -- 2.2.2 Step 2: Populate the materialized view -- 2.2.3 Step 3: Tune the materialized view -- 2.3 Materialized view maintenance considerations -- 2.3.1 Deferred refresh -- 2.3.2 Immediate refresh -- 2.4 Loading base tables (LOAD utility) -- 2.5 Materialized view ALTER considerations -- 2.6 Materialized view DROP considerations -- 2.7 Materialized view matching considerations -- 2.7.1 State considerations -- 2.7.2 Matching criteria considerations -- 2.7.3 Matching permitted -- 2.7.4 Matching inhibited -- 2.8 Materialized view design considerations -- 2.8.1 Step 1: Collect queries & -- prioritize -- 2.8.2 Step 2: Generalize local predicates to GROUP BY -- 2.8.3 Step 3: Create the materialized view -- 2.8.4 Step 4: Estimate materialized view size -- 2.8.5 Step 5: Verify query routes to "empty" the materialized view -- 2.8.6 Step 6: Consolidate materialized views -- 2.8.7 Step 7: Introduce cost issues into materialized view routing -- 2.8.8 Step 8: Estimate performance gains.
2.8.9 Step 9: Load the materialized views with production data -- 2.8.10 Generalizing local predicates application example -- 2.9 Materialized view tuning considerations -- 2.10 Refresh optimization -- 2.11 Materialized view limitations -- 2.11.1 REFRESH DEFERRED and REFRESH IMMEDIATE -- 2.11.2 REFRESH IMMEDIATE and queries with staging table -- 2.12 Replicated tables in nodegroups -- Chapter 3. DB2 UDB's statistics, analytic, and OLAP functions -- 3.1 DB2 UDB's statistics, analytic, and OLAP functions -- 3.2 Statistics and analytic functions -- 3.2.1 AVG -- 3.2.2 CORRELATION -- 3.2.3 COUNT -- 3.2.4 COUNT_BIG -- 3.2.5 COVARIANCE -- 3.2.6 MAX -- 3.2.7 MIN -- 3.2.8 RAND -- 3.2.9 STDDEV -- 3.2.10 SUM -- 3.2.11 VARIANCE -- 3.2.12 Regression functions -- 3.2.13 COVAR, CORR, VAR, STDDEV, and regression examples -- 3.3 OLAP functions -- 3.3.1 Ranking, numbering and aggregation functions -- 3.3.2 GROUPING capabilities ROLLUP & -- CUBE -- 3.3.3 Ranking, numbering, aggregation examples -- 3.3.4 GROUPING, GROUP BY, ROLLUP and CUBE examples -- Chapter 4. Statistics, analytic, OLAP functions in business scenarios -- 4.1 Introduction -- 4.1.1 Using sample data -- 4.1.2 Sampling and aggregation example -- 4.2 Retail -- 4.2.1 Present annual sales by region and city -- 4.2.2 Provide total quarterly and cumulative sales revenues by year -- 4.2.3 List the top 5 sales persons by region this year -- 4.2.4 Compare and rank the sales results by state and country -- 4.2.5 Determine relationships between product purchases -- 4.2.6 Determine the most profitable items and where they are sold -- 4.2.7 Identify store sales revenues noticeably different from average -- 4.3 Finance -- 4.3.1 Identify the most profitable customers -- 4.3.2 Identify the profile of transactions concluded recently -- 4.3.3 Identify target groups for a campaign. 4.3.4 Evaluate effectiveness of a marketing campaign -- 4.3.5 Identify potential fraud situations for investigation -- 4.3.6 Plot monthly stock prices movement with percentage change -- 4.3.7 Plot the average weekly stock price in September -- 4.3.8 Project growth rates of Web hits for capacity planning purposes -- 4.3.9 Relate sales revenues to advertising budget expenditures -- 4.4 Sports -- 4.4.1 For a given sporting event -- 4.4.2 Seed the players at Wimbledon -- Appendix A. Introduction to statistics and analytic concepts -- A.1 Statistics and analytic concepts -- A.1.1 Variance -- A.1.2 Standard deviation -- A.1.3 Covariance -- A.1.4 Correlation -- A.1.5 Regression -- A.1.6 Hypothesis testing -- A.1.7 HAT diagonal -- A.1.8 Wilcoxon rank sum test -- A.1.9 Chi-Squared test -- A.1.10 Interpolation -- A.1.11 Extrapolation -- A.1.12 Probability -- A.1.13 Sampling -- A.1.14 Transposition -- A.1.15 Histograms -- Appendix B. Tables used in the examples -- DDL of tables -- Appendix C. Materialized view syntax elements -- Materialized view main syntax elements -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover. |
Record Nr. | UNINA-9910823892403321 |
San Jose, Calif., : IBM Corp., 2002 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Patterns [[electronic resource] ] : information aggregation and data integration with DB2 information integrator / / Nagraj Alur ... [et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, CA, : IBM, International Technical Support Organization, 2004 |
Descrizione fisica | xxvi, 308 p. : ill |
Altri autori (Persone) | AlurNagraj |
Collana | IBM redbooks |
Soggetto topico |
Business - Data processing
Information resources management Database management |
Soggetto genere / forma | Electronic books. |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910449706603321 |
San Jose, CA, : IBM, International Technical Support Organization, 2004 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|