we are using db2 udb v8.2 on windows. All our tables are created with
"not logged initially" parameter. Our application with auto commit on.
I would like to do an online backup and rolling forward recovery, is
this allowed? because in the document, i read these: 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. If there any workaround to get rid of the parameter so we
could do online backup? thanks
3  3524 
<db********@yah oo.com> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.com.. . we are using db2 udb v8.2 on windows. All our tables are created with
"not logged initially" parameter. Our application with auto commit on.
I would like to do an online backup and rolling forward recovery, is
this allowed? because in the document, i read these: 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. If there any workaround to get rid of the parameter so we
could do online backup? thanks
NOT LOGGED INITIALLY is turned off as soon as one does a commit (explicitly
or with auto-commit), so if you do a backup after that and use the later
backup, you should be able to roll forward from the later backup forward.
You just cannot roll forward through a point in time when NOT LOGGED
INITIALLY is active.
In V8.2, this attribute is on by default.
It means that whenever you issue ALTER TABLE ... ACTIVATE NOT LOGGED
INITIALLY then everything between that and the next commit is not logged.
If you do not issue it, nothing changes and the table is in ormal state
and can be backed in its tablespace and recovered and rolled forward.
If you do and encounter a a rollback or a failure, as you recover the
table is marked inaccessible and you cannot recover it.
The fact it is enabled to be NLI does not do anything until you issue
the ACTIVATE.
HTH, Pierre. db********@yaho o.com wrote: we are using db2 udb v8.2 on windows. All our tables are created with
"not logged initially" parameter. Our application with auto commit on.
I would like to do an online backup and rolling forward recovery, is
this allowed? because in the document, i read these: 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. If there any workaround to get rid of the parameter so we
could do online backup? thanks
--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
So if i want to activate HADR (high availability disaster recovery) for
the database, in the document it said " non-replicated operations
include, but are not limited to --Tables created with the NOT LOGGED
initially option specified", so does that means i can't do HADR on our
current database because all the tables are created with the NLI
option? thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: lawrence |
last post by:
I'm not sure how this is normally done, on a large site, perhaps one
running Phorum. Occassionally a thread will have hundreds of entries,
perhaps a meg or two worth of data. You won't necessarily print all
that to the screen, but PHP has to hold it in memory. Run some
operations on it, or, more likely, have an array that you keep adding
things to, and very soon you run into the 8 meg limit that is the
default limit for PHP scripts.
...
|
by: martin |
last post by:
Hi,
We have a heavily used production server and a table which logs every
hit on a web site. This table has grown large over time and we want to
clear it down as efficiently as possible. We would like to issue a
truncate table statement, but with millions of rows we are a bit wary
of how this will affect server performance. The alternative is to
delete is stages using rowcount but of course this will generate a
large amount of logging....
|
by: Peter Sands |
last post by:
Hi,
I am testing out some restores to a stand-by server, by roll-forwading
the logs.
I have this setup.
There is no user-exit, but logretain is on, for archive logging.
I have 2 DB's on different servers ( a & b), but named the same.
I have done a 'restore into' to create the db on server b, then taken
a on-line dump of that DB, then done a restore, to bring it into a
roll-forward pendind mode.
|
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: DB2 Convert |
last post by:
Hi,
Correct me if I am wrong? Why should I specify at the restore
statement such as Restore Database ABC ... "WITHOUT ROLLING FOWARD"?
My understand is when I am using circular logging, automatically I
CAN'T do a rollforward. If I can't do rollforward due to the circular
logging, why should I
specify "WITHOUT ROLLING FORWARD"?
| | |
by: db2group88 |
last post by:
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.TABLEID=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...
|
by: Hazz |
last post by:
In this sample code of ownerdraw drawmode, why does the '(ComboBox) sender'
line of code need to be there in this event handler?
Isn't cboFont passed via the managed heap, not the stack, into this
cboFont_DrawItem event handler? Why does it need to be cast? -hazz
,.................
cboFont.Items.AddRange(FontFamily.Families);
}
private void cboFont_DrawItem(object sender,
|
by: MarkusJNZ |
last post by:
Hi, I have two different applications running on 2003 both in two
different vitrual directories. One application runs on the .NET
framework 1.1 whilst the other runs on 2.0.
If I change the framework version (via IIS admin ASP.NET tab) for
either application (Initally the 2.0 app was recognised by IIS as 1.1)
does this force IIS to restart?
?? Any links to further reading would be good.
|
by: BurtonBach |
last post by:
I have a small database that mostly keeps track of material quantities going into jobs we do. I have been able to make this work well for me. I now want to add the tracking of a rolling balance of one particular material that we keep a small amount in inventory. Is there a straight forward way to track a rolling balance in Access other than simply tracking the sums of the increases and decreases forever?
|
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: 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,...
| | |
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: 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...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
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...
| |
