Friday, September 9, 2016

October 14, 2016 – csDUG Conference

The Czech Republic and Slovakia DB2 Users Group (csDUG) is a new Regional User Group (RUG) that was created 4 years ago. csDUG was awarded by IBM during the last IDUG conference in Prague !

On October 14th 2016, we will be hosting our FOURTH csDUG EVENT, this year with TWO tracks!
The event is sponsored by IBM and CA Technologies.



This is a full day FREE conference with top industry speakers - an great opportunity DB2 users to meet industry experts !

Agenda of the conference



Location

IBM lab, building 4
V Parku 4, 148 00 Prague 4, Chodov
Czech Republic


Are you a qualified DB2 specialist? Do you want to discover what DB2 is or what it can do for you? Are you an experienced DBA in environments other databases and need support in DB2 for a new project? Are you interested in what role it can play a DB2 architecture of your business?
     --> Join the October 14 csDUG conference to listen to industry experts and network with other people interested in DB2!


Register to this FREE conference by sending an email to Register.csDUG.14.OCT@gmail.com
Please specify your name, country, job title, company and language(s) spoken.

Wednesday, April 6, 2016

PDUG conference in Warsaw - 5 & 6 April 2016

The VIII PDUG DB2 Conference took place in Warsaw, on April 5 & 6. The conference had 2 tracks (z/OS and LUW) and roughly 100 attendees (60 for z/OS, 40 for LUW).


PDUG VIII Kick-off

It was a great conference again, you may find the agenda at http://www.pdug.pl/media/9725/AgendazOS_VIIIkonferencjaPDUG.pdf


The event was sponsored by Asseco, CA Technologies, and IBM.

A few pictures from some sessions:

Pawel Hryb - PKO BP - DB2 Performance Reporting


Gareth Jones - IBM - DB2 v11 Overview


Ramon Menendez - BMC - Recovery Tales from Experience


Steve Thomas - CA Technologies - Cloning DB2 for z/OS objects


You may find more pictures and comments on https://twitter.com/db2forz

If you attended the Conference, feel free to leave a comment below to indicate, for example, which session / presenter you enjoyed the most !

Wednesday, October 7, 2015

3rd csDUG Conference: A great success!


40 attendees from Czech Republic, Slovakia, and some other European countries attended the 3rd csDUG Conference yesterday, in Ostrava. This one-day conference was held in the Tieto lab in Ostrava, and sponsored by CA Technologies and IBM. Various famous international speakers made the trip to share their DB2 expertise and give presentations about DB2 for z/OS.

Mariusz Koczar (Tieto) presenting SQL Monitoring Costs

Jacek Rafalak (Asseco) and Michal Bialecki (IBM) discussing SQL


Steve Thomas (CA Tech) presenting Real Time Stats

The nice view on Ostrava from Tieto's 12th floor

Sample of Free Education material for csDUG attendees

If you missed the conference this year you will have opportunity to attend next year. As we shape the next event, we would like to hear from you with your preferred city (Prague, Brno, Ostrava or Bratislava), the most convenient time of year for you, and what topics are you interested in. 

Group Picture of csDUG III

Feel free to post a comment below. Thank you.

Tuesday, September 1, 2015

October 6, 2015 – csDUG Conference

The Czech Republic and Slovakia DB2 Users Group (csDUG) is a new Regional User Group (RUG) that was created 2 years ago. Last year, csDUG was awarded by IBM during the IDUG conference !

On October 6th 2015, we will be hosting our THIRD csDUG EVENT, sponsored by Tieto, IBM and CA Technologies !

This is a full day FREE conference with top industry speakers - an great opportunity DB2 users to meet industry experts !

Agenda of the conference



Location

Ostrava, Tieto Office

28. října 3346/91
702 00 Ostrava
Czech Republic

Are you a qualified DB2 specialist? Do you want to discover what DB2 is or what it can do for you? Are you an experienced DBA in environments other databases and need support in DB2 for a new project? Are you interested in what role it can play a DB2 architecture of your business?
     --> Join the October 6 csDUG conference to listen to industry experts and network with other people interested in DB2!

