RE: BPCS-L Digest, Vol 2, Issue 65 -- BPCS-L


-----Original Message-----
From: bpcs-l-request@xxxxxxxxxxxx [mailto:bpcs-l-request@xxxxxxxxxxxx]
Sent: Wednesday, March 24, 2004 12:00 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 2, Issue 65


Send BPCS-L mailing list submissions to
        bpcs-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
        bpcs-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        bpcs-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."


Today's Topics:

   1. RE: triger pgm (Nathan Bennett)
   2. Re: BPCS AS400 ODBC Question (Bill)
   3. RE: BPCS AS400 ODBC Question (ENRIQUE CALVIN)
   4. RE: triger pgm (Dave Murvin)
   5. RE: Missing CEA Accounts (jreinardy@xxxxxxxxxxxxxxx)
   6. RE: triger pgm (Nathan Bennett)


----------------------------------------------------------------------

message: 1
date: Tue, 23 Mar 2004 20:14:05 +0100
from: "Nathan Bennett" <nabennis@xxxxxxxxx>
subject: RE: triger pgm

You can update the output record buffer in the trigger program prior to the
actual update.

Regards


-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
Behalf Of Charlie Borill
Sent: Tuesday, March 23, 2004 5:33 PM
To: SSA's BPCS ERP System
Subject: Re: triger pgm


Submit another job from the trigger program to perform the update to the RAR
record.

----- Original Message -----
From: "Danny Monselise" <dannym@xxxxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, March 23, 2004 11:17 AM
Subject: triger pgm


> Hi all
> i know it maybe outside the scope but:
> i have a trigger pgm linked to RAR (every invoice entered thru acr500 is
> populating a  file thru that triger pgm)
> now i need to update the same RAR record which at the same time - and it
> is locked-  has anyone solved that one ?
> danny
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



------------------------------

message: 2
date: Tue, 23 Mar 2004 11:43:39 -0800
from: "Bill" <billzbubb@xxxxxxxxxx>
subject: Re: BPCS AS400 ODBC Question


> Following question is not directly related to BPCS,
> However, this is related to AS400, ODBC and BPCS data
> library on As400. May be some friend can advise and
> help us.

You will get a much better answer on the Midrange List for this type of
question.

Bill




------------------------------

message: 3
date: Tue, 23 Mar 2004 10:55:57 +0000
from: "ENRIQUE CALVIN" <enriquecalvin@xxxxxxxxxxx>
subject: RE: BPCS AS400 ODBC Question

Hello All,

Without deeping more in the problem, when using a tool like Cognos, you can 
set-up in it the percentage of work effor you want on the server or on the 
client. Maybe, setting up the effor in the client (PC), your job takes less 
percentage of AS/400 CPU. In Cognos you can set this up in tag Client/Server

on Catalgo User Profiles menu.

Hope this is useful
Regards



>Hello All,
>
>We are using BPCS mixed Mode V8.1 on As400.
>
>Following question is not directly related to BPCS,
>However, this is related to AS400, ODBC and BPCS data
>library on As400. May be some friend can advise and
>help us.
>
>Scenario:
>----------
>When i use some windows based reprting tool (Like
>cognos) to extract BPCS data through ODBC, System
>automatically sumbit one job on AS400 and takes almost
>70-80% of CPU %.
>
>Question:
>---------
>Is there any way that whenever such job (Pre start
>job)  is created on As400, it should not take more
>than 10% of CPU% ?
>
>Or is there any other way  to put such job on low
>priority ?
>
>Note
>Since such jobs are submited automatically in Qserver,
>therefore, i am careful to play with qserver setting
>because Qserver is also handling OS400 related jobs.
>
>Job attributes are as follow>>>>
>
>
>
>WRKACTJOB command on AS400 shows the follwoing
>---------------------------------------------
>Job         User   Type     CPU%      Status
>---------------------------------------------
>QZDASOINIT  QUSER  PJ       90%        DEQW
>
>Further details shows the following
>
>Job:   QZDASOINIT     User:   QUSER          Number:
>491211
>
>
>Status of job . .. . . . . . . . . :   ACTIVE
>Current user profile . . . . . . . :   xxxxx
>Job user identity . . .. . . . . . :   xxxxx
>   Set by . . . . . . . . . . . . :     *DEFAULT
>Subsystem . . . . . . . . . . . . :   QSERVER
>   Subsystem pool ID . . . . . . . . :     1
>Type of job . . . . . . . . . . . . :   PJ
>Special environment . . . . . . . . :   *NONE
>Program return code . . . . . . . . :   0
>
>Controlled end requested  . .   . :   NO
>  System  ..... . . . . . . . . . . :   xxxxxx
>-------------------------------------------
>
>Regards,,,
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Finance Tax Center - File online. File on time.
>http://taxes.yahoo.com/filing.html
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail



