473,702 Members | 2,679 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL2038N A database system error "-5130" occurred during processing.

Hi hi, I'm trying to perform a redirected restore, but I get a nice
error returned. Does anyone have an idea of what the -5130 errorcode means?
db2inst@ELMO:~> db2 restore db efproddb into testprod redirect
SQL1277N Restore has detected that one or more table space containers are
inaccessible, or has set their state to 'storage must be defined'.
DB20000I The RESTORE DATABASE command completed successfully.

db2inst@ELMO:~> db2 set tablespace containers for 11 using \(PATH
\'/data/efproddb/tablespaces/c0001/t0001_04/\'\)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

db2inst@ELMO:~> db2 restore db efproddb continue
SQL2038N A database system error "-5130" occurred during processing.
Thanks.

-R-
May 2 '06 #1
6 5157
I feel the error due to which the resore failed is SQL5130N.
Do you feel there is lots of environment diffrence
SQL5130N The value specified for the configuration parameter
"<parameter >" is not in the valid range of
"<start-of-range>" to "<end-of-range>".

Explanation:

The request is not done because the value of "<parameter >" is not
within the valid range.

User Response:

Ensure that the value specified for "<parameter >" is within the
valid range, then try the request again.

May 2 '06 #2
Well, no shocking differences.
Both 64bit platforms with 64bit instances. (the platform where the
backup was taken and the platform where the backup is to be restored).

SQL5130N, that's something about messed up parameters? Not a clue where
to look.
Can the error have something to do with the tablespaces that are being
set for the restore?

-R-

Kiran Nair wrote:
I feel the error due to which the resore failed is SQL5130N.
Do you feel there is lots of environment diffrence
SQL5130N The value specified for the configuration parameter
"<parameter >" is not in the valid range of
"<start-of-range>" to "<end-of-range>".

Explanation:

The request is not done because the value of "<parameter >" is not
within the valid range.

User Response:

Ensure that the value specified for "<parameter >" is within the
valid range, then try the request again.

May 2 '06 #3
Jurgen,
Do you find any clues in db2diag.log ?
Jurgen Haan wrote:
Well, no shocking differences.
Both 64bit platforms with 64bit instances. (the platform where the
backup was taken and the platform where the backup is to be restored).

SQL5130N, that's something about messed up parameters? Not a clue where
to look.
Can the error have something to do with the tablespaces that are being
set for the restore?

-R-

Kiran Nair wrote:
I feel the error due to which the resore failed is SQL5130N.
Do you feel there is lots of environment diffrence
SQL5130N The value specified for the configuration parameter
"<parameter >" is not in the valid range of
"<start-of-range>" to "<end-of-range>".

Explanation:

The request is not done because the value of "<parameter >" is not
within the valid range.

User Response:

Ensure that the value specified for "<parameter >" is within the
valid range, then try the request again.


May 2 '06 #4
Ah... ofcourse.

2006-05-02-09.47.04.134361 +120 I21158097G500 LEVEL: Error
PID : 2387 TID : 332215680 PROC : db2agent (TESTPROD)
INSTANCE: db2inst NODE : 000 DB : TESTPROD
APPHDL : 0-758 APPID: *LOCAL.db2inst. 060502074346
FUNCTION: DB2 UDB, database utilities, sqludsfp, probe:556
MESSAGE : Failed to set database configuration parameter HDR_DB_ROLE to
standard
DATA #1 : Hexdump, 4 bytes
0xFFFEF6C0 : F6EB FFFF ....

Kiran Nair wrote:
Jurgen,
Do you find any clues in db2diag.log ?
Jurgen Haan wrote:

Well, no shocking differences.
Both 64bit platforms with 64bit instances. (the platform where the
backup was taken and the platform where the backup is to be restored).

SQL5130N, that's something about messed up parameters? Not a clue where
to look.
Can the error have something to do with the tablespaces that are being
set for the restore?

-R-

Kiran Nair wrote:
I feel the error due to which the resore failed is SQL5130N.
Do you feel there is lots of environment diffrence
SQL5130N The value specified for the configuration parameter
"<parameter >" is not in the valid range of
"<start-of-range>" to "<end-of-range>".

Explanatio n:

The request is not done because the value of "<parameter >" is not
within the valid range.

User Response:

Ensure that the value specified for "<parameter >" is within the
valid range, then try the request again.


May 2 '06 #5
Not sure why its showing HDR_DB_ROLE
As per documentation it should have been HADR_DB_ROLE, which is a
informational parameter showing current role of the database, that is
STANDARD, PRIMARY, or STANDBY...What is its value in datbase at time of
taking backup any idea ?

http://publib.boulder.ibm.com/infoce...n/r0011439.htm

Regards,
Kiran Nair
Jurgen Haan wrote:
Ah... ofcourse.

2006-05-02-09.47.04.134361 +120 I21158097G500 LEVEL: Error
PID : 2387 TID : 332215680 PROC : db2agent (TESTPROD)
INSTANCE: db2inst NODE : 000 DB : TESTPROD
APPHDL : 0-758 APPID: *LOCAL.db2inst. 060502074346
FUNCTION: DB2 UDB, database utilities, sqludsfp, probe:556
MESSAGE : Failed to set database configuration parameter HDR_DB_ROLE to
standard
DATA #1 : Hexdump, 4 bytes
0xFFFEF6C0 : F6EB FFFF ....

Kiran Nair wrote:
Jurgen,
Do you find any clues in db2diag.log ?
Jurgen Haan wrote:

Well, no shocking differences.
Both 64bit platforms with 64bit instances. (the platform where the
backup was taken and the platform where the backup is to be restored).

SQL5130N, that's something about messed up parameters? Not a clue where
to look.
Can the error have something to do with the tablespaces that are being
set for the restore?

-R-

Kiran Nair wrote:

I feel the error due to which the resore failed is SQL5130N.
Do you feel there is lots of environment diffrence
SQL5130N The value specified for the configuration parameter
"<parameter >" is not in the valid range of
"<start-of-range>" to "<end-of-range>".

Explanatio n:

The request is not done because the value of "<parameter >" is not
within the valid range.

User Response:

Ensure that the value specified for "<parameter >" is within the
valid range, then try the request again.



May 2 '06 #6
Stupid old me...

The restore was done in a newly created instances especially for that
restore, instead of the regular one.
This instance was not created with the -w64 parameter.
In short, I was trying to restore a 64bit backup into a 32bit environment.

D'oh!

-R-
May 5 '06 #7

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

Similar topics

5
16434
by: richard | last post by:
I have a licensed MS Office 97 package which I have moved from PC to PC over the years and I have just bought a new machine with XP Pro on it, the latest release. When I install Office, I get the error "an error occurred at changing the workgroup database" and "setup couldn't create a system.mdw file....run the workgroup administrator before you run this appliaction (-1011). When I run the workgroup administrator (something I have never...
1
2975
by: Angel | last post by:
I'm trying to connect to a fixed IP address (eg. http://10.60.903.50/TempFile) in order to retrieve one accii line of text in TempFile. I try to read the information with this code: string fullpath = " http://10.60.93.51/TempFile "; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(fullpath); //req.KeepAlive = false; HttpWebResponse res; StreamReader sr; string strResult = "";
3
29260
by: Jimski | last post by:
Hello all, I am having a problem where I get an error message when I call FlushFinalBlock when decrypting my encrypted text. I am using the Rijndael algorithm. The error message is "Length of the data to decrypt is invalid" and occurs on the csDecrypt.FlushFinalBlock.
0
1459
by: ksayal | last post by:
Hi, I'm creating a project. Whenever I try to add a user control or add an aspx page it gives me the following error. When I remove the inherits="" thing, it shows up the page.... What would be the cause of this problem.. Please suggest asap.. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error
10
3724
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server Error in '/QuickStartv20' Application. -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a configuration file
0
2334
by: matt.delvecchio | last post by:
hey all, recently i was getting this error in my apps: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
4
8005
by: Gary | last post by:
Hi, I get this error " " when my web page run, what does it mean? Hope someone can help!!! Gary
5
1511
by: Nick Gilbert | last post by:
Hi, I recently upgraded a website from ASP.NET 1.1 to 2.0. While working on the site and changing aspx or ascx files, I sometimes randomly get a compilation error after refreshing the page in the browser (NOT when building the project from within VS.NET). The only way to fix it is to clean the project and rebuild it - then reload the page again. This behaviour is very annoying and I can't work out what's causing it. None of my other...
0
1216
by: Gtu108 | last post by:
Hi, I am getting an error while uploading a published version of site. The error is like : Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load the assembly 'App_Web_oon-2ckc'. Make sure that it is compiled before accessing the page. Source Error:
6
5352
by: Bobby Edward | last post by:
Using ASP.NET 3.5 and MySQL (thru DevArt MyDirect.NET)... On the production server I get a "Parser Error" for every XSD dataset. It works perfect on my dev machine. But, on the production server I get the error. To troubleshoot the issue I went back to my dev machine and changed all the connectionstrings from localhost to the remote/production server db and made sure everything works fine. I then uploaded all the files to the...
0
8739
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9089
jinu1996
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8983
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
7831
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6575
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5907
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4667
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3107
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
3
2036
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.