473,396 Members | 2,016 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Using a response file to restore a UDB v7.2 server on a new box

I am attempting to run setup on a v7.2 EE CD using a response file as
input. This should result in my existing server configuration being
replicated on a new server. My problem is that I have 18 instances
that need to be created by the setup process, and it appears that the
response file (db2udbee.rsp) must have a linesize limitation that
limits the actual number of instances I can specify with the
SETUP_INSTANCES keyword. I have tried spanning two lines and
duplicating the keyword but neither works. Has anyone run into this?
Is there a possible continuation character that I need to use at the
end of the first line so that the setup program will look for
additional instances? Or am I going to be forced to not use this
keyword and instead use db2cfimp to import the instances after the
install completes? We plan on moving to v8 shortly, but I am still
responsible for a D/R procedure that will work prior to this.
Thanks in advance for any suggestions.
Nov 12 '05 #1
2 1443
Ian
Robert wrote:
I am attempting to run setup on a v7.2 EE CD using a response file as
input. This should result in my existing server configuration being
replicated on a new server. My problem is that I have 18 instances
that need to be created by the setup process, and it appears that the
response file (db2udbee.rsp) must have a linesize limitation that
limits the actual number of instances I can specify with the
SETUP_INSTANCES keyword. I have tried spanning two lines and
duplicating the keyword but neither works. Has anyone run into this?
Is there a possible continuation character that I need to use at the
end of the first line so that the setup program will look for
additional instances? Or am I going to be forced to not use this
keyword and instead use db2cfimp to import the instances after the
install completes? We plan on moving to v8 shortly, but I am still
responsible for a D/R procedure that will work prior to this.
Thanks in advance for any suggestions.


If you're building a server from scratch, don't you have a backup of
the files that define the userIDs and have the instance home
directories? You will need some of this to ensure that you get the
DBM config properly restored for each instance.

Also, if you create new instances as opposed to restoring backups of
existing instances, using a response file could be problematic if you
end up with different UIDs for the instance owners. I think it would
be easier to script the user / instance creation once the software is
installed on the server.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
Robert wrote:
I am attempting to run setup on a v7.2 EE CD using a response file as
input. This should result in my existing server configuration being
replicated on a new server. My problem is that I have 18 instances
that need to be created by the setup process, and it appears that the
response file (db2udbee.rsp) must have a linesize limitation that
limits the actual number of instances I can specify with the
SETUP_INSTANCES keyword. I have tried spanning two lines and
duplicating the keyword but neither works. Has anyone run into this?
Is there a possible continuation character that I need to use at the
end of the first line so that the setup program will look for
additional instances? Or am I going to be forced to not use this
keyword and instead use db2cfimp to import the instances after the
install completes? We plan on moving to v8 shortly, but I am still
responsible for a D/R procedure that will work prior to this.
Thanks in advance for any suggestions.


V7, and V8, have a line length limitation of 1024 for response files.
You may need to contact IBM support to have this fixed.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: James | last post by:
HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...
6
by: Charles Morrall | last post by:
I have no experience with DB2 as such, but I've been tasked with configuring backup of a server running DB2 v8 on Windows Server 2003. I do have some experience with backups in general though. The...
1
by: Mohammed Abdel-Razzak | last post by:
Dear sirs I`ve used SQLDMO to make a backup to my database How can I use it to restore database? thanks Mohammed
2
by: RAJ | last post by:
In our multi-tier application, we have several ASP.NET user controls which will update the same data source provided by middle tier logic. In this particular scenario we have one user control...
2
by: Brian Worth | last post by:
I have just upgraded from VB 4.0 to VB .NET 2002. One program under VB 4.0 was able to shut down or restart the (windows XP) machine using a series of API calls. (Getlasterror, GetCurrentProcess,...
3
by: KR | last post by:
Hi, One of our third-party software vendors is planning to implement BLOB in their database for storing certain documents. We are not too thrilled about it, since it can be a drain on our...
14
by: blueboy | last post by:
Hi, I am planning to automate a nighty restore of a DB on another server can someone point me in the right direction with the SQL script to modify the logical file names to the correct path and...
5
by: sat | last post by:
Hi, I'm working as a DB2 UDB DBA. I have some questions regarding SCP command... Actually every week redirect restore takes place from one of my production servers to test servers.. So, but...
2
by: spattag | last post by:
I am trying to script the process RESTORE FILELISTONLY using an Exec() statement. I cant seem to get it to work with a variable. Here is what I have. Declare @Sql varchar(100) Declare @File...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.