Re: Qlick R4I performance problem on IBM i

I've used this and have not seen issues like you are hinting at.
You can use any of the IBM i performance tools to look and see what is 
happening.
initial thoughts:
Make sure there is enough memory in the pool where the ODBC jobs are 
running.
Consider Alternate Subsystem Routing.
https://dawnmayi.com/2015/08/03/route-db2-requests-to-a-specific-subsystem/
IBM has made is easier now that when i first explored it:
https://archive.midrange.com/midrange-l/200503/msg01345.html

Not sure it would help, but it is no cost option, Journal Caching.

For the QLIK software, i recall not having a large number of files per 
"task".  To be sure you should ask QLIK support.

I created this SQL to monitor/find the jobs. all our jobs are run by a 
user named UDTFQLIK

SELECT Aj.Subsystem,Aj.Job_Name
        ,Aj.Authorization_Name AS "Current User"
        ,Ns.Remote_Address, ns.local_port
        ,Aj.Cpu_Time AS "MilliSeconds Used"
        ,Aj.Elapsed_Cpu_Percentage, Aj.Elapsed_Cpu_Time
        ,Aj.Open_files,Aj.Sql_Statement_Text
   FROM TABLE(Qsys2.Active_Job_Info(
                RESET_STATISTICS => 'NO'
               ,JOB_NAME_FILTER => 'QZ*'
               ,CURRENT_USER_LIST_FILTER=>'UDTFQLIK'
               ,DETAILED_INFO => 'ALL' ))
        AS Aj
          ,Qsys2.Netstat_Job_Info AS Ns
     WHERE Aj.Job_Name = Ns.Job_Name
     order by Aj.Elapsed_Cpu_Percentage desc
     ;




gio.cot via MIDRANGE-L wrote on 5/21/2026 2:48 PM:
> Hi all
> 
> We are trying to use R4I , but we have performance problems ..  can some one
> have experience with this product (R4I) .. where can i find suggestion for
> solving performance problems ?
> 
> Thanks in advanvce
> 
> Gio
> 

-- 

-- .
Bryan

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.