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 > problems with old version of ods 7.23 on w2k

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-18-05, 16:05
clony clony is offline
Registered User
 
Join Date: Jan 2005
Posts: 12
problems with old version of ods 7.23 on w2k

Hi everyone, i'm new in this forum.

i'd like to know how can i install informix ods (version 7.23) on w2k. I guest i'm doing everithing correct but the Command Center just don't go into the on-line mode. So i can't set the logical files and other stuffs. Does anybody know some kind of "magic" to do in this case?

The "sagent.log" file give me this message:

"18/01/1905 09:45:15 - Cannot complete the operation because the database server is changing modes or is off-line. Retry the operation at a later time."

thanks.

Clony
Reply With Quote
  #2 (permalink)  
Old 01-18-05, 18:00
saatatya saatatya is offline
Registered User
 
Join Date: Jan 2005
Posts: 30
Check the online.log (MSGPATH) for more information about the failure.

_______________
Sanjit Chakraborty
Reply With Quote
  #3 (permalink)  
Old 01-19-05, 06:05
clony clony is offline
Registered User
 
Join Date: Jan 2005
Posts: 12
Thanks saatatya, but in this log file everithing appears to be normal, see the log below:
"
Wed Jan 19 07:53:02 2005

07:53:02 DR: DRAUTO is 0 (Off)
07:53:04 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
07:53:04 Physical Recovery Started.
07:53:04 Physical Recovery Complete: 0 Pages Restored.
07:53:04 Logical Recovery Started.
07:53:08 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

07:53:09 Dataskip is now OFF for all dbspaces
07:53:09 Init operation complete - Mode Online
07:53:09 On-Line Mode
07:53:21 Checkpoint Completed: duration was 1 seconds.
"

It gives the message that the database server is online but when i try to set the logical files to another size i have to change to administrative mode and it gives the message that "the database server is changing modes or is off line"

any help?

thanks.
Reply With Quote
  #4 (permalink)  
Old 01-19-05, 12:28
saatatya saatatya is offline
Registered User
 
Join Date: Jan 2005
Posts: 30
Not sure what exactly you are doing.

Try these:
1) Login as user ‘informix’
2) Take the informix database server offline
3) Update LOGSIZE accordingly in the ONCONFIG file
4) Bring informix database server online

If you are increasing the logical log size, make sure you have enough space available in the dbspace where logical logs exist.

Cheers!
Reply With Quote
  #5 (permalink)  
Old 01-21-05, 08:24
clony clony is offline
Registered User
 
Join Date: Jan 2005
Posts: 12
informix 7.23 doesn't work

Well, i've tryed everything, but the real problem is that this version of Informix ODS (7.23) seems not work well with W2K, cause everything is correct, but the database server does not change from offline to online, even login in with the user informix and doing all that was suggested here. The database simply can't change to online mode.
The database works, the services starts, i can access the tables, insert data and other stuff like this, the only problem is that i can't manage the logs, start the continous logical logs backup, setup the dbspace and etc.

I guess i'll give up, if anyone has more ideas please help me!

Regards to everybody!
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