Clarification on SBSPACES

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@forte-intl.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: > 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. 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@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Ronald Cole wrote: > 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. What exactly do you mean/need? Here's my /etc/init.d/informix script, which you can symlink into rc2.d and rc5.d as S99informix and K00informix respectively. It only starts/stops one engine; on other platforms I've made my boot scripts work against multiple engines but so far haven't needed to on Linux. On the other platforms, I've made it so that optional engine names can be given after the start or stop parameter, for the convenience of controlling that engine. Otherwise all engines listed in the config file would be assumed. Anyway, multi-engine will have to wait for some other 60 seconds... <file name="/etc/init.d/informix"> #!/bin/sh # # description: Starts and stops the informix engines # config: /etc/sysconfig/informix # Source function library. if [ -f /etc/init.d/functions ] ; then . /etc/init.d/functions elif [ -f /etc/rc.d/init.d/functions ] ; then . /etc/rc.d/init.d/functions else exit 0 fi # Source networking configuration. . /etc/sysconfig/network if [ -f /etc/sysconfig/informix ]; then . /etc/sysconfig/informix fi RETVAL=0 start() { echo -n $"Starting Informix services: " daemon oninit $ONINIT_OPTIONS RETVAL=$? echo return $RETVAL } stop() { echo -n $"Shutting down Informix services: " onmode -ky RETVAL=$? echo return $RETVAL } restart() { stop start } rhstatus() { status oninit onstat - } case "$1" in start) start ;; stop) stop ;; restart) restart ;; status) rhstatus ;; *) echo $"Usage: $0 {start|stop|restart|status}" exit 1 esac exit $? </file> <file name="/etc/sysconfig/informix"> ONINIT_OPTIONS= set -a LANG=C INFORMIXDIR=/usr/informix PATH=$INFORMIXDIR/bin:$PATH LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql DBCENTURY=C DBDATE=dmy2/ INFORMIXSERVER=maloo ONCONFIG=onconfig.malAC_CONFIG=$INFORMIXDIR/etc/ac_config.mal set +a </file>

"Andrew Hamm" <ahamm@mail.com> writes: > Ronald Cole wrote: >> [I] have been unable to find >> oninit/onmode exit codes documented anywhere in IBM's rather extensive >> online documentation... > > What exactly do you mean/need? Here's my /etc/init.d/informix script > > start() { > echo -n $"Starting Informix services: " > daemon oninit $ONINIT_OPTIONS > RETVAL=$? > echo > return $RETVAL > } > > stop() { > echo -n $"Shutting down Informix services: " > onmode -ky > RETVAL=$? > echo > return $RETVAL > } 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@forte-intl.com> Phone: (760) 499-9142 President, CEO Fax: (760) 499-9152 My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B