Automatic table maintenance work? When? How often? For which tables?
These SQL queries will help to clarify questions of this kind.
--------------------------------------------------------------------------------
-- SQL-Statistics-Diag.sql - Statistics Collection Vorgänge
--------------------------------------------------------------------------------
--
-- Successfully completed autoReorg and autoRunst events:
SELECT DATE(TIMESTAMP), TIME(TIMESTAMP),
CASE
WHEN ... weiterlesen
Gernot
13
Feb2014
This excellent guide describes how autonomic features can help to make database administration as easy and low-cost as possible.
The basis for the descriptions and recommendations in this paper is database version DB2 9.7. If there are commands or SQL-statements that are related to other versions, the specific version is explicitly ... weiterlesen
13. Februar 2014Gernot
13
Feb2014
Do you need to convert decimal value to hexadecimal representation? Then you should try this:
--
WITH DEMO AS (SELECT DECIMAL( 12345678.905 , 15, 3 ) AS DECVALUE -- 8 bytes internally
FROM SYSIBM.SYSDUMMYE )
-- ... weiterlesen
13. Februar 2014Gernot
06
Feb2014
The "CA Performance Handbook for DB2 for z/OS"Â handbook helps DB2 performance tuners to complete the following tasks:
Design databases for high performance.
Understand how DB2 processes SQL and transactions, and tune those processes for performance.
For database performance management, the philosophy of performance tuning begins with database design and extends through the database and application ... weiterlesen
6. Februar 2014Gernot
04
Feb2014
DB2 10 for z/OS customers who want a basic  tool for evaluating DB2 audit records:
PI05578: Enhance DSN1SMFP to support DB2 10 for z/OS:
http://www-01.ibm.com/support/docview.wss?uid=swg1PI05578
For more details on how to use DSN1SMFP, see article "DSN1SMFP with DB2 11 for z/OS – revival of a dead".
4. Februar 2014Gernot
28
Nov2013
Project Title: Automated STROBE batch measurement reports and alerts
Subject: Instead of ad-hoc or permanent monitoring, an individual solution based on Compuware's STROBE will periodically monitor distinct address spaces at distinct time and duration. Measurement reports will be created automatically from STROBE sample datasets. A REXX procedure will then analyse measurement reports. In ... weiterlesen
28. November 2013Gernot
28
Nov2013
Do you want to determine the maintenance level of you BMC software products?
BMC Software updates all mainframe deliverables at regular intervals. The Program Update Tape (PUT) system makes available the latest service and maintenance for BMC Software products that are installed with the Installation System.
Some suggestions easy to apply.
BMC tools ... weiterlesen
28. November 2013Gernot
21
Nov2013
An excellent SAP document describes how to avoid database REORG operations in SAP Systems operating with DB2 10.1 LUW
Techniacal environment: SAP NetWeaver 7.0 and higher on DB2 for Linux, UNIX, and Windows (DB2 for LUW) version 10.1 or higher.
Document Summary: Database tables with frequent INSERT, UPDATE and DELETE operations become fragmented over time. This ... weiterlesen
21. November 2013Gernot
20
Nov2013
„IEB1099I – IEBCOPY is not APF authorized“ is issued during execution of stored procedure
/ DB2 for z/OS, z/OS
Starting in z/OS V1R13, IEBCOPY is no longer APF-authorized. It does not need to be run from an authorized library, and calling programs do not need to be APF-authorized. However, In V1R12 IEBCOPY is APF-authorized.
DB2 9 for z/OS and DB2 10 for z/OS only:
SYSPROC.ADMIN_UPDATE_SYSPARM must run non APF-authorized. However, IEBCOPY ... weiterlesen
20. November 2013Gernot
19
Nov2013
For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv!
Themen: Was ist neu in DB2 10.5 for Linux/Unix/Windows, Command dbstart nach Übernahme, DB2 Abfrage Optimierung durch OPTIMIZATION GUIDELINES, DB2 Bind Files und Package Namen, New Feature in DB2 V10.1 FP3, Chats mit dem Labor, Schulungen / Tagungen / Informationsveranstaltung u.v.m.
Hier ... weiterlesen
19. November 2013Gernot
10
Okt2013
In january 2007 the IBM DB2 PTF PK34261/UK20793 introduced DSN1SMFP, a DB2-supplied application for processing DB2 trace data into reports that are useful for evaluating and auditing the DB2 environment for Common Criteria. This is very useful if you have no or restricted access to performance reporting tools like OMEGAMON XE ... weiterlesen
10. Oktober 2013Gernot
10
Okt2013
The following script references "Perl module xmpPerl.pm – function package used by DBA Perl scripts"
The following very simple script is just a small frame for sending mail via network from command level or as a service for other scripts.
#!/usr/local/bin/perl -w
################################################################################
# xmpMail - send text as email so single ... weiterlesen
10. Oktober 2013Gernot
01
Okt2013
IBM published the planned general availability date for IBM DB2 11 for z/OS:Â October 25, 2013
For more details see IBM EMEA Announcement ZP13-0480, dated October 1, 2013:
http://www.ibm.com/common/ssi/rep_ca/0/877/ENUSZP13-0480/ENUSZP13-0480.PDF
1. Oktober 2013Gernot
01
Okt2013
IBM is announcing the end of support of selected IBM DB2 and IBM DB2 Connectâ„¢ products.
Effective April 30, 2015, IBM will withdraw support for the following programs licensed under the IBM International Program License Agreement:
... weiterlesen
1. Oktober 2013Gernot
27
Aug2013
Latest DB2 10 for z/OS redbooks have been updated:
DB2 10 for z/OS Performance Topics, last updated 23 Aug 2013
Changed information
Correction in 7.5, “Dynamic SQL literal replacement†on page 212 for JCC driver literal support enabling.
Updated information on APARs in Appendix A, “Recent maintenance†on page 353.
New information
Added information on APARs in ... weiterlesen
27. August 2013Gernot
01
Aug2013
Please follow the direct link to IBM™s download pages of IBM Data Studio Client 4.1
Click here.
Use IBM Installation Manager to select, download, and install only the code, features, or product extensions that you want. Product extensions allow you to extend your install beyond the Data Studio feature set.
For most installations, ... weiterlesen
1. August 2013Gernot
29
Jul2013
Do you want to compare DB2 Linux/Unix/Windows databases, structures, contents or configurations. Or do you want to compare table data or structures with DB2 for z/OS? Here's list of products which could be useful:
Embarcadero DB Change Manager:
Does not support DB2 for z/OS, but great for comparing DB2 UDB's, compares even structures ... weiterlesen
29. Juli 2013Gernot
25
Jul2013
Nutzen Sie bereits das volle Wertschöpfungspotential Ihrer DB2 Systeme? Was gibt es Neues in der DB2-Entwicklung und wie können Sie davon bestmöglich profitieren?
Die DB2 Aktuell 2013 bietet Ihnen Antworten auf diese Fragen und:
Zwei Tage konzentrierter Wissenstransfer mit hochkarätigen Referenten.
Eine hervorragende Plattform für aktiven Erfahrungsaustausch und Kontaktpflege.
Klären Sie Ihre Fragen, ... weiterlesen
25. Juli 2013Gernot
13
Jul2013
Do you want to delete an obsolete z/OS dataset without RECALL'ing or RECOVER'ing from CA-DISK, HSM or other storage management systems?
This is a very smart ans resource saving way - replace nn by the number of days of requested retention period.
//*
//*-------------------------------------------------------------------*
//* LISTCAT+SORT+DEL = DELETION OF DATASETS OLDER THAN nn DAYS
//*-------------------------------------------------------------------*
//LISTC ... weiterlesen
13. Juli 2013Gernot
01
Jun2013
Problem:
You want to create a database but DB2 issues the message ...
SQL1005N Â The database alias "<name>" already exists in either the local
   database directory or system database directory.
