Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Posts
    52

    Unanswered: how i get data from logged database into not loged database?

    I have Two databases, one is logged and the other is not, is there a way to bypass the informix and get the data?

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Do you want to use distributed queries?
    If you want to update a database from another database, they have to be in the same logging mode.
    rws

  3. #3
    Join Date
    Oct 2002
    Posts
    52
    No updates, just read.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Why would you want to bypass informix?
    Is informix too slow?
    If you use IDS, you'll need pagedumps... then analyse the pages...and so forth
    If you use SE, you can use the C-Isam libraries.
    rws

  5. #5
    Join Date
    Oct 2002
    Posts
    52
    Since I added the logs backup, yes, the informix is slow.
    I wanted to eliminate some of the logs backup by moving some of the not important tables to a non logged database.
    The problem is I need to prepare that one report that contains tables from both databases.

  6. #6
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    What version of Informix do you use?
    You can access the databases like:

    select taba.*,tabb.*
    from database1:taba taba, database2:tabb tabb
    where taba......
    rws

  7. #7
    Join Date
    Oct 2002
    Posts
    52
    hi

    I use IDS 7.31 TD1

    I can use the format you sugests but not when one database is logged and the other is not.

Posting Permissions

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