If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > how i get data from logged database into not loged database?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-02, 08:34
thedafna thedafna is offline
Registered User
 
Join Date: Oct 2002
Posts: 52
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?
Reply With Quote
  #2 (permalink)  
Old 10-27-02, 15:24
Roelwe Roelwe is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 10-28-02, 05:02
thedafna thedafna is offline
Registered User
 
Join Date: Oct 2002
Posts: 52
No updates, just read.
Reply With Quote
  #4 (permalink)  
Old 10-28-02, 06:56
Roelwe Roelwe is offline
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old 10-28-02, 09:15
thedafna thedafna is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 10-28-02, 10:26
Roelwe Roelwe is offline
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old 10-29-02, 14:47
thedafna thedafna is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On