IBM Db2 11. 1 certification guide explore techniques to master database programming and administration tasks in IBM Db2
Mastering material for dealing with DBA certification exams About This Book Prepare yourself for the IBM C2090-600 certification exam Cover over 50 Db2 procedures including database design, performance, and security Work through over 150 Q&As to gain confidence on each topic Who This Book Is For...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, London ; Mumbai :
Packt
2018.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630612806719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright and Credits
- Packt Upsell
- Foreword
- Contributors
- Table of Contents
- Preface
- Chapter 1: Introduction to the Db2 Certification Path
- Db2 11.1 Certification track
- Db2 10.5 Fundamentals for LUW-Exam C2090-615
- Db2 11.1 Fundamentals for LUW-Exam C2090-616
- Db2 11.1 DBA for LUW-Exam C2090-600
- Preparing for the C2090-600 certification exam
- Registering for the C2090-600 certification exam
- Summary
- Chapter 2: Db2 Server Management
- Working with Db2 instances
- Creating an instance
- Dropping an instance
- Listing instances
- Displaying the Db2 service level
- Verifying the database's readiness for upgrading
- Upgrading a database instance
- Starting and stopping an instance
- Attaching and detaching to an instance
- Quiescing an instance
- Configuring the Db2 system environment
- Listing and modifying the global registry
- Aggregate registry variables
- Configuring Db2 instances and databases
- The Db2 database manager configuration
- The Db2 database configuration
- DB2 autonomic computing features
- Self-Tuning Memory Manager (STMM)
- Automatic storage
- Creating storage groups
- Altering storage groups
- Dropping storage groups
- A word about Db2 workload manager (WLM)
- The WLM objects
- Workloads
- Thresholds
- Work action and work class sets
- Histogram templates
- A word about IBM Data Server Manager (DSM)
- Summary
- Practice questions
- Solutions
- Chapter 3: Physical Design
- Database planning
- Creating a Db2 database
- Enabling automatic storage
- Buffer pools
- Buffer pool planning
- Creating a buffer pool
- Altering a buffer pool
- Storage groups
- Storage group planning
- Altering storage groups
- Renaming a storage group
- Dropping a storage group
- Tablespaces
- Containers
- Tablespace planning
- Creating tablespaces.
- Adding containers to automatic storage tablespaces
- Tablespace rebalance operation
- Reclaimable storage
- Converting DMS tablespaces to use automatic storage
- Smart disk storage management
- Creating a table
- Alter table
- Expression-based indexes
- Invalidation of database objects
- Revalidation of database objects
- Online table move
- Tracking the execution of online table move
- Online table move planning
- Online table move-running changes
- Copy schema procedure
- Range clustering and range partitioning tables
- Range clustered tables
- Range clustered table planning
- Range partitioned tables
- Listing the data partitions
- Detaching a data partition
- Attaching a data partition
- MDC
- MQT
- ITC
- Db2 BLU Acceleration
- Implementing BLU
- BLU compression and statistics
- BLU disk space management
- BLU platform management
- Anatomy of a columnar table
- Db2 V11.1 BLU advances
- db2convert
- Db2 pureScale
- Members
- Cluster-caching facility (CF)
- Shared disk storage
- Cluster services and interconnect
- Db2 v11.1 pureScale advances
- Availability
- Installation and upgrades
- Management and performance
- Features
- Self-tuning database memory manager (STMM) in pureScale
- Self-tuning CF memory in pureScale
- Db2_DATABASE_CF_MEMORY (DB2 registry variable)
- CF_DB_MEM_SZ (DB CFG in 4K pages)
- CF_GBP_SZ, CF_LOCK_SZ, CF_SCA_SZ (DB CFG in 4K pages)
- Data compression
- Static row compression
- Should the table be compressed?
- Getting information about the compression dictionary
- Building a row compression dictionary
- Index compression
- LOBs and XML compression
- Temporary tables and replication support
- Adaptive compression
- SQL compatibilities
- Compatibility features for Netezza
- Summary
- Practice questions
- Solutions
- Chapter 4: Implementing Business Rules.
- Business rules
- NOT NULL constraints
- DEFAULT constraints
- CHECK constraints
- UNIQUE constraints
- NOT ENFORCED informational constraints
- Referential integrity constraints
- The INSERT rule for referential constraints
- The update rule for referential constraints
- The delete rule for referential constraints
- The SET INTEGRITY statement
- Views with CHECK OPTION
- Creating and using triggers
- The system catalog views
- Summary
- Practice questions
- Answers
- Chapter 5: Monitoring Db2 Activity
- Monitoring infrastructure
- Monitoring table functions
- Monitoring system information
- Monitoring activities
- Monitoring data objects
- Monitoring locks
- Monitoring system memory
- Monitoring the pureScale environment
- Additional monitoring table functions
- Monitoring table functions: a quick reference
- Administrative views for monitoring
- A word about the MONREPORT module
- Event monitors
- EXPLAIN facility tools
- A word about the EXPLAIN operators
- Db2 troubleshooting tools
- The db2pd command
- The dsmtop command
- Summary
- Practice questions
- Solutions
- Chapter 6: Db2 Utilities
- Data movement file formats
- Data movement utilities
- The Db2 Export utility
- The Db2 Import utility
- The Db2 Load Utility
- Phases of a load operation
- Data load best practices for BLU Column-Organized Tables
- Monitoring a Load operation
- The DB2 Ingest Utility
- Monitoring an Ingest operation
- DB2 utilities comparison - Import vs. Ingest vs. Load
- A word about the CATALOG STORAGE ACCESS command
- Other DB2 data movement options
- The SYSPROC.ADMIN_MOVE_TABLE () procedure
- The SYSPROC.ADMIN_COPY_SCHEMA () procedure
- Object Copy using the db2move command
- A word about the db2look tool command
- Database maintenance utilities
- The REORGCHK utility
- The REORG Utility
- The RUNSTATS Utility.
- The REBIND Utility
- Flushing the Package Cache Utility
- The ADMIN_CMD () procedure
- Summary
- Practice questions
- Answers
- Chapter 7: High Availability
- Transactions and logging parameters
- Transaction logging strategies
- Database recovery methods
- Backup and recovery
- The Db2 backup utility
- Incremental and delta backups
- A word about hardware accelerated backup
- The Db2 restore utility
- The Db2 roll-forward utility
- The Db2 recover utility
- A word about the db2relocatedb command
- High availability and disaster recovery
- HADR synchronization modes
- HADR-specific parameters
- Setting up an HADR multiple standby environment
- A word about the Db2 HA instance configuration utility (db2haicu)
- Activating the RoS feature
- Db2 pureScale architecture
- Geographically dispersed Db2 pureScale db2cluster (GDPC)
- Db2 pureScale db2cluster service command options
- Explicit Hierarchical Locking
- Summary
- Practice questions
- Answers
- Chapter 8: Db2 Security
- Authentication and authorization
- Authorities and privileges
- Authorities
- The system administrative authority (SYSADM)
- The system control authority (SYSCTRL)
- The system maintenance authority (SYSMAINT)
- The system monitor authority (SYSMON)
- The database administrator authority (DBADM)
- The security administrator authority (SECADM)
- The SQL administrator (SQLADM) authority
- The workload management administrator authority (WLMADM)
- The Explain administrator authority (EXPLAIN)
- The Access control administrator authority (ACCESSCTRL)
- The data access administrator authority (DATAACCESS)
- The data load (LOAD) authority
- Privileges
- LDAP-based authentication
- Role-based access control
- Trusted context and trusted connections
- Row and column access control (RCAC)
- Row permissions
- Column masks.
- The Db2 audit facility
- Audit policies
- The db2audit tool command
- Secure Socket Layer (SSL) implementation in Db2
- Db2 native encryption
- Summary
- Practice questions
- Answers
- Other Books You May Enjoy
- Index.
