› › Db2 Universal Database In The Solaris Operating Environment

DB2 for Solaris

Author : Tom Bauch

Publisher : Prentice Hall Professional

Page : 578 pages

File Size : 12,25 MB

Release : 2004

Category : Computers

ISBN : 9780130463807

Get eBook

Book Description

-- The insider's guide to table structures, cluster configuration, and other optimization opportunities. -- Provides best practices techniques for installing, configuring, and optimizing DB2 in the Solaris Operating Environment. -- Covers the new Solaris Operating Environment security features to make your databases even more secure! -- Part of the IBM Press DB2 Series. This is the only IBM insider's reference and guidebook for making the most of DB2 in Solaris enterprise environments. Coverage includes: integrating Solaris and DB2 to build more secure database applications; working with DB2's management utilities in a Solaris environment; client/server communications under Solaris; special issues and opportunities associated with running DB2 Universal Database Enterprise Edition under Solaris, and much more! The authors explain configuring Solaris and DB2 failover support and provide expert tips and techniques for DB2/Solaris performance monitoring, optimization, and troubleshooting. If you manage or develop for DB2 on Solaris, this book is critical to your success -- and you can't find it anywhere else!



DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide

Author : George Baklarz

Publisher : Prentice Hall Professional

Page : 916 pages

File Size : 35,76 MB

Release : 2003

Category : Computers

ISBN : 9780130463616

Get eBook

Book Description

DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning, enhance business intelligence, and maximize performance, scalability, and reliability. Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... "and authoritative preparation for IBM's newest DB2 certification exam." This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database v8, including best practices for DB2 database design and development; day-to-day administration and backup; expert techniques for deploying networked, Internet-centered, and XML-based database applications; migrating to DB2 UDB v8; and much more.You'll also find an unparalleled collection of IBM tips and tricks for maximizing the performance, availability, and value of any database system. Coverage includes: Manageability and serviceability enhancements, including new tools for storagemanagement and monitoring database health Performance improvement withmultidimensional clustering, enhanced prefetching, threading of Java UDFs and storedprocedures, and materialized query tables New Setup wizards, configuration assistants, GUItools, and DB2 Administration Server (DAS) improvements Availability andscalability enhancements New DB2 v8 Replication and Data Warehouse Centers Major improvements for developers, including SQL, XML, JDBC, and CLIenhancements Whether you're a DBA, a developer, a DB2 certification candidate, or all three, "DB2Universal Database v8 for Linux, UNIX, and Windows Database AdministrationCertification Guide" is the one book you can't afford to be without. Straight from IBM, the ultimate guide to running DB2 v8 and preparing for IBM's latest DB2certification exam! In-depth coverage of DB2 v8 database administration and development Covers new DB2 v8 enhancements in manageability, serviceability, reliability, availability, and performance Contains in-depth coverage of new DB2 v8 tools, including the Replication, Data Warehouse, and Development Centers Presents expert tips and best practices from IBM's own DB2 customer support organization About the CDThe CD-ROM included with this book contains a complete trial version of DB2 UDB V8Personal Edition, plus the DB2DEMO program to help explore the many features of DB2.



DB2 Universal Database for OS/390 V7.1 Application Certification Guide

Author : Susan Lawson

Publisher : Prentice Hall Professional

Page : 628 pages

File Size : 20,16 MB

Release : 2002

Category : Computers

ISBN : 9780131007710

Get eBook

Book Description

IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514) Expert DB2 programming tips, techniques, and guidelines from application development experts Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more CD-ROM contains complete DB2 application development sample exam The definitive, authoritative guide to DB2 OS/390 application development certification Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more Includes a full section on object-relational programming and other advanced techniques Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514) About the CD The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam. IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments--and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514). This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application development exam for the OS/390 and z/OSplatforms. IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes: Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder Best practices for application testing, debugging, and performance tuning The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF Object-relational programming, including user-defined functions, user-defined data types, and triggers In-depth coverage of locking and concurrency Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource. IBM DB2 Series



Configuring and Tuning Databases on the Solaris Platform

Author : Allan N. Packer

