Skip to Content
author's profile photo Former Member
Former Member

DB2 Hostname Change

Dear All,

Our SAP Servers use Linux Suse 11 for OS with DB2 v10.1.0.2 which run on VMware virtualization on Blade Server.

Because of that our DRC planning will be done by restoring VMware images.

But, there are issues when we try to restore the Production servers images (seperated between PROD-CI and PROD-DB)

On OS level, IP, Hostname also the SAP parameters has been replaced with the new ones (named PROD-CIDR and PROD-DBDR), the issues came up when we try to change to change DB2 hostname parameter using :

db2set -g DB2SYSTEM=[new DB2 server hostname]

we got this error:

DBI1309E System error.

Explanation:

The tool encountered an operating system error.

User response:

A system error was encountered during registry access. Ensure that there

is enough space on the file system where the registry is located, and

that there is a valid LAN connection if the registry is remote.

when we looked at the db2diag.log, we got this info:

FUNCTION: DB2 Common, Generic Registry, GenRegBin::Change, probe:240

MESSAGE : ECF=0x900001EE=-1879047698=ECF_GENREG_RECORDBUF_FREEMEM_FAILURE

Failed to free recordbuf memory

CALLED : DB2 Common, OSSe, ossMemFree

RETCODE : ECF=0x900003EE=-1879047186=ECF_MEM_NULL_POINTER

The address provided is NULL

---------------------------------------------------------------------------------------------------------------------------------------------------

FUNCTION: DB2 Common, OSSe, ossMemFree, probe:20

MESSAGE : ECF=0x900003EE=-1879047186=ECF_MEM_NULL_POINTER

The address provided is NULL

DATA #1 : String, 75 bytes

NULL pointer for memory allocation address found at: GenRegBin.C, line 1453

---------------------------------------------------------------------------------------------------------------------------------------------------

FUNCTION: DB2 Common, Generic Registry, GenRegBin::Change, probe:70

MESSAGE : ECF=0x900001BC=-1879047748=ECF_GENREG_FAILED_TO_LOCK_REGISTRY

Failed to lock the registry

CALLED : DB2 Common, Generic Registry, GenRegFile::Lock

RETCODE : ECF=0x900001DA=-1879047718=ECF_GENREG_UNABLE_TO_OPEN_LOCK_FILE

Unable to open the lock file

---------------------------------------------------------------------------------------------------------------------------------------------------

FUNCTION: DB2 Common, Generic Registry, GenRegFile::Lock, probe:50

MESSAGE : ECF=0x900001DA=-1879047718=ECF_GENREG_UNABLE_TO_OPEN_LOCK_FILE

Unable to open the lock file

CALLED : DB2 Common, OSSe, OSSHFile::open

RETCODE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED

Access denied

---------------------------------------------------------------------------------------------------------------------------------------------------

Does anyone have this issue before?

Kindly help,

Regards,

Stan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 30, 2014 at 02:34 PM

    Hi Stan,

    Please refer SAP note

    70856 - DB2 specific actions when renaming DB host


    Hope this helps.


    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 30, 2014 at 10:31 AM

    Hi Stan

    I think the command should be (as root) :

    db2iset -g DB2SYSTEM=<new host name>

    Also ensure that your db2nodes.cfg file contains the new host name.

    Regards

    Robert

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Robert,

      Thank you for your reply,

      As seen in the picture I attached below, I tried to use the db2iset command as root, but the OS said that it doesn't recognize the command. I also tried to use db2set as root, still showed the same result.

      Then I tried to login as db2admin [db2p01], and tried the db2iset command, but they said it is a wrong command and tried to fix it as db2set. And there's the result, the same as what I mentioned before.

      So the DB2SYSTEM value is still using the old hostname

      Regards,

      Stan

      DB2SET.jpg (129.3 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2014 at 07:54 AM

    Dear All,

    Finally I got the chance to give an update...

    Just yesterday, I finally succeed to replicate and configure the DR server of our QA system.

    Our steps are:

    • Replicate the QA Server
    • Build new server as DR server, set networking not to connect at power on
    • After power on the server, I change some setting, which is
      • Change /etc/hosts value,

    Need to change the IP address, set the new IP and leave the hostname as it is

    • Change Network Setting from YAST,

    When we create new server from replication, they will create new connection properties (set as eth1), where the new assigned network hardware set. The old connection properties (set as eth0) contain the old IP, and will not contain hardware information/empty. So we need to delete the old connection properties and set the new IP to the new connection properties (also change the conf name from eth1 to eth0)

    • Connect DR server to the network

    After this, we already can ping the DR server

    • Start SAP services

    Then, the SAP DR can be accessed by SAP Logon by adding new connection while the real QA is still online.

    So far, we've tested it up to that point and haven't try to insert some transaction and also haven't check any issue related to SAP parameters.

    If there's no trouble, we intended to replicate the Production servers... 😀

    Any inputs / suggestions about this? Is there any point that we need to check first at this point?


    Regards,

    Stan Beta

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.