------------------------------

message: 4
date: Tue, 23 Mar 2004 19:41:38 -0800
from: Dave Murvin <davem@xxxxxxxx>
subject: RE: triger pgm

I think you also have to specify *YES on the Allow Repeated Change 
(ALWREPCHG) keyword on the ADDPFTRG command.

At 11:14 AM 3/23/2004, Nathan Bennett  wrote:
>You can update the output record buffer in the trigger program prior to the
>actual update.


Dave Murvin
DRM Enterprises, Inc.




------------------------------

message: 5
date: Wed, 24 Mar 2004 09:06:18 -0600
from: jreinardy@xxxxxxxxxxxxxxx
subject: RE: Missing CEA Accounts

Thanks to those who responded to this.  We did find the issue late Monday. A
user had run a query to create a partial extract of the GCR file.
Unfortunately, the output file was also called GCR and she placed it in a
library that was earlier in her library list than the production files.
Therefore, CEA was using a bad GCR file and giving us strange results.
Renaming the file cleared up the issue.  We are now reexamining security on
our libraries!  

Regards,

Jim Reinardy 
 

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of jreinardy@xxxxxxxxxxxxxxx
Sent: Friday, March 19, 2004 11:28 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Missing CEA Accounts

We are running 6.04 mixed mode, and having trouble with CEA accounts not
showing up under the Event Processor.    The account cross-reference under
the setup does not show any data, either.  We have done queries against the
database files and everything appears to fine there.  Security appears to be
set as necessary for CEA.  We are not aware of any changes made that
triggered this, and it has been running fine for 5 years prior to this.  Any
ideas?
 
James Reinardy
Director - IS
Badger Meter, Inc.
Milwaukee, WI


The information contained in this message is confidential and is intended
for the addressee(s) only.  If you have received this message in error or
there are any problems please notify the originator immediately.  The
unauthorized use, disclosure, copying or alteration of this message is
strictly forbidden. Badger Meter, Inc. will not be liable for direct,
special, indirect or consequential damages arising from alteration of the
contents of this message by a third party or as a result of any virus being
passed on.

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message
email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.


The information contained in this message is confidential and is intended
for the addressee(s) only.  If you have received this message in error or
there are any problems please notify the originator immediately.  The
unauthorized use, disclosure, copying or alteration of this message is
strictly forbidden. Badger Meter, Inc. will not be liable for direct,
special, indirect or consequential damages arising from alteration of the
contents of this message by a third party or as a result of any virus being
passed on.



------------------------------

message: 6
date: Wed, 24 Mar 2004 18:43:32 +0100
from: "Nathan Bennett" <nabennis@xxxxxxxxx>
subject: RE: triger pgm

Yes you do, sorry should have mentioned it.

Thanks

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
Behalf Of Dave Murvin
Sent: Wednesday, March 24, 2004 4:42 AM
To: SSA's BPCS ERP System
Subject: RE: triger pgm


I think you also have to specify *YES on the Allow Repeated Change
(ALWREPCHG) keyword on the ADDPFTRG command.

At 11:14 AM 3/23/2004, Nathan Bennett  wrote:
>You can update the output record buffer in the trigger program prior to the
>actual update.


Dave Murvin
DRM Enterprises, Inc.


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



------------------------------

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) digest list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



End of BPCS-L Digest, Vol 2, Issue 65
*************************************