change log path - DB2 Database

Yasaswi Pulavarti

Once a DB2 UDB 8.1 server is setup and three instances created, can
the location of physical log files be changes without any problems?
Please explain.
Thanks,
Yasaswi

Nov 12 '05 #1

Subscribe Reply

9720

Philip Nelson

Yasaswi Pulavarti wrote:

Once a DB2 UDB 8.1 server is setup and three instances created, can
the location of physical log files be changes without any problems?
Please explain.
Thanks,
Yasaswi

Yasaswi,

Yes, you use

db2 "UPDATE DB CFG FOR dbname USING NEWLOGPATH wherever-you-want"

You should also look at other DB CFG parameters related to logging -

MIRRORLOGPATH : for dual logging
OVERFLOWLOGPATH : for holding logs retrieved from archive by user exit
LOGRETAIN : to turn on log retention
USEREXIT : to supply code for archiving your logs

ACtually you would be advised to install Fixpack 7a to bring you to V8.2
level, where there is much better archive logging capabilities built in
(rather than using the USEREXIT).

This is all well documented in the manuals.Â*Â*Â*SuggestÂ*youÂ*checkÂ*theseÂ*out
before asking on the group (your other question is also answered by a look
at the manuals).

Phil

Nov 12 '05 #2

Mark Yudkin

Yes. Just reconfigure them in CC.
"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google.c om...

Once a DB2 UDB 8.1 server is setup and three instances created, can
the location of physical log files be changes without any problems?
Please explain.
Thanks,
Yasaswi

Nov 12 '05 #3

Similar topics

7260

command prompt change dir

by: Peter Vestergaard | last post by:

Hi Probably a simple question but I have not been able to find out how: I want my python script to generate a path based on some simple lookups and then change my path so that when the script...

Python

1795

Deploying Headache: Need to change path to server

by: sling blade | last post by:

I have developled my first major app and i am trying to deploy it in to a host server for publication. However the app tries to use the physical path used during development. Is the path...

ASP.NET

2379

Probing Change from B2 to RTM??

by: Joel D Kraft | last post by:

I'm using controls in my ASP.NET application from a couple of vendors. Between the vendors and thier versioning, I've set up subfolders under my bin directory: bin bin\Infragistics\v5.2...

ASP.NET

2490

How to change the path of the session cookie ASP.NET_SessionId

by: svilst | last post by:

How can I change the path of the cookie 'ASP.NET_SessionId'? The path is "/" and I'd like to set the path to particular virtual directory. The following approach does not work: protected void...

ASP.NET

1663

Help or Suggestions on how to change path

by: jpr | last post by:

Hello, I have almost ultimate my database which works with forms that export their data to word documents. The code behind the forms indicates that path to which it will find the word...

Microsoft Access / VBA

5347

How to change settings directory to run gnuplot on linux [solved?]

by: MacKris | last post by:

Hi, I'm a chemist trying to use the python script GaussSum.py with gnuplot for creating dataplots, and need some help. Whenever I try to produce a plot from the GaussSum GUI I get the error sh:...

Python

3177

2.4->2.5 current directory change?

by: Chris Mellon | last post by:

This appears to be a change in behavior from Python 2.4 to Python 2.5, which I can't find documented anywhere. It may be windows only, or related to Windows behavior. In 2.4, the current...

Python

13169

Change existing element in XML file

by: yhlove | last post by:

Hi I'm trying to change element in xml file as described below: the xml file: ---------------- <MyProg> <Path>test1</Path> </MyProg>

Visual Basic .NET

4970

How do I change the current path for OpenFileDialog ?

by: =?Utf-8?B?UGVy?= | last post by:

I want to change the current path in the OpenFileDialog in runtime. When the user presses OK-button I'm checking the selected path if it's valid for my application. If it's not valid I want to set...

C# / C Sharp

2134

Change environment setting path

by: bart.hernalsteen | last post by:

Hi, I want to read the envorinment setting "path" and then on certain conditions change this setting. ex path : "%SystemRoot%\system32;%SystemRoot%;%SystemRoot% \System32\Wbem;C:\Program...

Visual Basic .NET

7134

What is ONU?

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,...

General

7180

Problem With Comparison Operator <=> in G++

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,...

C / C++

7395

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5485

AI Job Threat for Devs

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,...

Career Advice

4921

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

4609

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3108

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3103

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

667

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP