Hi

We have informix Database 9.2 running on Solaris, ad our database is
registered with datablades, which we are not using at all.

As i am going to set up a new server , i have exported the database
and changed the .sql file removed all the scrap except what needs for
our Database did dbimport and application works fine with this.

My question is if we are not going to use datablades , do we need to
have SBSPACE in our database? When i try to register ETX it will point
an error abt SBSPACE otherwise if i dont install no problem.

At the moment the prod and test boxes have datablades, but to put the
database on new server with dbimport it needs SBSPACE.

Is it Ok to go with the above process i.e.,
1.changing the .sql file and import the database OR
2. Unregister the Datablades and do dbexport and import the db on new
server

I observed even after unregistering, some procedures, datatypes will
be still there. Any suggestions would be appreciated.

Regards
Kalpan Pai

Is there a well written/highly regarded, all knowing and all powerful
IDS 9.4 uber-startup script for Red Hat that someone might share?
I've googled and found half-attempts and looked at IIUG, but couldn't
find what I'm looking for.

Barring that, I'm writing one myself, but have been unable to find
oninit/onmode exit codes documented anywhere in IBM's rather extensive
online documentation... but it is slow to dig through pdf's in a
browser and maybe I missed it.

--
Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412
Ronald Cole <ronald (AT) forte-intl (DOT) com> Phone: (760) 499-9142
President, CEO Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B

KalpanaPai wrote:

You might need an sbspace if you are using ER (or planning to use it);
maybe even for HDR.

You don't have to register the blades you aren't using. If you are
really sure you have no current use for an sbspace, you can leave it
out on the new system -- you can always add one later if need be.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

"Andrew Hamm" <ahamm (AT) mail (DOT) com> writes:
Yeah, the values in RETVAL that your are returning... where are the
oninit/onmode return values documented?

--
Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412
Ronald Cole <ronald (AT) forte-intl (DOT) com> Phone: (760) 499-9142
President, CEO Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B

Ronald Cole wrote:
(which also is interesting!)
here is what Rick wrote in 2001
http://groups.google.com/groups?q=sy...ion.com&rnum=1

! the above link has wrapped, and I still do not know, how to post
links out of google in a proper way

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

Ronald Cole wrote:
ummm, it's somewhere in the admin guide. Perhaps in the section that
documents the command line utilities?

"Andrew Hamm" <ahamm (AT) mail (DOT) com> writes:
First place I looked. Command line arguments are documented in gory
detail, command return values are completely glossed over.

--
Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412
Ronald Cole <ronald (AT) forte-intl (DOT) com> Phone: (760) 499-9142
President, CEO Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B