Muutke küpsiste eelistusi

E-raamat: DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS

4.23/5 (33 hinnangut Goodreads-ist)
  • Formaat: PDF+DRM
  • Sari: IBM Press
  • Ilmumisaeg: 19-Apr-2012
  • Kirjastus: Pearson
  • Keel: eng
  • ISBN-13: 9780132836432
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 51,67 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OSSuurem pilt
  • Formaat: PDF+DRM
  • Sari: IBM Press
  • Ilmumisaeg: 19-Apr-2012
  • Kirjastus: Pearson
  • Keel: eng
  • ISBN-13: 9780132836432
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 and v10. Mullins fully covers new DB2 innovations including temporal database support; hashing; universal tablespaces; pureXML; performance, security and governance improvements; new data types, and much more. Using current versions of DB2 for z/OS, readers will learn how to: * Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF * Write proficient, code-optimized DB2 SQL * Implement efficient dynamic and static SQL applications * Use binding and rebinding to optimize applications * Efficiently create, administer, and manage DB2 databases and applications * Design, build, and populate efficient DB2 database structures for online, batch, and data warehousing * Improve the performance of DB2 subsystems, databases, utilities, programs, and SQL stat DB2 Developer's Guide, Sixth Edition builds on the unique approach that has made previous editions so valuable. It combines: * Condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of documents * Detailed discussions of crucial details within each topic * Expert, field-tested implementation advice * Sensible examples
Preface xxiii
Part I SQL Techniques, Tips, and Tricks
1 The Magic Words
3(53)
An Overview of SQL
4(9)
SQL Tools of the Trade
13(29)
Static SQL
42(2)
Dynamic SQL
44(1)
SQL Performance Factors
45(11)
2 Data Manipulation Guidelines
56(79)
A Bag of Tricks
56(2)
SQL Access Guidelines
58(32)
Complex SQL Guidelines
90(20)
Common Table Expressions and Recursion
110(5)
Working with Nulls
115(4)
Date and Time Guidelines
119(6)
Data Modification Guidelines
125(10)
3 Using DB2 Functions
135(32)
Aggregate Functions
135(6)
Scalar Functions
141(18)
Table Functions
159(1)
MQSeries Built-In Functions
159(2)
XML Built-In Functions
161(1)
The Raise_Error Function
162(1)
The CAST Operation
163(1)
Built-in Function Guidelines
163(4)
4 Using DB2 User-Defined Functions and Data Types
167(33)
What Is a User-Defined Function?
167(1)
Types of User-Defined Functions (UDFs)
168(22)
What Is a User-Defined Data Type?
190(1)
User-Defined Data Types (UDTs) and Strong Typing
191(9)
5 Data Definition Guidelines
200(124)
An Overview of DB2 Database Objects
200(1)
DB2 Databases
201(3)
Creating and Using DB2 Table Spaces
204(35)
DB2 Storage and STOGROUPs
239(5)
Table Guidelines
244(31)
General Table Guidelines
275(3)
Normalization and Denormalization
278(12)
Assuring Data Integrity in DB2
290(1)
Referential Integrity
290(12)
Views, Aliases, and Synonyms
302(11)
Index Guidelines
313(1)
Naming Conventions
313(9)
Miscellaneous DDL Guidelines
322(2)
6 DB2 Indexing and Hashing Guidelines
324(29)
How an Index Works
324(2)
Creating Indexes
326(11)
DB2 Hashing and Hash Organized Tables
337(4)
Index and Hash Guidelines
341(12)
7 Database Change Management, Schema Evolution, and Database Definition On Demand
353(20)
Online Schema Changes
354(16)
Versioning for Online Schema Changes
370(3)
8 Using DB2 Triggers
373(20)
What Is a Trigger?
373(15)
Trigger Guidelines
388(5)
9 Large Objects and Object/Relational Databases
393(15)
Defining the Term "Object/Relational"
393(1)
What Is a Large Object?
394(9)
LOB Guidelines
403(4)
DB2 Extenders
407(1)
10 pureXML: Using XML in DB2 for z/OS
408(20)
What Is XML?
408(4)
Pure XML
412(13)
XML-DB2 Guidelines
425(3)
11 Supporting Temporal Data in DB2 for z/OS
428(20)
The Need for Temporal Data
428(2)
DB2 Temporal Support
430(16)
Temporal Data Guidelines
446(1)
Summary
447(1)
12 DB2 Security, Authorization, and Auditing
448(38)
Authorization and Privileges
448(28)
Database Auditing
476(4)
Using External Security (for Example, RACE, ACF2, and Top Secret)
480(6)
Part II DB2 Application Development
13 Using DB2 in an Application Program
486(81)
Embedded SQL Basics
487(2)
Embedded SQL Guidelines
489(15)
Host Variables
504(7)
Programming with Cursors
511(14)
Modifying Data with Embedded SQL
525(2)
Application Development Guidelines
527(9)
Batch Programming Guidelines
536(11)
Online Programming Guidelines
547(5)
General SQL Coding Guidelines
552(2)
Introduction to Java
554(9)
Using REXX and DB2
563(2)
Developing Applications Using Only SQL
565(2)
14 Dynamic SQL Programming
567(34)
What Is Dynamic SQL?
567(2)
Dynamic SQL Versus Static SQL
569(7)
The Four Classes of Dynamic SQL
576(12)
pureQuery
588(1)
Making Dynamic SQL More Static and Vice Versa
589(5)
Dynamic SQL Guidelines
594(7)
15 Program Preparation
601(55)
Program Preparation Steps
601(7)
Running a DB2 Program
608(1)
Preparing a DB2 Program
609(13)
What Is a DBRM?
622(1)
What Is a Plan?
622(1)
What Is a Package?
623(5)
What Is a Collection?
628(1)
Versions
629(1)
Converting DBRM-Based Plans in DB2 V10
630(1)
Program Preparation Objects
631(1)
Program Preparation Guidelines
632(24)
16 Using DB2 Stored Procedures
656(33)
What Is a Stored Procedure?
657(4)
Implementing DB2 Stored Procedures
661(17)
Procedural SQL
678(5)
The Procedural DBA
683(4)
IBM Data Studio
687(2)
17 DB2 and the Internet
689(15)
The Internet Phenomenon
689(3)
Accessing DB2 over the Internet
692(3)
Finding DB2 Information Using the Internet
695(9)
Part III DB2 In-Depth
18 The Doors to DB2
704(68)
DB2 Program Execution Basics
704(2)
TSO (Time-Sharing Option)
706(20)
CICS (Customer Information Control System)
726(25)
IMS (Information Management System)
751(12)
CAF (Call Attach Facility)
763(4)
RRSAF (Recoverable Resource Manager Services Attach Facility)
767(1)
Comparison of the Environments
768(4)
19 Data Sharing
772(20)
Data Sharing Benefits
772(2)
Data Sharing Requirements
774(4)
The DB2 Coupling Facility
778(4)
Data Sharing Naming Conventions
782(1)
Data Sharing Administration
783(4)
Data Sharing Application Development Guidelines
787(1)
Data Sharing Administration Guidelines
788(4)
20 DB2 Behind the Scenes
792(24)
The Physical Storage of Data
792(16)
What Makes DB2 Tick
808(4)
Specialty Processors
812(4)
21 The Optimizer
816(58)
Physical Data Independence
817(1)
How the Optimizer Works
818(3)
Filter Factors
821(2)
Screening
823(1)
Access Path Strategies
824(44)
Other Operations Performed by the Optimizer
868(6)
22 The Table-Based Infrastructure of DB2
874(15)
The DB2 Catalog
874(12)
The DB2 Directory
886(3)
23 Locking DB2 Data
889(37)
How DB2 Manages Locking
889(3)
Locks Versus Latches
892(1)
Lock Duration
892(3)
Table Space Locks
895(2)
Table Locks
897(1)
Page Locks
898(1)
Row Locks
899(2)
Lock Suspensions, Timeouts, and Deadlocks
901(3)
Partition Independence
904(4)
Lock Avoidance
908(3)
Data Sharing Global Lock Management
911(3)
LOBs and Locking
914(2)
DB2 Locking Guidelines
916(5)
Other DB2 Components
921(1)
The Big Picture
922(4)
Part IV DB2 Performance Monitoring
Defining DB2 Performance
926(1)
Types of DB2 Performance Monitoring
927(1)
24 DB2 Performance Monitoring
928(52)
DB2 Traces
929(7)
Trace Destinations
936(1)
Using IFCIDs
937(1)
Tracing Guidelines
938(2)
Performance Monitoring and Reporting: Online and Batch
940(27)
Monitoring and Reporting Strategy
967(3)
Performance Profiles
970(2)
Viewing DB2 Console Messages
972(5)
Displaying the Status of DB2 Resources
977(2)
Monitoring z/OS
979(1)
25 Using Explain
980(34)
How Explain Works
980(2)
Access Paths and the Plan_Table
982(16)
Cost Estimates and the DSN_Statemnt_Table
998(3)
Function Resolution and the DSN_Function_Table
1001(1)
Additional Explain Tables
1002(1)
Explaining the Dynamic Statement Cache
1003(2)
Explain Guidelines
1005(7)
Additional Tools for Managing Access Paths
1012(2)
26 The Five R's
1014(7)
Approaches to Rebinding
1014(2)
A Best Practice Approach to Rebinding
1016(5)
27 DB2 Object Monitoring Using the DB2 Catalog and RTS
1021(43)
DB2 Catalog Queries
1021(27)
Real Time Statistics
1048(10)
Reviewing the Rules for an Effective Monitoring Strategy
1058(6)
Part V DB2 Performance Tuning
28 Tuning DB2's Environment
1064(25)
Tuning the z/OS Environment
1064(23)
Tuning the Teleprocessing Environment
1087(2)
29 Tuning DB2's Components
1089(54)
Tuning the DB2 Subsystem
1089(25)
Tuning the Database Design
1114(2)
Tuning the Application
1116(21)
The Causes of DB2 Performance Problems
1137(6)
30 DB2 Resource Governing
1143(9)
The Resource Limit Facility
1143(9)
Part VI DB2 Utilities and Commands
31 An Introduction to DB2 Utilities
1152(24)
Generating Utility JCL
1152(4)
Monitoring DB2 Utilities
1156(2)
The IBM DB2 Utilities
1158(1)
Using LISTDEF and TEMPLATE
1159(14)
Issuing SQL Statements in DB2 Utilities
1173(3)
32 Data Consistency Utilities
1176(25)
The Check Utility
1177(1)
The Check Data Option
1177(9)
The Check LOB Option
1186(2)
The Check Index Option
1188(3)
The Repair Utility
1191(1)
The Repair DBD Option
1192(1)
The Repair Locate Option
1193(3)
The Repair Set Option
1196(2)
Repair and Versions
1198(1)
The Report Utility
1198(2)
The Diagnose Utility
1200(1)
33 Backup and Recovery Utilities
1201(39)
The Copy Utility
1202(13)
The Copytocopy Utility
1215(3)
The Mergecopy Utility
1218(2)
The Quiesce Utility
1220(4)
The Recover Utility
1224(8)
The Rebuild Index Utility
1232(3)
The Repair Utility
1235(1)
The Report Recovery Utility
1235(1)
Backing Up and Restoring the System
1236(4)
34 Data Movement and Organization Utilities
1240(49)
The Load Utility
1240(20)
The Unload Utility
1260(5)
The REORG Utility
1265(24)
35 Catalog Manipulation Utilities
1289(25)
The CATENFM Utility
1289(1)
The CATMAINT Utility
1289(1)
The DSNJCNVB Utility
1290(1)
The Modify Recovery Utility
1290(3)
The Modify Statistics Utility
1293(2)
The Runstats Utility
1295(16)
The Stospace Utility
1311(3)
36 Stand-Alone Utilities and Sample Programs
1314(26)
The Stand-Alone Utilities
1314(18)
DB2 Sample Programs
1332(8)
37 DB2 Commands
1340(26)
DB2 Environment Commands
1340(3)
Information-Gathering Commands
1343(10)
Administrative Commands
1353(5)
Environment Control Commands
1358(1)
DSN Commands
1359(2)
IMS Commands
1361(1)
CICS Commands
1362(2)
TSO Commands
1364(1)
IRLM Commands
1364(2)
38 DB2 Utility and Command Guidelines
1366(10)
Utility Guidelines
1366(6)
The Pending States
1372(4)
39 DB2 Contingency Planning
1376(18)
What Is a Disaster?
1376(4)
DB2 Recovery Basics
1380(7)
Additional DB2 Disaster Recovery Technologies
1387(1)
DB2 Environmental Considerations
1388(2)
DB2 Contingency Planning Guidelines
1390(4)
Part VII The Ideal DB2 Environment
40 Components of a Total DB2 Solution
1394(29)
DB2 Tools
1394(26)
DB2 Tools Vendors
1420(3)
41 Organizational Issues
1423(23)
Education
1423(6)
Standards and Procedures
1429(11)
Operational Support
1440(1)
Political Issues
1441(2)
Environmental Support
1443(1)
Tool Requirements
1443(3)
Part VIII Distributed DB2
The Advantages of Data Distribution
1446(1)
DB2 Data Distribution
1446(1)
DB2 Data Warehousing
1447(1)
42 DRDA
1448(10)
What Is DRDA?
1448(1)
DRDA Functions
1449(2)
DRDA Architectures and Standards
1451(2)
The Five DRDA Levels
1453(2)
Putting It All Together
1455(3)
43 Distributed DB2
1458(15)
Distributing Data Using DB2
1458(2)
DB2 Support for the DRDA Levels
1460(1)
Methods of Accessing Distributed Data
1460(5)
Packages for Static SQL
1465(1)
Two-Phase Commit
1466(4)
Miscellaneous Distributed Topics
1470(3)
44 DB2 Connect
1473(12)
An Overview of IBM DB2 Connect
1473(12)
45 Distribution Guidelines
1485(21)
Distribution Behind the Scenes
1485(2)
Block Fetch
1487(4)
Dynamic Cursor Pre-Open
1491(1)
Distributed Performance Problems
1491(5)
Distributed Database Design Issues
1496(3)
Distributed Data Placement
1499(1)
Distributed Optimization
1500(1)
Distributed Security Guidelines
1501(1)
Miscellaneous Distributed Guidelines
1502(4)
46 Data Warehousing with DB2
1506(35)
Defining the Basic Terms
1507(3)
Designing a Data Warehouse
1510(3)
Populating a Data Warehouse
1513(6)
Accessing the Data Warehouse
1519(1)
Managing the Data Warehouse
1520(1)
The Big Picture
1520(1)
IBM Data Warehousing Solutions
1521(1)
Materialized Query Tables
1522(11)
General Data Warehouse Guidelines
1533(5)
DB2-Specific Data Warehousing Guidelines
1538(3)
Index 1541
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 (www.TheDatabaseSite.com). 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 Platinums 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 industrys 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 http://db2portal.blogspot.com. Complete information on Craigs published articles and books can be found on his website at www.craigsmullins.com.

Craig 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 www.twitter.com/craigmullins.

 
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97801328364322e.html
Märksõnad: