Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
6  8186 
Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>... Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>... Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have had
some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent consistent
state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
I'm not exactly an expert on this area, but...
I would expect repeatable behavior on this. The tablespaces
are likely being marked offline due to the replay of some log record
and each time you try to rollforward through that you will likely
get the same result. I expect there may be some messaging in
the admin log or db2diag.log concerning this.
I don't know what all kinds of operations may have this effect, but
I believe that one example is if one performs a non-logged LOAD
operation and during the recovery there is not a "load copy" file
available to the rollforward, it will mark the tablespace offline.
(Because the load data is not available and was not logged, the
rollforward cannot correctly recovery the tablespace.) I believe
there should be info in the docs about how to repair a tablespace
after such an occurrence if this was the cause.
I expect there are other possible reasons too, but I don't know
any specific details concerning them.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message
news:<c7**********@hanover.torolab.ibm.com>... Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have
had some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent
consistent state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
I'm not exactly an expert on this area, but...
I would expect repeatable behavior on this. The tablespaces
are likely being marked offline due to the replay of some log record
and each time you try to rollforward through that you will likely
get the same result. I expect there may be some messaging in
the admin log or db2diag.log concerning this.
I don't know what all kinds of operations may have this effect, but
I believe that one example is if one performs a non-logged LOAD
operation and during the recovery there is not a "load copy" file
available to the rollforward, it will mark the tablespace offline.
(Because the load data is not available and was not logged, the
rollforward cannot correctly recovery the tablespace.) I believe
there should be info in the docs about how to repair a tablespace
after such an occurrence if this was the cause.
I expect there are other possible reasons too, but I don't know
any specific details concerning them.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Thanks Steve.
Do you know what is causing this kind of problem? I attempted to
restore the same database with rolling foward, again. The result was
identical to the previous attempt, those same tablespaces were still
offline.
Regards,
T.C. Sheng
"Steve Pearson" <st*******@my-deja.com> wrote in message
news:<c7**********@hanover.torolab.ibm.com>... Did you look at basic error information ("db2 ? sql1271w")? According
to that, and this seems consistent with your description, you may have
had some errors during the rollforward, which offlined some tablespaces.
In that case, it should not seem strange that restore *without rolling
forward*
would not report similar problems...but of course one must be aware that
the database in this case is not "recovered" to its most recent
consistent state.
Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"T.C. Sheng" <TC*****@SYSVIEW.COM.TW> wrote in message
news:85**************************@posting.google.c om... Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".
While most of the tablespaces were recovered, but some were off-line.
Strangely, if I would restored this same database without rolling
forward, then all tablespaces were recovered without any warnings.
Can anyone tell me what causes this type of SQL warning?
T.C. Sheng
P.S. DB2 V8 on AIX running archive log mode
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jens Kalkbrenner |
last post by:
MS SQL-Server 7.0
Bypassing recovery for database 'EfW_765' because it is marked IN LOAD.
What does this mean?
Our customer is backing up is maindatabase and is recovering it to this
database for...
|
by: mediodia |
last post by:
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive...
|
by: andyjgw |
last post by:
Hi
I was in the situation of cloning a SQL server database last night.
Today, a dependent application was behaving a little erratically though
most things were fine after sorting out some ntfs...
|
by: T.C. Sheng |
last post by:
Hi all,
I has experienced a backup/restored problem and need some help. After
mydb is restored and roll-forwarded, I received this message:
SQL1271W Database "mydb" is recovered but one or...
|
by: llothar |
last post by:
When i use -W4 on visual c 7.0 i get warning C4054
translator1.c(1703) : warning C4054: 'type cast' : from function
pointer 'void * (__cdecl *)(se_agent *)' to data pointer 'void *'...
|
by: okonita |
last post by:
Hi all, I am running a recover tocopy procedure and twice with different image copy I found this informational message AND no data recovered:
DSNUCBAL - THE IMAGE COPY DATA SET...
|
by: Okonita |
last post by:
Hi all, I am running a recover tocopy procedure and twice with
different image copy I found this informational message AND no data
recovered:
DSNUCBAL - THE IMAGE COPY DATA SET...
|
by: Lexxzy |
last post by:
Hi to all,
I've a problem about to attach a recovered database file in the enterprise manager.
My problem goes this way, I want to attach a recovered database file. So when I followed this...
|
by: Albert |
last post by:
Hi,
i want to send the recovered password using Maildefinition. But i don't find
any "password" to add to the control PasswordRecovery1 as body of the email.
It works but only the username is in...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
