ifxclone
User attempted to use ifxclone to clone an Informix database from Linux to AIX, but encountered error -83673 ('Unexpected message type') causing physical restore to fail. Multiple experts confirmed that ifxclone cannot be used across different OS/hardware platforms because archive formats are not portable between platforms. Alternative solutions suggested: use export/import or let replication populate an empty target database.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I finally got my grid and CDR setup to work (with a little help from you guys) and then decided I'd try making it easier by using ifxclone...now I can't get that to work :/...I've created the files for the spaces that the source has on the target. I've created the sqlhosts and onconfig on the target. ifxclone --source=batcave --sourceIP=tfx3 --sourcePort=5857 --target=penguin --targetIP=sd36 --targetPort=3700 --useLocal --trusted That is the command I'm using. I'm going from Linux to AIX. 08:07:50 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 08:07:50 Started 1 B-tree scanners. 08:07:50 B-tree scanner threshold set at 5000. 08:07:50 B-tree scanner range scan size set to -1. 08:07:50 B-tree scanner ALICE mode set to 6. 08:07:50 B-tree scanner index compression level set to med. 08:07:50 Dataskip is now OFF for all dbspaces 08:07:50 Recovery Mode 08:07:50 (-83673) Unexpected message type 50331648. 08:07:50 Physical restore failed for dbspace number 1. 08:07:50 Snapshot instantiation failed, killing myself. 08:07:52 The Master Daemon Died 08:07:52 PANIC: Attempting to bring system down That's what I'm getting in the target server's logs. I'm not sure what that (-83683) error is I can't find it anywhere either. g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor g_riddler group - - i=490 enigma onsoctcp sd36 3500 g=g_riddler That's my sqlhosts too. I don't see any issues in any of this other than it's not working which has me confused. Any help would be great. Thanks
Original post: I finally got my grid and CDR setup to work (with a little help from you guys) and then decided I'd try making it easier by using ifxclone...now I can't get that to work :/...I've created the files for the spaces that the source has on the target. I've created the sqlhosts and onconfig on the target. ifxclone --source=batcave --sourceIP=tfx3 --sourcePort=5857 --target=penguin --targetIP=sd36 --targetPort=3700 --useLocal --trusted That is the command I'm using. I'm going from Linux to AIX. 08:07:50 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 08:07:50 Started 1 B-tree scanners. 08:07:50 B-tree scanner threshold set at 5000. 08:07:50 B-tree scanner range scan size set to -1. 08:07:50 B-tree scanner ALICE mode set to 6. 08:07:50 B-tree scanner index compression level set to med. 08:07:50 Dataskip is now OFF for all dbspaces 08:07:50 Recovery Mode 08:07:50 (-83673) Unexpected message type 50331648. 08:07:50 Physical restore failed for dbspace number 1. 08:07:50 Snapshot instantiation failed, killing myself. 08:07:52 The Master Daemon Died 08:07:52 PANIC: Attempting to bring system down That's what I'm getting in the target server's logs. I'm not sure what that (-83683) error is I can't find it anywhere either. g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor g_riddler group - - i=490 enigma onsoctcp sd36 3500 g=g_riddler That's my sqlhosts too. I don't see any issues in any of this other than it's not working which has me confused. Any help would be great. Thanks Response: I don't think this is going to work between a Linux machine and an AIX machine. According to http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .adref.doc%2Fids_adr_1093.htm if you go down to the prerequisites section it mentions the hardware/software requirements are the same as for HDR, and for HDR the machines you are replicating between have to be the same platform. Jacques Renaut IBM Informix Advanced Support APD Team
Since ifxclone uses ontape to archive and restore the database, and since
archives are note portable between platforms, you cannot use ifxclone to
clone a server to a different OS or hardware platform. You will either
have to use export and import or something similar, or you will have to
create an empty database on AIX and let ER populate it.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Sep 5, 2012 at 8:26 AM, NATE HICKS <nathaniel.hicks@trnswrks.com>wrote:
> I finally got my grid and CDR setup to work (with a little help from you
> guys)
> and then decided I'd try making it easier by using ifxclone...now I can't
> get
> that to work :/...I've created the files for the spaces that the source
> has on
> the target. I've created the sqlhosts and onconfig on the target.
>
> ifxclone --source=batcave --sourceIP=tfx3 --sourcePort=5857
> --target=penguin
> --targetIP=sd36 --targetPort=3700 --useLocal --trusted
>
> That is the command I'm using. I'm going from Linux to AIX.
>
> 08:07:50 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 08:07:50 Started 1 B-tree scanners.
> 08:07:50 B-tree scanner threshold set at 5000.
> 08:07:50 B-tree scanner range scan size set to -1.
> 08:07:50 B-tree scanner ALICE mode set to 6.
> 08:07:50 B-tree scanner index compression level set to med.
> 08:07:50 Dataskip is now OFF for all dbspaces
> 08:07:50 Recovery Mode
> 08:07:50 (-83673) Unexpected message type 50331648.
> 08:07:50 Physical restore failed for dbspace number 1.
> 08:07:50 Snapshot instantiation failed, killing myself.
> 08:07:52 The Master Daemon Died
> 08:07:52 PANIC: Attempting to bring system down
>
> That's what I'm getting in the target server's logs. I'm not sure what that
> (-83683) error is I can't find it anywhere either.
>
> g_waynemanor group - - i=488
> batcave onsoctcp tfx3 5857 g=g_waynemanor
> g_riddler group - - i=490
> enigma onsoctcp sd36 3500 g=g_riddler
>
> That's my sqlhosts too. I don't see any issues in any of this other than
> it's
> not working which has me confused.
>
> Any help would be great.
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340ecd0f969804c8f49a5d
Minor correction. IFXCLONE does not use ontape. It does, however, use=
the
BAR routines within the server. That is why ifxclone is able to take
advantage of parallelism that onbar, (but not ontape) is able to do.
From: "Art Kagel" <art.kagel@gmail.com>
To: ids@iiug.org,
Date: 09/05/2012 08:47 AM
Subject: Re: ifxclone [28227]
Sent by: ids-bounces@iiug.org
Since ifxclone uses ontape to archive and restore the database, and sin=
ce
archives are note portable between platforms, you cannot use ifxclone t=
o
clone a server to a different OS or hardware platform. You will either
have to use export and import or something similar, or you will have to=
create an empty database on AIX and let ER populate it.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinion=
s
and do not reflect on my employer, Advanced DataTools, the IIUG, nor an=
y
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of=
other individuals affiliated with any entity with which I am affiliated=
nor
those of the entities themselves.
On Wed, Sep 5, 2012 at 8:26 AM, NATE HICKS
<nathaniel.hicks@trnswrks.com>wrote:
> I finally got my grid and CDR setup to work (with a little help from =
you
> guys)
> and then decided I'd try making it easier by using ifxclone...now I c=
an't
> get
> that to work :/...I've created the files for the spaces that the sour=
ce
> has on
> the target. I've created the sqlhosts and onconfig on the target.
>
> ifxclone --source=3Dbatcave --sourceIP=3Dtfx3 --sourcePort=3D5857
> --target=3Dpenguin
> --targetIP=3Dsd36 --targetPort=3D3700 --useLocal --trusted
>
> That is the command I'm using. I'm going from Linux to AIX.
>
> 08:07:50 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 08:07:50 Started 1 B-tree scanners.
> 08:07:50 B-tree scanner threshold set at 5000.
> 08:07:50 B-tree scanner range scan size set to -1.
> 08:07:50 B-tree scanner ALICE mode set to 6.
> 08:07:50 B-tree scanner index compression level set to med.
> 08:07:50 Dataskip is now OFF for all dbspaces
> 08:07:50 Recovery Mode
> 08:07:50 (-83673) Unexpected message type 50331648.
> 08:07:50 Physical restore failed for dbspace number 1.
> 08:07:50 Snapshot instantiation failed, killing myself.
> 08:07:52 The Master Daemon Died
> 08:07:52 PANIC: Attempting to bring system down
>
> That's what I'm getting in the target server's logs. I'm not sure wha=
t
that
> (-83683) error is I can't find it anywhere either.
>
> g_waynemanor group - - i=3D488
> batcave onsoctcp tfx3 5857 g=3Dg_waynemanor
> g_riddler group - - i=3D490
> enigma onsoctcp sd36 3500 g=3Dg_riddler
>
> That's my sqlhosts too. I don't see any issues in any of this other t=
han
> it's
> not working which has me confused.
>
> Any help would be great.
>
> Thanks
>
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340ecd0f969804c8f49a5d
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Thanks Madison. However, the point about requiring the target and source
to be the same OS and platform is the important part (except for the single
exception of HPUX/PA-RISC and HPUX/Itanium being interportable). The OP
can't do what he wants to do the way he is attempting to do it.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Sep 5, 2012 at 9:54 AM, Madison Pruet <mpruet@us.ibm.com> wrote:
> Minor correction. IFXCLONE does not use ontape. It does, however, use=
> the
> BAR routines within the server. That is why ifxclone is able to take
> advantage of parallelism that onbar, (but not ontape) is able to do.
>
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org,
> Date: 09/05/2012 08:47 AM
> Subject: Re: ifxclone [28227]
> Sent by: ids-bounces@iiug.org
>
> Since ifxclone uses ontape to archive and restore the database, and sin=
> ce
> archives are note portable between platforms, you cannot use ifxclone t=
> o
> clone a server to a different OS or hardware platform. You will either
> have to use export and import or something similar, or you will have to=
>
> create an empty database on AIX and let ER populate it.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinion=
> s
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor an=
> y
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of=
>
> other individuals affiliated with any entity with which I am affiliated=
> nor
>
> those of the entities themselves.
>
> On Wed, Sep 5, 2012 at 8:26 AM, NATE HICKS
> <nathaniel.hicks@trnswrks.com>wrote:
>
> > I finally got my grid and CDR setup to work (with a little help from =
> you
> > guys)
> > and then decided I'd try making it easier by using ifxclone...now I c=
> an't
>
> > get
> > that to work :/...I've created the files for the spaces that the sour=
> ce
> > has on
> > the target. I've created the sqlhosts and onconfig on the target.
> >
> > ifxclone --source=3Dbatcave --sourceIP=3Dtfx3 --sourcePort=3D5857
> > --target=3Dpenguin
> > --targetIP=3Dsd36 --targetPort=3D3700 --useLocal --trusted
> >
> > That is the command I'm using. I'm going from Linux to AIX.
> >
> > 08:07:50 IBM Informix Dynamic Server Initialized -- Complete Disk
> > Initialized.
> > 08:07:50 Started 1 B-tree scanners.
> > 08:07:50 B-tree scanner threshold set at 5000.
> > 08:07:50 B-tree scanner range scan size set to -1.
> > 08:07:50 B-tree scanner ALICE mode set to 6.
> > 08:07:50 B-tree scanner index compression level set to med.
> > 08:07:50 Dataskip is now OFF for all dbspaces
> > 08:07:50 Recovery Mode
> > 08:07:50 (-83673) Unexpected message type 50331648.
> > 08:07:50 Physical restore failed for dbspace number 1.
> > 08:07:50 Snapshot instantiation failed, killing myself.
> > 08:07:52 The Master Daemon Died
> > 08:07:52 PANIC: Attempting to bring system down
> >
> > That's what I'm getting in the target server's logs. I'm not sure wha=
> t
> that
> > (-83683) error is I can't find it anywhere either.
> >
> > g_waynemanor group - - i=3D488
> > batcave onsoctcp tfx3 5857 g=3Dg_waynemanor
> > g_riddler group - - i=3D490
> > enigma onsoctcp sd36 3500 g=3Dg_riddler
> >
> > That's my sqlhosts too. I don't see any issues in any of this other t=
> han
> > it's
> > not working which has me confused.
> >
> > Any help would be great.
> >
> > Thanks
> >
> >
> >
> >
> ***********************************************************************=
> ********
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae9340ecd0f969804c8f49a5d
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340af3538b2304c8f4c5ce
well now that that's cleared up it's back to the grid for me...horrible attempt at humor...thank you all very much...now to hope I can get this to realize the template like I need it to so I don't have to manually add a couple hundred tables...