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
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be