hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TA BLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).
since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks
2  4295  db********@yaho o.com wrote: hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TA BLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).
since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks
This is not an error message, it's a warning. It's warning you that
you won't be able to recover the data in the table without performing
a backup of the tablespace.
What is the NOTIFYLEVEL dbm config param set to (this controls how much
info gets written to the windows event log).
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
but from the event viewer, i do see it is showing as error (the event
viewer tell me it is error with red stop sign). currently the
notifylevel is 3. i will change to 2 to see how it works, is this the
right way to do it?
Ian <ia*****@mobile audio.com> wrote in message news:<41******* ***@corp.newsgr oups.com>... db********@yaho o.com wrote:
hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TA BLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).
since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks
This is not an error message, it's a warning. It's warning you that
you won't be able to recover the data in the table without performing
a backup of the tablespace.
What is the NOTIFYLEVEL dbm config param set to (this controls how much
info gets written to the windows event log).
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: yongsing |
last post by:
I tried to create an index on a column of a table. It failed because
the creation caused the transaction log to be full. What can I do?
Should I export out the data in the table, then recreate the table
with the index, and finally import back the data?
Thanks in advance.
Yong Sing
|
by: xixi |
last post by:
hi, i found that in alter table command , you can do activate not
logged initially to help not log any changes made to the table to log
file, cause i have to delete almost 1 million records and my logfilsiz
is 6120 pages, with 15 log primary and 20 log seconday, but still run
with log file full error. but i also read that any error in the unit
of work in which the not logged initially attribute is activate will
result in the rollback, and...
|
by: DB_2 |
last post by:
Greetings,
I was searching Google for ways to turn off transaction logging for
some queries. I came across this old post from Feb 2003:
> From: fareeda (fareeda@pspl.co.in)
> Subject: Re: Question related to "CREATE TABLE AS SELECT" in DB2
> Newsgroups: comp.databases.ibm-db2
> Date: 2003-02-27 21:11:59 PST
>
|
by: Daniel Chou |
last post by:
Hello,
I have two questions about "not logged initially":
1. Before using "alter table tbname activate not logged initially",
should the table be created with "not logged initially"?
2. After using "alter table tbname activate not logged initially",
how to deactivate it?
|
by: efiryago |
last post by:
I have about 200 tables in a DB2 V8.1.4 LUW application schema. There
is a third party java appllication that accesses this schema. It
started failing and relevant entries in db2diag.log have this:
COM.ibm.db2.jdbc.DB2Exception: SQL1476N
The current transaction was rolled back because of error "-952".
SQLSTATE=40506
which caused by
SQL1476N The current transaction was rolled back because of
| | |
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: pramod |
last post by:
Hi
I know we can truncate a table in DB2 by first creating it with NOT
LOGGED INITIALLY option. and when we need to truncate it, run the
following command
alter table <table name> activate not logged initially with empty table
My question is:
1. Do we have to connect to the database with auto-commit off every
|
by: tojigneshshah |
last post by:
Hi,
In a stored procedure,
If i use "alter table <tablename> activate not logged intially with
empty table", i get SQL104n error.
If i use "execute immediate alter table <tablename> activate not logged
initially with empty table" then i get SQL0107n (saying max.length is
64 characters)
|
by: Troels Arvin |
last post by:
Hello,
Until this date, I believed that DB2 has no TRUNCATE TABLE command. But
then I came across
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0023297.htm
where it says:
After an ALTER TABLE statement containing
REORG-recommended operations, you can execute
only the following statements on a table:
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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: 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...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
