Donnerstag, 24 of April of 2014

Archives from month » September, 2012

Perl Script to list or terminate DB2 connections provides following functions …

  • lists all databases (local and remote) at current DB2 instance
  • lists all connections at the DB2 instance, or only those connected to a specified database
  • terminates all connections, or only those connected to a specified database, or a specific thread id

Options supported:

  • -l: (deflt. option) display all threads
  • -d {dbname|*}: display threads on distinct or all databases
  • -t {id|*}: terminate distinct thread id or all threads (on database or instance)
  • -a LOCKS: display locks

 Any suggestions – don’t hesitate to contact me!

Free book: DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

By John Campbell, Cristian Molaro, and Surekha Parekh

First Edition

First Printing—October 2011

© 2011 IBM. All rights reserved.

The objective of this book is to help customers plan their migration strategy effectively and efficiently by providing the right information, facts, and guidance. The knowledge you’ll find in these pages will ensure not only that you are adopting IBM best practices but also that you will reap the cost savings and business benefits of DB2 10. We believe the guidance and direction captured here will help our customers gain competitive advantages by doing more with less—more business insight, more performance, and more operational efficiency with less cost.

The launch of this book is timely, with support for IBM DB2 for z/OS Version 8 retiring in April 2012. For the first time in the history of DB2 for z/OS, customers can skip a level and not only take advantage of features in DB2 9 but also realize the immediate cost savings in DB2 10. Upgrading to the latest version of database software can be a time-consuming, expensive, and confusing process. Deciding whether you are the right candidate to skip a release is a difficult decision unless you have access to the right information, facts, and guidance to help you make that judgment. This book will help simplify some of these decisions.

The book is segmented into two parts:

I. Planning for DB2 10 for z/OS upgrade

II. Gaining the financial benefits of DB2 10 for z/OS

DB2 10 for z/OS: The Smarter, Faster Way to Upgrade – click here for free PDF file.


New IBM Redbook: Unleashing DB2 10 for Linux, UNIX, and Windows – special offer

This book is for database administrators and application developers who are considering DB2 10 for a new installation, an upgrade from a previous version of DB2, or a migration from a vendor product. It explains key features and illustrates concepts with real-world examples to provide a clear idea of how powerful these features are.
Together, these features provide functionality that lower operational costs, ease development, and provide greater reliability.

This IBM® Redbooks® publication provides a broad understanding of the key features in IBM DB2® 10 and how to use these features to get more value from business applications. It includes information about the following features:

  • Time Travel Query, which you use to store and retrieve time-based data by using capability built into DB2 10, without needing to build your own solution
  • Adaptive compression, an enhanced compression technology that adapts to changing data patterns, yielding extremely high compression ratios
  • Multi-temperature storage, which you may use to optimize storage costs by identifying and managing data based on its “temperature” or access requirements
  • Row and column access control, which offers security access enforcement on your data, at the row or column level, or both
  • Availability enhancements, which provide different DB2 availability features for different enterprise needs; high availability disaster recovery (HADR) multiple-standby databases provide availability and data recovery in one technology, and the IBM DB2 pureScale® Feature provides continuous availability and scalability that is transparent to applications
  • Oracle compatibility, which allows many applications written for Oracle to run on DB2, virtually unchanged
  • Ingest utility, a feature-rich data movement utility that allows queries to run concurrently with minimal impact on data availability

The Vervanté Bookstore offers this IBM redbook as printed document for USD 25 – click here.

Redbook as PDF-File is available here.

Updated doc “Tuning SAP with DB2 on IBM AIX”

IBM’s BI/ERP Solutions Center has just updated the whitepaper “Tuning SAP with DB2 on IBM AIX“:

Performance analysis and tuning guide for SAP on DB2 and AIX. The paper describes how to analyze performance indicators for SAP with DB2 on AIX, and it contains examples of typical problems and processes used to analyze them.