Strategizing DB2-transforming from Oracle O & M

Strategizing DB2-transforming from Oracle O & M (the first choice for database O & M workers)
Basic Information
Author: Wang feipeng Wang fuguo Liu xusun Yue [Translator's introduction]
Series name: dancing DB2 Series
Press: Electronic Industry Press
ISBN: 9787121177439
Mounting time:
Published on: February 1, August 2012
Start: 16
Page number: 480
Version: 1-1
Category: Computer

More about "" and "strategizing DB2 -- transforming from Oracle O & M" (the first choice for database O & M workers)
Introduction
Books
Computer books
Strategizing DB2-transforming from Oracle O & M is the third edition of the DB2 series.
The book interprets the management and maintenance of DB2 databases in easy-to-understand languages, and puts forward new ideas for DB2 O & M, it also elaborates on common problems, analysis ideas and solutions of DB2 databases in the O & M process from the perspective of actual practice, with typical industry cases, which are interlocking and brilliant, it is a worthy DB2 learning book.
"Strategizing DB2-transformation from Oracle O & M" is suitable for reading and using database administrators, database O & M personnel, database architects, database consultants, and college students studying database O & M technologies or teachers engaged in related courses.
Directory
Strategizing DB2-transforming from Oracle O & M
Chapter 2 dBA and DB2 O & M 1
1.1 DBAs confusion: transformation from Oracle to DB2 O & M 2
1.1.1 "database generation II" past and present 2
1.1.2 challenges to Oracle transformation 4
1.2 DBAs, Do you have confidence in your career? 6
1.2.1 which database is more promising: Oracle or DB2 7
1.2.2 "Qian tu" and what is more important for improving capabilities 8
1.3 DBA's responsibilities: unlimited scenery in Qifeng 9
1.3.1 routine maintenance 10
1.3.2 troubleshooting 14
1.4 DBA practice: strategizing and winning 17 thousand miles
1.4.1 building a golden house 17
1.4.2 proficient in software and hardware 18
1.4.3 Strengthen Spiritual Cultivation 19
1.4.4 skilled tools 20
1.5 readers using this book 23
1.6 O & M strategy notes -- strategizing from Mongolia 23
1.7 Conclusion 25
Chapter 2 DB2 installation and configuration-yoga-style O & M setting sail 26
2.1 find out the features of the version-DB2 version and features 27
2.1.1 meet her and select her-DB2 version 27
2.1.2 understand her-DB2 features 28
2.2 is not "difficult to start with everything"-DB2 installation 30
2.2.1 key first step-modifying system kernel parameters 30
2.2.2 easy to start-install DB2 31 on Linux platform through the installation wizard
2.2.3 advanced DB2 installation method (applicable to Linux/Unix platforms) 40
2.2.4 enjoy results-database operation experience 44
2.2.5 differences in installation on different platforms-key points for installation on Windows, Linux, and UNIX platforms 45
2.2.6 DB2 installation FAQ 47
2.3 configuration determines everything-DB2 environment and parameter configuration 49
2.3.1 environment variable (environment variables) 50
2.3.2 file Registry 51
2.3.3 Database Manager configuration parameters (dbm cfg) 52
2.3.4 database configuration parameters (db cfg) 53
2.3.5 instance 54 configured with Parameters
2.4 DB2 database system cataloguing 56
2.4.1 what is DB2 cataloguing Table 56
2.4.2 syscat cataloguing view 57
2.4.3 sysstat cataloguing view 60
2.4.4 comparison with Oracle Data Dictionary 61
2.5 O & M strategy notes-62
2.6 summary 63
Chapter 2 confused view-DB2 management and operations 64
3.1 starting from the DB2 architecture 65
3.1.1 DB2 architecture: hierarchical management 65
3.1.2 DB2 process model: thread vs process 66
3.1.3 understanding the DB2 Memory Model: Not easy 69
3.2 DB2 instance 75
3.2.1 what is instance 76
3.2.2 what you must know: instance management command 77
3.3 DB2 database 78
3.3.1 create a database: There are so many knowledge 78
3.3.2 what you must know: database management command 80
3.4 DB2 tablespace 82
3.4.1 types of tablespaces: Actually many 82
3.4.2 what you must master: DB2 storage plan 83
3.4.3 three axes for tablespace Management 88
3.4.4 overcome difficulties: reduce the table space high level mark 91
3.5 DB2 access and Operations 95
3.5.1 DB2 access interface 95
3.5.2 remote database access method 96
3.5.3 practice: connect to remote database 98
3.5.4 what you must understand: Practical DB2 command 100
3.6 DB2 Security Control 102
3.6.1 what is authentication 102 in DB2?
3.6.2 what is authorization 104 in DB2?
3.6.3 how to encrypt sensitive data 117
3.6.4 Security cornerstone of the three-tier architecture: Trusted context 120
3.7 O & M strategy notes-When oracle users meet DB2 121
3.8 summary of this chapter 122
Chapter 2 Open Sesame door-DB2 Data Warehouse 4th
4.1 what is a data warehouse 124
4.1.1 Data Warehouse misunderstanding 124
4.1.2 data warehouse architecture 126
4.2 DB2 features supporting data warehouses 127
4.2.1 partitioned database 127
4.2.2 flexible Data Partition 129
4.2.3 join policy 132 in a partitioned Environment
4.2.4 materialized query Table 134
4.3 DB2 Data Warehouse System Design 135
4.3.1 BCU/BPU design principles 135
4.3.2 principle of data storage on BPU 138
4.3.3 Database File System Division 138
4.3.4 database generated in the repository 139
4.3.5 design of database partition groups 139
4.3.6 buffer pool design 140
4.3.7 Database Log design 141
4.3.8 table space design 142
4.3.9 table storage skills 142
4.3.10 Data Compression 143
4.4 Data Warehouse practice 143
4.4.1 hardware environment 143
4.4.2 Planning and Implementation of instances in a data warehouse 144
4.4.3 Planning and Implementation of databases in Data Warehouses 149
4.4.4 DB2 parameter settings in the data warehouse 152
4.4.5 others 154
4.5 DB2 workload management (WLM) 156
4.5.1 create WLM monitoring 156
4.5.2 how to control the load of known jobs by 158
4.5.3 how to control unforeseen workloads 159
4.5.4 limits the workload of parallel load by 162
4.6 daily data warehouse O & M 163
4.6.1 is the DB2 Data Warehouse scalable? 163
4.6.2 maintain database partitions 163
4.6.3 two common commands in a partitioned Database: 168
4.6.4 Data Warehouse backup and recovery 169
4.7 comparison with Oracle Data Warehouse 169
4.8 O & M strategy notes: predict where a subway is built before purchasing a house. 170
4.9 summary of this Chapter 172
Chapter 4 lock processing and Concurrency Control in O & M 5th
5.1-database O & M in Concurrent Environments 174
5.2 magic weapon for concurrency control-DB2 lock mechanism resolution 180
5.2.1 lock and transaction consistency 181
5.2.2 lock types and relationships 184
5.3 custom concurrency-DB2 isolation level 188
5.3.1 isolation-level resolution 188
5.3.2 isolation level setting 190
5.3.3 isolation level and lock FAQ 192
5.4 model drama-Case Study of lock 194
5.4.1 unlock "template" routine 194
5.4.2 Sha jiabang started 195
5.4.3 lock wait analysis 197
5.4.4 lock timeout analysis 202
5.4.5 lock upgrade analysis 205
5.4.6 Deadlock Detection 206
5.5 careful calculation -- DB2 concurrency is maximized by 215
5.5.1 concurrency and performance problems 215
5.5.2 concurrency and application design 216
5.5.3 how to maximize concurrency by 217
5.6 strong PK-Comparison of DB2 and Oracle concurrency mechanisms 220
5.7 experience-Tips for improving system concurrency 221
5.8 O & M strategy notes: Have you ever purchased online tickets? If it feels slow, let's take a look at 224.
5.9 conclusion 225
Chapter 2 routine DB2 O & M-Monitoring 6th
6.1 required courses for O & M personnel-monitoring 227
6.1.1 principles of monitoring 227
6.1.2 monitoring task 228
6.2 what do you need to do every day 230
6.2.1 monitoring bucket status 231
6.2.2 host status monitoring: 234
6.2.3 check database status 236
6.2.4 daily monitoring tasks and commands table 245
6.3 what do you need to do every week 246
6.3.1 check full backup 246
6.3.2 check whether runstats 248 is required
6.3.3 check whether the table needs to be reorganized 248
6.3.4 search for and re-bind the invalid package 250
6.3.5 monitoring changes to new objects and applications 250
6.4 what do you need to do every month 252
6.4.1 monthly completion of monitoring 252
6.4.2 statistics increase by 253
6.4.3 check permission change 254
6.4.4 Audit user operations 255
6.4.5 check the Software Update 258
6.5 Monitoring Tool-DB2 monitoring tool 259
6.5.1 snapshot monitor 259
6.5.2 event monitor 262
6.5.3 monitor table function 266
6.5.4 management view 268
6.5.5 db2pd 270
6.5.6 db2top 273
6.6 how to monitor specific problems 274
6.7 O & M strategy notes-female O & M guide 280
6.8 conclusion 281
Chapter 4 prepare for disaster-database backup and recovery 7th
7.1 DB2 Diamond's secret 283
7.1.1 O & M personnel must see the log truth 283
7.1.2 disaster recovery caused by sudden power failure: 290
7.1.3 archiving logs is awesome and can scare people by 292
7.1.4 relationship between logs and Backup Recovery 295
7.2 start with one stop: 295
7.2.1 is backup simple? 295
7.2.2 teach you how to use BACKUP command 298
7.2.3 Oracle, DB2, version recovery, and Rollback Recovery 300
7.2.4 teach you how to use restore and rollforward commands 302
7.2.5 There is a shortcut: The recover command restores 306
7.2.6 tips: Restore the deleted table 309
7.3 step on the accelerator and run 312
7.3.1 backup and recovery 312
7.3.2 Incremental backup and recovery 313
7.3.3 full backup and tablespace backup 316
7.3.4 large-capacity tape library backup recovery 318
7.3.5 redirect to recover data-322 of the requests for machine damage
7.3.6 flash copy-advanced backup method 326
7.4 toolkit 327
7.4.1 metric tool 327
7.4.2 view history 329
7.4.3 check backup media integrity 331
7.4.4 instance parameter Export and Import 332
7.5 backup and recovery in the DPF partition environment 333
7.5.1 features of backup and recovery in the DPF partition environment 333
7.5.2 discuss Backup and Restore command 334 again
7.5.3 the following commands must be known: db2_all and Raah command 337
7.6 best practices 338
7.6.1 understand DB2 backup policy 338
7.6.2 how can I keep my backups well organized? 339
7.6.3 what other parameters can be adjusted? 340
7.7 O & M strategy notes-one-stop solution 342
7.8 conclusion 343
Chapter 4 data movement-age of data migration 8th
8.1 Data migration is always ready for 345
8.1.1 mobile data is not easy: 345
8.1.2 mobile means do more and benefit 345
8.1.3 "Mobile Grain and grass" first 346
8.2 data migration twins-port brothers 348
8.2.1 teach you how to use the Export command to export data 348
8.2.2 teach you how to use the import command to import data 353
8.3 load view 363
8.3.1 teach you how to use the load command to import data 363
8.3.2 four phases of load 366
8.3.3 you need to know the table status and response methods during the load process 368
8.3.4 the load speed is the same as that of Liu Xiang.
8.3.5 load is good, or import is better 372
8.4 what other mobile methods are available? 373
8.4.1 move data between databases using db2move 374
8.4.2 use admin_move_table to move the table in the database 378
8.4.3 use admin_copy_schema to move objects in the database 382
8.4.4 special object moving method 383
8.4.5 mobile data on the physical layer: 389
8.5 move data in Multi-partition environments by 395
8.5.1 load 395 in Multi-partition Environments
8.5.2 load in Multi-partition environments 400
8.6 comparison between Oracle Data movement and DB2 data movement 401
8.7 O & M strategy notes-three indicators tested 402
8.8 summary of this Chapter 403
Chapter 2 database Fault Diagnosis 9th
9.1 fire-fighting 405
9.1.1 is the database faulty? Urgent! 405
9.1.2 FAQs and fault categories 407
9.1.3 troubleshooting 6 tips 408
9.1.4 daily O & M protection before occurrence 409
9.2 fault diagnosis tools you must master 410
9.2.1 collection of diagnostic information by db2support 410
9.2.2 db2diag analysis accident scene 413
9.2.3 db2pd diagnosis and tuning 415
9.2.4 db2trc tracking internal DB2 operations 416
9.3 A thrilling troubleshooting practice 417
9.4 DB2 database troubleshooting case set 420
9.4.1 instance-related issue highlights 421
9.4.2 storage planning problem 425
9.4.3 a basket of 431 DB2 logs, backup and recovery
9.4.4 load, be sure to hold 433
9.4.5 routine O & M 435
9.4.6 Data Warehouse troubleshooting 436
9.5 O & M strategy notes-Haha, IBM people like to see problems on pangu 440
9.6 conclusion 441
Appendix A comparison between Oracle and DB2 442
Appendix B Comparison of Oracle and DB2 terms 444
Appendix C comparison of Oracle and DB2 commands 446
Appendix D abbreviations 450
Postscript 455
References 456

This book is from: China Interactive publishing network