Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Billy Wheeler — — source: Informix-list mailing list archive (1991-1998)
Hello
-> We use dbimport -l <database name> to import the previously exported
-> data. The database is about 1GB size, dbimport -l gives an error "Too
-> long transaction " while loading data to a table which has about
-> 200,000 records.
-> Is there a parameter i need to change? Or I can only use dbimport
-> without -l option? If we don't use -l how do we turn the logging for
-> a database after creating the database?
The quickest way of getting around this is to not import the data using
-l. dbimport the data, do a level 0 archive and go into Logs/Databases
in tbmonitor to change the logging.
If you must dbimport -l, you're going to have to make your logs many and
big and run a continuous backup at the same time.
Regards
Billy
----
Digitec Online - 20 Nodes....* Johannesburg, South Africa +27-11-476-2008
.............................* Best BBS * RsaNET User Choice Awards 1993
first.last@digitec.co.za.....* Best Sysop * RsaNET User Choice Awards 1993
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.