Dbimport & The Grid
User asked how to run dbimport and dbaccessdemo7 within an Informix Grid environment. The challenge is that dbimport implicitly creates the database, complicating grid execution. Madison Pruet suggested using ifx_grid_connect/ifx_grid_execute procedures with a wrapper procedure, and for dbimport specifically: compress the export directory, use ifx_grid_copy to transfer it to grid nodes, then use the wrapper to extract and run dbimport on each…
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
How can I replicate a dbimport execution within a Grid environment?
Same question for dbaccessdemo7 program.
The example will not work since dbimport implicity creates the database.
database sysmaster;
execute procedure ifx_grid_connect(grid1, 1);
create database mydb with log;
create procedure sysdbopen()
execute procedure ifx_grid_connect(grid1, 3);end procedure;
Thanks a lot.
Try the following...
execute procedure ifx_grid_connect('grid1');
create procedure xqt_cmd(cmd lvarchar)system cmd;
end procedure;
execute procedure ifx_grid_execute('grid1', "dbaccessdemo7");
I haven't tried this, but am pretty sure that it would work.
With dbimport, you can tar and compress the export directory and then use
ifx_grid_copy to transfer the compressed export directory to the nodes
within the grid, Then you can use the xqt_cmd() procedure that I described
above to expand and untar the file - and finally use the xqt_cmd procedure
to run dbimport on each of the nodes.
From: "JUAN ROCA" <jluis.roca@hotmail.com>
To: ids@iiug.org,
Date: 03/27/2014 06:14 AM
Subject: Dbimport & The Grid [32827]
Sent by: ids-bounces@iiug.org
How can I replicate a dbimport execution within a Grid environment?
Same question for dbaccessdemo7 program.
The example will not work since dbimport implicity creates the database.
database sysmaster;
execute procedure ifx_grid_connect(‘grid1’, 1);
create database mydb with log;
create procedure sysdbopen()
execute procedure ifx_grid_connect(‘grid1’, 3);end procedure;
Thank’s a lot.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Madison: You say the sweetest things!
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Thu, Mar 27, 2014 at 9:18 AM, Madison Pruet <mpruet@us.ibm.com> wrote:
>
> Try the following...
>
> execute procedure ifx_grid_connect('grid1');
> create procedure xqt_cmd(cmd lvarchar)> system cmd;
> end procedure;
>
> execute procedure ifx_grid_execute('grid1', "dbaccessdemo7");>
>
> I haven't tried this, but am pretty sure that it would work.
>
> With dbimport, you can tar and compress the export directory and then use
> ifx_grid_copy to transfer the compressed export directory to the nodes
> within the grid, Then you can use the xqt_cmd() procedure that I described
> above to expand and untar the file - and finally use the xqt_cmd procedure
> to run dbimport on each of the nodes.
>
>
>
>
> From: "JUAN ROCA" <jluis.roca@hotmail.com>
>
> To: ids@iiug.org,
>
> Date: 03/27/2014 06:14 AM
>
> Subject: Dbimport & The Grid [32827]
>
> Sent by: ids-bounces@iiug.org
>
>
>
>
>
>
> How can I replicate a dbimport execution within a Grid environment?
> Same question for dbaccessdemo7 program.
>
> The example will not work since dbimport implicity creates the database.
>
> database sysmaster;
> execute procedure ifx_grid_connect(‘grid1’, 1);
> create database mydb with log;
> create procedure sysdbopen()
> execute procedure ifx_grid_connect(‘grid1’, 3);> end procedure;
>
> Thank’s a lot.
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e011772014ebe6204f59673ec
Try the following...
execute procedure ifx_grid_connect('grid1');
create procedure xqt_cmd(cmd lvarchar)system cmd;
end procedure;
execute procedure ifx_grid_execute('grid1', "dbaccessdemo7");
I haven't tried this, but am pretty sure that it would work.
With dbimport, you can tar and compress the export directory and then u=
se
ifx_grid_copy to transfer the compressed export directory to the nodes
within the grid, Then you can use the xqt_cmd() procedure that I descri=
bed
above to expand and untar the file - and finally use the xqt_cmd proced=
ure
to run dbimport on each of the nodes.=
You didn't understand???????? ;-)
=
From: "Art Kagel" <art.kagel@gmail.com> =
=
To: ids@iiug.org, =
=
Date: 03/27/2014 08:21 AM =
=
Subject: Re: Dbimport & The Grid [32829] =
=
Sent by: ids-bounces@iiug.org =
=
Madison: You say the sweetest things!
Art
Art S. Kagel, Principal Consultant
ASK Database Management
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 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 Thu, Mar 27, 2014 at 9:18 AM, Madison Pruet <mpruet@us.ibm.com> wrot=
e:
>
>
Try the following...
execute procedure ifx_grid_connect('grid1');
create procedure xqt_cmd(cmd lvarchar)system cmd;
end procedure;
execute procedure ifx_grid_execute('grid1', "dbaccessdemo7");
I haven't tried this, but am pretty sure that it would work.
With dbimport, you can tar and compress the export directory and then use
ifx_grid_copy to transfer the compressed export directory to the nodes
within the grid, Then you can use the xqt_cmd() procedure that I described
above to expand and untar the file - and finally use the xqt_cmd procedure
to run dbimport on each of the nodes.
From: "JUAN ROCA" <jluis.roca@hotmail.com>
To: ids@iiug.org,
Date: 03/27/2014 06:14 AM
Subject: Dbimport & The Grid [32827]
Sent by: ids-bounces@iiug.org
How can I replicate a dbimport execution within a Grid environment?
Same question for dbaccessdemo7 program.
The example will not work since dbimport implicity creates the database.
database sysmaster;
execute procedure ifx_grid_connect(‘grid1’, 1);
create database mydb with log;
create procedure sysdbopen()
execute procedure ifx_grid_connect(‘grid
>
> MeKAmSwgMyk7DQplbmQgcHJvY2VkdXJlOw0KDQpUaGFua
+KAmXMgYSBsb3QuDQoNCg0KKioqKioq
>
>
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKio=
qKioq
>
>
KioqKioqKioqKioqKioqKg0KDQogIEZvcnVtIE5vdGU6IFVzZSAiUmVwbHkiIHRvIHBvc3Q=
gYSBy
> ZXNwb25zZSBpbiB0aGUgZGlzY3Vzc2lvbiBmb3J1bS4NCg0KDQo=3D
>
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e011772014ebe6204f59673ec
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Thank's a lot Madison, I'll try this.
Please note that the grid procedure execution is like this:
execute procedure ifx_grid_procedure('grid1','xqt_cmd("dbaccessdemo7 -log")')
IT CORRECTLY WORKS !!!
Madison: I thought I understood?!?!?
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Thu, Mar 27, 2014 at 9:30 AM, Madison Pruet <mpruet@us.ibm.com> wrote:
> You didn't understand???????? ;-)
>
> =
>
> From: "Art Kagel" <art.kagel@gmail.com> =
>
> =
>
> To: ids@iiug.org, =
>
> =
>
> Date: 03/27/2014 08:21 AM =
>
> =
>
> Subject: Re: Dbimport & The Grid [32829] =
>
> =
>
> Sent by: ids-bounces@iiug.org =
>
> =
>
> Madison: You say the sweetest things!
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> 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 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 Thu, Mar 27, 2014 at 9:18 AM, Madison Pruet <mpruet@us.ibm.com> wrot=
> e:
>
> >
> >
> Try the following...
>
> execute procedure ifx_grid_connect('grid1');
> create procedure xqt_cmd(cmd lvarchar)> system cmd;
> end procedure;
>
> execute procedure ifx_grid_execute('grid1', "dbaccessdemo7");>
>
> I haven't tried this, but am pretty sure that it would work.
>
> With dbimport, you can tar and compress the export directory and then use
> ifx_grid_copy to transfer the compressed export directory to the nodes
> within the grid, Then you can use the xqt_cmd() procedure that I described
> above to expand and untar the file - and finally use the xqt_cmd procedure
> to run dbimport on each of the nodes.
>
>
>
>
> From: "JUAN ROCA" <jluis.roca@hotmail.com>
>
> To: ids@iiug.org,
>
> Date: 03/27/2014 06:14 AM
>
> Subject: Dbimport & The Grid [32827]
>
> Sent by: ids-bounces@iiug.org
>
>
>
>
>
>
> How can I replicate a dbimport execution within a Grid environment?
> Same question for dbaccessdemo7 program.
>
> The example will not work since dbimport implicity creates the database.
>
> database sysmaster;
> execute procedure ifx_grid_connect(‘grid1’, 1);
> create database mydb with log;
> create procedure sysdbopen()
> execute procedure ifx_grid_connect(‘grid>
> >
> > MeKAmSwgMyk7DQplbmQgcHJvY2VkdXJlOw0KDQpUaGFua
> +KAmXMgYSBsb3QuDQoNCg0KKioqKioq
> >
> >
> KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKio=
> qKioq
>
> >
> >
> KioqKioqKioqKioqKioqKg0KDQogIEZvcnVtIE5vdGU6IFVzZSAiUmVwbHkiIHRvIHBvc3Q=
> gYSBy
>
> > ZXNwb25zZSBpbiB0aGUgZGlzY3Vzc2lvbiBmb3J1bS4NCg0KDQo=3D
> >
> >
> >
> >
> ***********************************************************************=
> ********
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e011772014ebe6204f59673ec
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c3ee7850e7ec04f5973aa3
Truly amazing.... ;-)
=
From: "JUAN ROCA" <jluis.roca@hotmail.com> =
=
To: ids@iiug.org, =
=
Date: 03/27/2014 09:12 AM =
=
Subject: Re: Dbimport & The Grid [32833] =
=
Sent by: ids-bounces@iiug.org =
=
Please note that the grid procedure execution is like this:
execute procedure ifx_grid_procedure('grid1','xqt_cmd("dbaccessdemo7
-log")')
IT CORRECTLY WORKS !!!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=