Hi,
it depends on the size of the table and how fast the table is growing. But it is always the best take care that extents reduce < 50 extens. If the limit is reached you get problem, no row can be inserted any more in that table.
Hi,
if you do use ontape you have to use always 1 Tape for each backup. Informix always starts writing with the beginning of the tape and overwrites the contents.
Hi,
it looks like that some variable are not set correctly. If all Informix variable and system varible are correct you are able to start most of Informix commands(dbexport, dbaccess, onstat ....) from any user.
Syntax is ok.
Hi,
ok, set chmod777 dir where the dbexport is in it. chmod 777 all files too, just to be shure. Try dbimport with user informix by real login not with su.
Hi,
do you have a *.sql file. Can you open it by an editor. Check it. Also, please check the file dbexport.out. Last line have to be: DBexport completed.
Hi,
try like tm88gt write, build up the dir with all files you see on the server. Start the dbexport within that dir you are able to see dbxxx.exp. If that doesn't work we will get in touch.
Hi,
unload the tables mit command
unload to xxx.unl
select * from table
drop table and create table mit first extent and next size
load from xxx.unl
insert into table
Hi,
what system do you use for the Informix server. If it is a Windows Server you habe to build up the sqlhosts in the registry, Unix in dir /informix.
Hi,
try finderr 847 this says:
Error in load file line number.
A problem exists with the data on the indicated line of the load data file. The operation stopped after it inserted lines up to but not including the line that is noted (number-1 rows have been inserted). If this operation is...
Hi,
strange problem, if you do have installed Unixware 7.1.0, updates should work.Important is the order of installation.
2 years ago i did download also most of the same package as you need, for example 7401i. I installed them without problems. I needed to install cause to work proper with...
Hi Shriyan,
I tested this. I used IDS 7.30.UC2 on Unixware 7.1.0.
But the select wasn't logged. Before testing I made ontape -a saved current log. The next log was filled with 0.00 %, after select again 0.00 %. I tried 3 times this select , result 0.00 %. Anything else wouldn't be nice.
Hi,
I had this kind of problem too. Unixware 7.1 tried to print via printbox intel netport 10/100. Suddenly the printboxes didn't print any more. Ping also was succesfull. Ok, i changed the queue name in the box , and this new queue name is now the printer name in Unix. for example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.