Register to this FREE conference by sending an email to Register.csDUG.6.OCT@gmail.com
Please specify your name, country, job title, company and language(s) spoken.


Friday, June 26, 2015

SQL Adria Conference 2015 June 14-18 (Dubrovnik)

The DB2 SQL Adria Conference just ended, and it was a great conference again, in a great location!


The event was sponsored by IBM, IDUG and CA Technologies, and the agenda can be found here. Below a group picture of the SQL Adria team :



A few picture from some sessions:

IBM Fellow Namik Elre Speaks about DB2 Accelerator and IBM SPARK project

Steen Rasmussen explains what’s in DB2 10 and 11 for Application Developers

Cristian Molaro takes a deep dive into DB2 11 Performance

 Steve Thomas goes over DB2 Real Time Statistics (RTS)


Last, but not the least, SQL Adria would not be the same without the CA dinner and networking event sponsored by CA Technolgies:


If you attended the Conference, feel free to leave a comment below to indicate, for example, which session / presenter you enjoyed the most !

Wednesday, March 18, 2015

PDUG Conference 2015 March 17 & 18 (Warsaw)

The fifth DB2 PDUG Conference just ended, and it was a great conference again. The event was sponsored by CompFort Meridian, a local company that delivers solutions to help medium to large businesses to make efficient use of their IT systems.



There were roughly 50 attendees on the DB2 for z/OS track, and about 20 on the LUW track.

A few picture from some sessions:

Lost without a trace (Denis Tronin)

Application development goodies – what’s HOT in DB2 10 and 11 - make your favorite DBA love You !! (Steen Rasmussen)

DB2 RACF auth exit w DB2 v11 (Michał Białecki)

Dynamic SQL Best Practices (Gareth Jones, and session moderator Malgorzata in the front)

Recovery Management for DB2 (Christopher Duellmann)

Database Statistics - Good Practices Not Only For Experienced Administrators (Jacek Rafalak)

If you attended the Conference, feel free to leave a comment below to indicate, for example, which session / presenter you enjoyed the most !

Wednesday, December 17, 2014

How to use SYSSTATFEEDBACK to drive your RUNSTATS

DB2 v11 introduced a new catalog table SYSIBM.SYSSTATFEEDBACK, which contains information about missing or conflicting catalog statistics for SQL statements [more info].


Some users are very cautious about collection of statistics, some others would rather prefer this process to be automatic.
If you are part of the second group, this new feature is for you! However, the process is not fully automatic: DB2 will only fill the SYSSTATFEEDBACK catalog table with suggestions, when he/she thinks that executing RUNSTATS may be beneficial. During the last IDUG, when asked if there is any plan to “close the loop”, IBMers answered that there is no such plan. In other words, we should not expect this process to be automated by DB2 itself.

A related note in the DB2 11 for z/OS Technical Overview


Tooling available


In Version 18.0, CA Database Analyzer™ for DB2 for z/OS has been enhanced with additional support for DB2 11 Optimizer recommended RUNSTATS statistics. This tool now provides by default an extract object condition (EOC), that evaluates the SYSSTATFEEDBACK table and currently selects all objects (at the partition level) with a REASON value of BASIC, KEYCARD, or CONFLICT. The sample Real Time Object Selection RTOS$S$C is provided for this purpose:

The sample RTOS$S$C is provided,
under creator INSTALL.

The sample RTOS$S$C extracts objects 
from the SYSSTATFEEDBACK table.

Create an Action Procedure (to execute RUNSTATS) 
tied to RTOS$S$C

CA Database Analyzer generated the RUNSTATS commands 
based on SYSSTATFEEDBACK recommendations.

A couple of useful notes




  • The column STATS_FEEDBACK (in SYSIBM.SYSTABLES catalog table) controls whether the data is collected for a particular table (so you can exclude some specific tables from this process).
  • When the recommended statistics are collected, the RUSNTATS utility removes data from the SYSIBM.SYSSTATFEEDBACK catalog table.