IDS Forum

Re: moving from one server to another

Posted By: Walter Lowich
Date: Friday, 7 March 2008, at 10:04 a.m.

In Response To: moving from one server to another (GARY MARKWALTER)

The versions of Informix must be the same, as must the hardware servers themselves.
Make sure all links are properly created and that the raw devices have owner and group equal to "informix' and the permissions are "rw-rw----". also, make sure that the SERVER NAME and all aliases are defined in sqlhosts and in /etc/services.

Walter Lowich

GARY MARKWALTER <gary.markwalter@hp.com> wrote:
Hi all,

I am needing to move an informix 7.31 db from one server Idaho to another
server in Texas. I have asked that the following be done and it has been
completed.
1. shutdown informix
2. take a backup of the raw logical volumes in Idaho
3. ship the tapes
4. restore to the same raw logical volumes on the texas server.

I Have created the links to point to the raw logical volumes and I have a copy
of the onconfig file from idaho. I have also set the informixdir var.

I am still not able to startup the db on the texas server.

I need to know what I am missing. (e.g. files, env vars, etc...)
Below is what happens when I try and start up the db. I have to be honset, it
has been over 7 years since I did this kind of procedure. Hence I need some
major help and detailed steps. Thanks in advance.

11:17:20 Segment locked: addr=0x320000, size=350609408

Wed Mar 5 11:17:21 2008

11:17:21 Event alarms enabled. ALARMPROG = '/informix/PS2/etc/no_log.sh'
11:17:27 DR: DRAUTO is 0 (Off)
11:17:27 Requested shared memory segment size rounded from 2180KB to 2184KB
11:17:27 Informix Dynamic Server Version 7.31.FD2X9 Software Serial Number ACP
#J126201
11:17:27 Assert Failed: chunk failed sanity check

11:17:27 Informix Dynamic Server Version 7.31.FD2X9
11:17:27 Who: Session(1, informix@aristot, 0, 354623528)

Thread(21, main_loop(), c0000000151fa028, 1)

File: rspartn.c Line: 7319
11:17:27 Results: Chunk 1 is being taken OFFLINE.
11:17:27 Action: Restore chunk from archive. If this is a temporary dbspace

chunk, drop and add the dbspace to enable it.
11:17:28 See Also: /informix/PS2/dump/af.3fd10c7
11:17:28 I/O error, Primary Chunk '/informix/PS2/sapdata/physdev1/data1' --
Off
line (sanity)
11:17:28 Assert Failed: chunk failed sanity check

11:17:28 Informix Dynamic Server Version 7.31.FD2X9
11:17:28 Who: Session(1, informix@aristot, 0, 354623528)

Thread(21, main_loop(), c0000000151fa028, 1)

File: rspartn.c Line: 7319
11:17:28 Results: Chunk 1 is being taken OFFLINE.
11:17:28 Action: Restore chunk from archive. If this is a temporary dbspace

chunk, drop and add the dbspace to enable it.
11:17:29 See Also: /informix/PS2/dump/af.3fd10c7
11:17:29 I/O error, Mirror Chunk '/informix/PS2/sapdata/physdev2/data2' --
Offl
ine (sanity)
11:17:29 Informix Dynamic Server Stopped.
11:17:29 mt_shm_remove: WARNING: may not have removed all/correct segments

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!

---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

Messages In This Thread

• moving from one server to another
  GARY MARKWALTER -- Wednesday, 5 March 2008, at 1:28 p.m.
  • Re: moving from one server to another
    Art S. Kagel (Oninit) -- Wednesday, 5 March 2008, at 1:48 p.m.
  • Re: moving from one server to another
    Walter Lowich -- Friday, 7 March 2008, at 10:04 a.m.
    • AW: moving from one server to another
      Andreas.KUTSCHE@spar.at -- Monday, 10 March 2008, at 4:47 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.