Hi All

We are running production box with informix 9.21 on solaris, the
present database has installed with DATABLADES
(ETX,LLD adn TXT) but we are not using any blobs, clobs ,rowdatatypes
etc in our database.
Separate webserevr running tomcat.

We got a new database server for a better performance with more memory
and disks ,we have installed
the same version of informix on new box without creating SBSPACES.

We have migrate the database to new server adn put on production.

For testing , i did dbexport from the present server, edited the .sql
file removed all the code related to
datablade procedures, tables, functions, datatypes etc. Did dbimport
on new server, and our application
looks working fine.

We want to run our application on new server without datablades and
sbspaces.
Is the above method is fine to migrate the database, or do i need to
lok at any other areas?
And also could you please suggest how do i put the new database server
for load testing?
So that i can do some performance measure.

Any ideas, suggestions will be much appreciated!!!
Thanks Heaps
Kalpana Pai

I'd probably import the entire database and then use blademangler
to remove the blades rather than doing it my hand.

re: load testing, there are a number of free tools that will load up
apache/tomcat, check out the apache and tomcat websites

KalpanaPai wrote:
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

Any suggestions please !!!!!!!!!!!
Is loadrunner and QALoad testing tolls are free downloadables, if so
where can i find them ?
Thnaks
Kalpana


kalpanapai (AT) hotmail (DOT) com (KalpanaPai) wrote in message news:<8b77f6f5.0309141505.588d66c (AT) posting (DOT) google.com>...

No these tools are not free .... QALoad is from Compuware (this is good for
homegrown applications) ... and LoadRunner is from Mercury Interactive
(this is very good for Internet applications).

HTH

Thanx much,

Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100

As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi



kalpanapai@hotmai
l.com To: informix-list (AT) iiug (DOT) org
(KalpanaPai) cc:
Sent by: Subject: Re: Database Migration to new server - Any suggestions Urgent
owner-informix-li
st (AT) iiug (DOT) org


09/16/2003 02:22
PM
Please respond to
kalpanapai





Any suggestions please !!!!!!!!!!!
Is loadrunner and QALoad testing tolls are free downloadables, if so
where can i find them ?
Thnaks
Kalpana


kalpanapai (AT) hotmail (DOT) com (KalpanaPai) wrote in message
news:<8b77f6f5.0309141505.588d66c (AT) posting (DOT) google.com>...

sending to informix-list

On Unix platforms, people prefer TCL/TK expect for loadtesting or
scenario testing because it is free and not too resource intensive.

Vivek

-----Original Message-----
From: kalpanapai [mailto:kalpanapai (AT) hotmail (DOT) com]
Sent: Tuesday, September 16, 2003 2:23 PM
To: informix-list
Subject: Re: Database Migration to new server - Any suggestions Urgent


Any suggestions please !!!!!!!!!!!
Is loadrunner and QALoad testing tolls are free downloadables, if so
where can i find them ?
Thnaks
Kalpana


kalpanapai (AT) hotmail (DOT) com (KalpanaPai) wrote in message
news:<8b77f6f5.0309141505.588d66c (AT) posting (DOT) google.com>...
sending to informix-list