473,378 Members | 1,084 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

V8 FP 8 : Restore error messages.

SS
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

Nov 12 '05 #1
6 4900
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
Nov 12 '05 #2
SS
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

Nov 12 '05 #3
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
Nov 12 '05 #4

"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
Nov 12 '05 #5
SS
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.

Nov 12 '05 #6

"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
Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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...
13
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...
2
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....
1
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...
9
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...
2
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...
7
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...
5
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...
0
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 ...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.