baanspider
11th January 2008, 09:38
Hi experts,

I am on baan4 on informix 9.4.

I did an exercise to copy application and data to DR server.

I restored everything from tape.
Informix is up and running
I have changed licence6.1 file to replace with the DR server name
No problem running rc.start.
What must I do now? I checked log.bshell but it does not give any relevant info.

Please see attached file

Thanks n regards,

sukesh75
12th January 2008, 07:35
Hi,
I see that you have updated your Licence6.1 file..What about tabledef6.1? Did you do the necessary adjustment in this file as well??

sk

baanspider
14th January 2008, 03:47
Hi

I retrieved the file tabledef6.1 from the prod. server into DR server.
There is nothing to change in this file.
Do you have any other ideas? Appreciate your input.

Thanks n regards,

baanspider
14th January 2008, 05:34
Hi

Must i change the value in /etc/services?

There is a line
baan_tcp 5002/tcp #Baan to Informix connection

Maybe this is wrong. What shall i used instead of 5002?
How do i find out?

thanks n regards

sukesh75
14th January 2008, 08:11
The tabledef6.1 should point to the server your database is on. Since you have copied your data to the DR server, the tabledef6.1 should have all the tables pointing to this server instead of your production server...

sk

baanspider
16th January 2008, 03:08
Hi sukesh

My file is as below
tibom010:060:informix(ONCONFIG=onconfig.baan,INFORMIXDIR=/usr/informix/I940.FC7,INFORMIXSERVER=baan_hm,INF_LEVEL1=0):Y
tiitm001:060:informix(ONCONFIG=onconfig.baan,INFORMIXDIR=/usr/informix/I940.FC7,INFORMIXSERVER=baan_hm,INF_LEVEL1=0):Y
tipcs021:060:informix(ONCONFIG=onconfig.baan,INFORMIXDIR=/usr/informix/I940.FC7,INFORMIXSERVER=baan_hm,INF_LEVEL1=0):Y
tipcs022:060:informix(ONCONFIG=onconfig.baan,INFORMIXDIR=/usr/informix/I940.FC7,INFORMIXSERVER=baan_hm,INF_LEVEL1=0):Y
cpcom000:*:informix(ONCONFIG=onconfig.baan,INFORMIXDIR=/usr/informix/I940.FC7,INFORMIXSERVER=baan_hm,INF_LEVEL1=0):Y

I am still using informixserver = baan_hm because i copied the whole informix over from Prod to DR. So the informixserver name does not change. Only my hostname changes from Mars to Pluto.

I already changed the hostname in license6.1

Please advise

thanks n regards

baanspider
16th January 2008, 03:09
Hi sukesh

Is there somewhere that we can check the informixserver is equal to baan_hm

regards,

baanspider
16th January 2008, 03:19
Hi sukesh

how to find out whether baan_hm is set up correctly in my DR server now?

thanks n regards

dave_23
16th January 2008, 07:00
from a unix command line do

DBSLOG=01570 qptool6.1 -q"select * from ttiex300" -c0

that will create a file called dbs.log in your current directory.

gzip and post that file.

Dave

sukesh75
16th January 2008, 08:46
This might be a late question, but to understand the scenario properly, whats DR stand for?
Are you using a 3-tier setup? I could see three names in your post. Mars, Pluto and baan_hm. Mars could be your production server while Pluto your DR server so whats baan_hm (database server?) ? Looks more or less like a 3-tier setup to me...

am i right?

sk

baanspider
18th January 2008, 08:38
Hi

Our application and database are on one server

I also got this error when i type the DBS command

resolve symbols: loader error: dlopen : /baan/bse/bin/inf_srv6.1 : symbol "_array_new2" unresolved.

thanks n regards,

dave_23
18th January 2008, 09:09
there's your problem you're missing some components on your OS.

try:
ldd inf_srv6.1

should tell you what lib you're missing.

Dave

baanspider
21st January 2008, 03:02
Hi Dave

I checked. All the lib files listed in ldd inf_srv6.1 are there.
the inf_srv6.1 is also in baan/bse/bin directory

what else is wrong?

thanks n regards,

dave_23
21st January 2008, 21:13
well, if the files are actually there (and not symlinks that go to 64 bit versions, or to nowhere) then maybe you have a problem with your some of your environment variables like LD_LIBRARY_PATH or SHLIB_PATH.
you could compare the two between your boxes.

Also you may want to look for the porting set release notes (or even re-download the porting set from the baan ftp site and install it on the DR Box)

Also, your Unix / Informix versions are the same across both boxes: correct?

Dave

baanspider
22nd January 2008, 02:21
Thank you Dave for your answer.

Appreciate if you can give me more suggestions.

Yes both the server is on same unix and informix. I have also upgraded the portingset to latest.
Where do you find whether the paths are the same? I typed env. but it does not show SHLIB_PATH or LIBRARY_PATH

thanks n regards