DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [First edition.] |
Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
Descrizione fisica | 1 online resource (1248 p.) |
Disciplina | 005.7565 |
Soggetto topico | Database management - Examinations |
Soggetto genere / forma | Electronic books. |
ISBN | 1-58347-716-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
Record Nr. | UNINA-9910460827703321 |
Saraswatipura Mohankumar
![]() |
||
Boise, ID : , : MC Press Online, LLC, , [2015] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [First edition.] |
Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
Descrizione fisica | 1 online resource (1248 p.) |
Disciplina | 005.7565 |
Soggetto topico | Database management - Examinations |
ISBN | 1-58347-716-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
Record Nr. | UNINA-9910797930103321 |
Saraswatipura Mohankumar
![]() |
||
Boise, ID : , : MC Press Online, LLC, , [2015] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [First edition.] |
Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
Descrizione fisica | 1 online resource (1248 p.) |
Disciplina | 005.7565 |
Soggetto topico | Database management - Examinations |
ISBN | 1-58347-716-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
Record Nr. | UNINA-9910822041103321 |
Saraswatipura Mohankumar
![]() |
||
Boise, ID : , : MC Press Online, LLC, , [2015] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
IBM Db2 11. 1 certification guide : explore techniques to master database programming and administration tasks in IBM Db2 / / Mohankumar Saraswatipura, Robert Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, London ; ; Mumbai : , : Packt, , 2018 |
Descrizione fisica | 1 online resource (474 pages) |
Disciplina | 005.7565 |
Soggetto genere / forma | Electronic books. |
ISBN | 1-78862-787-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910466518303321 |
Saraswatipura Mohankumar
![]() |
||
Birmingham, London ; ; Mumbai : , : Packt, , 2018 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
IBM Db2 11. 1 certification guide : explore techniques to master database programming and administration tasks in IBM Db2 / / Mohankumar Saraswatipura, Robert Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, London ; ; Mumbai : , : Packt, , 2018 |
Descrizione fisica | 1 online resource (474 pages) |
Disciplina | 005.7565 |
Soggetto non controllato |
Database Management
Relational Databases Electronic Data Processing Personnel Computers |
ISBN | 1-78862-787-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910796738803321 |
Saraswatipura Mohankumar
![]() |
||
Birmingham, London ; ; Mumbai : , : Packt, , 2018 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
IBM Db2 11. 1 certification guide : explore techniques to master database programming and administration tasks in IBM Db2 / / Mohankumar Saraswatipura, Robert Collins |
Autore | Saraswatipura Mohankumar |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, London ; ; Mumbai : , : Packt, , 2018 |
Descrizione fisica | 1 online resource (474 pages) |
Disciplina | 005.7565 |
Soggetto non controllato |
Database Management
Relational Databases Electronic Data Processing Personnel Computers |
ISBN | 1-78862-787-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910812752003321 |
Saraswatipura Mohankumar
![]() |
||
Birmingham, London ; ; Mumbai : , : Packt, , 2018 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|