Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011

    Red face Unanswered: Error 458: Long transaction aborted when import Informix DB

    Dear all,
    I have problem when execute command to import Informix db.

    - Step 1: Create Instance Server with name: smt (all steps successfull)
    - Step 2: Create folder to import db:
    Example : create "C:\smt"
    - Step 3: Set location by command promt
    C:\Program Files\IBM\Informix\11.70\smt.cmd
    - Step 4: Set command C:\smt> dbimport databaseName -d smt -l bufferd.

    When excuting - > appear errror: Long Transaction Abort.

    Could all of you help me to solve it.?
    Thanks so much.

  2. #2
    Join Date
    Feb 2011
    Tell "dbimport" to create the database without logging by omitting the "-l" option:

    dbimport databaseName -d dbspaceName

    On completion, run a backup (using TAPEDEV /dev/null if you just want to fake it) to add logging as follows (or equivalent command if you use "onbar"):

    ontape -s -L 0 -B databaseName

    Doug Lawry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts