Last monday, I tried to create a working table, and failed because of 'Log
Full'. There were two applications running at that time - one is autoload
(during the split phase), another one is "insert into a (NLI) ... SELECT ...
FROM ...".
I checked the db2diag.log (level=4) and notification file. It was
interesting that there was no any information about log full.
I had to kill the autoload process.
I haven'g got time to see if I can reproduce it on the testing machine. Have
some one met the same scenario? Are you lucky that you have some idea about
this?
TIA 6 3040
Wonder if your insert stmt could have been a long-running insert where
it hadn't committed yet ... but was in the process of filling up the
log. Perhaps it never got to the point where it put any msgs out because
it never committed?
Larry Edelstein
Fan Ruo Xin wrote: Last monday, I tried to create a working table, and failed because of 'Log Full'. There were two applications running at that time - one is autoload (during the split phase), another one is "insert into a (NLI) ... SELECT ... FROM ...". I checked the db2diag.log (level=4) and notification file. It was interesting that there was no any information about log full. I had to kill the autoload process. I haven'g got time to see if I can reproduce it on the testing machine. Have some one met the same scenario? Are you lucky that you have some idea about this? TIA
Thanks, Larry.
My insert stmt should not cause the problem. Because I activated the Not
Logged Initially.
"Larry" <La***@nospam.n et> wrote in message
news:cD******** ************@ne ws4.srv.hcvlny. cv.net... Wonder if your insert stmt could have been a long-running insert where it hadn't committed yet ... but was in the process of filling up the log. Perhaps it never got to the point where it put any msgs out because it never committed?
Larry Edelstein
Fan Ruo Xin wrote:
Last monday, I tried to create a working table, and failed because of
'Log Full'. There were two applications running at that time - one is
autoload (during the split phase), another one is "insert into a (NLI) ... SELECT
.... FROM ...". I checked the db2diag.log (level=4) and notification file. It was interesting that there was no any information about log full. I had to kill the autoload process. I haven'g got time to see if I can reproduce it on the testing machine.
Have some one met the same scenario? Are you lucky that you have some idea
about this? TIA
I agree with Larry. NOT LOGGED INITIALLY only refers to INSERTs in the same
unit of work as the CREATE that specifies the no logging.
"Fan Ruo Xin" <fa*****@sbcglo bal.net> wrote in message
news:LI******** *******@newssvr 32.news.prodigy .com... Thanks, Larry. My insert stmt should not cause the problem. Because I activated the Not Logged Initially.
"Larry" <La***@nospam.n et> wrote in message news:cD******** ************@ne ws4.srv.hcvlny. cv.net... Wonder if your insert stmt could have been a long-running insert where it hadn't committed yet ... but was in the process of filling up the log. Perhaps it never got to the point where it put any msgs out because it never committed?
Larry Edelstein
Fan Ruo Xin wrote:
Last monday, I tried to create a working table, and failed because of 'Log Full'. There were two applications running at that time - one is autoload (during the split phase), another one is "insert into a (NLI) ...
SELECT ... FROM ...". I checked the db2diag.log (level=4) and notification file. It was interesting that there was no any information about log full. I had to kill the autoload process. I haven'g got time to see if I can reproduce it on the testing
machine. Have some one met the same scenario? Are you lucky that you have some idea about this? TIA
Fan Ruo Xin wrote: My insert stmt should not cause the problem. Because I activated the Not Logged Initially.
Do you have auto-commit turned off?
Did you run an ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY in the same
transaction/unit-of-work in which the INSERT is run? If not, then you
don't have NLI for the insert.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Thanks Mark & Knut.
Yes I am 100% sure that they are in the same transaction. I thought I got
wrong db2 sql error message. If my log full, the information should be
recorded in db2 diaglog.
"Knut Stolze" <st****@de.ibm. com> wrote in message
news:cc******** **@fsuj29.rz.un i-jena.de... Fan Ruo Xin wrote:
My insert stmt should not cause the problem. Because I activated the Not Logged Initially.
Do you have auto-commit turned off? Did you run an ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY in the same transaction/unit-of-work in which the INSERT is run? If not, then you don't have NLI for the insert.
-- Knut Stolze Information Integration IBM Germany / University of Jena
Fan Ruo Xin wrote: Thanks Mark & Knut. Yes I am 100% sure that they are in the same transaction. I thought I got wrong db2 sql error message. If my log full, the information should be recorded in db2 diaglog.
I would think that you should have gotten an error message in the
db2diag.log.
Oh, are you logging onto the same file system on which the db2diag.log is
also written? Maybe you ran into a disk-full situation and DB2 couldn't
even write the db2diag.log any more?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jonathan Trevor |
last post by:
Hi,
Spent nearly 8 hours googling and trying code on this yesterday without much
success. I'd like to write a .NET application (using .NET primitives, older
Win32 calls, or WMI etc) to work out which users can log onto a machine the
application is running on. The platforms I'd like to support are
NT/2000/XP - although 98 would be good too.
It looks like for 2000 and XP OS' the answer is listed in the "Local
Security Policy" control...
|
by: Jay Chan |
last post by:
I keep getting the following error message when I run a serie of SQL
commands:
Server: Msg 9002, Level 17, State 6, Line 15
The log file for database 'tempdb' is full.
Back up the transaction log for the database
to free up some log space.
I have tried "dump transaction tempdb with no_log" right before I run
the SQL command. But that doesn't help.
|
by: Klemens |
last post by:
what do entry's like this in db2diag.log indicate?
-------------------------------------------
2004-01-14-09.07.52.650000 Instance:WWS Node:000
PID:3512(db2syscs.exe) TID:1116 Appid:*LOCAL.WWS.01AFC9110326
data protection sqlpALR_OpenExtent Probe:5 Database:XTRADE
RenameArray: add unarchived log 1227.
2004-01-14-09.07.52.947000 Instance:WWS Node:000
PID:3512(db2syscs.exe) TID:1116 Appid:*LOCAL.WWS.01AFC9110326
|
by: Phil Sherman |
last post by:
What is the relationship between the snapshot elements:
Log pages written
Number write log IOs
Number partial page log IOs
There doesn't appear to be any information in my PDF System monitor
guide or the online information center.
When a COMMIT is issued; a log page containing updates must be written
to disk before control is returned to the application program. This
|
by: Rob |
last post by:
I need to allow a user with the default "Full Data User" permissions
on the front-end database to relink to a table in a backend to which
he has the same permissions.
(I'd like to do read, update, insert, delete, which are the DEFAULTS
for a "Full data user", but just so you know I have also added
"Administrator" for this group in front and backends, just to try and
figure out the problem and it didn't help).
Anyway I cycle through the...
| |
by: william |
last post by:
Hi All,
I'm using Microsoft logging library to log errors in my vb.net
applications(web service). I put
"Microsoft.Practices.EnterpriseLibrary.Logging.dll" into web.config file for
codebase, the code sample just likes:
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity
|
by: jan.marien |
last post by:
we have a table with jobs and a table with job_history information.
Users can define jobs and let them run every X minutes/hours , like a
cronjob.
The jobs table has the following trigger:
CREATE TRIGGER JOBS_AFTER_DELETE
AFTER DELETE ON JOBS
REFERENCING OLD AS o
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
|
by: yousefomar |
last post by:
Hi Pros,
I have a weird problem here. I am logging from my .NET app to a custom log, but unfortunately, the events are redirected to the Application log. I am sure that I am specifying the log name and the source name accurately. I am using some code like the following:
EventLog ev = new EventLog(myLog);
if (EventLog.SourceExists(mySource))
{
if (EventLog.LogNameFromSourceName(mySource) !=...
|
by: TC |
last post by:
I installed an ASP.NET application on my web server, but it doesn't
work. When I browse to a page, I get an error message. The message
doesn't say much, but it does tell me:
An error message detailing the cause of this specific request failure
can be found in the application event log of the web server. Please
review this log entry to discover what caused this error to occur.
How do I review the "application event log"? Is it a file on...
|
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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
|
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: 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
| |
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...
| |