RE: BPCS AS400 ODBC Question -- BPCS-L

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