473,320 Members | 1,958 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 application error ADM5530E

hi, we are using db2 v8.1 win 64 bit with fp3. i get this error message from
the control panel : Administrative Tools, Event Viewer, application

2003-10-22-17.52.43.850000 Instance:DB2 Node:000
PID:2608(db2syscs.exe) TID:3100 Appid:AC10049E.G79D.00F866005503
data management sqldEndNoLogList Probe:1 Database:NJIPD

ADM5530E The COMMIT processing of table "TBSPACEID=4.TABLEID=2828" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you take a
backup of this table's table space(s).

What does this mean? why i need to do a backup? thanks
Nov 12 '05 #1
1 1935
Xixi,

this is the reason why you need a backup.
From the DB2 doc's:

Because changes to the table are not logged, you should consider the
following when deciding to use the NOT LOGGED INITIALLY table attribute:
a.. All changes to the table will be flushed out to disk at commit
time. This means that the commit may take longer.
b.. If the NOT LOGGED INITIALLY attribute is activated and an activity
occurs that is not logged, the entire unit of work will be rolled back if a
statement fails or a ROLLBACK TO SAVEPOINT is executed (SQL1476N).
c.. You cannot recover these tables when rolling forward. If the
rollforward operation encounters a table that was created or altered with
the NOT LOGGED INITIALLY option, the table is marked as unavailable. After
the database is recovered, any attempt to access the table returns SQL1477N.
Note:
When a table is created, row locks are held on the catalog tables
until a COMMIT is done. To take advantage of the no logging behavior, you
must populate the table in the same unit of work in which it is created.
This has implications for concurrency
Regards,
Joachim
"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0*************************@posting.google.co m...
hi, we are using db2 v8.1 win 64 bit with fp3. i get this error message from the control panel : Administrative Tools, Event Viewer, application

2003-10-22-17.52.43.850000 Instance:DB2 Node:000
PID:2608(db2syscs.exe) TID:3100 Appid:AC10049E.G79D.00F866005503
data management sqldEndNoLogList Probe:1 Database:NJIPD

ADM5530E The COMMIT processing of table "TBSPACEID=4.TABLEID=2828" that used NOT LOGGED INITIALLY has been initiated. It is recommended that you take a backup of this table's table space(s).

What does this mean? why i need to do a backup? thanks

Nov 12 '05 #2

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

Similar topics

6
by: Javier Cortés Cortés | last post by:
i am getting this error when i am trying to access any file(with the ext. aspx) from my remote server. the error is : Server Error in '/' Application....
1
by: Keith | last post by:
All, I have been told this is an ASP.NET issue and not an IIS issue, so I am posting this here. I have a problem with ASP.NET returning an HTTP 500 error when trying to run ASPX pages on...
9
by: Steve Buster | last post by:
All right, I have read every forum, newsgroup etc about this issue and no one seems to know how to fix it. I am getting a "Server Application Unavailable" exception running my .NET 1.1...
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....
4
by: tommy | last post by:
hello everbody, i write a little asp-application with forms-authentication. i copy my aspx-files with web.config to my webspace and i get the error above... i tried to set the...
9
by: Wayne Wengert | last post by:
I built an ASP application and it runs fine on my local IIS. I am trying to move the application to my web service (ISP) out on the internet. I've read several of the help articles but they all...
3
by: Sean | last post by:
HI There, I am having trouble deploying my .aspx pages to a remote server, I have made changes to the config file and it still returns an error. I have also contacted the server administrator to...
21
by: Chris | last post by:
I'm trying to get an existing VS.NET project up on my Win2003 server and I get the following error (on the actual website page): "It is an error to use a section registered as...
2
by: saggydel | last post by:
I have 3 web application these all are independent to each other. 1 web application have .aspx, .aspx.cs, web.config, .dll and some other Supporting files. I want to make a common setup of all 3...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: 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....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.