473,594 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2set

Does the utility db2set permanently sent variables in the Registry or
will it set values only for current session.
Thanks,
Yasaswi
Nov 12 '05 #1
2 3681
db2set results in a permanent change/set or any variable.
It updates the actual register and for some variable you may be required
to stop/start the instance.
HTH, Pierre.

Yasaswi Pulavarti wrote:
Does the utility db2set permanently sent variables in the Registry or
will it set values only for current session.
Thanks,
Yasaswi


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #2
Yasaswi Pulavarti wrote:
Does the utility db2set permanently sent variables in the Registry or
will it set values only for current session.
Thanks,
Yasaswi

The db2 registry setting is permanent. The vast majority of its values
requires db2stop/db2start for DB2 to pick up the changes.

Cheers
Serge
Nov 12 '05 #3

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

Similar topics

16
7028
by: Stanley Sinclair | last post by:
Bear with me. I am being very calm; took a Valium. I have waited two weeks to write this, because every time I wrote it before the message was, at best, nasty. I need to use the services of NET SEARCH EXTENDER. This is the first time in over five years of IBM (DB2) developing that I need this. I don't know how to do it. (Db2 v8.1.2, Windows) I see that I must deal with indexes, with cache, with other stuff.
1
9657
by: g | last post by:
Hi, I'm trying to setup the DB2 client to work with LDAP but as soon as I type the 'db2set' command with no parameters I get this error msg: -sh-2.05b$ db2set DBI1306N The instance profile is not defined. Explanation: The instance is not defined in the target machine registry.
9
8688
by: Eugene | last post by:
I am trying to use db2batch from my XP client against a remote database. And here's what I am getting: C:\work\Tuning\DB2\db2batch> db2batch -d oakl0 -a fs/fs -f db2batch.sql Running in Embedded Dynamic mode. --------------------------------------------- --#SET PERF_DETAIL 5
12
2859
by: Nobody | last post by:
DB2 500G database, Wintel, heavily loaded OLTP (5M+ transactions a day; all transactions are extremely small, all selects are controlled (no ad-hoc), 99% of all selects are very small (no table scans, index scans are very limited in size) ). Write performance is generally more important than read performance, read performance of heavy queries (the ones with table scans) is not important at all. Question: how to spread data across...
2
2289
by: DB2 News Group | last post by:
Has anyone run into issues of having db2set run by an instance owner process every 10 seconds. We are performing auditing and it is showing up literally every 10 seconds. I have shut down the governor and all event monitors except for DB2DETAILDEADLOCK and still it persists. In addition, I have verified that there are no connection via the instance owner which are persistent.
3
2468
by: nekiv90 | last post by:
Dear all, On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an account that is neither a member of LOCAL nor DOMAIN Admin group? I have created a non-admin domain account to log in the machine and include it to a group that is assigned to SYSADM_GROUP. It can do all sort of things except that it returns SQL1092N when executing DB2SET command.
4
1312
by: aj | last post by:
I'm on the west coast of Florida south of Tampa, and as I wait for my house to look like something from the Flinstones, and am making sure that all of my disaster recovery ducks are in a row, I though maybe someone could use my linux-based script that backs up DB2 configuration data, which I call "lifeboat". Just put your own info anywhere you see UPPERCASE text in <> brackets. I store everything in /db2/lifeboat/...
2
12389
by: Burkhard Schultheis | last post by:
On Linux and other UNIX like systems, you can configure a db2 instance to start automatically at system start with the command db2iauto -on <instance name>. But how does it work? On Linux (SuSE 9.3) I see no entry in /etc/inittab and no entry within /etc/init.d. All I see is this: There is an undocumented DB2 variable (db2set -lr doesn't know it) DB2AUTOSTART, which will be set to YES or unset via the db2iauto command. Which mechanism...
2
2394
by: 4.spam | last post by:
Hello, all. DB2 v9.5.1 ESE, Windows 2003 Server 64-bit, 4 CPU (8 cores) each, DPF environment. There are 2 DPF instances on the same set of 5 computers. One computer holds coordinator partitions and other 4 hold partitioned tables (2 logical nodes per computer). Application: DataStage v8 running some (say 32) parallel massive single row inserts
0
7946
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
8251
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
8372
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
6654
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...
1
5739
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3859
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3897
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1478
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1210
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.