Rename IB nodes from production. Examples show both HR Production and Finance Production nodes renamed.

renameIBnodes.sql

-- -------------------------
-- Rename Default Local Node
-- -------------------------

  -- Rename IB Nodes
UPDATE sysadm.psmsgnodedefn
SET
    msgnodename = 'HNONPROD',
    authoptn = 'P',
    ibpassword = '<encrypted password>',
    userid = '<user>',
    -- Remote Gateway is HR, LOCAL is Finance
    conngatewayid = 'HR'
WHERE
    msgnodename = 'HPROD';

UPDATE sysadm.psnodeuritext
SET
    msgnodename = 'HNONPROD'
WHERE
    msgnodename = 'HPROD';

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

UPDATE sysadm.psmsgnodedefn
SET
    msgnodename = 'FNONPROD',
    authoptn = 'P',
    ibpassword = '<encrypted password>',
    userid = '<user>',
    localdefaultflg = 'Y',
    -- Remote Gateway is HR, LOCAL is Finance
    conngatewayid = 'LOCAL'
WHERE
    msgnodename = 'FPROD';

UPDATE sysadm.psnodeuritext
SET
    msgnodename = 'FNONPROD'
WHERE
    msgnodename = 'FPROD';

-- Receiver Node

UPDATE sysadm.psibrtngdefn
SET
    receivernodename = 'HNONPROD'
WHERE
    receivernodename = 'HPROD';

UPDATE sysadm.psibrtngdefn
SET
    receivernodename = 'FNONPROD'
WHERE
    receivernodename = 'FPROD';

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

UPDATE sysadm.psibrtngsubdefn
SET
    receivernodename = 'HNONPROD'
WHERE
    receivernodename = 'HPROD';

UPDATE sysadm.psibrtngsubdefn
SET
    receivernodename = 'FNONPROD'
WHERE
    receivernodename = 'FPROD';

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

UPDATE sysadm.psrtngdfnparm
SET
    receivernodename = 'HNONPROD'
WHERE
    receivernodename = 'HPROD';

UPDATE sysadm.psrtngdfnparm
SET
    receivernodename = 'FNONPROD'
WHERE
    receivernodename = 'FPROD';

-- Sender Node

UPDATE sysadm.psibrtngdefn
SET
    sendernodename = 'HNONPROD'
WHERE
    sendernodename = 'HPROD';

UPDATE sysadm.psibrtngdefn
SET
    sendernodename = 'FNONPROD'
WHERE
    sendernodename = 'FPROD';

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

UPDATE sysadm.psibrtngsubdefn
SET
    sendernodename = 'HNONPROD'
WHERE
    sendernodename = 'HPROD';

UPDATE sysadm.psibrtngsubdefn
SET
    sendernodename = 'FNONPROD'
WHERE
    sendernodename = 'FPROD';

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

UPDATE sysadm.psrtngdfnparm
SET
    sendernodename = 'HNONPROD'
WHERE
    sendernodename = 'HPROD';

UPDATE sysadm.psrtngdfnparm
SET
    sendernodename = 'FNONPROD'
WHERE
    sendernodename = 'FPROD';
    
    
-- -------------
-- Trusted Nodes
-- -------------

TRUNCATE TABLE sysadm.pstrustnodes;

INSERT INTO sysadm.pstrustnodes VALUES ( 'FNONPROD' );

INSERT INTO sysadm.pstrustnodes VALUES ( 'HNONPROD' );