473,836 Members | 2,150 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

transaction log is full

i am using db2 udb v8.1 , so if parameter retain log records is off ,
i am assuing it use circular logging, in the doc it explains the log
records fill the log files and then overwrite the initial log records
in the initial log file, so if so, why we still have transaction log
is full error complaint? but if the log never clean up, so isn't it
will be problem that i have to keep increase the log file size, log
files numbers? our application only insert one record each time and
auto commit is on , but still has log full error.
Nov 12 '05
20 19000
My contention was that you are not committing as you think you are. I
strongly suggest your using DB2 monitoring to figure out what is _really_
happening in the database. Staring at your code isn't going to tell you
thatm, especially with statements like "should commit", when it is apparent
from the error message that is isn't. You can debug your code later.

"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** ***@posting.goo gle.com...
it is circular logging. the insert, delete, update will always be one
row, with auto commit on, it sould be commit right away, i am using
prepare statement to do write, so it is ps.executeUpdat e(); should
commit the write right away, and i did the test, i didn't have
connection.comm it() to commit the change and i have the data in the
table. i still don't understand why i only do change on data one row a
time then commit still have the log full error

Nov 12 '05 #11
i have change the logfilsiz = 1024, 15 logprimary, 20 log seconday, so
total is 120 M log space, but still have error 964 for one single row
insert, about 230 bytes long, i don't understand
Nov 12 '05 #12
i have change the logfilsiz = 1024, 15 logprimary, 20 log seconday, so
total is 120 M log space, but still have error 964 for one single row
insert, about 230 bytes long, i don't understand
Nov 12 '05 #13
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?
Nov 12 '05 #14
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?
Nov 12 '05 #15
xixi wrote:
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?


I would guess that you have other applications running, which caused logs to
be written but have not yet committed (or rolled back) the changes. Thus,
the logs are still active and cannot be reused.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #16
xixi wrote:
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?


I would guess that you have other applications running, which caused logs to
be written but have not yet committed (or rolled back) the changes. Thus,
the logs are still active and cannot be reused.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #17
I've said twice already: you need to monitor what's happening. Staring at
your source code or publishing your configuration here isn't going to help
you. You must use the DB2 monitoring facilities to find out what's
happening.

"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** ***@posting.goo gle.com...
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?

Nov 12 '05 #18
I've said twice already: you need to monitor what's happening. Staring at
your source code or publishing your configuration here isn't going to help
you. You must use the DB2 monitoring facilities to find out what's
happening.

"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** ***@posting.goo gle.com...
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?

Nov 12 '05 #19
Hi xixi,

check with snapshot for all applications which application is using your
active log space. Furthermore, check your first active log file.
Possibly you have num_log_span or max_log set?
What is in your db2diag and notify log?

Stefan
xixi schrieb:
do db get cfg, i have log_retain_stat us=no , user_exit_statu s = off,
logfilsiz = 1024, 15 log primary, 20 file seconday, the disk still
have over 10g space, but i found only 33 files under
\DB2\NODE0000\S QL00002\SQLOGDI R, and i get error 964, why is that?

Nov 12 '05 #20

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

Similar topics

10
13352
by: TZoner | last post by:
1) Can one find the location of the 'Transaction Log' at: <Hard Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf? 2) Is it safe to delete it, as SQL will create a new Transaction Log when it realises none already exist? 3) When trying to do 2) I get error message that file is in use, even though SQL Server is closed. Any suggestions? 4) Can anyone shed light on the error message 'Write on ... <my path
3
7578
by: Thiko | last post by:
Hi I take one nightly full database backup at 02:00 and backup the transaction log to one backup set every 15mins. The commands to do this are as follows and are set up to run as database jobs: -- Database Backup BACKUP DATABASE TO WITH NOINIT ,
3
30121
by: Bucfan1 | last post by:
Hello All, I have been encountering trouble with a SQL Server 2000 Transaction log file, mainly with the constant growth and lack of the autoshrink option. Here are the details: 1.) OS is Windows 2000 server sp3 2.) SQL Server 2000 (Build 2195) sp3 3.) Database Recovery Mode is set to Full 4.) Maintenance Plan for "Transaction Log Backup" is set to remove files older then 1hr.
0
2088
by: xo55ox | last post by:
Hi, I have been trying to set up an automated restore process from prod to backup server. First, I schedule the full database backup nightly, transfer the backup file and restore it to the database on the backup server. Meanwhile, I leave the database ready to accept transaction log from the transaction log backup at noon daily. And I had used different restore options to test out the transaction that was being applied. And I couldn't...
2
3248
by: francois1 | last post by:
I am running a website with a SQL Server database attached. My transaction logs are full and my hosting co. won't allocate more disk space for me. I need to delete my database transaction logs and asume I will need to run an SQL script to do this. Problem: I do not have MS Enterprise Manager of any database utility on my website apart from MS Access. Where can I download a free SQL tool that I can use to delete the transaction logs...
3
1634
by: TG | last post by:
Coming from a (mostly) Oracle shop, I am unclear how SS transaction logs work as far as up to point of failure recovery goes. I have the few MSSQL databases I look after in full recovery mode, and I set up maintenance plans to back these up online on a daily basis. In the research I did it was recommended backing up the transaction logs as well on a frequent basis to ensure recovery to POF or point in time. I had assumed that they work...
4
13227
by: yashgt | last post by:
Hi, We have created a SQL server 2000 database. We observe that the transaction log keeps growing over time. We are now about to run out of space. We have been periodically shrinking the database. Nevertheless the size has increased. I would imagine that a transaction log can be eliminated if we stop the database. Can that be done? Is there a way to completely wipe off the transaction log? Thanks,
0
1666
by: flobroed | last post by:
Hi, I've a question regarding the transaction-log backup on SQL-Server 2000. We have implemented a low cost replication. Every evening we make a full backup and beginning at 7 to 18 we make transaction-log backups which are restore (no recovery) to the "standby-server". The full backups are restored every evening. Today i noticed something strange. Yesterday the last transaction log was made at 19 and afterwards applied to the standby...
3
2703
by: sifrah | last post by:
Hi All, My SQL server transaction log is getting bigger every day and my HDD if running out of space. So i follow the MS KB about how to Shrinking the Transaction Log. After doing so the log is much much smaller as i can see the size of it under enterprise manager. The problem is that the HDD still shows the same size. If i shrink the DB why the and reduce its size why the HDD does not
5
2727
by: Kruton | last post by:
Hello everyone, This is more of an architectural question about SQL Server. Can someone please explain why when I perform a query such as the one below that updates a table using begin and end transaction I am unable to programmatically truncate the transaction log. The only way I have found to truncate the transaction log is to stop and start the SQL Server Service. Does this transaction use the tempdb? Is that why I am unable to...
0
9810
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
9656
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,...
1
10573
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,...
0
10241
tracyyun
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...
0
9358
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...
0
5642
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
5812
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4443
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
3
3102
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.