Tag: SQL workload

DB2 z/OS SQL workload analysis

Southwest Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , , , ,

Heart of Texas Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , ,

2017-01 Db2 12 technical overview: Roy’s first features review

This Db2 12 technical overview presents in an “easy to read” table list a review of new Db2 12 features Have you encountered any other Db2 12 changes you’d like to discuss?   Now that Db2 12 has gone GA

Tagged with: , , , , , , , , ,

2015-03: DB2 z/OS object changes: Quiet Times for maintenance

Do you have an idea when tables are in use?   Ahhh! Wouldn’t it be great if we all had just quiet times? Sadly we never have time for anything these days, let alone for peace and quiet! The quiet

Tagged with: , , , , ,

2015-01 BIFCIDS – Where’s the BIF?

How will you deal with loop-hole usage in production code?     The IFCIDs 366 and 376 DB2 provides many and varied IFCIDs. But for today, I’m most interested in the 366 and 376. The 366 is available in DB2

Tagged with: , , , , , ,

2015-02: DB2 z/OS AUDIT – Boring Boring Boring

  New IFCIDs 316 – 400/401 for DB2 z/OS Audit “on the fly” I use the Monty Python title as it reminded me of an old telephone book joke in England: look up „boring“ in the Yellow pages – there

Tagged with: , ,