On Thu, 8 Jan 2015 14:38:40 +0000, Martin Packer <[email protected]> wrote:
>Here your multitenancy concerns seem to be at the DB2 subsystem level. I >don't think many would advocate sharing a DB2 subsystem between Prod and >Test. Nor would I, but it happens. Especially for off-platform things coming up via DDF. "Oh, there's a test system?" Also as business units get more functional capability to solve their own problems by either writing their own queries or employing clever software that does such things for them, we see more iterative testing work coming from business users. It is hard to determine if a real business user is doing important productive work today or is simply trying out a new idea. (Which is of course also quite possibly important work as well.) And some of those initial iterations can be pretty terrible queries and after the first 5 minutes the user cancelled it from their end but DB2 doesn't know that and keeps on chugging for hours or days. Having the final period in your DDF service class be discretionary or essentially so can be a very good thing, but as pointed out it doesn't always solve all of the issues. Enabling DB2's governor is a good idea as well. Scott ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
