Database Log-file - DB2 Database

Jan Suchanek

Hello,

my db2 V8.1 stopped just without any reason. Now I am wondering where I
con find a log file which explains this behaviour... I cant find
anything in the instance directory.
The database is running on a Linux system

Any help would be appreciated.

Greetings, Jan

Nov 12 '05 #1

Subscribe Reply

4450

mairhtin o'feannag

The db2diag.log should be under the instance owner's directory, in
sqllib/db2dump directory. If it's not that way on your system, you may
have to search the whole instance owner's directory structure. But
db2diag.log will be in there somewhere! It tells you what DB2 thinks
happened when it crapped out.

Good Luck!

Mairhtin

Jan Suchanek <ja**********@gmx.de> wrote in news:41********@news.uni-
ulm.de:

Hello,

my db2 V8.1 stopped just without any reason. Now I am wondering where I
con find a log file which explains this behaviour... I cant find
anything in the instance directory.
The database is running on a Linux system

Any help would be appreciated.

Greetings, Jan

Nov 12 '05 #2

Knut Stolze

mairhtin o'feannag wrote:

The db2diag.log should be under the instance owner's directory, in
sqllib/db2dump directory. If it's not that way on your system, you may
have to search the whole instance owner's directory structure. But
db2diag.log will be in there somewhere! It tells you what DB2 thinks
happened when it crapped out.

The db2diag.log gets written to whatever path the DBM CFG parameter DIAGPATH
says. If this parameter is not set, then sqllib/db2dump is used as
Mairhtin explained.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #3

Similar topics

Secure Database Systems

by: Sarah Tanembaum | last post by:

I was wondering if it is possible to create a secure database system using RDBMS(MySQL, Oracle, SQL*Server, PostgreSQL etc) and web scripting/programming language(Perl, PHP, Ruby, Java, ASP, etc)...

PHP

Restore database to a certain point of time.

by: Rajesh Garg | last post by:

I will make it simpler to look... I have DB1 - as backup for day 1 LOg1 as backup of logs T1 T2 T3 T4 T5 ...some transaction on day 2 Now i backup again DB2 Log2

Microsoft SQL Server

Database restore question

by: Andre | last post by:

Hi, I have a database (or better: used to have) and backup consisting of - the initial (complete) database - all log files since then (or so I thought) After making a data entry error I wrote...

Microsoft SQL Server

IIS Log / Custom Error database discrepancies

by: Mark Metzner | last post by:

We currently have custom error logging setup on all of our websites. We have IIS setup to redirect to our custom 500-100.asp page which logs the error to a database and then redirects to a...

ASP / Active Server Pages

pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'

by: Frank van Vugt | last post by:

Hi, I noticed that when using the single commandline: drop database <name>; create database <name>; this sometimes fails due to a pg_autovacuum process running on the background. When...

PostgreSQL Database

ERROR: REINDEX DATABASE: Can be executed only on the currently open database.

by: Clodoaldo Pinto Neto | last post by:

I suspect there is something wrong because it takes 73s to delete a single line from a table whith 140 lines. So I tried to reindex the database: bash-2.05b$ postgres -P -O -D /var/lib/pgsql/data...

PostgreSQL Database

Problems restarting after database crashed (signal 11).

by: Christopher Cashell | last post by:

Yesterday, while attempting to access a database, I received errors saying that the database was innaccessible. After investigating a little, I found the following in the PostgreSQL log files: ...

PostgreSQL Database

BACKUP LOG cannot be performed because there is no current database backup

by: Najm | last post by:

Hi All, I am facing this issue very frist time. I add a logical device as following: USE master GO EXEC sp_addumpdevice 'disk', 'AdvWorksData',

Microsoft SQL Server

Added users to a logged shipped database

by: Justin | last post by:

I have 2 sql server 2000 database that participate in log shipping. Server A is the source database, which log ships to a database on Server B. The database on Server B is in a warm stand by/read...

Microsoft SQL Server

database hangs in MyPHPAdmin/can't login to web site

by: JRough | last post by:

I cannot log into our web site. I have a test web site and a real site. On Friday I could log in and today Monday I cannot log in. I have 2 databases In PHPMyAdmin, the real database and and a...

PHP

How to build RAID in BIOS?

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

Computer Hardware

Changing the language in Windows 10

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

Windows Server

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

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

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

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

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

transfer the data from one system to another through ip address

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

C# / C Sharp