473,732 Members | 2,205 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Modifying DB2 Profiles/Config files

Hello,

I have had a lot of problems installing a DB2 v8.1 Personal Edition on
a RHEL4. Solved most of them by using a JDK-1.4.1 instead of the
default 1.3.1, which comes with DB2. But I still have two problems,
and I think they have something in common:

1) an instance was created during the installation. I am trying to add
a new instance by using: "/opt/IBM/db2/V8.1/instance/db2icrt -d -a
server -s ese -u db2fenc1 db2inst2", and this fails in the set_cfgfile
routine. The debug looks like:

+ set_cfgfile
+ trac set_cfgfile
+ '[' 0 -eq 0 ']'
+ echo '## call function set_cfgfile'
+ tee -a /tmp/db2icrt.log.458 1
## call function set_cfgfile
+ set -x
+ '[' ese = EEE -o ese = eee ']'
+ '[' ese = EE -o ese = ee ']'
+ '[' ese = ESE -o ese = ese ']'
+ CFGFILE=db2sysm p
+ '[' '!' -f /opt/IBM/db2/V8.1/cfg/db2sysmp ']'
+ trax set_cfgfile
+ '[' 0 -eq 0 ']'
+ echo '## exit function set_cfgfile'

Indeed, there isn't such a file "/opt/IBM/db2/V8.1/cfg/db2sysmp". In
that directory, there are two files starting with "db2sys": "db2sysrq"
and "db2syssr". When copying one of these "profile" files to
"db2sysmp", the instance is created. The question is: why wasn't a
profile file for ESE/WSE set up from the very beginning by the
installation process?

2) whenever I create a new instance, or try to use the instance
created during the installation, a lot of tools like "db2ca", "db2cc",
etc. don't work because:

sh: /opt/IBMJava2-131/jre/bin/java: No such file or directory
DB2JAVIT : RC = 127

This "IBMJava2-131" seems to be hardcoded in many utilities. The DB2
installation used a "IBMJava2-141" JVM, there wasn't/isn't any "131"
on the disk.

I can update the "JDK_PATH" pro database manager, and then the
instance tools "db2cc", "db2ca", etc. work. But when creating new
instances, they inherit the old IBMJava2-131 path.

What's even more interesting, this "hardcored path" IBMJava2-131
appears in both "profiles" files mentioned above, "db2sysrq" and
"db2syssr". How can one modify/generate this sort of profile files,
and modify variables like "JDK_PATH" at the "DB2 Installation" level
(as opposed to "DB2 Instance/DBM level")?

Thank you,
Bogdan

Oct 18 '07 #1
1 3770
bo*********@gma il.com wrote:
Hello,

I have had a lot of problems installing a DB2 v8.1 Personal Edition on
a RHEL4. Solved most of them by using a JDK-1.4.1 instead of the
default 1.3.1, which comes with DB2. But I still have two problems,
and I think they have something in common:

1) an instance was created during the installation. I am trying to add
a new instance by using: "/opt/IBM/db2/V8.1/instance/db2icrt -d -a
server -s ese -u db2fenc1 db2inst2", and this fails in the set_cfgfile
routine. The debug looks like:
You have personal edition, you claim. So why are you trying to create a wse
(or even ese) instance? Just leave the "-s" flag out of your command
altogether (with the 'ese' parameter). That should solve that problem.

db2icrt defaults to the "largest" available instance type. If you have ESE
installed, it defaults to ESE. If you have WSE or Express installed, it
defaults to that type (Express uses the WSE instance type). Similarly
Personal Edition uses the "standalone " type (which doesn't have a -s flag
option on Linux, you need to use the default), and clients use the "client"
type.
Indeed, there isn't such a file "/opt/IBM/db2/V8.1/cfg/db2sysmp". In
There shouldn't be ... unless you have ESE installed.
that directory, there are two files starting with "db2sys": "db2sysrq"
and "db2syssr". When copying one of these "profile" files to
"db2sysmp", the instance is created. The question is: why wasn't a
profile file for ESE/WSE set up from the very beginning by the
installation process?
Because you don't have ESE or WSE installed?
2) whenever I create a new instance, or try to use the instance
created during the installation, a lot of tools like "db2ca", "db2cc",
etc. don't work because:

sh: /opt/IBMJava2-131/jre/bin/java: No such file or directory
DB2JAVIT : RC = 127

