October 2006
Intermediate to advanced
160 pages
4h 9m
English
book
DB2 for z/OS: Data Sharing in a Nutshell
by Paolo Bruni, Mark Anders, KyengDong Park, Mark Rader, Judy Ruby-Brown
Content preview from DB2 for z/OS: Data Sharing in a Nutshell
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
122 Data Sharing in a Nutshell
7.1 CLOSE YES and CLOSE NO table spaces
The CLOSE specification you made for CREATE/ALTER TABLESPACE has
different implications in data sharing.
Any table space or index which has remained in a read-only state with no activity
for a period of time longer than the pseudo-close interval (PCLOSEN/PCLOSET
DSNZPARM) is physically closed to reduce data sharing overhead (the object
can become non-GBP-dependent if it is closed on all but one member or if it is
open on multiple members but all are read-only). Its disadvantage is that the next
access to the object must go through physical open again. There can be
significant overhead, particularly if a large number of objects are accessed at the
same time after a period ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.