Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. richman

    informix 9.2 server stop on its own

    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
  2. richman

    oninit error : cannot open chunk /dev/online_root

    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...
  3. richman

    problem joining lines in awk

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

    i want to install a SetNet32 on a w

    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
  5. richman

    Designer Object Does Not Match Table

    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.
  6. richman

    i want to install a SetNet32 on a w

    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...
  7. richman

    Installation on NT -Need Help ASAP-

    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...
  8. richman

    Designer Object Does Not Match Table

    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...
  9. richman

    Installation on NT -Need Help ASAP-

    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
  10. richman

    Locale Problem, Please Help!

    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...
  11. richman

    Does anybody knows Informix Security very well ?

    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
  12. richman

    Informix - dbexport

    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...
  13. richman

    Locked Up Database --- Need Help ASAP

    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
  14. richman

    how to make dbexport compressed?

    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.
  15. richman

    scripts and stored procedures

    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...
  16. richman

    commandline dbaccess

    If I understand you correctly the answer is yes. The piece of code I supplied can be wrapped with unix shell commands. The stuff in between the !'s are for the database only - the remainder is for the shell. e.g.; echo "`date` Selecting rows from table ABC . . ." dbaccess 'DBNAME'...
  17. richman

    commandline dbaccess

    In Unix create a command file containing the following; dbaccess 'DBNAME' -<<! 'SQL #1'; 'SQL #2'; ! If the command file you created is called mysql.sh run it as follows; nohup mysql.sh & This will execute SQL #1 followed by SQL #2 (against database DBNAME) and save the output in a file...
  18. richman

    Hi, I'm new to perl and haven't y

    Hi, I'm new to perl and haven't yet figured out how to rewrite an existing file. I have a text book that came with dozens of example scripts all pointing to /usr/bin/perl. The path on our unix machine is /opt/local/bin/perl/bin. I would like to create a script that changes the path, posted in...

Part and Inventory Search

Back
Top