Publisher : Prentice Hall Professional

Page : 556 pages

File Size : 44,74 MB

Release : 2002

Category : Computers

ISBN : 9780130834171

Get eBook

Book Description

Covers key performance issues related to using leading databases on Sun servers for system administrators and database programmers. This book brings together best-practice guidelines for every aspect of database tuning on Sun servers.



DB2 Universal Database V8 Application Development Certification Guide

Author : Steve Sanyal

Publisher : Prentice Hall Professional

Page : 436 pages

File Size : 41,87 MB

Release : 2003

Category : Computers

ISBN : 9780130463913

Get eBook

Book Description

"The accompanying CD-ROM contains a complete trial version of IBM DB2 Universal Database Personal Edition version 8.1, for Windows operating environments, evaluation copy"--Back cover.





DB2 Universal Database for OS/390

Author : Susan Graziano Sloan

Publisher : IBM Press

Page : 484 pages

File Size : 28,94 MB

Release : 2001

Category : Computers

ISBN : 9780130198488

Get eBook

Book Description

This book will be written for people who are new to the DB2 product. The readers/users will be migrating from desktop systems or coming from other popular database systems such as Oracle. Many will be also coming from other operating systems such as Windows and UNIX.



DB2 SQL Procedural Language for Linux, UNIX, and Windows

Author : Paul Yip

Publisher : Prentice Hall Professional

Page : 352 pages

File Size : 37,60 MB

Release : 2003

Category : Computers

ISBN : 9780131007727

Get eBook

Book Description

This certification guide offers a complete, start-to-finish coverage of DB2 Universal Database Version 8 administration. With Version 8 key topics such as Performance Enhancements, Manageability Enhancements, etc. are addressed.



DB2 Universal Database V7.1 for UNIX, Linux, Windows, and OS/2

Author : George Baklarz

Publisher : Prentice Hall Professional

Page : 840 pages

File Size : 27,22 MB

Release : 2001

Category : Computers

ISBN : 9780130913661

Get eBook

Book Description

DB2 Universal Database version 7.1 for UNIX, Linux, Windows and 0S/2 Database Administration Certification Guide, 4th edition.



DB2 Universal Database V7.1 Application Development

Author : Steve Sanyal

Publisher : Prentice Hall PTR

Page : 324 pages

File Size : 16,11 MB

Release : 2001

Category : Computers

ISBN : 9780130913678

Get eBook

Book Description

The first start-to-finish guide to IBM's brand-new DB2 Application Developer certification exam! Write DB2 applications using Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, Perl DBI, stored procedures, and more! Leverage new DB2 extenders for searching documents, XML composition/decomposition; managing multimedia databases, and more. Complete cross-platform coverage for UNIX, Linux, Windows and OS/2 environments! IBM has just expanded its highly successful DB2 certification program to include a developer's exam -- and this is the first book to offer start-to-finish preparation! The book covers every DB2 Application Developer exam objective, and includes a complete sample exam. Start by reviewing the DB2 client/server environment, comparing the multiple programming interfaces available to DB2 application developers, and understanding when to choose each. Next, walk through the fundamentals of DB2 application development with Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, and the Perl DBI. Learn how to create effective stored procedures, and when to use them. Discover how to use DB2 extenders to enhance your application's functionality, adding more effective search features, XML support, multimedia archive management, and more. Steve Sanyal is a Software Developer for the DB2 Universal Database Application Development Team at the IBM Toronto Lab. He specializes in JDBC, SQLJ and CLI/ODBC, and leads IBM's project to develop Java and XML-based performance and troubleshooting tools for DB2. David Martineau is a Staff Software Developer providing technical support for the DB2 UDB Application Development Team. He has provided sample code for DB2 UDB using interfaces such as ADO, CLI and Net.Data. Michael Kyprianou has worked with DB2 Universal Database and its predecessors since 1995. He is an IBM Advanced Technical Expert in DB2 DRDA and certified in DB2 UDB Database Administration and Application Development. Kevin Gashyna is a DB2 Universal Database application development specialist specializing in DB2 Extenders and Net.Data.