This "IBMJava2-131" seems to be hardcoded in many utilities. The DB2
installation used a "IBMJava2-141" JVM, there wasn't/isn't any "131"
on the disk.
The default for v8.1 is Java 1.3 because Java 1.4 didn't exist at the time.
You should upgrade to v8.2, that should change the default.
I can update the "JDK_PATH" pro database manager, and then the
instance tools "db2cc", "db2ca", etc. work. But when creating new
instances, they inherit the old IBMJava2-131 path.

What's even more interesting, this "hardcored path" IBMJava2-131
appears in both "profiles" files mentioned above, "db2sysrq" and
"db2syssr". How can one modify/generate this sort of profile files,
and modify variables like "JDK_PATH" at the "DB2 Installation" level
(as opposed to "DB2 Instance/DBM level")?
As far as I'm aware, you can't. These are instance variables, and there is
no global version of these variables to use.
Oct 20 '07 #2

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

Similar topics

2
1656
by: yvan | last post by:
I was wondering if someone here could help me with modifying this PHP template so that it does something very specific for me. My knowledge of PHP is very limited (I'm more of a Cold Fusion developer), which is why I'm inquiring here. Anyways, first I'll show you the PHP code, and then I'll explain what kind of modification I need to have applied: ------------------------------------------------------------------------------ <?
2
1354
by: B. Hummer | last post by:
My corporate environment uses redirected profiles for Application Settings, My Documents and Desktop. I've already gotten through the fact that to run my apps "trusted" that I need to have the build directory on my local PC and not in my redirected My Documents (\\servername\redirect\username\My Documents\). Now I'm running into a new problem. VS2003 / .NET v1.x stores the user's security.config in the Application Settings folder of the...
8
2343
by: vadim | last post by:
Hi, Is there a .Net control available that allows to write into web.config file appsettings section? The idea is to create encrypted user name and password for database connection and then use them from ASP.Net. The program that will create the encrypted entries is a simple winform app. ConfigurationSettings.appsettings allows to read web.config sections but how
0
1684
by: george_Martinho | last post by:
It seems that the ASP.NET Microsoft team didn't think about this!! The profilemanager class has the following methods: - DeleteInactiveProfiles. Enables you to delete all profiles older than a specified date. - DeleteProfile. Enables you to delete a profile associated with a specified username. - DeleteProfiles. Enables you to delete a set of profiles. - FindInactiveProfilesByUserName. Returns a collection of ProfileInfo
1
2782
by: moondaddy | last post by:
I need to have multiple deployment profiles for a .net 2.0 winforms project. This is my requirement: 1) Re-use same project for multiple ClickOnce deployment profiles. 2) Each profile will have it's own custom deployment properties such as Publish Version Number, Start Menu and application Name in start menu. For example, in the past (before ClickOnce deployment) I had to build Setup.exe files and distribute them to various...
0
940
by: Ryan Adler | last post by:
We would like to use the Profiles in ASP.NET 2.0, and I have started a few tests. I have created our own provider to connect to our data source, and this is working fine. I have also gone ahead and created our own Profile class, derived from ProfileBase. I added and tested a few properties, and everything works perfectly. The problem I have is, we would like to use the property groups which are available if the profile is defined in the...
3
6207
by: Jeff | last post by:
Hey asp.net 2.0 I want to populate a GridView with the profile properties off all users registered on a website! For example like this: <profile enabled="true"> <properties>
3
1221
by: =?Utf-8?B?V2ViQnVpbGRlcjQ1MQ==?= | last post by:
I have seen a few articals that show how to start using properties, even a few on custom providors for profiles, but have not yet seen any basic steps on how to initialize the database tables and how to connect to them in the web config. My sqlserver is on a seprate machine using mixed mode security with a specific sql user assigned to allow access. Any and a --
5
2638
by: IUnknown | last post by:
Ok, we are all aware of the situation where modifying the folder structure (adding files, folders, deleting files, etc) will result in ASP.NET triggering a recompilation/restart of the application. In a nutshell, I understand how this can be considered desireable by some, but I am not one of those people. My situation is that we have a root site (hosted @ http://www.mydomain.com) in the root application folder '/'.
0
8946
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8774
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9447
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9307
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9181
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8186
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6031
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3261
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2721
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.