DB2 10.1 Fundamentals

DB2 10.1 Fundamentals PDF Author: Roger E. Sanders
Publisher: MC Press
ISBN: 9781583473498
Category : Database management
Languages : en
Pages : 0

Get Book Here

Book Description
Beginning with an explanation of the certification process and working toward fundamental exam objectives, this guide gives test-takers all they need to know to pass the DB2 10.1 Fundamentals certification exam (Exam 610). Each chapter is followed by an extensive set of practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Additional topics covered include database objects, working with data using SQL and XQuery, working with DB2 tables, views and indexes, and data concurrency. Complete with a practice exam and answer key containing full explanations of correct answers, this is the ultimate resource for those who plan to earn their DB2 10.1 Fundamentals certification.

System z Parallel Sysplex Best Practices

System z Parallel Sysplex Best Practices PDF Author: Frank Kyne
Publisher: IBM Redbooks
ISBN: 0738434671
Category : Computers
Languages : en
Pages : 202

Get Book Here

Book Description
This IBM® Redbooks® publication pulls together diverse information regarding the best way to design, implement, and manage a Parallel Sysplex® to deliver the levels of performance and availability required by your organization. This book should be of interest to system programmers, availability managers, and database administrators who are interested in verifying that your systems conform to IBM best practices for a Parallel Sysplex environment. In addition to z/OS® and the sysplex hardware configuration, this book also covers the major IBM subsystems: CICS® DB2® IMSTM MQ WebSphere® Application Server To get the best value from this book, readers should have hands-on experience with Parallel Sysplex and have working knowledge of how your systems are set up and why they were set up in that manner.

SQL Tuning

SQL Tuning PDF Author: Dan Tow
Publisher: "O'Reilly Media, Inc."
ISBN: 059655236X
Category : Computers
Languages : en
Pages : 338

Get Book Here

Book Description
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Oracle to DB2 Conversion Guide: Compatibility Made Easy

Oracle to DB2 Conversion Guide: Compatibility Made Easy PDF Author: Yvonne Chan
Publisher: IBM Redbooks
ISBN: 0738438758
Category : Computers
Languages : en
Pages : 456

Get Book Here

Book Description
This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.

DB2 9 for Z/OS Stored Procedures

DB2 9 for Z/OS Stored Procedures PDF Author: Paolo Bruni
Publisher: IBM.Com/Redbooks
ISBN: 9780738485935
Category : Computers
Languages : en
Pages : 924

Get Book Here

Book Description


ABCs of z/OS System Programming Volume 8

ABCs of z/OS System Programming Volume 8 PDF Author: Paul Rogers
Publisher: IBM Redbooks
ISBN: 0738436828
Category : Computers
Languages : en
Pages : 396

Get Book Here

Book Description
The ABCs of IBM® z/OS® System Programming is a 13-volume collection that provides an introduction to the z/OS operating system and the hardware architecture. Whether you are a beginner or an experienced system programmer, the ABCs collection provides the information you need to start your research into z/OS and related subjects. If you would like to become more familiar with z/OS in your current environment, or if you are evaluating platforms to consolidate your e-business applications, the ABCs collection serves as a powerful technical tool. . This IBM Redbooks® publication, Volume 8, shows you how to: - Adopt a systematic and thorough approach to dealing with problems and identifying the different types of problems - Determine where to look for diagnostic information and how to obtain it - Interpret and analyze the diagnostic data collected - Escalate problems to the IBM Support Center when necessary - Collect and analyze diagnostic data—a dynamic and complex process - Identify and document problems, collect and analyze pertinent diagnostic data and obtain help as needed, to speed you on your way to problem resolution The content of the volumes is as follows Volume 1: Introduction to z/OS and storage concepts, TSO/E, ISPF, JCL, SDSF, and z/OS delivery and installation Volume 2: z/OS implementation and daily maintenance, defining subsystems, JES2 and JES3, LPA, LNKLST, authorized libraries, SMP/E, Language Environment® Volume 3: Introduction to DFSMS, data set basics storage management hardware and software, catalogs, and DFSMStvs Volume 4: Communication Server, TCP/IP, and VTAM® Volume 5: Base and Parallel Sysplex® , System Logger, Resource Recovery Services (RRS), global resource serialization (GRS), z/OS system operations, automatic restart management (ARM), Geographically Dispersed Parallel SysplexTM (GDPS® ) Volume 6: Introduction to security, RACF, Digital certificates and PKI, Kerberos, cryptography and z990 integrated cryptography, zSeries® firewall technologies, LDAP, and Enterprise identity mapping (EIM) Volume 7: Printing in a z/OS environment, Infoprint® Server and Infoprint Central Volume 8: An introduction to z/OS problem diagnosis Volume 9: z/OS UNIX System Services Volume 10: Introduction to z/ArchitectureTM , zSeries processor design, zSeries connectivity, LPAR concepts, HCD, and HMC Volume 11: Capacity planning, performance management, WLM, RMFTM , and SMF

