Qlik Replicate Qlik Replicate handle sessions on Db2 for i series

[lguevara]

Hi,

I would like to understand the difference in session handling in the following scenarios:

I use as a source Db2 for i series 7.4 in qlik replicate 202411

When performing a full load task.

When running a task in CDC  mode.

When doing a simple endpoint test (Test Connection).

When stopping a task.

Because I want to identified if a session is running o when was the last login to audit.

Thanks

[john_wang]

Hello @lguevara ,

I’m not sure I fully understand your question — could you please elaborate?
Are you referring to the number of connections, the connection establishment process, or the queries running within the sessions?

thanks,

John.

[DesmondWOO]

Hi @lguevara ,

Qlik Replicate performs the Full Load and Change Data Capture (CDC) using the account specified in the DB2 iSeries endpoint.

Regards,
Desmond

[lguevara]

Hi @john_wang 

Yes I want to understand connection establishment process, because since db2 how identified this connection session.

thanks,

[DesmondWOO]

Hi @lguevara ,

You might want to try running SELECT * FROM QSYS2.NETSTAT_INFO. You can also check QSYS2.ACTIVE_DB_CONNECTIONS, but this function does not exist in an older version. I recommend checking in with the AS400 administrator for more details.

Regards,
Desmond