IDS Forum

HDR Implementation

Posted By: MUKESH TANUKU
Date: Tuesday, 13 June 2017, at 2:10 a.m.

Hi All

While HDR implementation on Unix

My scenario:

1. Two different servers with identical hardware and software.
2. Installed IDS on both servers.
3. Created Instances manually with all onconfig, sqlhost, environment variables set.
4. set all HDR related parameters in onconfig on both servers identical.
5.set below parameters on both servers

- DBSERVERNAME

- MSGPATH

- ROOTNAME

- ROOTPATH

- ROOTSIZE

- DBSPACETEMP

- SBSPACETEMP

- SBSPACENAME

- DRAUTO

- DRINTERVAL

- HDR_TXN_SCOPE

- DRTIMEOUT

- LTAPEDEV

- TAPEDEV
6. set the sqlhost same on both servers.
7. connection between both servers are trusted.
8. On server A, ontape backup is generated

and onmode -d primary <secondary_servername>

is executed.
9.on server B restored the backup, ontape -p

and onmode -d secondary <primary_servername>

is executed.

on secondary if we check the state of the server:

[root@localhost storage]# onstat -

IBM Informix Dynamic Server Version 12.10.FC8AEE -- Quiescent -- Up 00:21:56 -- 148084 Kbytes

find the online.log below.

11:18:47 IBM Informix Dynamic Server Started.
11:18:47 Requested shared memory segment size rounded from 4308KB to 4796KB

Tue Jun 13 11:18:48 2017

11:18:48 Requested shared memory segment size rounded from 110629KB to 110632KB
11:18:49 Successfully added a bufferpool of page size 2K.

11:18:49 Event alarms enabled. ALARMPROG = '/mnt/informix/hdr_secondary/etc/alarmprogram.sh'
11:18:49 Booting Language <c> from module <>
11:18:49 Loading Module <CNULL>
11:18:49 Booting Language <builtin> from module <>
11:18:49 Loading Module <BUILTINNULL>
11:18:54 DR: DRAUTO is 0 (Off)
11:18:54 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
11:18:54 Event notification facility epoll enabled.
11:18:54 Trusted host cache successfully built:/etc/hosts.equiv.
11:18:54 CCFLAGS2 value set to 0x200
11:18:54 SQL_FEAT_CTRL value set to 0x8008
11:18:54 SQL_DEF_CTRL value set to 0x4b0
11:18:54 IBM Informix Dynamic Server Version 12.10.FC8AEE Software Serial Number AAA#B000000
11:18:54 Warning: stat() failed for chunk file /mnt/informix/storage/tmpsbspaces
11:18:54 Cannot Open Primary Chunk '/mnt/informix/storage/tmpsbspaces', errno = 2
11:18:54 oninit: Cannot open chunk '/mnt/informix/storage/tmpsbspaces'. errno = 2

11:18:55 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

11:18:55 Started 1 B-tree scanners.
11:18:55 B-tree scanner threshold set at 5000.
11:18:55 B-tree scanner range scan size set to -1.
11:18:55 B-tree scanner ALICE mode set to 6.
11:18:55 B-tree scanner index compression level set to med.
11:18:55 DR: Reservation of the last logical log for log backup turned on
11:18:55 Data replication type and state information reset. To start DR, use

the 'onmode -d' command and wait for the pair to be operational,

before shutting down the database server

11:18:55 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed

in DBSPACETEMP: 'tmpdbspaces'
11:18:55 Dataskip is now OFF for all dbspaces
11:18:55 Restartable Restore has been ENABLED
11:18:55 Recovery Mode
11:18:57 Physical Restore of rootdbs, dbspaces, plogs, llogs, sbspaces started.

11:21:04 Checkpoint Completed: duration was 0 seconds.
11:21:04 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a14cf Interval: 147

11:21:04 Maximum server connections 0
11:21:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

11:21:04 Checkpoint Completed: duration was 0 seconds.
11:21:04 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a14d8 Interval: 148

11:21:04 Maximum server connections 0
11:21:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

11:21:04 Checkpoint Completed: duration was 0 seconds.
11:21:04 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a14e1 Interval: 149

11:21:04 Maximum server connections 0
11:21:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

11:21:04 Checkpoint Completed: duration was 0 seconds.
11:21:04 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a14ea Interval: 150

11:21:04 Maximum server connections 0
11:21:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

11:21:50 Checkpoint Completed: duration was 0 seconds.
11:21:50 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a14f1 Interval: 151

11:21:50 Maximum server connections 0
11:21:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

11:21:51 Physical Restore of rootdbs, dbspaces, plogs, llogs, sbspaces Completed.
11:21:51 Checkpoint Completed: duration was 0 seconds.
11:21:51 Tue Jun 13 - loguniq 41, logpos 0x2642278, timestamp: 0x5a1509 Interval: 151

11:21:51 Maximum server connections 0
11:22:44 No logical log restore will be performed.
11:22:44 Clearing the physical and logical logs has started
11:23:22 Cleared 1006 MB of the physical and logical logs in 37 seconds
11:23:22 Dropping temporary TBLspace 0x101010, recovering 25 pages.
11:23:22 Physical Recovery Started at Page (1:20021).
11:23:22 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
11:23:22 Logical Recovery Started.
11:23:22 10 recovery worker threads will be started.
11:23:22 Logical Recovery has reached the transaction cleanup phase.
11:23:22 Logical Recovery Complete.

0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:23:23 Assert Warning: recreate of temporary sbspsace failed sbsnum:6, err=0

11:23:23 IBM Informix Dynamic Server Version 12.10.FC8AEE
11:23:23 Who: Session(1, informix@localhost.localdomain, 0, 0x44c42028)

Thread(7, main_loop(), 44bfb028, 1)

File: rstbs.c Line: 4899
11:23:23 Results: Downing sbspace.
11:23:23 Action: Please notify IBM Informix Technical Support.
11:23:23 stack trace for pid 5910 written to /mnt/informix/hdr_secondary/tmp/af.3ef7dd3
11:23:23 See Also: /mnt/informix/hdr_secondary/tmp/af.3ef7dd3
11:23:23 recreate of temporary sbspsace failed sbsnum:6, err=0

11:23:23 Bringing system to Quiescent Mode with no Logical Restore.

11:23:24 Quiescent Mode
11:23:24 Checkpoint Completed: duration was 0 seconds.
11:23:24 Tue Jun 13 - loguniq 41, logpos 0x2644018, timestamp: 0x5a152b Interval: 152

11:23:24 Maximum server connections 0
11:23:24 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 1

11:23:26 Defragmenter cleaner thread now running
11:23:26 Defragmenter cleaner thread cleaned:0 partitions
11:23:49 DR: Error - Server must be in recovery mode

Messages In This Thread

• HDR Implementation
  MUKESH TANUKU -- Tuesday, 13 June 2017, at 2:10 a.m.
  • Re: HDR Implementation
    Marcus Haarmann -- Tuesday, 13 June 2017, at 2:41 a.m.
    • Re: HDR Implementation
      MUKESH TANUKU -- Tuesday, 13 June 2017, at 7:01 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.