473,883 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL5035N The database requires migration to the current release.


Any help or advice appreciated.

We have just installed and configured a new DB2 v.8.1 with latest
FixPack. Just a few days later it dies and now we have a DB that is
totally unusable.

- - - -

It went all wrong one morning when connecting gave us this msg:

SQL5035N The database requires migration to the current

The DB was newly created on this server from scratch. Data imported
with IXF files. This should absolutely not give this messeage !!

After trying this and that - we tried to migrate :

SQL1704N Database migration failed. Reason code "7".

It seams we had to try a Restore :

The database alias name or database name "OSTEST" could not be
found. SQLSTATE=42705

We could not Restore into the same DB !!
But we could Restore to a new name.
The original DB cannot be dropped. We tried a lot, but now we just get
an SQL1092N most of the time ...

SQL1092N "" does not have the authority to perform the
requested command.

- - - -

Whatever is wrong, the SQL5035N should never occur.

My external support tells me to do a total rebuild of the server.

Is v.8.1 just Beta software ??
Should I go for DB2 v.7.2 - (It has to be DB2)
Far Cry (with a smile).

Nov 12 '05
11 9553
So this database is completely new and was created and loaded only after
you installed DB2 UDB V8.1? That is strange, unless it's something to do
with the IXF file picking up version information from wherever it was
created. If that is the case, you might need to do the migration. But in
any case, I would recommend that you open a PMR with IBM to troubleshoot

Larry Edelstein

Evaluator wrote:
On Fri, 6 Feb 2004 12:08:43 -0500, "PM \(pm3iinc-nospam\)"
<PM(pm3iinc-nospam)@sympati co.ca> wrote:

When you're done with your problems, you could consider installing the fp4a
since you're at fp4.

That is what we have done. Added a FixPack to v.8.x.

All responses think that there is Migration involved. There is not.
It's an error message that said so. And it is simply not true.

We installed a new 8.1 (on a new scratch server). Added the fixpack
you mention. Created a new database, loaded data from IXF files. And a
few days later the messages appears.

The messages makes no sense !! Please understand that it's IBM DB2
that mentions the migration. It should not be needed.

And I'm not "done with my problem".
The DB2 killed my access to data. And restore is not possible, as you
can see from the original message.


Nov 12 '05 #11
On Sat, 07 Feb 2004 14:56:56 GMT, Larry <La***@nospam.n et> wrote:

...., I would recommend that you open a PMR with IBM to troubleshoot

Larry Edelstein

Thanks for your input.
I guess you're right.
(Someone has to be the first to get the strange errors ...)

Nov 12 '05 #12

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

Similar topics

by: noah | last post by:
Does PHP have a feature to associate Cookie sessions with a persistent database connection that will allow a single transaction across multiple HTTP requests? Here is how I imagine my process: I have an series of interactive HTML forms. The user begins a Cookie session. A database connection is opened and a transaction is begun. After the user goes through any number of pages where they update the database they finish on a page where...
by: mountain man | last post by:
Greetings to all database professionals and laymen, Let us make a bold assumption that we have developed a software tool for the SQL Server environment which simply acts as an interface between an end-user in an organization and the database, through the exclusive use of stored procedures which are authored by the organization or by software developers. All development work at the application software level may thereby be conducted...
by: Evgeny Gopengauz | last post by:
Let us suppose that I have two similar databases and need to create an sql-script upgrating one database structure to another. For example, these databases are from different versions of some software, first is from early version, next is from current, and second one contains several new tables, sevelal new fields in old tables, several new or changed stored procedures, UDFs and so on. How to solve this problem using standard tools?
by: cat_dog_ass | last post by:
I am used to programming in DOS mode via Borland C++. I would now like to create programs for the Windows envirinment. Is it absoultely necessary to use Visual C++ to do this? Are there other tools that can help me in doing Windows programming via C++? How am I going to create drop-down menus and allow my programs to interact with the mouse? Regards, Icon
by: rkusenet | last post by:
http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.
by: Henry Reardon | last post by:
I'm having some migration problems. On Friday, I upgraded from DB2 7.2 (FP9) to DB2 8.2 (FP7), then applied Fixpack 8. I'm running Windows XP. My migrations did not work and I am trying to fix them manually. The Control Center gives me SQL0535 for some of the databases and SQL1039C for the others. I'll describe the SQL0535 problems in this note and make a separate post for SQL1039C.
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through VS, however, when I change to release and put it out on the web it fails giving me the following error message The underlying connection was closed. Could not establish a trust relationship with the remote server.
by: Shawnk | last post by:
Some Sr. colleges and I have had an on going discussion relative to when and if C# will ever support 'true' multiple inheritance. Relevant to this, I wanted to query the C# community (the 'target' programming community herein) to get some community input and verify (or not) the following two statements. Few programmers (3 to7%) UNDERSTAND 'Strategic Functional Migration
by: Mikeland | last post by:
Please, can you help me about this error: SQL1091C The release number of the database is not valid. SQLSTATE=08004 I connect to a db Version: 7, Release: 1 whit a database manager Version: 7, Release: 2
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
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,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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();...
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
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 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.