Australasia's Biggest Online Store

We won't be beaten by anyone. Guaranteed

DB2 Developer's Guide

New or Used: $139.88
Product Details

Table of Contents

Preface xxiiiPART I: SQL TECHNIQUES, TIPS, AND TRICKSChapter 1 The Magic Words 3An Overview of SQL 4SQL Tools of the Trade 13Static SQL 42Dynamic SQL 44SQL Performance Factors 45Chapter 2 Data Manipulation Guidelines 56A Bag of Tricks 56SQL Access Guidelines 58Complex SQL Guidelines 90Common Table Expressions and Recursion 110Working with Nulls 115Date and Time Guidelines 119Data Modification Guidelines 125Chapter 3 Using DB2 Functions 135Aggregate Functions 135Scalar Functions 141Table Functions 159MQSeries Built-In Functions 159XML Built-In Functions 161The RAISE_ERROR Function 162The CAST Operation 163Built-In Function Guidelines 163Chapter 4 Using DB2 User-Defined Functions and Data Types 167What Is a User-Defined Function? 167Types of User-Defined Functions (UDFs) 168What Is a User-Defined Data Type? 190User-Defined Data Types (UDTs) and Strong Typing 191Chapter 5 Data Definition Guidelines 200An Overview of DB2 Database Objects 200DB2 Databases 201Creating and Using DB2 Table Spaces 204DB2 Storage and STOGROUPs 239Table Guidelines 244General Table Guidelines 275Normalization and Denormalization 278Assuring Data Integrity in DB2 290Referential Integrity 290Views, Aliases, and Synonyms 302Index Guidelines 313Naming Conventions 313Miscellaneous DDL Guidelines 322Chapter 6 DB2 Indexing and Hashing Guidelines 324How an Index Works 324Creating Indexes 326DB2 Hashing and Hash Organized Tables 337Index and Hash Guidelines 34Chapter 7 Database Change Management, Schema Evolution, and Database Definition On Demand 53Online Schema Changes 354Versioning for Online Schema Changes 370Chapter 8 Using DB2 Triggers 373What Is a Trigger? 373Trigger Guidelines 388Chapter 9 Large Objects and Object/Relational Databases 393Defining the Term "Object/Relational" 393What Is a Large Object? 394LOB Guidelines 403DB2 Extenders 407Chapter 10 pureXML: Using XML in DB2 for z/OS 408What Is XML? 408pureXML 412XML-DB2 Guidelines 425Chapter 11 Supporting Temporal Data in DB2 for z/OS 428The Need for Temporal Data 428DB2 Temporal Support 430Temporal Data Guidelines 446Summary 447Chapter 12 DB2 Security, Authorization, and Auditing 448Authorization and Privileges 448Database Auditing 476Using External Security (for Example, RACF, ACF2,and Top Secret) 480PART II: DB2 APPLICATION DEVELOPMENTChapter 13 Using DB2 in an Application Program 486Embedded SQL Basics 487Embedded SQL Guidelines 489Host Variables 504Programming with Cursors 511Modifying Data with Embedded SQL 525Application Development Guidelines 527Batch Programming Guidelines 536Online Programming Guidelines 547General SQL Coding Guidelines 552Introduction to Java 554Using REXX and DB2 563Developing Applications Using Only SQL 565Chapter 14 Dynamic SQL Programming 567What Is Dynamic SQL? 567Dynamic SQL Versus Static SQL 569The Four Classes of Dynamic SQL 576pureQuery 588Making Dynamic SQL More Static and Vice Versa 589Dynamic SQL Guidelines 594Chapter 15 Program Preparation 601Program Preparation Steps 601Running a DB2 Program 608Preparing a DB2 Program 609What Is a DBRM? 622What Is a Plan? 622What Is a Package? 623What Is a Collection? 628Versions 629Converting DBRM-Based Plans in DB2 V10 630Program Preparation Objects 631Program Preparation Guidelines 632Chapter 16 Using DB2 Stored Procedures 65 6What Is a Stored Procedure? 657Implementing DB2 Stored Procedures 661Procedural SQL 678The Procedural DBA 683IBM Data Studio 687Chapter 17 DB2 and the Internet 689The Internet Phenomenon 689Accessing DB2 over the Internet 692Finding DB2 Information Using the Internet 695PART III: DB2 IN-DEPTHChapter 18 The Doors to DB2 704DB2 Program Execution Basics 704TSO (Time-Sharing Option) 706CICS (Customer Information Control System) 726IMS (Information Management System) 751CAF (Call Attach Facility) 763RRSAF (Recoverable Resource Manager Services Attach Facility) 767Comparison of the Environments 768Chapter 19 Data Sharing 772Data Sharing Benefits 772Data Sharing Requirements 774The DB2 Coupling Facility 778Data Sharing Naming Conventions 782Data Sharing Administration 783Data Sharing Application Development Guidelines 787Data Sharing Administration Guidelines 788Chapter 20 DB2 Behind the Scenes 792The Physical Storage of Data 792What Makes DB2 Tick 808Specialty Processors 812Chapter 21 The Optimizer 816Physical Data Independence 817How the Optimizer Works 818Filter Factors 821Screening 823Access Path Strategies 824Other Operations Performed by the Optimizer 868Chapter 22 The Table-Based Infrastructure of DB2 874The DB2 Catalog 874The DB2 Directory 886Chapter 23 Locking DB2 Data 889How DB2 Manages Locking 889Locks Versus Latches 892Lock Duration 892Table Space Locks 895Table Locks 897Page Locks 898Row Locks 899Lock Suspensions, Timeouts, and Deadlocks 901Partition Independence 904Lock Avoidance 908Data Sharing Global Lock Management 911LOBs and Locking 914DB2 Locking Guidelines 916Other DB2 Components 921The Big Picture 922PART IV: DB2 PERFORMANCE MONITORINGDefining DB2 Performance. 926Types of DB2 Performance Monitoring 927Chapter 24 DB2 Performance Monitoring 928DB2 Traces 929Trace Destinations 936Using IFCIDs 937Tracing Guidelines 938Performance Monitoring and Reporting: Online and Batch 940Monitoring and Reporting Strategy 967Performance Profiles 970Viewing DB2 Console Messages 972Displaying the Status of DB2 Resources 977Monitoring z/OS 979Chapter 25 Using EXPLAIN 980How EXPLAIN Works 980Access Paths and the PLAN_TABLE 982Cost Estimates and the DSN_STATEMNT_TABLE 998Function Resolution and the DSN_FUNCTION_TABLE 1001Additional Explain Tables 1002Explaining the Dynamic Statement Cache 1003EXPLAIN Guidelines 1005Additional Tools for Managing Access Paths 1012Chapter 26 The Five R's 1014Approaches to Rebinding 1014A Best Practice Approach to Rebinding 1016Chapter 27 DB2 Object Monitoring Using the DB2 Catalog and RTS 1021DB2 Catalog Queries 1021Real Time Statistics 1048Reviewing the Rules for an Effective Monitoring Strategy 1058PART V: DB2 PERFORMANCE TUNINGChapter 28 Tuning DB2's Environment 1064Tuning the z/OS Environment 1064Tuning the Teleprocessing Environment 1087Chapter 29 Tuning DB2's Components 1089Tuning the DB2 Subsystem 1089Tuning the Database Design 1114Tuning the Application 1116The Causes of DB2 Performance Problems 1137Chapter 30 DB2 Resource Governing 1143The Resource Limit Facility 1143PART VI: DB2 UTILITIES AND COMMANDSChapter 31 An Introduction to DB2 Utilities 1152Generating Utility JCL 1152Monitoring DB2 Utilities 1156The IBM DB2 Utilities 1158Using LISTDEF and TEMPLATE 1159Issuing SQL Statements in DB2 Utilities 1173Chapter 32 Data Consistency Utilities 1176The CHECK Utility 1177The CHECK DATA Option 1177The CHECK LOB Option 1186The CHECK INDEX Option 1188The REPAIR Utility 1191The REPAIR DBD Option 1192The REPAIR LOCATE Option 1193The REPAIR SET Option 1196REPAIR and Versions 1198The REPORT Utility 1198The DIAGNOSE Utility 1200Chapter 33 Backup and Recovery Utilities 1201The COPY Utility 1202The COPYTOCOPY Utility 1215The MERGECOPY Utility 1218The QUIESCE Utility 1220The RECOVER Utility 1224The REBUILD INDEX Utility 1232The REPAIR Utility 1235The REPORT RECOVERY Utility 1235Backing Up and Restoring the System 1236Chapter 34 Data Movement and Organization Utilities 1240The LOAD Utility 1240The UNLOAD Utility 1260The REORG Utility 1265Chapter 35 Catalog Manipulation Utilities 1289The CATENFM Utility 1289The CATMAINT Utility 1289The DSNJCNVB Utility 1290The MODIFY RECOVERY Utility 1290The MODIFY STATISTICS Utility 1293The RUNSTATS Utility 1295The STOSPACE Utility 1311Chapter 36 Stand-Alone Utilities and Sample Programs 1314The Stand-Alone Utilities 1314DB2 Sample Programs 1332Chapter 37 DB2 Commands 1340DB2 Environment Commands 1340Information-Gathering Commands 1343Administrative Commands 1353Environment Control Commands 1358DSN Commands 1359IMS Commands 1361CICS Commands 1362TSO Commands 1364IRLM Commands 1364Chapter 38 DB2 Utility and Command Guidelines 1366Utility Guidelines 1366The Pending States 1372Chapter 39 DB2 Contingency Planning 1376What Is a Disaster? 1376DB2 Recovery Basics 1380Additional DB2 Disaster Recovery Technologies 1387DB2 Environmental Considerations 1388DB2 Contingency Planning Guidelines 1390PART VII: THE IDEAL DB2 ENVIRONMENTChapter 40 Components of a Total DB2 Solution 1394DB2 Tools 1394DB2 Tools Vendors 1420Chapter 41 Organizational Issues 1423Education 1423Standards and Procedures 1429Operational Support. 1440Political Issues 1441Environmental Support 1443Tool Requirements 1443Part VIII Distributed DB2The Advantages of Data Distribution 1446DB2 Data Distribution 1446DB2 Data Warehousing 1447Chapter 42 DRDA 1448What Is DRDA? 1448DRDA Functions 1449DRDA Architectures and Standards 1451The Five DRDA Levels 1453Putting It All Together 1455Chapter 43 Distributed DB2 1458Distributing Data Using DB2 1458DB2 Support for the DRDA Levels 1460Methods of Accessing Distributed Data 1460Packages for Static SQL 1465Two-Phase Commit 1466Miscellaneous Distributed Topics 1470Chapter 44 DB2 Connect 1473An Overview of IBM DB2 Connect 1473Chapter 45 Distribution Guidelines 1485Distribution Behind the Scenes 1485Block Fetch 1487Dynamic Cursor Pre-Open 1491Distributed Performance Problems 1491Distributed Database Design Issues 1496Distributed Data Placement 1499Distributed Optimization 1500Distributed Security Guidelines 1501Miscellaneous Distributed Guidelines 1502Chapter 46 Data Warehousing with DB2 1506Defining the Basic Terms 1507Designing a Data Warehouse 1510Populating a Data Warehouse 1513Accessing the Data Warehouse 1519Managing the Data Warehouse 1520The Big Picture 1520IBM Data Warehousing Solutions 1521Materialized Query Tables 1522General Data Warehouse Guidelines 1533DB2-Specific Data Warehousing Guidelines 1538Index 1541

