Search results for query: *

Hi, Forget now onarchive. This tool is no more supported. Concerning backup and restore, you can choose between ontape and onbar. Both tools are using the dbspace as the smaller unit to backup and restore. You cannot backup and restore only one database or one table. If you want to do this...

Hi, based on your informations we cannot diagnose anything. Your sessions are all in waiting for condition (flag Y in your onstat -u) but it's normal if no sql is running in these sessions. If you start in a windows dbaccess and select a database and do nothing. Your session will have the same...

Sorry I didn't notice that you were in release 5. INFORMIXSERVER is only for IDS 7.x or 9.x In release 5.X, sqlhosts should be like this : dbservername protocol hostname servicename with: dbservername similar to the one in $TBCONFIG protocol: olsoctcp or oltlitcp hostname: should be listed...

You CANNOT have two values for your DBSERVERNAME parameter. You have to set one value in DBSERVERNAME and the others will be listed in the DBSERVERALIASES, with a comma as separator. Then you set the variable INFORMIXSERVER to the value of DBSERVERNAME or to one of the values of...

Hi, to provide a fast answer, please provide : - sqlhosts file - DBSERVERNAME and DBSERVERALIASES in your ONCONFIG file - /etc/hosts - uname -, or hostname result jean

Hi, Bufwaits can be due to the LRU and Read-ahead settings and to the number of BUFFERS : so check the LRU with onstat -R and onstat -F and try to increase a little more the BUFFERS parameter. Concerning RA-AHEAD, you didn't specify any value in the $ONCONFIG but your ration is fine...

We cannot say directly that this is a bug. Your problem is that you have a down chunk, the number 26. Check this with onstat -d and verify what kind of dbspace is using it. Check with a command dd if you have still access to the device.

The logical logs are coming full with temporary table. In fact, your request is building a temp table (this is logged) and then is droping it (this is logged also). You can check what happen if you run a tblog during the execution of your transaction. You will need to rewrite your request.

Did you use setnet32 to setup the client configuration ?

Look in the registry to find informations on your instance: HKEY_LOCAL_MACHINE\SOFTWARE\Informix There you will find keys for the setup and the environment. Jean Briere

Hi, You don't need to reinstall as there is no software control of the number of users. Informix tried to setup a licence manager in old days (online 5.0) but stopped it due to a lot of bugs. You have to perform a tradeup (32 -> 48 users) and then keep the new licence number as a certificate...

Are you sure that the file /home/informix/config/rootdbs exist and has the good permissions : Owner and group = informix permissions : 644

Other solution is to use onbar with ISM instead of ontape. Be careful with the previous message because in case of logical restore, you will need to perform a lot of tasks : unzip, copy, unzip, copy ... for the GOOD files.