RE: BPCS DATABASE ADMIN (was SFC650 slowwwwwwwwww)

["Wolf, Roger" <Roger.Wolf@xxxxxxxxxx>]

Title: RE: BPCS DATABASE ADMIN (was SFC650 slowwwwwwwwww)

The ability to use DFU on a source file was dropped a few release ago on the AS/400. 

Here is the message I get with V4R3M0 with the command.

upddta wolf/qddssrc
File QDDSSRC in WOLF is not a data file.

Before I got PDM or DBU on the production machine I had to move the file to a Development machine with it on it change it there and send it back.  I learned this when I tried to change FTP statement on a source file on a machine with out PDM-SEU

-----Original Message-----
From:   DAsmussen@aol.com [SMTP:DAsmussen@aol.com]
Sent:   Monday, February 07, 2000 10:31 PM
To:     BPCS-L@midrange.com
Subject:        Re: BPCS DATABASE ADMIN (was SFC650 slowwwwwwwwww)

Fkolmann,

In a message dated 2/6/00 6:00:00 PM Eastern Standard Time,
fkolmann@revlon.com.au writes:

<<snip>>
> The point is that BPCS IMO can no longer be shipped to users and left to
tick
>  over.  BPCS and the fact it uses extensive SQL means you
>  MUST HAVE A DATABASE ADMINISTRATOR OR PERIODICALLY HIRE A
>  DATABASE ADMINISTRATOR TO  FIND DATABASE PERFORMANCE
>  PROBLEMS.
>  In the end most problems are easily found via PRTSQLINF and simply fixed
> with an
>  SQL Create Index or equivalently with a DDS LGL FILE, but what do you do
if you
>  have NO SQL ACCESS  nor a DDS compiler.

Well, DDS support is there, even if you have to use DBU/DFU to key the specs.
 I'm pretty sure that RUNSQLSTM is available as well.  There is a problem
with the DBA as usually defined in an AS/400 environment, though.  Most
AS/400 shops don't know what a DBA is supposed to do, and often hire people
for the job that are equally clueless.
<<snip>>

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-mail:  DAsmussen@aol.com

"The greatest joy in life is doing things that others say you cannot do." --
Walter Bagehot
+---