dbimport unlogged

dbimport unlogged

Post by Soulmonge » Fri, 27 Apr 2001 07:47:14



   How can I make an unlogged dbimport on Informix ODS 7.3??? I'm trying to
load a very big file and it fails....

  TIA

 
 
 

dbimport unlogged

Post by Murray Woo » Fri, 27 Apr 2001 11:10:46


The default is not to log.  Do not include the logging parameters.

MW

 -----Original Message-----

On Behalf Of Soulmonger
Sent:   Thursday, 26 April 2001 10:47 a.m.

Subject:        dbimport unlogged

   How can I make an unlogged dbimport on Informix ODS 7.3??? I'm trying to
load a very big file and it fails....

  TIA


 
 
 

1. Using Delete and wanting unlogged

I have SQL server 6.5 running on NT server 4.0 -

I have a 3 million+ row table, and I am wanting to archive off some records.

I created a new database and used a non-logged "select into" to get the
records off that I want to archive.

I then backed this database/table off to tape,  and deleted it.

Now I need to get the records off the original table.

During the course of running a "delete .. where" statement,  my syslogs
filled up,  even though I checked truncate log on checkpoint.

Has anyone out there done anything similar, and discovered a better way?  I
need help !!!!

Thanks in advance.
Steve Rogers
 (remove the "saveme" to reply)

2. Accessing database via ODBC vs Net8 (sqlnet)

3. Using Delete and wanting unlogged PART II

4. Apr file passwords

5. Unlogged transactions

6. multiple users -- intranet

7. What are unlogged transactions

8. US-Chic-IL-Oracle Implementation Specialists-Functional

9. Unlogged transactions

10. SQL 6.5: Determining whether unlogged changes have taken place

11. logical log entries for unlogged db

12. unlogged database

13. dbimport fails with error -371: but it's not true