Reason:
The alias name specified has already been used. If no alias is specified in the catalog database command, the database ... weiterlesen
1. Juni 2013Gernot
30
Mai2013
SQL check for unused indexes!
Before dropping indexes, verify that following PTF's are installed.
RA10 PSY UK76968 UP12/03/27 P F203
R910 PSY UK76969 UP12/03/27 P F203
If not installed, LASTUSED is not being updated when an index is used to enforce a referential integrity constraint.
--------------------------------------------------------------------------------
-- Check for unused indexes
-- Before dropping indexes, verify that ... weiterlesen
30. Mai 2013Gernot
30
Mai2013
With EMEA annoucement letter ZP13-0262 (april 23rd 2013) IBM has announced  "DB2 10.5 with BLU Acceleration, the multi-workload database software for the era of big data, improves performance while helping to reduce storage costs".
New and improved DB2 capabilities:
Analytics at the speed of thought: DB2's new BLU Acceleration feature is in-memory ... weiterlesen
30. Mai 2013Gernot
26
Apr2013
The DB2 symposium fills the gap between classic conferences and workshops. In classic conferences many topics are covered, but each speaker has only a limited time for each topic. Interaction between speakers and attendees is normally restricted. In a workshop it is the other way around. Two, three or more ... weiterlesen
26. April 2013Gernot
26
Apr2013
IDUG DB2 Tech Conference in Barcelona, Spain 2013
Barcelona, Spain
October 13-18, 2013
Call For Presentations:
You can submit your abstracts by clicking here.
IDUG DB2 Tech Conference in Berlin Wrap Up Article:
The Conference was a great success attracting attendees who came together to hear about the latest in DB2 and network with their peers. ... weiterlesen
26. April 2013Gernot
04
Apr2013
For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv!
Themen: Die GSE DB2 LUW Working Group Tagung in Heidelberg, DB2 Troubleshooting – db2stop hangs, Monitoring archivierter Log Files, automatisierte Datenbank-Reorganisation mit DB2 für LUW 10.1, Chats mit dem Labor, Schulungen / Tagungen / Informationsveranstaltung u.v.m.
Hier geht’s zum IBM DB2 Newsletter ... weiterlesen
4. April 2013Gernot