(Robert Catterall) I’ve long been an advocate of Big Memory (meaning, lots of real storage) for DB2 for z/OS systems. For years, I was disappointed at seeing one production DB2 subsystem after another running in a z/OS LPAR with 16 GB, 20 GB, maybe 40 GB of memory — enough real storage to run decen
Tag: IBM
Optimizing Database Performance, part 4: File Placement and Page Sizing
(Craig S. Mullins) Today we start by discussing file placement and data set allocation.
Configuring the DB2 System Environment
(Mohankumar Saraswatipura) During normal operation, the DB2 database manager’s behavior is controlled, in part, by a collection of values that defines the DB2 operating environment. Some of these values are operating system environment variables, and others are special DB2-specific system-level valu
What Does a DB2 for z/OS System Look Like When You Have Memory to Burn?
(Robert Catterall) I’ve long been an advocate of Big Memory (meaning, lots of real storage) for DB2 for z/OS systems. For years, I was disappointed at seeing one production DB2 subsystem after another running in a z/OS LPAR with 16 GB, 20 GB, maybe 40 GB of memory — enough real storage to run decen
Perform scalable data exchange using InfoSphere DataStage DB2 Connector
(Angelia Song, Brian Caufield, Fan Ding, Mi Wan Shum and Sriram Padmanabhan) DB2 for z/OS delivers innovations in operational efficiency for out-of-the-box savings, business resiliency, warehouse deployment and enhanced business analytics. DB2 for z/OS is a cost-effective, simple, and proven databas
Wired or weird Tweets? Doesn’t matter to Bluemix, DB2, and Node-RED…
(Henrik Loeser) Someone to talk to, someone to take the meeting minutes. Well, I can offer that – at least partially. I took the Node-RED service on Bluemix for a test drive and created a Twitter service.
Influencing the DB2 Optimizer: Part 5 – Changing DB2 Catalog Statistics
(Craig S. Mullins) When the standard methods of influencing DB2’s access path selection — as discussed in the first 4 parts of this series (1, 2, 3, 4) — do not produce satisfactory results, you can take matters into your own hands and resort to updating the statistics in the DB2 Catalog.
Perform scalable data exchange using InfoSphere DataStage DB2 Connector
(Angelia Song, Brian Caufield, Fan Ding, Mi Wan Shum and Sriram Padmanabhan) DB2 for z/OS delivers innovations in operational efficiency for out-of-the-box savings, business resiliency, warehouse deployment and enhanced business analytics. DB2 for z/OS is a cost-effective, simple, and proven databas
Wired or weird Tweets? Doesn’t matter to Bluemix, DB2, and Node-RED…
(Henrik Loeser) Someone to talk to, someone to take the meeting minutes. Well, I can offer that – at least partially. I took the Node-RED service on Bluemix for a test drive and created a Twitter service.
Influencing the DB2 Optimizer: Part 5 – Changing DB2 Catalog Statistics
(Craig S. Mullins) When the standard methods of influencing DB2’s access path selection — as discussed in the first 4 parts of this series (1, 2, 3, 4) — do not produce satisfactory results, you can take matters into your own hands and resort to updating the statistics in the DB2 Catalog.
