DB2 V5 for OS390 data sharing

John Rosser

DB2 V5 for OS390 data sharing
Since DBM1 is subject to the 2G OS390 address space limit, I wonder if
adding another member to the ds group would be a good idea. Adding another
member, at least from my viewpoint, would allow us to grow virtual
bufferpools and give apps better data hit ratio. This would also lessen the
risk of 878, A78s storage. Also allow us to tune one member towards
dynamic apps (PSoft) and one member towards our static apps (home grown).

Sure there are pitfalls such as how to direct jobs, users, DDF, etc. to one
member or the other. But DB2 data availability would reach near 100%!

Any thoughts?

Regards,
John Rosser
Duke Energy Corporation



Venkat (PCA) Pillay

Re: DB2 V5 for OS390 data sharing
(in response to John Rosser)
Data sharing sure does help to alleviate 2G storage limitation but
alternatively you could reduce your VP and increase your HP or wait till V6
to use data space.

Directing jobs to a particular member is not a problem because you could use
GROUP ID or SSID while attaching (CICS can not use GROUP id). You could have
different member in different LPAR or m/c also.

> -----Original Message-----
> From: John Rosser [SMTP:[login to unmask email]
> Sent: Wednesday, January 05, 2000 2:33 PM
> To: [login to unmask email]
> Subject: DB2 V5 for OS390 data sharing
>
> Since DBM1 is subject to the 2G OS390 address space limit, I wonder if
> adding another member to the ds group would be a good idea. Adding another
> member, at least from my viewpoint, would allow us to grow virtual
> bufferpools and give apps better data hit ratio. This would also lessen
> the
> risk of 878, A78s storage. Also allow us to tune one member towards
> dynamic apps (PSoft) and one member towards our static apps (home grown).
>
> Sure there are pitfalls such as how to direct jobs, users, DDF, etc. to
> one
> member or the other. But DB2 data availability would reach near 100%!
>
> Any thoughts?
>
> Regards,
> John Rosser
> Duke Energy Corporation
>
>
>
>
>