db2 application error ADM5530E

xixi

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(db2sys cs.exe) TID:3100 Appid:AC10049E. G79D.00F8660055 03
data management sqldEndNoLogLis t Probe:1 Database:NJIPD

ADM5530E The COMMIT processing of table "TBSPACEID=4.TA BLEID=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

Subscribe Reply

1960

Joachim Mueller

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.c om> schrieb im Newsbeitrag
news:c0******** *************** **@posting.goog le.com...

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(db2sys cs.exe) TID:3100 Appid:AC10049E. G79D.00F8660055 03
data management sqldEndNoLogLis t Probe:1 Database:NJIPD

ADM5530E The COMMIT processing of table "TBSPACEID=4.TA BLEID=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

Similar topics

635

Server Error in '/' Application

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. ---------------------------------------------------------------------------- ---- Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application

ASP.NET

3159

Server Application Unavailable HTTP 500 error

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 Windows Server 2003 Enterprise Edition Only. This works on Windows 2000, Windows 2003 Web Edition and

ASP.NET

647

Server Application Unavailable

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 application. I use W2K SP4 and have applied the hot Fix KB824146 and KB824105, both IE fixes. I don't have VS installed because this is a Quality Environment. I do have .NET SDK and .NET 1.1 Runtime installed. I can't change my APSNET user to run as...

ASP.NET

4915

'current custom error settings for application prevent details of application error from being viewed. '

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. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the server. The current

ASP.NET

5392

Server Error in '/' Application. -> web.config

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 custom-errors-tag ="off" but nothing happens.... what is my failure????

ASP.NET

1894

Deploy an ASP Application

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 seem to think I am deploying to localhosts. I created a new directory on my web page and copied most of the files from the wwwroot subdirectory where my project exists. When I try to open the page (by pointing to "WebForm1.aspx in the new...

ASP.NET

375

Server Error in '/' Application.

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 create an application in IIS, what other checks can I make? Sean !-- error mesage

ASP.NET

2180

Website set as application?

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 allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS." I've been told by the previous developer that the website needs to be set as a "application". I...

ASP.NET

1967

running a web application from browser

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 web application With this setup I want to install the 3 web application in the /inetpub/wwwroot Folder. I don’t want to include source code in wwwroot folder. Then I want to run all 3 application separately from browser with parameters. I tried...

.NET Framework

9617

What is ONU?

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...

General

9453

Changing the language in Windows 10

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,...

Windows Server

10036

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

7451

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6710

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5354

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5481

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4007

transfer the data from one system to another through ip address

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

C# / C Sharp

3607

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP