Hi
I am trying to restore my database in V8 FP8. The first restore attempt
failed(because of an incorrect parameter I defined), so I issued the
command again(after correction!!). In version 7 this used to work fine,
but in version 8 it has showed me this error message in the
db2diag:(dbname changed)
2005-08-09-10.14.01.878677-420 I301783124C382 LEVEL: Warning
PID : 25672 TID : 1 PROC : db2agent
(SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43 APPID: *LOCAL.db2inst1.050809171401
FUNCTION: DB2 UDB, base sys utilities, sqleCheckForBackupRestore,
probe:10
RETCODE : ZRC=0xFFFFFBA1=-1119
2005-08-09-10.14.01.880057-420 I301783507C383 LEVEL: Severe
PID : 25672 TID : 1 PROC : db2agent
(SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43 APPID: *LOCAL.db2inst1.050809171401
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization,
probe:20
RETCODE : ZRC=0xFFFFFBA1=-1119
2005-08-09-10.14.01.880687-420 I301783891C364 LEVEL: Severe
PID : 25672 TID : 1 PROC : db2agent
(SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43 APPID: *LOCAL.db2inst1.050809171401
FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10
RETCODE : ZRC=0xFFFFFBA1=-1119
This message is repeating in the diaglog every 1 minute. I even tried
to issue a db2 "restore db sample abort" command but that returns
saying that no restore command was issued. There are no connections
shown to the database. Could someone help me know how I can work around
this?
Any help in this regard will be much appreciated.
Thanks
SS 6 4902
SS wrote:
^^
If this is some kind of political statement, I would not expect much help.
It it's a joke, it's a bad one. But that's OT. I am trying to restore my database in V8 FP8. The first restore attempt failed(because of an incorrect parameter I defined), so I issued the command again(after correction!!). In version 7 this used to work fine, but in version 8 it has showed me this error message in the
Having the full command you tried would help people with analyzing this.
just my 2 ct's
Norbert
Nobert,
I 'changed my working directory to my archieve directory.
cd /db2inst1/arch/db/
and then issued the command
db2 "restore db SAMPLE replace existing taken at 20050402190253"
but since I wanted this to run for the in nohup mode, I stopped the
command (control-C)
and then restarted
nohup db2 "restore db SAMPLE replace existing taken at 20050402190253"
I have stopped and restarted restores successfully in V7 without any
glitch, but this time it landed us up in trouble.
Thanks
Norbert Munkel wrote: SS wrote: ^^ If this is some kind of political statement, I would not expect much help.
They're the dudes initials Norbert, chill out.
Art S. Kagel
"SS" <su******@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com... Nobert, I 'changed my working directory to my archieve directory. cd /db2inst1/arch/db/ and then issued the command db2 "restore db SAMPLE replace existing taken at 20050402190253" but since I wanted this to run for the in nohup mode, I stopped the command (control-C) and then restarted nohup db2 "restore db SAMPLE replace existing taken at 20050402190253"
Do not attempt to terminate DB2 command-line processes with ^C.
I have stopped and restarted restores successfully in V7 without any glitch, but this time it landed us up in trouble.
Yes. Don't do that. You've got DB2 in a wierd state. db2stop, db2start,
and then issue the proper restore command and you will be fine.
--
Matt Emmerton
Thanks Matt.
I tried that(db2stop,db2start).
But the restore would still print the above mentioned error message in
db2diag.log file at the 1 minute interval everytime I ran it.
I am just going to drop the db now and do a redirected restore instead.
lets see how that works.
Never thought the upgrade would make restore that fragile.
"SS" <su******@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com... Thanks Matt. I tried that(db2stop,db2start). But the restore would still print the above mentioned error message in db2diag.log file at the 1 minute interval everytime I ran it.
I am just going to drop the db now and do a redirected restore instead. lets see how that works.
Never thought the upgrade would make restore that fragile.
If you can reproduce the bad behaviour (after getting things to work via
redirected restore), then I would advise you to open a PMR. Obviously,
hitting ^C is a typical thing to do, and if it messes things up, we should
get it fixed.
--
Matt Emmrton This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Michael Bourgon |
last post by:
I need to build an automated email that gives the completion messages
when a database is restored (i.e. "Executed as user: sa. Executing
RESTORE DATABASE DB1 FROM...
|
by: |
last post by:
Hi
I am trying to copy a 20 GB database from server 1 to 2. I took a full
backup, copied to server2 and restored ( ready for use) using EM.
After the message restore completed, I see the...
|
by: DMAC |
last post by:
The following failed in EM (or whatever it is called now management
studio I think) and I scripted it out and ran it in a query window to
get more info. This works fine in SQL 2000 but not in 2005....
|
by: Hakim |
last post by:
Hi there,
I am a rookie in DB2. I have tried to do a database restoration on my
system.
Since it should not go directly to our REAL database, I tried to
restore to a dummy database.
Below...
|
by: GL |
last post by:
I am running DB2 8.1.1 on AIX 5.1
Having a problem with a redirected restore.
Once into the restore continue phase, I immediately get the following
“SQL2059W A device full warning was...
|
by: P. Adhia |
last post by:
Hello All,
I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x)
on DB2 V8.2 system (AIX 5.2). I get the above error with no other
details. db2diag.log has a series of error...
|
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...
|
by: smoi |
last post by:
Hi all,
My manager ask me to do backup for 3 database and restore them in a new server.
I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL...
|
by: mitrofun63 |
last post by:
Hello.
On my production site i have DB2 9.1.2 database configured for
archiving logs and making backup through
TSM Data Protection for DB2 UDB
The LOGARCHMETH1 parameter is set to ...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |