I have a new instalation that I am ironing out the wrinkles in. In the
process I have had a few crashes and now my SQLlib\DB2 Dir is full of
..0 and .000 files. What is the best way to clean up this Dir without
damaging anything permanatly?
13  2353  ja******@gmail. com wrote: I have a new instalation that I am ironing out the wrinkles in. In the
process I have had a few crashes and now my SQLlib\DB2 Dir is full of
.0 and .000 files. What is the best way to clean up this Dir without
damaging anything permanatly?
Assuming youhave no intention to call support..
rm -rf (or the equivalent of Windows) does a great job :-)
You may want to back up the db2diag.log, eventlog etc...
Note that cleaning out the log files every so often is good house
keeping. (just rename them every 24 hours or so and archive away - cron
job).
DB2 will recreate the files when it finds them missing.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
I am in a windows enviroinment. Im not sure what rm -rf means...
It means "del * /s"...but don't do that...on windows (unlike unix) the
default diagnostic path is shared with the dbm config file, and some
other important directories etc. I'd suggesting changing your diagnostic
paths to point to a different directory. If you want to remove all the
files from the directory, back them up first in case something goes
wrong...I think the only thing you'll need is the config file(db2sys*)
but I'm not 100% sure what's created by default in that path. ja******@gmail. com wrote: I am in a windows enviroinment. Im not sure what rm -rf means...
Ok so back up the Dir and delete the 0 and 000 files
do you remember where the diagnostic path is defined, in the db cfg or
dbm cfg?
Sean McKeough wrote: It means "del * /s"...but don't do that...on windows (unlike unix) the
default diagnostic path is shared with the dbm config file, and some
other important directories etc.
Now that is just nasty...
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
But you told me to do it....
In the dbm cfg, look for DIAGPATH
HTH, Pierre
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ja******@gmail .com> a écrit dans le message de news: 11************* *********@g14g2 00...legr oups.com... Ok so back up the Dir and delete the 0 and 000 files
do you remember where the diagnostic path is defined, in the db cfg or
dbm cfg? ja******@gmail. com wrote: But you told me to do it....
Who believes what's on the internet....?
Sorry. Wasn't aware of this Windows special.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
But you work for the IBM TORONTO LAB!!! Its your job to know.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: StinkFinger |
last post by:
Hello all,
After enabling sessions for my website I have approx. 785 files in my
sessiondata folder. Now, I know what these are, however, I don't know
when/how is the best way to clean them (besides running a weekly delete
batch file).
Once the users leaves and closes the browser, the session is essential dead,
right ? So, why would I need to keep these files around ? I looked in
PHP.INI but I could not find any "cleaning" settings to...
|
by: Jaans |
last post by:
I have a problem that relates to running "cleanup" code when an application
is forcibly ended using the "End Process" of "Task Manager" (Please note that
this is very different from "End Task" since end task sends a message to the
application, requesting it to close)
My real problem is that our application makes entries into a database when
the application starts, and then corresponding entries when the application
closes ("cleanup")....
|
by: fabio de francesco |
last post by:
Hi
what do you think of the following? Why are we permitted to do that?
And why the C++ Library doesn't stop someone willing to perfom that
assignement (*a = 20)?
#include <iostream>
using std::cout;
|
by: DKM |
last post by:
Here are the source code files to a Java applet that utilizes
LiveConnect to communicate with Javascript, and the HTML file.
The thing works both in IE 6.0 and FireFox 1.4. but with some problems.
IE crashes when one refreshes the page or leave the page. This happens
only after calling the Java method more than once. It does not crash if
the Java method is called just once and then the page is refreshed.
FireFox does not crash at all...
|
by: Pierre Saint-Jacques |
last post by:
DB2 V8.2 has a new envir. var.
DB2_USE_ALTERNATE_PAGE_CLEANING=YES
The docs. mention that this will make DB2 ignore chngpgs_thresh and use
softmax to even the rate of writing out of the bp's.
What agent process then takes over.
On a workload of 10000 trans./min., I get over 9000 bp's writes out of
my snapshot. However, LSAN Gap Cleaners, Thereshold Cleansers and
Victim Page Cleaners are all = 0
| | |
by: Brent |
last post by:
I have just installed Office 2003 and Visual Studio Tools for Office 2003,
including the Developer Extensions for Access. I kept my Access 2000/MOD
installation intact (I hope), installed Access 2003 and upgraded all the
other Office apps. I have all updates/service packs installed including Jet
SP8. OS is XP Pro.
I have a repeatable situation where opening a report with code will cause
any mdb to crash every time. The following is one...
|
by: Mikey |
last post by:
Do NativeWindows get destroyed when the app shuts down?
While my app is running I can Spy++ and see my NativeWindow handle.
After app shutdown it's no longer there.
But this is confusing because if I Spy++ on the messages, and do a
DestroyHandle, I see a WM_DESTROY, but do not see this message when
the app shuts down. I presume the window has indeed been destroyed,
because Spy++ doesn't pick it up.
|
by: Thomas Neubauer |
last post by:
Hello,
i am learning c# and have created now a simple project that just creates 6
random numbers.
My form includes a button and 6 labels for the random numbers. The program
seems to work correct,
however when after a few button clicks the program crashes.
Does anyone know where the reason could be?
|
by: Now You Know |
last post by:
Carpet Cleaners Los Angeles Home Carpet Rug Upholstery Cleaning
Phone 1 310 925 1720 OR 1-818-386-1022
Local Call California Wide
We offer carpet cleaning services such as; Steam Cleaning, Dry
Cleaning, Fabric Lounge Suite Cleaning, Leather Lounge Suite Cleaning,
Tile & Grout Cleaning, Mattress Cleaning, Wet Carpet / Water Damage
Restoration for: offices, homes, restaurants, clubs and hotels
http://carpetcleanersorangecounty.blogspot.com/...
|
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...
|
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,...
| | |
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...
|
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
| |
