Schlagwort: Db2 11

Z/OS Db2 11

Southwest Db2 Users Group – Februar 2018

SEGUS and SOFTWARE ENGINEERING sponsern diese Veranstaltung und präsentieren:
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.

Getagged mit: , , , , , , , , , , ,

Heart of Texas Db2 Users Group – Februar 2018

SEGUS and SOFTWARE ENGINEERING sponsern diese Veranstaltung und präsentieren:
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.

Getagged mit: , , , , , , , , , , ,

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

Getagged mit: , , , , ,

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

Getagged mit: , , , , , ,

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

Getagged mit: , , , , , ,

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

Getagged mit: , , , , , , , , , , ,

2016-02 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

Getagged mit: , , , , , , , , ,

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

Getagged mit: , , , , , , , , ,

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

Getagged mit: ,

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

Getagged mit: , , , , , ,