We are considering converting our DB2 Z/os V8 infrastructure datasets to be
SMS managed – this includes 18 test/systest subsystems and 12 production
subsystems – across 10 lpars. This is in preparation for DB2 V10 (We know
that it is not necessary to convert before V10 but wanted to rid ourselves
of managing the private volumes that we have today).
In various IBM manuals we have seen that 3 storage groups are recommended:
1 for the catalog and directory, 1 for the BSDS and active logs and a third
for DB2 application data. Our DASD group is trying to convince us that
separate SMS storage pools are unnecessary and we should put the catalog,
directory, BSDS and logs into the same SMS pool as the application
databases. Their contention is that with todays technology (DS8000 model
8700) our non-SMS volumes (used today for infrastructure) are just virtual
volumes stripped across very large physical drives so that in reality our
infrastructure datasets are today currently mixed in with everything anyway
and trying to separate them into separate SMS pools is unnecessary. We do
have separate DB2 application database pools for production and test with
different migration strategies and ACS routines will be enhanced to further
differentiate migration strategies for archive logs etc.
1.What are other shops doing and what might have you done differently now
that you're using SMS?
2. If we have no intention of ever using BACKUP/RESTORE SYSTEM
functionality, is there any reason (recovery, performance or future
capabilities) that would prevent us from using the same SMS pools for both
DB2 infrastructure and DB2 application datasets?
I monitor the list with a condensed version once a day so if you ask me any
questions, I can’t respond quickly.
Thanks for your thoughts.
ITG Enterprise Infrastructure
DB2 for Z/os Infrastructure
Voice: 570 585 3147
Email: [login to unmask email]
The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv