db2 values current sqlid
You could also try set current schema
Your command below works for me - are you issuing this from the command
center? The command center sometimes does funny things with session
ownership (typically if you ask to see query results presented on a
separate page):. If using the Command Center, try deselecting the
Command Center option “Automatically display query results on the query
results page”.
Raquel wrote:
How do I perform a SET CURRENT SQLID in CLP and also, is there any
command I can give on the CLP to know what my CURRENT SQLID is?
When I issue:
db2 set current sqlid='db2admin'
It says the command executed successfully, but it seems that when I
execute any further command on CLP (like db2 select * from table), it
is not using db2admin (the SQLID that I set).
TIA
Raquel.
