To check what is the current SQLID

, ,
1

Hi

Can you please tell me is there any way to check what is the current SQLID for a particular region .

I know we can set the SQLID by login in to the SYSDB2 .But how can we check the current SQLID.

2

SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

3

Hi

I have checked for the current SQLID in the table
SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1.The SQLID is "CPINCA ".

Then i loged in to the onlines and changed the SQLID using SYSDB2 from “CPINCA” to "TWNETMA ".
After that i ran the query once again which is still showing the old one CPINCA.

So are there any other tables which i need to check

4

Hi

Can anyone please respond to my doubt