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

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

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.

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

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

I am looking for suggestions on the best way to do the following. I have a production database using raw files on BCV disks. The database is 7.31.FD5 IDS. It is approximately 250 GB. Once a week I need to split off a copy of the BCV disk, mount it to a different server and database. From...

Has anyone ran into this problem before? If so, how did you get around it? I'm trying to automate an export and import of a test database. We are on IDS 7.31.FD5 I am issueing the following command. dbexport -c -ss -o /histdb/dump weshst When I look at the create table sql, it is not...

I am trying to initialize a new database (oninit -ivy) on a server. You would think it would be pretty straight forward, but after I issue the command I am seeing the following in the alert log. Some of the things I have validated are that the sqlhosts entry are matching my /etc/hosts...

Yesterday we did a shutdown of our Oracle database and HP-UX server because one of the client programs was hanging. The database and server were both shut down cleanly without errors. When the HP-UX/database were started, the performance drastically nose dived for all queries. Here are a...