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