IT Service Management Best Practices Using IBM SmartCloud Control Desk

IT Service Management Best Practices Using IBM SmartCloud Control Desk PDF Author: Axel Buecker
Publisher: IBM Redbooks
ISBN: 0738438677
Category : Computers
Languages : en
Pages : 802

Get Book Here

Book Description
SmartCloud Control Desk is a comprehensive IT Asset and Service Management solution that helps reduce cost and minimize service disruptions. It does so through automated service request handling, efficient change management, and optimized asset lifecycle management across IT and enterprise domains. SmartCloud Control Desk helps to reduce total cost of ownership by using one unified solution to license, install, and manage multiple ITIL processes under one price point. It can also help reduce business risk by using advanced impact analysis and defining automated change procedures that ensure integrity of existing infrastructure while supporting business agility. SmartCloud Control Desk improves efficiency and quality of service by unifying asset, change, and problem management. It lowers cost and mitigates license compliance risk by performing end to end software asset management. It also delivers an adaptive, role-based simplified UI that can be more intuitive for novice users, which reduces training costs, while allowing access from anywhere at anytime through mobile device support that includes BlackBerry, iOS, and Android. In addition, SmartCloud Control Desk supports both a profit center business model for internal IT organizations, and an external Service Provider model. It allows organizations to manage customers and customer agreements and bills for managed assets, usage, and work activities while improving utilization rates and reducing unnecessary purchases by managing the IT asset lifecycle. You can deploy SmartCloud Control Desk in a variety of ways; traditional on-premise, SaaS, VM image. This approach can make it more affordable to meet your current business needs, and seamlessly move between delivery models while keeping the same functionality. This IBM® Redbooks® publication covers IBM SmartCloud® Control Desk product configuration, customization, and implementation best practices.

IBM PowerHA SystemMirror for AIX Cookbook

IBM PowerHA SystemMirror for AIX Cookbook PDF Author: Dino Quintero
Publisher: IBM Redbooks
ISBN: 0738440019
Category : Computers
Languages : en
Pages : 570

Get Book Here

Book Description
This IBM® Redbooks® publication can help you install, tailor, and configure the new IBM PowerHA® Version 7.1.3, and understand new and improved features such as migrations, cluster administration, and advanced topics like configuring in a virtualized environment including workload partitions (WPARs). With this book, you can gain a broad understanding of the IBM PowerHA SystemMirror® architecture. If you plan to install, migrate, or administer a high availability cluster, this book is right for you. This book can help IBM AIX® professionals who seek a comprehensive and task-oriented guide for developing the knowledge and skills required for PowerHA cluster design, implementation, and daily system administration. It provides a combination of theory and practical experience. This book is targeted toward technical professionals (consultants, technical support staff, IT architects, and IT specialists) who are responsible for providing high availability solutions and support with the IBM PowerHA SystemMirror Standard on IBM POWER® systems.

DB2 10 for z/OS Performance Topics

DB2 10 for z/OS Performance Topics PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738435716
Category : Computers
Languages : en
Pages : 422

Get Book Here

Book Description
DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks® publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

SAP Backup using Tivoli Storage Manager

SAP Backup using Tivoli Storage Manager PDF Author: Budi Darmawan
Publisher: IBM Redbooks
ISBN: 0738432970
Category : Computers
Languages : en
Pages : 440

Get Book Here

Book Description
In this IBM® Redbooks® publication, we give an overview of different data management topics related to a typical SAP® data center. The intrinsic functionality of SAP is not designed to completely handle all the tasks of a data center by itself, but the SAP system offers several interface possibilities to attach external tools to it to accomplish this task We explain SAP basic concepts and the issues with SAP data management. We introduce Tivoli® Storage Manager and all of its products that are related to SAP data management. We provide some comparison between database backup and recovery tools. Finally, we discuss data archiving using IBM DB2® CommonStore for SAP, and discuss high availability requirements and disaster recovery considerations. The second part of this book discusses a practical implementation of SAP backup and recovery with Tivoli Storage Manager. We implement this setup on two separate SAP systems: one running DB2 and the other running Oracle® database. We also implement LAN-free backup and FlashCopy® scenarios. In the sample implementation section, we show many different tasks, such as backup and restore, database recovery, backup monitoring, and tuning. We also cover some advanced backup/availability considerations, such as split mirror backup and standby databases. This book helps individuals that operate an SAP environment to devise a strategy for a sound and comprehensive data backup solution using the IBM Tivoli Storage Management product family.