Recent content by jbcamel

I don't use SE so I'm only guessing here: I do know that when you unload a table and reload it using the "onunload" and "onload" statements the priviledges are revoked and have to be recreated. Is it possible that to fix the index problem Informix rebuilt the table (or...

You need to add "where tabid > 100" to the above query or you will include the rows in the system catalog tables. Jane

Great. Think I'll file this away in case I ever have similar problems. Jane

Only guessing here: Is this a new database instance? Did you initialize the shared memory before you tried to start it? Are you logged on as root or informix? Is there any error number with the message? Sometimes it's hard to tell when the message is a Unix error or an Informix error...

You have my sympathies. There is usually a file somewhere on your systems that shows you the default settings for the Unix kernel parameters. However these always need to be tuned to fit your system's usage. For now I think your best bet is trying to find the Informix file that tells you the...

Actually this is an issue for your Unix System Admin. SHMSEG is a Unix kernel parameter that will need to be changed. Somewhere in the installation notes for your operating system it should tell you what it should be set to. On our system it's in $INFORMIX/release/en_us/0333/ONLINE.7.2 I'd...

What does the message in your online log say? If you've reached a maximum of some parameter setting it will tell you in the log. I can tell you something from experience: if a user kills their Informix process using a kill -9 it can cause the database to crash. They MUST use the onmode -z...

How about trying: ls -R *html

While I'm not familiar with SCO I'm pretty sure the cpio command is the same: find / -depth -print | cpio -oavcC 32768 > /dev/your/tapedrive or of you don't want to use an explicit path: cd / find . -depth -print | cpio -oavcC 32768 > /dev/your/tapedrive This will back up everything from the...

Not sure what application you are using. In my office we put a line in the user's .profile that sends them directly into the GUI application when they log on. If they exit the application they automatically get logged off. The last few lines of their .profile looks like this: if [...

I'm not familiar with your platform but I can imagine all kinds of reasons why stopping your system clock would cause problems. There are lots of system processes that run in the background (daemons). Many of them go to sleep and wake up at different intervals. They obviously use the system...

Jim, Many of the tables that will show up are temporary tables created by Informix. Don't ask me what they're for. I asked Informix once and got one of those garbled responses that made me think they didn't know either. They tend to come and go depending upon system usage. For the tables...

Wow, that seems like an awful lot of work for a backup. Of course the good part is you can restore a single table, which you couldn't do if you used Informix to do the backup. However I don't know how you would apply your logical logs if you needed to do a restore. As I said I don't have any...

I was told by Informix that once a table has more than 8 extents then paging becomes a performance problem. I monitor extents every few weeks and if I see a table has 9 or more extents I usually rebuild it. I know at first Informix said 8 extents was best. Then they said it didn't matter...

type: onstat -d It lists the location of all the database chunks. If it says something like: /dev/ios/rsdisk00s4 or /dev/vd/rvdisk5 Then it's a raw disk. If it says something like: /home/informix/data/file1 Then it's a regular Unix file. If you don't know where the data is how can you...