Tag: Db2 migration

z/OS Version Migration

IDUG 2017 EMEA Db2 Tech Conference

IDUG 2017 EMEA Db2 Tech Conference, Lisbon, Portugal. IDUG EMEA – October 2nd, 2017 –
SEGUS & SOFTWARE ENGINEERING present:

Db2 12 Continuous Delivery – New challenges for deployment:
Fundamental changes in the Db2 z world often lead to concerns. Let’s face it – some changes force us to change! While a Db2 version migration usually took months, or even years, there will be no new Db2 version after 12, but continuous code drops.

Tagged with: , , ,

Central Canada DB2 Users Group 2017

Central Canada DB2 Users Group 2017, Toronto, ON, Canada CCDB2UG –  on Tuesday June 5-6th, 2017 SEGUS & SOFTWARE ENGINEERING present Pdf – DB2 12 Continuous Delivery – New challenges for deployment. Fundamental changes in the DB2 z world often lead

Tagged with: , , ,

2017-03 Db2 11 RBA/LRSN Migration 6 to 10 bytes

Db2 11 RBA/LRSN Migration 6 to 10 bytes: How long do you think it will take you to get from 6 – 10 Bytes and Simple/Segmented to UTS’s? Are you thinking days, months, years?? This month, I want to discuss

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: , , , , , , , , ,

2016-07 – Migration Planning : Stuck in a BIND

Migration planning to DB2 11 z/OS: Two queries to list the NULLID and the PLAN packages that need a DB2 REBIND I was at a customer site the other week and we were getting weird data out of the IFCIDs

Tagged with: , , , , , ,

2016-04 DB2 SYSCOPY – Do you know what is in it? Redux

DB2 10, DB2 11 Migration & DB2 Database maintenance A special query to check and clear out the DB2 Catalog   This is a redux of my original Newsletter from February 2013 with additional data at the very end – The

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

2016-03 DB2 z/OS Real Time Statistics (RTS) Revisited – Information missing (part 2)

DB2 z/OS Real Time Statistics (RTS) –  NULL initialization made easy A second RTS query to set this time *all* of your RTS KPIs and counters to enable good DB2 Database Maintenance before a REORG, RUNSTAT or a DB2 Migration for DB2

Tagged with: , , , , , ,

2016-2 Real Time Statistics (RTS) Revisited – Information missing (part 1)

Easy Real Time Statistics (RTS) data initialization from DB2 9 to DB2 11: Special query to run before a REORG, RUNSTAT or a DB2 Migration. How many RTS rows did you find?   Hands up who knows nothing about the

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

GIVE and TAKE Program

1,2,3 Give and Take 2020 Information on the Give and Take Programs 4,5,6,7 Previous Give & Take We have “GIVEn” various free-of-charge Use Cases from our SQL WorkloadExpert for Db2 z/OS like: 1 Index Maintenance Costs 2 EXPLAIN Suppression 3

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: , , , , , ,