RE: BPCS AS400 ODBC Question

["ENRIQUE CALVIN" <enriquecalvin@xxxxxxxxxxx>]

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