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.
Application recovery tool for IMS and DB2 databases [[electronic resource] ] : a data recovery guide / / [Paolo Bruni ... et al.]
| Application recovery tool for IMS and DB2 databases [[electronic resource] ] : a data recovery guide / / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : IBM International Technical Support Organization, 2002 |
| Descrizione fisica | xviii, 166 p. : ill |
| Disciplina | 005.8/6 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Data recovery (Computer science)
IMS (DL/I) (Computer system) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910454616203321 |
| [San Jose, Calif.], : IBM International Technical Support Organization, 2002 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Application recovery tool for IMS and DB2 databases [[electronic resource] ] : a data recovery guide / / [Paolo Bruni ... et al.]
| Application recovery tool for IMS and DB2 databases [[electronic resource] ] : a data recovery guide / / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : IBM International Technical Support Organization, 2002 |
| Descrizione fisica | xviii, 166 p. : ill |
| Disciplina | 005.8/6 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Data recovery (Computer science)
IMS (DL/I) (Computer system) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910782026403321 |
| [San Jose, Calif.], : IBM International Technical Support Organization, 2002 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Application recovery tool for IMS and DB2 databases : a data recovery guide / / [Paolo Bruni ... et al.]
| Application recovery tool for IMS and DB2 databases : a data recovery guide / / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif.], : IBM International Technical Support Organization, 2002 |
| Descrizione fisica | xviii, 166 p. : ill |
| Disciplina | 005.8/6 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Data recovery (Computer science)
IMS (DL/I) (Computer system) |
| 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 -- Part 1 The recovery functions of DB2 and IMS -- Chapter 1. Overview of DB2 data recovery -- 1.1 Basics of DB2 data recovery -- 1.1.1 DB2 recovery components -- 1.1.2 Changing data -- 1.1.3 DB2 data recovery -- 1.2 Examples of DB2 data recovery functions -- 1.2.1 Default recovery using the latest full copy and log -- 1.2.2 TOCOPY recovery using the latest full copy -- 1.2.3 TOCOPY recovery using an incremental copy -- 1.2.4 TOLOGPOINT recovery using log RBA -- 1.2.5 MERGECOPY utility -- Chapter 2. Overview of IMS data recovery -- 2.1 Overview of IMS data recovery -- 2.1.1 The need for recovery -- 2.1.2 The database utilities -- 2.2 Examples of backup and recovery utilities -- 2.2.1 Database Image Copy utilities -- 2.2.2 Database Change Accumulation utility -- 2.2.3 Database Batch Backout utility -- 2.2.4 Database Recovery utility -- 2.2.5 Impact of recovery variables -- 2.3 Overview of Database Recovery Control: DBRC -- 2.3.1 DBRC usage -- Chapter 3. IMS Online Recovery Service -- 3.1 ORS overview -- 3.2 Installation considerations -- 3.2.1 Requirements -- 3.2.2 Operational conditions -- 3.2.3 Defining the ORS environment -- 3.3 Operating and administering ORS -- 3.3.1 Database administrator roles with ORS -- 3.3.2 Database availability -- 3.3.3 ORS and IMS shutdown -- 3.3.4 Performance -- 3.4 Sample operation procedures and outputs -- 3.4.1 Displaying database information -- 3.4.2 Stopping and deallocating the database -- 3.4.3 Building the recovery lists -- 3.4.4 ORS: displaying the databases status -- 3.4.5 Starting the recovery -- 3.4.6 Displaying database status during recovery -- 3.4.7 Completing the recovery -- Chapter 4. Recovering IMS and DB2 data.
4.1 Consistency of application data across IMS and DB2 -- 4.1.1 Overview -- 4.1.2 Two-phase commit protocol -- 4.2 Maintaining consistency after termination or failure -- 4.3 LOG protocol -- 4.3.1 Termination -- Part 2 IBM Application Recovery Tool for IMS and DB2 Databases -- Chapter 5. ART's overview -- 5.1 The IBM Data Management tools -- 5.1.1 Recovery and replication area -- 5.2 Application Recovery Tool for IMS and DB2 Databases -- 5.2.1 The recovery process -- 5.2.2 The use of a VIC point -- 5.3 The new release -- Chapter 6. ART's installation and customization -- 6.1 Installation and customization -- 6.1.1 Overall installation process -- 6.1.2 ISPF Primary Panel and Installation Main Panel -- 6.2 Prepare ART under DB2 Environment (DB2 bind) -- 6.2.1 DB2 binding -- 6.2.2 Verifying DB2 installation -- 6.3 Prepare ART under IMS Environment (ACB generation) -- 6.3.1 IMS ACB generation -- 6.3.2 Verifying the IMS installation -- 6.4 Delete and define ART RECON for IMS and DB2 -- 6.5 Adding DRMEXEC to a menu or CLIST -- 6.6 Replacing the current parmlib -- Chapter 7. Using ART for DB2 recovery -- 7.1 ART and DB2 utilities -- 7.1.1 Online verses batch invocation of ART DB2 utility control -- 7.1.2 DRMFIC: Full Image Copy -- 7.1.3 DRMIIC: Incremental Image Copy -- 7.1.4 DRMMERGE: Mergecopy utility -- 7.1.5 DRMDLET2: Modify Recovery -- 7.1.6 DRMMDISK: Manage disk space -- 7.2 Primary panel -- 7.2.1 DRMVIC: Virtual Image Copy -- 7.2.2 DRMMAP: Recovery map -- 7.2.3 DRMRECOV: Recovery utility -- 7.2.4 DRMDCHEK: Check data utility -- 7.2.5 DRMAOP: Auto operator -- 7.3 Scenarios using ART -- 7.3.1 Recovery to a VIC -- Chapter 8. Using ART for IMS recovery -- 8.1 ART and IMS utilities -- 8.1.1 DRMINIT: DBRC INIT -- 8.1.2 DRMIC: IMS Image Copy -- 8.1.3 DRMCA: IMS DBRC CA -- 8.1.4 DRMRROEG: Reorg IMS RECON data sets -- 8.1.5 DRMDLET1: IMS DBRC cleanup. 8.1.6 DRMMDISK: Disk management of database -- 8.2 IMS primary panel -- 8.2.1 DRMVIC: Virtual Image Copy -- 8.2.2 DRMMAP -- 8.2.3 DRMRECOV -- Chapter 9. Using ART for IMS and DB2 recovery -- 9.1 Introduction -- 9.1.1 Image copies in IMS and DB2 -- 9.1.2 Concurrent Image Copies in IMS and DB2 -- 9.2 DRMVIC -- 9.3 DRMRECOV -- 9.4 DRMRECOV examples -- 9.4.1 Invoking the DRMRECOV function -- 9.5 DRMRECOV and IMS/ORS -- 9.5.1 About the interface routine: AORS -- 9.5.2 Sample execution -- Part 3 Appendixes -- Appendix A. Sample JCL and output for DB2 Recovery -- A.1 DB2 COPY utility -- A.2 ART DRMMAP -- Appendix B. Sample JCL and output for IMS recovery -- B.1 Image Copies -- B.1.1 Standard Image Copy -- B.1.2 Concurrent Image Copy -- B.1.3 Image Copy Type 2 -- B.2 Change Accumulation -- B.3 Batch Back-out -- B.4 Database Recovery -- B.5 Recovering VSAM files for IMS database -- B.6 Dsect listing for I/C and C/A header record -- Appendix C. Additional material -- Locating the Web material -- Using the Web material -- System requirements for downloading the Web material -- How to use the Web material -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover. |
| Record Nr. | UNINA-9910825052403321 |
| [San Jose, Calif.], : IBM International Technical Support Organization, 2002 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
The business value of DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.
| The business value of DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al. |
| Autore | Bruni Paolo |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xiv, 216 p. : ill |
| Disciplina | 005.75/65 |
| Collana | Redbooks |
| Soggetto topico |
Database management
Client/server computing Business - Data processing |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783529603321 |
Bruni Paolo
|
||
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
The business value of DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.
| The business value of DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al. |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xiv, 216 p. : ill |
| Disciplina | 005.75/65 |
| Collana | Redbooks |
| Soggetto topico |
Database management
Client/server computing Business - Data processing |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450121403321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
The business value of DB2 UDB for z/OS / / Paolo Bruni ... [et al.
| The business value of DB2 UDB for z/OS / / Paolo Bruni ... [et al. |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xiv, 216 p. : ill |
| Disciplina | 005.75/65 |
| Collana | Redbooks |
| Soggetto topico |
Database management
Client/server computing Business - Data processing |
| 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. Evolution of the mainframe -- 1.1 The evolution of z/Architecture -- 1.1.1 Lower cost of entry to mainframes -- 1.1.2 More options in pricing and performance -- 1.1.3 Leveraging investment in existing applications -- 1.2 Hardware -- 1.3 Operating systems -- 1.3.1 Value of z/OS -- 1.3.2 Evolution of z/OS -- 1.3.3 Other mainframe operating systems -- 1.4 Processor -- 1.5 Management -- 1.6 Preparing new mainframers -- 1.7 2000 through 2005: The era of on demand -- Chapter 2. The evolution of DB2 for z/OS -- 2.1 The evolution of DB2 UDB for z/OS -- 2.2 DB2 and Parallel Sysplex industry leadership -- 2.2.1 Extreme availability -- 2.2.2 Near-linear scalability -- 2.2.3 Preservation of investment -- 2.2.4 Controlled enablement of new functionality on version upgrade -- 2.2.5 Rolling maintenance and new releases without an outage -- 2.2.6 Ability to fallback -- 2.2.7 Conclusion -- 2.3 Summary for DB2 -- Chapter 3. DB2 synergy with zSeries and z/OS -- 3.1 The zSeries, z/OS, and DB2 partnership -- 3.1.1 z/OS highlights -- 3.1.2 zSeries architecture highlights -- 3.1.3 DB2 UDB for z/OS -- 3.2 Parallel Sysplex and data sharing -- 3.2.1 Shared nothing -- 3.2.2 Shared disk -- 3.2.3 Shared data -- 3.2.4 Advantages of data sharing -- 3.2.5 Cost benefit -- 3.2.6 Summary -- 3.3 Compression -- 3.4 Security -- 3.4.1 zSeries security features -- 3.4.2 DB2 controls -- 3.4.3 DB2 and multilevel security -- 3.4.4 Summary -- 3.5 Encryption -- 3.5.1 DB2 column level encryption -- 3.5.2 IBM Data Encryption for IMS and DB2 Databases -- 3.5.3 Summary -- 3.6 Sort -- 3.7 z/OS Unicode Conversion Services -- 3.8 UNIX System Services -- 3.9 WorkLoad Manager, Intelligent Resource Director, and VIPA -- 3.9.1 WorkLoad Manager.
3.9.2 Intelligent Resource Director -- 3.9.3 Virtual IP addressing -- 3.9.4 Summary -- 3.10 Disk storage -- 3.10.1 ESS -- 3.10.2 FICON channels -- 3.10.3 VSAM data striping -- 3.10.4 Geographically Dispersed Parallel Sysplex -- 3.10.5 HyperSwap -- 3.11 zSeries 990 -- 3.12 64-bit virtual storage -- 3.13 HyperSockets -- 3.13.1 Specialized processor for Linux -- 3.14 zSeries Application Assist Processor for Java -- 3.15 Summary -- Chapter 4. Business resiliency -- 4.1 The DB2 business computing environment -- 4.2 DB2 for z/OS and zSeries resiliency -- 4.2.1 Reliability -- 4.2.2 Availability -- 4.2.3 Scalability -- 4.2.4 Manageability and adaptability -- 4.2.5 Security -- 4.2.6 Accessibility and extensibility -- 4.2.7 Summary -- Chapter 5. The on demand environment -- 5.1 z/Architecture adaptation through evolution -- 5.1.1 Revenue protection and growth -- 5.1.2 Return on investment -- 5.1.3 Business resiliency -- 5.1.4 Security -- 5.2 Advanced technologies -- 5.2.1 Open standards -- 5.2.2 Web services -- 5.2.3 Service-oriented architecture -- 5.3 Enhanced application support -- 5.3.1 WebSphere -- 5.3.2 DB2 development -- 5.3.3 IBM Rational -- 5.3.4 IBM Lotus -- 5.3.5 Microsoft .Net framework -- 5.3.6 Independent software vendors and packaged solutions -- 5.3.7 DB2 utilities -- 5.4 z/OS.e for workloads for On Demand Business -- Chapter 6. Readiness for new workloads -- 6.1 Background for new workload creation -- 6.2 Development of new business transaction applications -- 6.2.1 Prioritizing for new applications -- 6.2.2 Security for new applications -- 6.2.3 Ability to accommodate growth -- 6.2.4 Rapid development of high performance applications -- 6.3 Enhancement of existing applications -- 6.3.1 Using utilities instead of developing programs -- 6.4 Purchasing new software packages -- 6.4.1 Usability, availability, and scalability -- 6.4.2 Performance. 6.4.3 Tools and administration -- 6.5 Acquisition of new companies -- 6.6 Consolidation -- 6.6.1 Consolidation via new business acquisition -- 6.6.2 Server consolidation -- 6.7 Development or augmentation of BI systems -- 6.7.1 Preliminary sizing estimate and capacity planning for growth -- 6.7.2 Data movement into the BI system -- 6.7.3 Availability -- 6.7.4 Scalability -- 6.7.5 Systems management -- 6.7.6 Parallelism -- 6.7.7 Query performance and throughput -- 6.7.8 Database support skills -- 6.7.9 Conclusions for BI systems on z/OS -- 6.8 Customer growth -- 6.9 Requirement for storing new data types -- 6.10 DB2 Query Management Facility -- 6.10.1 DB2 QMF components -- 6.10.2 More on Visionary -- 6.11 Summary -- Chapter 7. Evaluating the cost of your solution -- 7.1 Total cost of ownership -- 7.1.1 What is TCO? -- 7.1.2 Mainframe differentiators -- 7.2 zSeries and DB2 UDB for z/OS -- 7.2.1 Mainframe Charter -- 7.2.2 Hardware -- 7.2.3 Mainframe pricing -- 7.2.4 System utilization -- 7.2.5 Staff utilization -- 7.2.6 Quality of service -- 7.3 Summary -- Chapter 8. The future of DB2 for z/OS -- 8.1 New workloads -- 8.1.1 Native SQL stored procedures -- 8.1.2 Integrated XML -- 8.1.3 Portability, ERP support, and family compatibility -- 8.2 Business resiliency -- 8.2.1 Enhanced security -- 8.2.2 Enhanced manageability -- 8.2.3 Table Append option -- 8.2.4 Index changes -- 8.2.5 Temporary storage architecture and use -- 8.3 DB2 for z/OS platform synergy -- 8.3.1 Shared memory and distributed connections -- 8.3.2 Index compression -- 8.4 Total cost of ownership -- 8.4.1 Autonomic computing -- 8.4.2 Optimization -- 8.5 Conclusion -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910825287603321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data federation with IBM DB2 Information Integrator V8.1 [[electronic resource] /] / [Paolo Bruni ... et al.]
| Data federation with IBM DB2 Information Integrator V8.1 [[electronic resource] /] / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxxviii, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Relational databases
Information resources management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910449999503321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data federation with IBM DB2 Information Integrator V8.1 [[electronic resource] /] / [Paolo Bruni ... et al.]
| Data federation with IBM DB2 Information Integrator V8.1 [[electronic resource] /] / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxxviii, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Relational databases
Information resources management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783396103321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data federation with IBM DB2 Information Integrator V8.1 / / [Paolo Bruni ... et al.]
| Data federation with IBM DB2 Information Integrator V8.1 / / [Paolo Bruni ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxxviii, 424 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo |
| Collana | IBM redbooks |
| Soggetto topico |
Relational databases
Information resources management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- What this redbook is about -- The contents -- The audience -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Introduction -- Chapter 1. Information integration concepts -- 1.1 The business need -- 1.1.1 Business challenges -- 1.1.2 Business on demand -- 1.1.3 From on demand to grid computing -- 1.1.4 From grid to federated data -- 1.2 IBM's information integration -- 1.2.1 Consolidation and federation -- 1.2.2 Transparency, transparency -- 1.3 The DB2 Information Integrator family of products -- 1.3.1 DB2 Information Integrator -- 1.3.2 DB2 Information Integrator for Content -- 1.3.3 Extension through partnership -- 1.3.4 DB2 Information Integrator and Life Sciences -- 1.3.5 The evolution -- Chapter 2. IBM DB2 Information Integrator V8.1 -- 2.1 Overview -- 2.2 DB2 Information Integrator functions and objects -- 2.2.1 Database server -- 2.2.2 Federated database -- 2.2.3 Configuring the federated system -- 2.2.4 Replication -- 2.2.5 Wrapper development kit -- Part 2 Configuring the federated data solution -- Chapter 3. The case study -- 3.1 The federated system -- 3.1.1 The base system -- 3.1.2 The DB2 Federated Data -- 3.1.3 Information Integrator for relational data sources -- 3.1.4 The final picture -- 3.2 Setting up the environment -- 3.2.1 The starting point -- 3.2.2 Connecting DB2 for z/OS and Informix data sources -- 3.2.3 Installing Information Integrator -- 3.2.4 Connecting Oracle data source -- 3.2.5 Connecting Microsoft SQL Server data source -- 3.2.6 Connecting XML data source -- 3.2.7 Connecting flat file data source -- 3.2.8 Connecting Microsoft Excel data source -- 3.2.9 System environment: Summary -- 3.3 The data and the application -- 3.3.1 Data model -- 3.3.2 Data distribution.
3.3.3 Data access -- Chapter 4. Configuring DB2 Federated Data support -- 4.1 Background information -- 4.2 Setting up the DB2 UDB instance on AIX -- 4.2.1 Pre-installation requirements -- 4.2.2 32-bit or 64-bit DB2 ESE installation and instance -- 4.2.3 Installation instructions -- 4.2.4 DB2 database configuration for federation -- 4.3 Integrating DB2 UDB for z/OS -- 4.3.1 Cataloging DB2 for z/OS -- 4.3.2 Creating the DB2 for z/OS wrapper -- 4.3.3 Creating the DB2 for z/OS server -- 4.3.4 Altering DB2 for z/OS server definition and server options -- 4.3.5 Creating DB2 for z/OS user mappings -- 4.3.6 Altering DB2 for z/OS user mappings -- 4.3.7 Creating DB2 for z/OS nicknames -- 4.3.8 Altering DB2 for z/OS nicknames -- 4.4 Integrating Informix Dynamic Server -- 4.4.1 Informix client configuration -- 4.4.2 Informix wrapper libraries -- 4.4.3 Creating the Informix wrapper -- 4.4.4 Creating the Informix server -- 4.4.5 Altering Informix server definition and server options -- 4.4.6 Creating Informix user mappings -- 4.4.7 Altering Informix user mappings -- 4.4.8 Creating Informix nicknames -- 4.4.9 Altering Informix nicknames -- 4.5 Integrating DB2 UDB for iSeries -- Chapter 5. Installing and configuring DB2 Information Integrator -- 5.1 General prerequisites -- 5.2 Installing DB2 Information Integrator -- 5.2.1 Start the installer -- 5.2.2 Installation response file examples -- 5.2.3 Installation hints, tips, and techniques -- 5.3 Applying installed wrappers to instances -- 5.4 Integrating Oracle 9i -- 5.4.1 Configuration information for Oracle 9i wrapper -- 5.4.2 Creating the Oracle wrapper -- 5.4.3 Creating the Oracle server -- 5.4.4 Altering Oracle server definition and server options -- 5.4.5 Creating Oracle user mappings -- 5.4.6 Altering Oracle user mappings -- 5.4.7 Creating Oracle nicknames -- 5.4.8 Altering Oracle nicknames. 5.5 Integrating Microsoft SQL Server 2000 -- 5.5.1 Microsoft SQL Server client configuration -- 5.5.2 Creating the Microsoft SQL Server wrapper -- 5.5.3 Creating the Microsoft SQL Server server -- 5.5.4 Altering Microsoft SQL Server definition and server options -- 5.5.5 Creating Microsoft SQL Server user mappings -- 5.5.6 Altering Microsoft SQL Server user mappings -- 5.5.7 Creating Microsoft SQL Server nicknames -- 5.5.8 Altering Microsoft SQL Server nicknames -- 5.6 Integrating XML data source -- 5.6.1 Introduction -- 5.6.2 Configuration information for XML wrapper -- 5.6.3 Creating the XML wrapper -- 5.6.4 Creating the XML server -- 5.6.5 Creating XML nicknames -- 5.6.6 Altering XML nicknames -- 5.7 Integrating table-structured files -- 5.7.1 Introduction -- 5.7.2 Table-structured file configuration information -- 5.7.3 Creating the table-structured file wrapper -- 5.7.4 Creating the table-structured file server -- 5.7.5 Creating table-structured file nicknames -- 5.7.6 Altering table-structured file nicknames -- 5.8 Integrating Microsoft Excel -- 5.8.1 Introduction -- 5.8.2 Configuration information for ODBC wrapper -- 5.8.3 Setting Excel ODBC on Windows -- 5.8.4 Setting OpenLink client on AIX -- 5.8.5 Creating ODBC wrappers -- 5.8.6 Creating ODBC servers -- 5.8.7 Altering the ODBC server -- 5.8.8 Creating the ODBC nickname -- 5.8.9 Altering ODBC nicknames -- 5.9 Maintaining -- 5.9.1 Applying FixPaks -- 5.9.2 Updating nickname statistics -- 5.9.3 Schema changes at data sources -- 5.9.4 Nicknames used in views and packages -- 5.10 Troubleshooting -- 5.10.1 Errors linking with data source clients -- 5.10.2 Errors when defining and using federated objects -- 5.10.3 Information to gather -- Part 3 Performance concepts with DB2 Information Integrator -- Chapter 6. A performance tutorial -- 6.1 Federated query performance -- 6.1.1 Performance factors. 6.1.2 The pushdown concept -- 6.1.3 Optimizing a federated query -- 6.1.4 Pushdown analysis and cost optimization -- 6.1.5 Importance of pushdown -- 6.1.6 Interpreting federated query execution plans -- 6.2 Tuning a query on a single data source -- 6.2.1 What is a good query? -- 6.2.2 Evaluating the execution plan with Explain -- 6.2.3 Federated server options for best performance -- 6.2.4 Analyzing performance of a single remote source query -- 6.3 Tuning a query on multiple data sources -- 6.3.1 Multiple source queries -- 6.3.2 A simple distributed two-source query -- 6.3.3 Execution plan for the simple distributed query -- 6.3.4 Performance of distributed queries -- 6.3.5 Federated queries with nicknames and partitioned tables -- 6.3.6 Summary of distributed query performance -- 6.4 Performance and availability with MQTs -- 6.5 Federated query performance checklist -- 6.5.1 Phase 1 -- 6.5.2 Phase 2 -- 6.5.3 Phase 3 -- Chapter 7. Our performance tools -- 7.1 DB2 Explain -- 7.1.1 Overview -- 7.1.2 DB2 Explain facilities -- 7.1.3 Explain tables -- 7.1.4 Explaining the queries -- 7.2 db2batch -- 7.3 Get Statistics utility: get_stats -- Part 4 Exploiting performance options -- Chapter 8. National language support -- 8.1 Introduction to code page settings -- 8.1.1 Remote relational data source -- 8.1.2 DB2 Information Integrator -- 8.1.3 DB2 Client -- 8.2 Supporting a non-default language -- 8.2.1 DB2 Information Integrator setting -- 8.2.2 DB2 Client setting -- 8.2.3 Conclusion -- 8.3 Adding a new language to an existing system -- 8.3.1 Remote data source code page definition -- 8.3.2 DB2 Information Integrator setting -- 8.3.3 DB2 Client setting -- 8.3.4 Conclusion -- Chapter 9. Nickname statistics -- 9.1 Overview -- 9.2 Nicknames with missing statistics -- 9.2.1 Check statistics for nicknames -- 9.2.2 Create the access plan -- 9.2.3 Perform the query. 9.3 Nicknames with statistics -- 9.3.1 Option 1: Update stats and recreate nickname -- 9.3.2 Option 2: Run get_stats utility -- 9.3.3 Check statistics for nicknames again -- 9.3.4 Create the access plan -- 9.3.5 Perform the query -- 9.4 Conclusion -- 9.4.1 Comparing the access plans -- 9.4.2 Summary -- Chapter 10. Major server options with relational data sources -- 10.1 Server option db2_maximal_pushdown -- 10.1.1 Overview -- 10.1.2 DB2_MAXIMAL _PUSHDOWN set to N (default) -- 10.1.3 DB2_MAXIMAL _PUSHDOWN set to Y -- 10.1.4 Conclusion on DB2_maximal_pushdown -- 10.1.5 DB2_MAXIMAL_PUSHDOWN vs. PUSHDOWN -- 10.2 Server option collating_sequence -- 10.2.1 Overview -- 10.2.2 COLLATING_SEQUENCE set to N (default) -- 10.2.3 COLLATING_SEQUENCE set to Y -- 10.2.4 Conclusion on collating_sequence -- 10.3 Oracle server option varchar_no_trailing_blanks -- 10.3.1 Trailing blanks with DB2, Informix, and SQL Server -- 10.3.2 Trailing blanks with Oracle -- 10.3.3 VARCHAR_NO_TRAILING_BLANKS set to N -- 10.3.4 VARCHAR_NO_TRAILING_BLANKS set to Y -- Chapter 11. Using data type mappings -- 11.1 Overview -- 11.2 Step 1: Explicit cast on nickname column -- 11.3 Step 2: Accommodate the default mapping -- 11.4 Step 3: Altering local column data type -- Chapter 12. Using function mappings -- 12.1 Overview -- 12.2 Mapping user defined functions -- Chapter 13. Major server options with non relational data sources -- 13.1 Overview -- 13.2 Pushdown with Excel data sources -- 13.2.1 PUSHDOWN set to N (default) -- 13.2.2 PUSHDOWN set to Y -- 13.3 Table-structured files parameter - Sorted -- 13.3.1 Nickname parameter SORTED set to N (default) -- 13.3.2 Nickname parameter SORTED set to Y -- 13.3.3 Conclusion -- Chapter 14. Using index specifications -- 14.1 Overview -- 14.2 Table acquires new index after nickname creation -- 14.3 Nicknames over remote views. 14.3.1 What about utilizing an existing index?. |
| Record Nr. | UNINA-9910824524903321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS tools for database administration and change management [[electronic resource] /] / [Paolo Bruni ... et. al.]
| DB2 for z/OS tools for database administration and change management [[electronic resource] /] / [Paolo Bruni ... et. al.] |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | San Jose, CA, : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxvii, 324 p. : ill |
| Disciplina | 005.74 |
| Altri autori (Persone) | BruniPaolo |
| 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-9910449862403321 |
| San Jose, CA, : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
