Tag: Db2 11

Z/OS Db2 11

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-10 Db2 log size: How big is your LOG?

  How to validate that your Db2 LOGs are OK ? Sizing of LOGs changed quite a bit in Db2 11 and Db2 12, so I thought a little recap about the correct sizing and ZPARMS was in order this

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

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

2015-06 SOUNDEX and other “cool” features – Part four: DB2 10-DB2 11

  Update for DB2 10 and all new for DB2 11   This newsletter completes my walk through of new Scalar functions that I began a few years ago. I will start today with two new ones that were introduced

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

2015-04 SQLCODEs of interest

  Are your DB2 11 SQLCODES up-to-date? I originally wanted to call this newsletter “SQLCODE101” but not all of my international readers may understand… Anyway, this newsletter is dedicated to that small group of people who, like me, share an interest in

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