May 29, 2002 02:29 PM
(in response to Tim Lowe)
When I meant was I don't encourage user level to use SPUFI and QMF.
for some junior DBA, I would be hesitated to give them production
Yes, it really depends on who is using it and if there is a good
rule to do
it. One of my arguments for this is that it is easier to screw up
production data if you provide them with 'ease of use' tools.
argument is it is harder to trace who has done what without any log
tools. Also if you have any application maintain RI, it will be
impossible to find out when the link is broken. I have worked in
and production updating throught SPFUI/any tools is restricted to
production DBAs. I don't know if your shop allows users to update
IBM Certified Solutions Expert
- DB2 V7.1 Database Administration for OS/390
----- Original Message -----
From: <[login to unmask email]>
To: <[login to unmask email]>
Sent: Wednesday, May 29, 2002 1:53 PM
Subject: Re: Isolation level of SPUFI
> I don't think it is fair to blame SPUFI or QMF for problems
> production data.
> In my opinion, both QMF and SPUFI can (and should) be used
> production data without problems.
> It is not the tool, but how it is used.
> If you eliminate SPUFI and QMF, someone might create the same
> problems with other tools.
> We cannot eliminate all of the tools, and expect the business
goals to be
> We do need to establish good rules, hire good people, train
them well and
> trust them.
> Otherwise, we are just trying to be overly protective of the
> (If nobody can touch production data, then nobody can break
> And, that just leads to rules that people don't understand
> and they want to move to other platforms with the false
> platform is the problem.
> Obviously, some client/server applications make this much more
> But, that does not mean that we should give up, it just means
that we need
> to work harder on education.
> We are talking about DB2 application developers and DB2
end-users that use
> their own dynamic sql (what we used to call
> Can we establish good rules about what data they can access
> Can we hire good people, and train them?
> First, I don't see any need to grant the Spufi RR plan to
> Second, you can create some simple rules to encourage using
> And, what do you do when the rules are broken (and they will
> regardless of anything we do).