Kategorie: DB2 for z/OS

DB2 for z/OS

15

Jul2012

DB2 10 for z/OS Explain Table Conversion required!

Each new release of DB2 introduces new columns or modifies existing columns in the EXPLAIN tables. DB2 has traditionally honored EXPLAIN tables in previous release formats, but it is best practice to use the current-release format in order to gather maximum benefit from your EXPLAIN data. In addition, EXPLAIN tables were ... weiterlesen
15. Juli 2012Gernot

15

Jul2012

Documents of the 2012’s BMC DB2 and Mainview User Meeting

Find below the free documents of the annual BMC DB2 and Mainview User Meeting in Munich, June 2012. The Evolution of the Mainframe: Meeting the Business Requirements of the Future - Nick Pachnos, BMC Software DB2 Track: Mainview for DB2 10.1 - Peter Plevka, BMC Software MIPS Aufrüstung vermeiden - ... weiterlesen
15. Juli 2012Gernot

05

Jun2012

DB2 10 for z/OS System & Application Monitoring and Tuning

DB2 10 for z/OS System & Application Monitoring and Tuning Part 1: System Monitoring and Tuning (PDF from FTP server) Part 2: Application Monitoring and Tuning and notes (PDF's from FTP server) IBM Silicon Valley Lab, San Jose, CA May, 2012
5. Juni 2012Gernot

21

Mai2012

Free IBM DB2 book „DB2 10 for z/OS: Cost Savings . . . Right Out of the Box“

DB2 10 for z/OS: Cost Savings . . . Right Out of the Box Dave Beulke, Roger Miller, Surekha Parekh, and Julian Stuhler First Edition First Printing—September 2010 © 2010 IBM Corporation. All rights reserved. The book is segmented in three sections: An introduction to DB2 10 by Roger Miller, highlighting the main features  and functions ... weiterlesen
21. Mai 2012Gernot

09

Apr2012

Comparing the architectural differences between DB2 for z/OS and DB2 for LUW

"Breaking the DB2 Platform Barrier" Comparing the Architectural Differences Between DB2 UDB for z/OS And DB2 UDB LUW Quest Software, Inc. Published in 2009 but one of the best overviews for DB2 "newbies" and staff working on both platforms! Read more!  
9. April 2012Gernot

07

Apr2012

How to analyze SQLCODE -805 (german text)

Ursachen für Programmabbruch mit -805 suchenDie Situation: Ein Anwendungs-Programm bricht mit -805 (Package-Fehler) oder -818 (DBRM-Fehler, bis DB2 for z/OS V9.1) ab! Die folgende Beschreibung soll Dich bei der Analyse des Fehler unterstützen  und Dir mögliche Ursachen aufzeigen. Vorgehensweise: Aus dem Text der DSNTIAR-Meldung die voneinander abweichenden Timestamps bzw den Timestamp des Consistency ... weiterlesen
7. April 2012Gernot

07

Apr2012

DB2 Trace Commands and Facilites

DB2 has extensive tracing facilities that generate trace records called IFCIDs. IFCIDs are produced by the DB2 Instrumentation Facility. These trace records describe internal events within DB2 at various levels of granularity. The Instrumentation Facility Interface allows application programs to retrieve IFCIDs from DB2. IFCIDs have a complex record format, ... weiterlesen
7. April 2012Gernot

29

Mrz2012

IBM’s „DB2z Hotline news“ superseded by „DB2 Exchange“

To DB2 z Hotline subscribers: For various reasons the information platform has changed from a mail distribution list to a EXCHANGE webpage. Now visable as the DB2 for z/OS Exchange on DeveloperWorks. It is basically a relaunch and rebranding of ' DB2 zHotline'. As previously received via the DB2 Hotline, it ... weiterlesen
29. März 2012Gernot

15

Mrz2012

DB2 Aktuell 2012 + Zertifizierung (german)

Experten zum Anfassen! Neben fachlich hochkarätigen Vorträgen bietet Ihnen diese Konferenz einen direkten Zugang zu den DB2 Experten aus den Silicon Valley und Toronto Labs der IBM. Aktuelle Fragestellungen, Probleme und Ideen können Sie außerhalb der offiziellen Agenda mit den Sprechern im Detail diskutieren und sich so mit den Spezialisten aus ... weiterlesen
15. März 2012Gernot

03

Mrz2012

DB2 versions

List of most important changes every DB2 for z/OS, DB2 for OS/390 or DB2 for MVS version brought with. (Partially in german language only.) Important links: IBM Support DB2 for z/OS IBM Software support lifecycles for DB2 for z/OS 10.1.0, DB2 for z/OS 9.1.0, DB2 for z/OS 8.1.0, (3 others) DB2 11 for ... weiterlesen
3. März 2012Gernot

16

Feb2012

DB2 Space calculation – from pages to tracks

All system z DASD I/O systems base on the IBM DASD device type IBM 3390 Model 3 and are compatible to it. This means that all calculations a DB2 DBA or sysadm can to do are on basis of this type and model characteristics. Quite typical for this DASD model: 12 ... weiterlesen
16. Februar 2012Gernot

09

Feb2012

Free IBM DB2 ebooks

Free IBM DB2 ebooks: Database fundamentals Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises! Programming fundamentals This book is an introduction to programming. It covers basic topics, including the computer structure, algorithms, ... weiterlesen
9. Februar 2012Gernot

04

Jan2012

IBM’s tools and sources for trouble-shooting access-path related problems

Do you search for tools and "how-to" solve access-path related problems. Here are some interesting links: Troubleshooting access-path-related performance problems Covers deployment of DB2PLI8 program (for DB2 Version 8 and DB2 9). Sending a SQL query to IBM support
4. Januar 2012Gernot