About the Author

Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher and editor of The Database Site ( Craig has also been appointed as an Information Champion by IBM.Craig has extensive experience in all facets of database systems development, including systems analysis and design, database and system administration, data analysis, and developing and teaching DB2 and database development classes. He has worked with DB2 since Version 1 and has experience in multiple roles, including programmer, DBA, instructor, and analyst. His experience spans industries, having worked for companies in the following fields: manufacturing (USX Corporation), banking (Mellon Bank), utilities (Duquesne Light Company), commercial software development (BMC Software, NEON Enterprise Software, and PLATINUM Technology, Inc.), consulting (ASSET, Inc. and Mullins Consulting, Inc.), and computer industry analysis (Gartner Group). In addition, Craig authored many of the popular "Platinum Monthly DB2 Tips" and worked on Platinum's DB2 system catalog and access path posters.Craig is a regular lecturer at industry conferences. You may have seen him present at such events as the International DB2 Users Group (IDUG), the IBM Information on Demand (IOD) Conference, the IBM DB2 Technical Conference, SHARE, DAMA, CMG, or at one of many regional user groups throughout the world. Craig is a member of the IDUG Volunteers Hall of Fame.Craig is also the author of Database Administration: The Complete Guide to Practices and Procedures(ISBN 0-201-74129-6). This book offers the industry's only comprehensive guide to heterogeneous database administration.Craig is a frequent contributor to computer industry publications, with hundreds of articles published over the past couple decades. His articles have been published in Byte, DB2 Update, Database Programming & Design, DBMS, Data Management Review, zJournal, and many others. Craig writes four regular columns, including "The DBA Corner" for Database Trends and Applications, "The Database Report" for The Data Administration Newsletter, "z/Data Perspectives" for zJournal, and "The Buffer Pool" for IDUG Solutions Journal. He also writes a blog focusing on DB2 topics at Complete information on Craig's published articles and books can be found on his website at graduated cum laude from the University of Pittsburgh with a B.S. degree and a dual major in computer science and economics. Follow Craig on Twitter at

Ask a Question About this Product More...
Write your question below:
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for Z/OS on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by, Inc.
Back to top