Wonder Club world wonders pyramid logo
×

Advanced topics in DB2 Book

Advanced topics in DB2
Advanced topics in DB2, and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b, Advanced topics in DB2 has a rating of 4.5 stars
   2 Ratings
X
Advanced topics in DB2, and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b, Advanced topics in DB2
4.5 out of 5 stars based on 2 reviews
5
50 %
4
50 %
3
0 %
2
0 %
1
0 %
Digital Copy
PDF format
1 available   for $99.99
Original Magazine
Physical Format

Sold Out

  • Advanced topics in DB2
  • Written by author Blaine Lucyk
  • Published by Reading, Mass. : Addison-Wesley, c1993., 1993/04/30
  • and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b
Buy Digital  USD$99.99

WonderClub View Cart Button

WonderClub Add to Inventory Button
WonderClub Add to Wishlist Button
WonderClub Add to Collection Button

Book Categories

Authors

Pt. I Environment Topics 1
1 How Many Environments / Subsystems to Set Up 3
2 Names and Authids: Ownership Has Its Privileges 21
3 Change Management and Database Migration 41
4 Mass Data Movement Using Full Image Copies 79
5 Mass Data Movement Using DFDSS 99
6 Data Movement Using Incremental Image Copies 107
7 RRDF Provides Ad Hoc Refresh and Continuous Availability 123
8 Stress Testing 133
9 QMF Print Command and Printers 153
10 QMF Batch 159
11 How To Split Screen from within QMF 163
12 How To Solve Inconsistent Timestamps 165
13 How To Circumvent DB2 Timestamp Consistency Checks 175
Pt. II Database Design Topics 181
14 Data Integrity Check 183
15 Placeholders 193
16 Surrogate Keys 201
17 Hot Spots 207
18 Sparse Indexes 213
19 Revolving Tablespaces 215
20 Batch Restartability 223
Pt. III SQL Topics 229
21 How To List Plans That Use Tablespace Scans 231
22 How To Enforce Domain Rules Using View DDL 233
23 How To Find Duplicate Rows 235
24 How To List Unused Indexes and Unusable Plans 237
25 How To Flip the Close Rule 239
26 How To Handle the Outer Join Problem 241
27 Existential Quantifier and Why It Is So Useful 247
28 Cautions About the Null Attribute 257
Pt. IV Performance Topics 263
29 Free Space: How Much Is Optimal? 265
30 How To Load a Tablespace with Varying Free Space 279
31 A Faster Method of Building Indexes 287
32 How To Tell When Your Tablespaces Have Gone into Extents 291
33 Denormalize versus DB2 Join 295
34 Influencing List Prefetch 311
35 RCT Design and Trade-offs 319
Pt. V Backup and Recovery Topics 341
36 How To Do Total System Backup and Recovery Quickly 343
37 How To Resurrect a Dropped Tablespace 349
38 How To Resurrect a Dropped Table 363
39 How To Back Out a Corrupting Program 373
40 How To Analyze a Deadlock 403
41 How To Get Information Out of the Log Using DSN1LOGP 413
42 How To Resurrect a Deleted Row Using Repair 421
Pt. VI Appendixes 437
A Useful Tools: CLISTs and Edit Macros 439
B How To Convert from Hexadecimal to Decimal 447
C Two's Complement Arithmetic: How To Interpret Numbers in DB2 451
D DB2 Page Formats 453
E Third-Party Vendor DB2 Tools 457
F VSAM Buffering Improves DSN1COPY Performance 493
References: Consolidated List 497
Index 501


Login

  |  

Complaints

  |  

Blog

  |  

Games

  |  

Digital Media

  |  

Souls

  |  

Obituary

  |  

Contact Us

  |  

FAQ

CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!!

X
WonderClub Home

This item is in your Wish List

Advanced topics in DB2, and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b, Advanced topics in DB2

X
WonderClub Home

This item is in your Collection

Advanced topics in DB2, and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b, Advanced topics in DB2

Advanced topics in DB2

X
WonderClub Home

This Item is in Your Inventory

Advanced topics in DB2, and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-b, Advanced topics in DB2

Advanced topics in DB2

WonderClub Home

You must be logged in to review the products

E-mail address:

Password: