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, sqleCheckForBac kupRestore,
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, sqlePrepareForS erialization,
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 4913
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******** *************@g 44g2000cwa.goog legroups.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,db 2start).
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******** *************@f 14g2000cwb.goog legroups.com... Thanks Matt. I tried that(db2stop,db 2start). 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
DISK='h:\backups\DB1\DB1_db_200411082056.BAK', RECOVERY (Message 0) Processed 3816 pages for database 'DB1', file
'DB1_Data' on file 1. (Message 4035) Processed 1
pages for...
|
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 database's status as LOADING.
We are on Sql Server 2000 (8.00.818) on Windows 2000 Adv Servers.
I ran dbcc on the source DB and it returned no errors....
|
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. I also tried
to 'create' the database first then ran this command below but with the
'force restore over existing database' checked on but this...
|
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 are my questions,
- should I create this dummy database first before I could restore?
|
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 encountered on device "TBS_IDX".
Do you want to continue(c), terminate this device only(d), abort the
utility(t)
? (c/d/t) t
| |
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 messages, starting with
following message -
2006-01-07-14.24.57.173819-300 I4955C325 LEVEL: Error
PID : 34928 TID : 1 ...
|
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: 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 Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the...
|
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 LOGARCHMETH1=VENDOR:/usr/tivoli/
tsm/tdp_r3/db264/libtdpdb264.a
I make an online backup with include logs to servers local disk and
then tranfer backup image...
|
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: 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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
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...
| |