Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2003
    Location
    Lebanon
    Posts
    2

    Cool Unanswered: Dbexport limitation 2 GB

    Dear All,

    I have a problem when running dbexport in order to do a backup for my database on the server
    Size of database to back up is 80GB.
    When running dbexport, 2GB are only backed up , since the size of the dbexport.out generated is 2GB and not 80 GB.
    Please note that there is no problem of space .
    Please advise if there is a parameter to adjust on the config File in order to bypass the 2GB limitation of Dbexport

    Your prompt reply are highly appreciated
    Last edited by Suzanne; 06-14-03 at 05:49.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    2 GB is an Informix limitation in all databaseservers
    until verson 9.40. In 9.40 the 2GB limit is removed.

    dbexport is not a backup tool. Think about ontape or
    onbar for this purpose.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Jun 2003
    Location
    Lebanon
    Posts
    2

    Cool Ontape

    Originally posted by eherber
    2 GB is an Informix limitation in all databaseservers
    until verson 9.40. In 9.40 the 2GB limit is removed.

    dbexport is not a backup tool. Think about ontape or
    onbar for this purpose.
    Thanks for your reply.
    Can you please advise what are the arguments to issue with the command OnTape if we want to do a copy for the database on the HDD and not on the tape.
    Why I cannot use the dbexport if i want to create a copy of my existing
    database on the disk?

    Thanks in advance

  4. #4
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    If your database is 80 GB big, dbexport is definetly the
    wrong tool.

    Beside the 2 GB-Limitation (which you will also have when using
    ontape to backup in a filesystem), the export and import of the
    data would take a lot of hours and your database is exclusively
    locked during that time.

    I would think about other methods like splitting the mirror
    (from the O/S side) or using the Informix HPL.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  5. #5
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    /dev/rdsk/***
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

  6. #6
    Join Date
    Mar 2002
    Posts
    112

    Re

    You can use onbar or ontape to backup because there are backup tools,
    but dbexport,import is database reorganize tool

  7. #7
    Join Date
    Aug 2003
    Posts
    1
    Originally posted by eherber
    2 GB is an Informix limitation in all databaseservers
    until verson 9.40. In 9.40 the 2GB limit is removed.

    dbexport is not a backup tool. Think about ontape or
    onbar for this purpose.
    Here is how to backup your database to disk.
    1. create an emty file using touch(UNIX), give the file rw access also the folder. ex. touch /backup/infbackup;chmod 777 /backup/infbackup
    2. modify onconfig file and change TAPEDEV /backup/infbackup
    TAPEBLK 1024 # tape block size
    TAPESIZE 4000000 # maximum amount data that the tape can handle
    3. restart informix
    4. ontape -s -L 0

  8. #8
    Join Date
    Aug 2003
    Location
    Mumbai,India
    Posts
    3

    Re: Dbexport limitation 2 GB

    Hi,

    i feel the problem of not genarating more than 2gb dbexport.out due to file system is mounted without large file option. if you mount the corresponding file system where dbexport.out created with large file options it will allow to create dbexport. however it is not advisable to take dbexport for such large database as others suggested.

    Thanks

  9. #9
    Join Date
    Aug 2003
    Location
    Mumbai,India
    Posts
    3

    Re: Dbexport limitation 2 GB

    Hi,

    i feel the problem of not genarating more than 2gb dbexport.out due to file system is mounted without large file option. if you mount the corresponding file system where dbexport.out created with large file options it will allow to create dbexport. however it is not advisable to take dbexport for such large database as others suggested.

    Thanks

Posting Permissions

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