Search results for query: *

Does anyone know if there is a hardware processor limit on version 7.31.FD5 of informix, i.e. it will only run on so many processors? Thanks in advance

I have a large table (roughly 30 GB) that I need to rebuild. The table has a number of indices. I have already rebuilt the table and am starting to rebuild the indices. It is taking a very long time for the indices to rebuild. It is only on the 2nd index after almost 13 hours. I am going...

Actually that was my second attempt. The postgres user gives me the same message, so I tried creating a new super user to see if it would work.

I can run the following command with no problem on my database. /usr/bin/vacuumdb --verbose --analyze --all -U super_user But if I try to execute it via a shell script, I receive the following error. The role does exist in the database. does not existnot connect to database postgres: FATAL...

I wanted to hear other's opinions of configurations for multiple database servers on the same physical server. For example, if you have a 4 processor unix server and have two database servers, would you set your NUMCPUVPS equal to 3 in both onconfig files, or would you set it to less since...

We had a problem yesterday where we exceeded the number of files allowed to be open by the kernel parameter NFILES. We got around this by increasing this setting. Doing some additional investigations, I noticed that we had some oninit processes with upward of 300 open files. Can someone...

The permissions were as mentioned above. Are there any environment settings or informix onconfig setttings that need to be different for raw vs cooked chunks?

I am trying to initialize a database using a raw device for the rootdbs. I keep getting an assertion failure during the oninit -i startup. If I remove the raw device and use a cooked file, I have no problems using the same exact configuration files, etc. Does anyone have any suggestions as...

Is there anything that can be tuned in informix that would help with the backup performance of both ontape and onbar? I have run a test with ontape to a null device on two different servers with the same size database (about 300 GB). On one server (with no users), the entire backup takes...

I have a problem with linked tables. I have no problem creating them with a primary key so that the tables are updatable. We have login restrictions to the database that forces me to change my password every 90 days. When I change the password (because I have my password set in the odbc...

Does anyone know of a system object called tran_hist that would be built in the rootdbs? It appeared, filled up the rootdbs then disappeared. Is this something that informix would create or is this something that some end user put there. TIA Craig

Does anyone know of any websites, etc that do any benchmarking of Oracle on Unix vs Oracle on Linux? I'm trying to get some baselines on how oracle behaves on different systems. Has anyone run any databases (around 1 TB of data) on linux? TIA Craig

I have a cube that has 3 levels in the time dimension. They are year, quarter and month. I am trying to find a way that I can show the prior year to date sales when my cube is displaying year (not drilling down to the month). Currently, with the formula I am using, unless I drill down to...

I have auditing turned on in order to capture logins to the database in the sys.aud$ table. I noticed that it is not capturing logins as sys. Does anyone know how I can capture this as well? Thanks

I need to create a something (maybe a trigger) that will capture all ddl type queries run against the database in order to be in SOX compliance. Does anyone have any recommendations for something that will run on a version 7 database? TIA

Is there a way to grep through files in a tar file without extracting the files? The tar file resides on disk if that makes any difference.

For my scenario that will not work. I have a database already on that server. I am making a copy of that database but need to have it look at a different location for the files. I am trying to keep from doing a dbexport and import because it takes to long.

Is there a way to move a chunk from one file system to another? I know in Oracle this is relatively easy. TIA

I do have all 3 listed in DBSPACETEMP

I am running IDS 7.31FD5. I have 3 temp different temp spaces defined. If someone runs a large job and runs 1 temp space out of space, I am getting error messages. I have checked and the other two spaces are relatively untouched. In this version, is it better to define one large temp...