|
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...
|
by: hikums |
last post by:
How to accomplish a tablespace move from 32K to 4K page size on AIX
5.2, DB2 UDB 8.2?
Enable forward recovery, take 32K tablespace backup, drop 32K
tablespace, create 4K tablespace, restore to 4K tablespace from the
backup, reset back to circular logging. Would this work?
|
by: Raj |
last post by:
How can we do an online restore of a tablespace using the incremental
backup's? we are on a partitioned database...
Also, how could we use backup copy made by the load (using the copy to
option in load) to revover the tablespace?
Thanks,
Raj
|
by: Raghava |
last post by:
hi all,
i was working on DB2 and came across an issue. i.e. can a tablespace be
rollforwarded to POINT-IN-TIME?
the scenario is as follows:
i created a data base and a tablespace in it.
i have enabled archival logging (enabled userexit and logretain) and
changed log path to a different location.
as the log path and logging method was...
|
by: Raj |
last post by:
For tablespace level recovery of the db is the following strategy good
enough?
Sunday's Table - Full offline backup
Mondays incremental to tape Monday's offline incremental backup +
Monday's logs
Tuesday's tape - Tuesday's offline incremental backup +
Monday's logs + Tuesday's logs
..
..
..
|
|
by: satish mullapudi |
last post by:
Hi All,
I am using Db2 UDB v 8.2 on RHEL . I have performed a load operation on
a table. Now that tablespace has been switched into RESTORE PENDING
state. Now I can only read the data in the table. I can't modify the
data in the table as it is giving me an error saying "Tablespace Access
denied". How can I bring the tablespace out of RESTORE...
|
by: morch |
last post by:
Hello,
I have an oddity on a production database. I get the following from
the DB CFG :
Backup pending = NO
Database is consistent = NO
Rollforward pending = TABLESPACE
Restore pending =...
|
by: aj |
last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1
I have a DB2 online DB backup that was done w/ the INCLUDE LOGS
option. I am interested in restoring that backup, and rolling
forward ONLY the logs contained in the backup and no more, then
bringing the DB online.
I do not want to use a userexit to try and retrieve additional
logs - I only want to roll...
|
by: danfan46 |
last post by:
Hi.
I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.
set integrity for ..table..
|
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...
|
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...
|
|
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. ...
|
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...
|
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...
|
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...
|
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...
|
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...
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|