Results 1 to 2 of 2

Thread: current server

  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: current server

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    select host_name from sysibmadm.env_sys_info

    The new administrative views are really useful.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •