473,396 Members | 1,599 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,396 software developers and data experts.

How to clear the log files from the circular logged database?

we are getting error as -964 while impoting the data from the export.

the current database is automatic scheduled.
Mar 21 '11 #1
1 2129
vijay2082
112 100+
Hi Neville,
Very little information to give you any exact solution. But to assume what you would like is to have sufficient space in the log files to carry out the current load.

In Db2 there is no need to prune or clear log files as in Sybase,SQL server and other db's. DB2 will do it automatically for you. IN your case I suspect there is no sufficient logs (primary+secondary log files) to complete your transaction. I will suggest you to increase the number of primary ( needs to restart your database) or secondary (is dynamic and no need to restart your database) log files.

you can look the database configuration pramater for these values and then increase it accordingly.

If you can't increase those values then place more frequent commits in the the current load/import operation.

Cheers, Vijay
Mar 31 '11 #2

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

Similar topics

3
by: Steve | last post by:
How do I store files in a database? I have done something similar before in a none microsoft language in a previous lifetime, byt breaking it down into chunks and storing it in a BLOB field. Is...
4
by: Octavio Alvarez | last post by:
Hi! I would like to implement a database which allows me to keep track of changes from users, but I don't know if there is any model already used for this. Let me show you what I mean. Say I...
1
by: grzybek | last post by:
Hi, I have question about techniques of using files in SQL Server in Web Application. Assuming that I send files from my Web App ( client ) to server and located these files on hard disk ( on...
1
by: akashkhasgiwala | last post by:
i am developing i web application in which every user will have an Xml File containing mostly text and date/time stamps this application will use MySql for storing data so pl tell me if i can STORE...
3
by: Lucky_Syringe | last post by:
I wrote this script to display different files from a database and properly display them by their respective MIME types. I have two questions: the first is that it just so happens not to work, and...
4
by: lyealain | last post by:
how to store many files in one database fields?? i manage to store one file into database field.. but fail to store many files..... how should i do that>> one database field for many files name.....
3
by: WebNewbie | last post by:
Hi, please help I've been wrestling with this for a very long time and its not working. I'm trying to display text files from a database when someone selects one or more list items of my listbox. The...
1
by: tarunluckynayak | last post by:
how do we store difeerent type of files in a database( ie; urls, .ppt,.xls,.doc, text, image) using sql or mysql so that they can be easily retrieved or viewed? reply ASAP
1
by: sho | last post by:
Using the following code i can able to upload all type of files into mysql database with longblob datatype, except video and audio files,where shall i change the code to upload the above said files....
1
kwaxy
by: kwaxy | last post by:
Hey Frendz, I can upload files into MS Access database, but unable to upload files to MSSQL database using ASP, can anyone help me plz ????
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
Oralloy
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,...
0
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...
0
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...
0
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,...

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.