Recent content by richman

hoctro, If you are using Unix the startup and shutdown scripts are found in specific filesystems. On Sun we have the startup in /etc/rc2.d and the shutdown in /etc/rc0.d directories. richman

hoctro, You do not say what type of OS you are operating and whether you are starting an existing instance or creating a new one. The first thing I would look at in Unix, based on your error messages, are the permissions on the chunk /dev/online_root - they should be 660. If the permissions...

ahuva, AWK/NAWK provides you with NF (Number of Fields) that could be used as an alternative to count. Rich

chaber, I don't know for sure. Having said that I see lots of references in the v7.23 manuals that describe exceptions if you are using SE - so I suspect they may be incompatible. Try to contact Informix they should have the answer. Rich

Hi, Problem solved! It was (thankfully) pointed out to me that I could drag and drop the missing columns from the RH window into the LH window under the appropriate object/table. Seems pretty simple (now that I know) - hope this helps someone else.

chaber, I run Informix setnet32 (v7.23) on Win2000. It is not clear to me, from what you wrote, what type of message you get back from ilogin.exe. To test my Informix setup, in setnet32.exe, I run ilogin.exe->File->Run->"YourDBName' (in Stores DB)->OK If you get a "Customer...

Eduarth, Sounds as if your primary root chunk is hosed (?) and it's mirror chunk is online. Again, I don't know where you could check the chunk error messages in NT (in Unix I would look at /var/adm/messages to find out if I/O errors exist with that particular device). How about looking at...

Hi, I have an object/table that has 17 (the correct number of) columns in the the table layout of Designer v5.0 (right hand window). In the objects window (left hand window) it shows only 10 columns for the same object/table. I don't know how/when this happened BUT - I tried refreshing the...

Eduarth, Just saw your post - I work with Unix not PC versions of Informix. In the Unix versions you can add a parameter (-v) which represents verbose mode. It tells you every step of the oninit process as it is performed. Maybe this will work on your PC . . . Rich S

Hi, I am still in the world of version 7.xx so I'll venture a guess or more . . . Primarliy the error message has one hint - "Also check if INFORMIXDIR points to a valid directory where Informix products are installed." If you haven't already done this . . .Check the exported...

Rostik, If this user should no longer have access to the database use the following; revoke connect from 'user'; If you want something else give more detail. Happy New Year - Rich

Shiva, I am not familiar with this error but there is something you can try (in Unix - not sure if it works elsewhere); dbexport -V - If dbexport is installed gives the version number (I suspect if you don't get a version number it is not installed). dbexport -- - list the options for...

Hi, I know this reply is WAY LATE (I just saw your problem today). I would check any database logs you have for any possible DB errors (e.g., $INFORMIXDIR/$INFORMIXSERVER.log and $INFORMIXDIR/$INFORMIXSERVER.console). Rich

alfonsogt, Since you are using Unix try the compress command to reduce the size of the dbexport files. If you execute compress -v 'filename' you can see the amount of space reduction. Then take the compressed file(s) and combine them using the tar command.

sweetsgup, I don't exactly know what you are asking. Given that I will say (again in Unix) that you can have one command file that executes SQL in separate file(s). For example; Note: DBNAME is your database name echo "`date` This executes sql_file_1" dbaccess DBNAME...