export onspaces commands

[Laurie Gustin]

In the back of my memory is a thought that says there is a way to export or
quickly create all the onspaces commands from one server so they can be
used to create spaces on another server, but I can't find it. Can anyone
help me find this?

Thanks!

Laurie

IDS 11.7FC7
linux

[Laurie Gustin]

Thank you Stuart. I knew it was out there somewhere ;)

Hi Laurie,****
** **
Try:****
** **
dbschema -c -ns****
** **
Regards,****
Stuart****
** **
*Sent:* 02 October 2013 15:11
*Subject:* export onspaces commands****
** **
In the back of my memory is a thought that says there is a way to export
or quickly create all the onspaces commands from one server so they can be
used to create spaces on another server, but I can't find it. Can anyone
help me find this?****
** **
Thanks!****
** **
Laurie****
** **
IDS 11.7FC7****
linux****
---
Stuart Brooks
t: 0208 750 2200
Technical Analyst
f: 0208 750 2201
Ardenta Limited
http://www.ardenta.com
****
Ardenta Limited is a company registered in England and Wales. Registered
number: 4181041. Registered office: Saxon House, Downside, Sunbury on
Thames, Middlesex, TW16 6RT.

[Stuart Brooks]

Hi Laurie,

Try:

dbschema -c -ns

Regards,
Stuart

From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org] On Behalf Of Laurie Gustin
Sent: 02 October 2013 15:11
To: informix-***@iiug.org
Subject: export onspaces commands

In the back of my memory is a thought that says there is a way to export or quickly create all the onspaces commands from one server so they can be used to create spaces on another server, but I can't find it. Can anyone help me find this?

Thanks!

Laurie

IDS 11.7FC7
linux



---


Stuart Brooks





t: 0208 750 2200


Technical Analyst



f: 0208 750 2201


Ardenta Limited







http://www.ardenta.com<http://www.ardenta.com/>



***@ardenta.com<mailto:***@ardenta.com>


[cid:***@b44cd775.45a4d45c]

Ardenta Limited is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT.

[Art Kagel]

dbschema -c # outputs an SQL script using SQL API functions to reproduce
the dbspaces and logical and physical logs.

dbschema -c -ns # outputs a shell script to do the same using onspaces and
onparams.

-OR- if you are using myschema:

myschema --infrastructure=sql
myschema --infrastructure=cmd

to get the same result.

Note that there are some bugs in the dbschema implementation prior to
11.70.FC4+ IB and the '-c' option doesn't exist prior to 11.70, so if you
have one of the earlier releases you'll have to use the latest release of
myschema.

Art


Art S. Kagel, Principal Consultant

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.

Post by Laurie Gustin
In the back of my memory is a thought that says there is a way to export
or quickly create all the onspaces commands from one server so they can be
used to create spaces on another server, but I can't find it. Can anyone
help me find this?
Thanks!
Laurie
IDS 11.7FC7
linux
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list