we have taken a flashcopy of filesystems from database sqlprod in prod system to test system
we had a database sqlprod cataloged in test system
we use inidb as snasphot to have access to this db
the problem is that if we are using
select current server from ...
we see the real db name (sqlprod) and we don't know on which system we are
is there any special register or other that would return the hostname or something that could us indicate on which server we are working
this with db2 ese 9.5 on Z/linux

or any other idea would be welcome
best regards, guy przytula

select host_name from sysibmadm.env_sys_info

The new administrative views are really useful.

Andy