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.
AIX and Linux interoperability [[electronic resource] /] / [Abhijit Chavan ... et al.]
| AIX and Linux interoperability [[electronic resource] /] / [Abhijit Chavan ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xvi, 300 p. : ill |
| Disciplina | 005.4/3 |
| Altri autori (Persone) | ChavanAbhijit |
| Collana | IBM redbooks |
| Soggetto topico | Operating systems (Computers) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450246103321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
AIX and Linux interoperability [[electronic resource] /] / [Abhijit Chavan ... et al.]
| AIX and Linux interoperability [[electronic resource] /] / [Abhijit Chavan ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xvi, 300 p. : ill |
| Disciplina | 005.4/3 |
| Altri autori (Persone) | ChavanAbhijit |
| Collana | IBM redbooks |
| Soggetto topico | Operating systems (Computers) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783396403321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
AIX and Linux interoperability / / [Abhijit Chavan ... et al.]
| AIX and Linux interoperability / / [Abhijit Chavan ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 |
| Descrizione fisica | xvi, 300 p. : ill |
| Disciplina | 005.4/3 |
| Altri autori (Persone) | ChavanAbhijit |
| Collana | IBM redbooks |
| Soggetto topico | Operating systems (Computers) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Identification and authentication -- 1.1 User security mechanisms -- 1.1.1 AIX security -- 1.1.2 Linux security -- 1.2 Pluggable Authentication Modules (PAM) -- 1.2.1 PAM configuration -- 1.2.2 PAM keywords -- 1.3 Linux PAM implementation -- 1.4 AIX PAM implementation -- 1.4.1 PAM modules and AIX -- 1.4.2 PAM applications and AIX -- Chapter 2. Centralized user management -- 2.1 Lightweight Directory Access Protocol (LDAP) -- 2.1.1 Introduction to LDAP -- 2.1.2 Using LDAP for authentication -- 2.2 Planning for LDAP authentication -- 2.3 LDAP servers -- 2.3.1 IBM Directory Server -- 2.3.2 The OpenLDAP directory server -- 2.4 Migrating user information to LDAP -- 2.4.1 Migrating users on Linux -- 2.4.2 Migrating users on AIX -- 2.5 LDAP authentication clients -- 2.5.1 AIX LDAP authentication client -- 2.5.2 Linux LDAP authentication client -- 2.5.3 PAM and NSS LDAP modules on AIX -- 2.6 Deploying LDAP for authentication -- 2.6.1 OpenLDAP server setup -- 2.6.2 AIX LDAP client setup -- 2.6.3 Linux LDAP client setup -- 2.7 Security considerations -- 2.7.1 Host access control -- 2.7.2 LDAP servers access and database backup -- 2.7.3 Encryption and PKI -- Chapter 3. Single sign-on -- 3.1 The Kerberos way -- 3.2 Kerberos configuration -- 3.2.1 Kerberos configuration files -- 3.2.2 Kerberos database -- 3.2.3 Controlling access to Kerberos -- 3.2.4 Starting Kerberos -- 3.3 Kerberos administration -- 3.3.1 Kerberos principals -- 3.3.2 Kerberos policies -- 3.3.3 Kerberos database management -- 3.3.4 Kerberos database replication -- 3.4 AIX Network Authentication Service (NAS) -- 3.4.1 Installing required packages -- 3.4.2 AIX Kerberos master server -- 3.5 Linux Kerberos support.
3.5.1 Red Hat Linux Kerberos packages -- 3.5.2 Configuring Kerberos on Linux -- 3.6 Discovering Kerberos services -- 3.6.1 Discovering Kerberos services using AIX NAS and LDAP -- 3.6.2 Discovering Kerberos services using DNS -- 3.7 Integrating Kerberos authentication -- 3.7.1 KDC setup -- 3.7.2 Standard Kerberos services -- 3.7.3 Kerberos authentication clients -- 3.8 Migrating users to Kerberos -- 3.9 Security considerations -- 3.10 Enterprise Identity Mapping (EIM) -- 3.10.1 EIM concepts -- 3.10.2 Using Enterprise Identity Mapping -- Chapter 4. Networking services -- 4.1 Protocols -- 4.1.1 Domain Name System (DNS) -- 4.1.2 Dynamic Host Configuration Protocol (DHCP) -- 4.1.3 Network Time Protocol (NTP) -- 4.1.4 Network Information Service (NIS) -- 4.2 Data transfers -- 4.2.1 rsync -- 4.2.2 rdist -- 4.3 Network management -- 4.3.1 SNMP -- 4.3.2 IBM Tivoli® Netview -- 4.3.3 ntop -- 4.3.4 UNIX network performance management commands -- Chapter 5. Sendmail -- 5.1 Sendmail overview -- 5.1.1 Installing Sendmail -- 5.1.2 Configuration file: sendmail.cf -- 5.1.3 Start and stop Sendmail -- 5.1.4 Mail aliases file -- 5.1.5 Mail queue -- 5.1.6 Mail logging -- 5.2 Mail server on AIX -- 5.2.1 Configuring mail server on AIX -- 5.2.2 Sending mail from Linux through an AIX hub -- 5.3 Mail server on Linux -- Chapter 6. Samba file and print server -- 6.1 Installing Samba on AIX -- 6.2 Installing Samba on Linux -- 6.3 Samba file and print server on AIX and client on Linux -- 6.3.1 Configuring a Samba server on AIX -- 6.3.2 Configuring a client on Linux -- 6.4 Samba file and print server on Linux and client on AIX -- 6.4.1 Configuring Samba server on Linux -- 6.4.2 Configuring a Samba client on AIX -- Chapter 7. NFS -- 7.1 What NFS is -- 7.2 Installing NFS on AIX -- 7.3 Installing NFS on Linux -- 7.4 Configuring an NFS server on AIX and an NFS client on Linux. 7.4.1 Configuring an NFS server on AIX -- 7.4.2 Configuring NFS client on Linux -- 7.5 Configuring an NFS server on Linux and an NFS client on AIX -- 7.5.1 Configuring an NFS server on Linux -- 7.5.2 Configuring the NFS client on AIX -- 7.6 Other NFS topics -- 7.6.1 NFS automount -- 7.6.2 User and group ID mapping -- 7.6.3 Access control lists -- 7.6.4 NFS locking -- Chapter 8. File systems and data archiving -- 8.1 Journaled File System (JFS) -- 8.1.1 Converting a existing ext3 file system to JFS -- 8.1.2 Using ACL on JFS -- 8.2 Universal Disk Format (UDF) -- 8.3 Backup and file systems -- 8.4 Data archiving -- Chapter 9. Security -- 9.1 IPSec -- 9.1.1 Security associations (SA) -- 9.1.2 Tunnels and key management -- 9.1.3 Installing IPSec on Linux -- 9.1.4 Installing IPSec on AIX -- 9.2 Security tools -- 9.2.1 OpenSSL -- 9.2.2 OpenSSH -- 9.2.3 tcp_wrapper -- Chapter 10. System administration applications -- 10.1 Web-based System Manager -- 10.1.1 Web-based System Manager architecture -- 10.1.2 Installing Web-based System Manager -- 10.1.3 Modes of operation -- 10.2 Web-based System Manager Client for Linux -- 10.2.1 Implementing a secure connection in server-client mode -- 10.2.2 Viewing configuration properties -- 10.3 Webmin -- 10.3.1 How to obtain Webmin -- 10.3.2 Installing Webmin -- 10.3.3 Starting the Webmin interface -- 10.3.4 Logging in to Webmin -- 10.3.5 Webmin panels/categories -- 10.3.6 Webmin security features -- Chapter 11. Printer sharing -- 11.1 Printing from Linux to a printer attached to AIX -- 11.1.1 Printing on AIX -- 11.1.2 Configuring remote printing on Linux -- 11.2 Printing from AIX to a printer attached to Linux -- 11.2.1 Installing a printer on Linux -- 11.2.2 Configuring remote printing on AIX -- 11.3 Configuring Directory-Enabled (LDAP) System V printing on AIX -- Chapter 12. Linux for IBM eServer pSeries and RS/6000. 12.1 Linux on a logical partition (LPAR) -- 12.2 AIX toolbox for Linux applications -- 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-9910824525203321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2003 | ||
| 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 | ||
| ||
Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.]
| Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.] |
| Autore | Ballard Chuck |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xx, 457 p. : ill |
| Collana | Redbooks |
| Soggetto topico |
Database management
Informix software |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783528103321 |
|
Ballard Chuck
|
||
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.]
| Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xx, 457 p. : ill |
| Collana | Redbooks |
| Soggetto topico |
Database management
Informix software |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450148603321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database strategies : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.]
| Database strategies : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xx, 457 p. : ill |
| Collana | Redbooks |
| Soggetto topico |
Database management
Informix software |
| 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 to this redbook -- 1.1 Understanding strategic directions for XPS -- 1.2 Objective of this redbook -- 1.3 Chapter abstracts -- Chapter 2. XPS and DB2 UDB architectures -- 2.1 High-level product overviews -- 2.1.1 IBM Informix Extended Parallel Server -- 2.1.2 DB2 Data Warehouse Edition -- 2.2 Understanding the architectures -- 2.3 Defining an instance -- 2.3.1 Informix XPS instance architecture -- 2.3.2 DB2 Universal Database instance architecture -- 2.4 Storage architecture -- 2.4.1 Pages -- 2.4.2 Containers and chunks -- 2.4.3 Logical disks -- 2.4.4 Logging -- 2.4.5 Storage architecture summary -- 2.5 Parallelism -- 2.5.1 The process model of XPS -- 2.5.2 The process model of DB2 -- 2.5.3 Intra-node parallelism -- 2.5.4 Inter-node parallelism -- 2.6 Memory management -- 2.6.1 XPS memory model -- 2.6.2 DB2 memory model -- 2.7 Partitioning -- 2.7.1 Fragmentation in XPS -- 2.7.2 Partitioning in DB2 -- 2.8 Terminology -- Chapter 3. Configuration -- 3.1 XPS and DB2 configuration -- 3.1.1 Knobs (configuration files and tuning parameters) -- 3.1.2 Commands -- 3.1.3 Granularity -- 3.1.4 Database manager -- 3.1.5 Dynamic parameters -- 3.1.6 Cataloging -- 3.1.7 Client access to DB2 instances -- 3.2 Configuration methods -- 3.2.1 DB2 configuration methods -- 3.2.2 Configuration Advisor and the AUTOCONFIGURE command -- 3.3 Configuration files and objects overview -- 3.3.1 Environment variables and the profile registry -- 3.3.2 Setting registry and environment variables -- 3.3.3 DB2 configuration files and objects -- 3.4 Configuring the instance -- 3.4.1 Page size(s) -- 3.4.2 Table spaces -- 3.4.3 Bufferpools -- 3.4.4 Physical and Logical Logs.
Chapter 4. Instance and database operations -- 4.1 Instance operation modes -- 4.1.1 Online mode -- 4.1.2 Offline mode -- 4.1.3 Quiescent mode -- 4.1.4 Creating and dropping the instance -- 4.2 Modifying the configuration -- 4.2.1 Working with the DAS -- 4.2.2 Viewing or updating the configuration using Control Center -- 4.2.3 Managing database partition groups -- 4.2.4 Managing buffer pools -- 4.3 Managing database storage -- 4.3.1 Table spaces and containers -- 4.3.2 Monitoring table space and container storage -- 4.3.3 Transactions and logs -- 4.4 Backup and recovery -- 4.4.1 Recovery types -- 4.4.2 Backup and restore methods -- 4.4.3 Table level restore -- 4.5 High availability -- 4.5.1 Log mirroring -- 4.5.2 Replication -- 4.5.3 Online split mirror and suspended I/O support -- 4.6 Security -- 4.6.1 Authorization and privileges -- 4.6.2 Roles and groups -- 4.6.3 Security levels -- 4.6.4 Client/server security -- 4.6.5 Authentication methods -- Chapter 5. Data types -- 5.1 Object names -- 5.2 Data type mapping -- 5.3 NULL values -- 5.4 Disk considerations -- 5.5 Character types -- 5.5.1 Truncation -- 5.5.2 NCHAR data type -- 5.5.3 VARCHAR data type -- 5.5.4 TEXT data type -- 5.6 Numerical data types -- 5.6.1 Numerical limits -- 5.7 DECIMAL -- 5.7.1 MONEY data type -- 5.7.2 SERIAL and SERIAL8 -- 5.8 Date and time types -- 5.8.1 DATE data type -- 5.8.2 DATETIME, TIME, and TIMESTAMP data types -- 5.8.3 INTERVAL data type -- 5.9 FLOAT -- 5.10 REAL or SMALLFLOAT -- 5.11 LOB data types -- 5.12 Sequence objects -- 5.13 Other object limits in DB2 -- 5.14 DB2 manuals -- Chapter 6. Data partitioning and access methods -- 6.1 Benefits of data partitioning -- 6.2 Hash fragmentation -- 6.3 Round robin fragmentation -- 6.4 Expression and range fragmentation -- 6.5 Hybrid fragmentation -- 6.6 Range partitioning using MDC -- 6.6.1 Benefits of MDC. 6.6.2 Design considerations for MDC tables -- 6.6.3 Operations on MDC tables -- 6.6.4 Space requirement for MDC -- 6.7 Range-clustered tables in DB2 -- 6.8 Roll-in and roll-out of data using UNION ALL views -- 6.8.1 Query optimization of UNION ALL views -- 6.8.2 Benefits of UNION ALL views -- 6.8.3 Limitations of UNION ALL views -- 6.9 MDC and UNION ALL views for roll-in and roll-out -- 6.10 Indexing strategies -- 6.10.1 Syntax for index creation -- 6.10.2 DB2 index expansions -- 6.10.3 Index types and access methods -- 6.10.4 Space requirements for indexes -- 6.10.5 Table and Index reorganization on DB2 -- 6.11 Joins -- 6.11.1 Join syntax -- 6.11.2 Join methods (generic) -- 6.11.3 Join strategies in a partitioned database -- 6.11.4 MERGE, UPDATE, and DELETE joins -- 6.12 Optimizer -- 6.12.1 The role of query optimizer -- 6.12.2 LEO: Learning Optimizer -- 6.12.3 Push-down hash join -- 6.12.4 Optimization strategies for intra-partition parallelism -- 6.12.5 Directives -- 6.12.6 Optimization classes -- 6.13 Performance enhancements in DB2 UDB V8.1 -- 6.13.1 Distributed catalog cache -- 6.13.2 Prefetch -- 6.13.3 Page cleaner I/O improvements -- 6.13.4 Multi-threading of Java-based routines -- 6.13.5 Join variations -- 6.13.6 Increased opportunity for selection of bit-filters -- 6.13.7 Informational constraints -- 6.13.8 Uniform page size -- Chapter 7. SQL considerations -- 7.1 SELECT issues -- 7.1.1 Selectivity -- 7.1.2 Statistical sampling -- 7.1.3 SELECT cursors -- 7.1.4 Joins -- 7.2 MATCHES predicate -- 7.3 Comments -- 7.4 SQLCODE and SQLSTATE -- 7.5 Built-in functions -- 7.6 SQL access to system catalogs -- 7.7 Quotations and character strings -- 7.8 Concatenation behavior -- 7.9 Implicit casting -- 7.10 Deferred constraint checking -- 7.11 Set Operators: UNION, INTERSECT, and MINUS -- 7.12 Multi-database access -- 7.13 Temporary tables. 7.13.1 Implicit -- 7.13.2 Explicit -- 7.14 Compound SQL -- 7.15 INSERT cursors -- 7.16 MERGE INTO -- 7.17 Online analytical processing SQL -- 7.18 Isolation levels -- 7.19 Optimizer directives -- 7.20 DDL issues -- 7.20.1 Creating and altering tables -- 7.20.2 Synonyms -- 7.20.3 Primary key definitions -- 7.20.4 Constraint naming -- 7.21 Triggers -- 7.21.1 SELECT triggers -- 7.21.2 BEFORE-statement triggers -- 7.21.3 Disabling triggers -- 7.22 Multidimensional Clustering in DB2 -- 7.23 DB2 Materialized Query Tables -- 7.23.1 Using and Configuring MQTs -- 7.24 System commands -- 7.24.1 CREATE DATABASE -- 7.24.2 Administrative commands -- 7.25 Statistics for table and indexes -- 7.26 Query Monitoring -- Chapter 8. Loading and unloading data -- 8.1 Loading and inserting data in a single stream -- 8.2 Parallel bulk loading -- 8.2.1 Handling bad rows -- 8.2.2 Performance and tuning considerations for loading with DB2 -- 8.3 Parallel unloading -- 8.3.1 XPS unloading -- 8.3.2 DB2 unloading -- 8.3.3 Parallel exports -- 8.4 Specific issues -- Chapter 9. Administration tools and utilities -- 9.1 Resource management -- 9.2 Performance tuning -- 9.3 Tools and wizards that are included with DB2 -- 9.3.1 Control Center -- 9.3.2 Command Editor -- 9.3.3 Task Center -- 9.3.4 SQL Assist -- 9.3.5 Visual Explain -- 9.3.6 Configuration Assistant -- 9.3.7 Journal -- 9.3.8 Health Center -- 9.3.9 Replication Center -- 9.3.10 License Center -- 9.3.11 Information Catalog Center -- 9.3.12 Data Warehouse Center -- 9.3.13 Web administration -- 9.3.14 Wizards, advisors, and launchpads -- 9.4 Optional tools -- 9.4.1 DB2 Performance Expert -- 9.4.2 DB2 Recovery Expert -- 9.4.3 DB2 High Performance Unload -- 9.4.4 DB2 Test Database Generator -- 9.4.5 DB2 Table Editor -- 9.4.6 DB2 Web Query Tool -- 9.4.7 Query Patroller -- 9.5 Utilities -- 9.5.1 Database reorganization. 9.5.2 Database statistics -- 9.5.3 Schema extraction -- 9.5.4 Maintaining database integrity -- 9.5.5 Throttling utilities -- 9.5.6 Validating a backup -- 9.6 Other administrative operations -- 9.6.1 Configuring automatic maintenance -- 9.7 Monitoring tools and advisors -- 9.7.1 Health check tools -- 9.7.2 Memory Visualizer -- 9.7.3 Storage Manager -- 9.7.4 Event monitor -- 9.7.5 Snapshots -- 9.7.6 Activity Monitor -- 9.7.7 DB2 Performance Expert -- 9.7.8 The db2pd utility, an onstat equivalent -- 9.7.9 Diagnostic files -- 9.7.10 Error message and command help -- Chapter 10. Planning the transition -- 10.1 Tasks and activities -- 10.1.1 Readiness assessment and scope -- 10.1.2 Tool evaluation -- 10.1.3 Estimating project duration -- 10.2 Data conversion -- 10.2.1 Preparation overview -- 10.2.2 Data conversion process -- 10.2.3 Time planning -- 10.2.4 The database structure -- 10.2.5 Data movement approaches -- 10.2.6 WebSphere Information Integrator -- 10.2.7 Modifying the application -- 10.2.8 Database objects and interfaces -- 10.3 After the transition -- Chapter 11. Application conversion considerations -- 11.1 Key considerations -- 11.2 Application transitioning from XPS to DB2 -- 11.3 Transactions -- 11.4 Savepoints -- 11.5 Locks and isolation levels -- 11.5.1 Lock escalation -- 11.5.2 Deadlocks -- 11.5.3 Isolation levels -- 11.6 Packages -- 11.6.1 Static versus Dynamic SQL -- 11.6.2 Binding -- 11.7 Cursors -- 11.8 Stored procedures -- 11.9 Programming languages -- 11.9.1 ESQL/C -- 11.9.2 JDBC -- 11.9.3 ODBC/CLI -- 11.9.4 C++ -- 11.9.5 Large objects -- 11.9.6 SQL Communications Area -- 11.9.7 SQLDA -- Chapter 12. DB2 Migration ToolKit for Informix -- 12.1 Features and functionality -- 12.2 Recommendations for Use -- 12.2.1 MTK installation and configuration -- 12.2.2 MTK Configurations -- 12.3 Technical overview of MTK -- 12.3.1 The MTK GUI. 12.3.2 The migration process. |
| Record Nr. | UNINA-9910825287103321 |
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 recovery expert for multiplatforms [[electronic resource] /] / [Bart Steegmans, Mark Samson, Manish Shah]
| DB2 recovery expert for multiplatforms [[electronic resource] /] / [Bart Steegmans, Mark Samson, Manish Shah] |
| Autore | Steegmans Bart |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2002 |
| Descrizione fisica | 1 online resource (300 p.) |
| Disciplina | 005.8/6 |
| Altri autori (Persone) |
SamsonMark
ShahManish |
| Collana | IBM redbooks |
| Soggetto topico |
Database management
Data recovery (Computer science) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910454045203321 |
|
Steegmans Bart
|
||
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2002 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
