473,320 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 multi-thread application and sql error Log full

Dear all,

I have the following situation using DB2 v9.5 in the multi-threaded way.

1. I created 30 working threads using _beginthread(...) C function.
2. For each working thread I put the following sequence at the beginning:
sqleBeginCtx(...)
sqleAttachToCtx(...)
connect to database
then, I'm using a semaphore to wait for something to do.
3. After each database operation I have a commit class which executes a EXEC SQL COMMIT command;

My problem is that sometimes I receive a sql error SQL0964C.

My application is running non stop with a average of 100.000 sql transactions per day.The number of primary/secondary logs is 4/10(each 250 * 4K).The sql error appears once a month.

Do you have any clue regarding this behaviour?

Thanks.
Apr 18 '13 #1
2 1729
vijay2082
112 100+
Hi, certainly this behaviour is not relared to DB2 being multithreaded. Looks like there is a bug in your application coding which is not commiting appropriately or some transaction is using more logs than expected.

Coupld of suggestions. Try increase your primary logs ( required deactivating the database). This will give you more window to diagnose your issue. Look out for any transaction which is holding active log for a long time.

You can also work with your DBA and look at the utilization of transaction log and increase it appropriately.

Can you paste the error snippet from db2diag.log file for the error along with a database snapshot and db cfg for the database for more information.

Cheers, Vijay
Apr 20 '13 #2
Thank you for your reply.

You're right, increasing primary logs solved this problem.
But what is "commiting appropriately" ?

I have the following operations:
Open cursor for update
fetch cursor
insert/update from current position to another table
delete from current position
commit/rollback

So, each operation is followed by commit operation.It seems there's no reason to need more log files.
One record involved in this operation has 2 Ko max.


Best regards.
Apr 22 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Dionísio Monteiro | last post by:
Hi there, After Installing IIS on a WinXP Pro machine, I have copied one of my web site files to test it on that machine. I have created a virtual directory, and when I try to access the site...
3
by: william | last post by:
Hi, When I tried to run asp page, I got error as follows: "Server Application Erro The server has encountered an error while loading an application during the processing of your request. Please...
0
by: Erwin | last post by:
Hi, I am trying to resolve a problem i am having . I am testing an application that is written in C#.NET. When i do my testrun on a system with an AGP videocard everything runs ok, but when i...
0
by: pillars | last post by:
I have been developing an application in Windows CE.Net using the .Net Compact Framework and C#. Data is saved to a local Sql Server CE database and then transferred wirelessly to a central server....
3
by: Damian | last post by:
Hi everyone I'm having an issue with one of our applications. I'm getting the following error when attempting to log in to the site: Server Error in 'xxxxxxxxxxxxxxxx' Application....
0
by: Alex | last post by:
Hello, I am after one week trying to make working IIS with ASP Net. I am really dissapointed about this situation. I tried every advice, article and so on... . It is not working......
6
by: Rich Wallace | last post by:
Hi all, I have a VB app that runs and manages individual XLS files within a single COM object. Upon processing the final fie, I attempt to close out the EXCEL object and release it using...
0
by: Mark A. Ziesemer | last post by:
I've seen a few other postings that looked similar to this, but most appear to have died without any working solutions, and lacked any helpful level of information to see if they might be related. ...
2
by: Marty Cruise | last post by:
Everything has been running like a dream, until I performed my last one-click deployment. Now on application close, users get: ================== Application Error The instruction at...
0
by: anubhavbajpai | last post by:
In regards to the Server Application Error, One may perform the following steps : 1. Restart the IIS Default website. 2. Go to Start -> Run -> type cmd -> On the command prompt, type iisreset...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.