473,805 Members | 2,297 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Restore V8 Fixpack 12 To Version 9

Hi
I try to restore 2 database from V8 fix pack 12 to V9
One of them can restore OK while the other give the below error message
Can any one give me some hint of how to fix this problem

SQL2519N The database was restored but the restored database was
not migrated to the current release. Error "-1704" with tokens
"3" is returned.

Explanation:

The backup image contains a previous release of the database.
After the database files were restored, an attempt was made to
migrate the database to the current release. The migration
failed.

The utility finishes processing but the database was not
migrated.

User Response:

Look at the SQLCODE (message number) in the message for more
information. Make changes and submit the Migrate command before
using the database.

Aug 19 '06 #1
2 2176
I have run the command

db2 migrate database DATABASENAME

Then I get this error message

SQL1074N database migation failed. reason code "3"

Question
The above error code mean not enough log space
But how do I increase the log space with without being able to connect to
the database?


"Tuong Do" <tu***@somewher e.on.earthwrote in message
news:44******** **************@ news.optusnet.c om.au...
Hi
I try to restore 2 database from V8 fix pack 12 to V9
One of them can restore OK while the other give the below error message
Can any one give me some hint of how to fix this problem

SQL2519N The database was restored but the restored database was
not migrated to the current release. Error "-1704" with tokens
"3" is returned.

Explanation:

The backup image contains a previous release of the database.
After the database files were restored, an attempt was made to
migrate the database to the current release. The migration
failed.

The utility finishes processing but the database was not
migrated.

User Response:

Look at the SQLCODE (message number) in the message for more
information. Make changes and submit the Migrate command before
using the database.

Aug 19 '06 #2
In article <44************ **********@news .optusnet.com.a u>,
tu***@somewhere .on.earth says...
I have run the command

db2 migrate database DATABASENAME

Then I get this error message

SQL1074N database migation failed. reason code "3"

Question
The above error code mean not enough log space
But how do I increase the log space with without being able to connect to
the database?

You don't need a connection to the database.
Using the command 'db2 update db cfg using <logfilsiz .. logprimary ..
logsecond ..deferred' doesn't activate the db and when submitting the
'migrate db' after that the new values will be used.
Aug 19 '06 #3

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

Similar topics

4
6207
by: ScottH | last post by:
I am running 7.2 with fixpack 10a under W2K. I got a backup from someone else in an attempt to debug a data issue. The other person created the database with UTF-8 (codepage 1208), so I created a new database with that codepage, cd to the directory where the backup was located, but the restore failed: db2 => create database MYDB using codeset UTF-8 territory us DB20000I The CREATE DATABASE command completed successfully. db2 =>...
0
1772
by: alederer | last post by:
Hallo! I have the following situation: DB2 V6.1 OS/390 and DB2 V6.1 auf AIX 4.3.3 running the database servers. A windows NT machine with db2 V7.1.040 FP3 (WR21254) client. Now I have a JDBC application which crashes when it tries to find out the primary keys of a table on the AIX db server using getPrimaryKeys on tables with primary keys (it don't crash with tables without primary keys!).
6
8621
by: cat | last post by:
Hi Folks, We are going to start a grand new project, which is DB2v7 FP10a sitting on AIX4.3.3 on M80 server. Here is my question, 1) According to Fixpack installation guide, I have to install Fixpack1(Pre-request of Fixpack 3 installation), Fixpack 3(Pre-request of Fixpack 10a) in order to successful install Fixpack 10a.Question is do I have to follow this sequence or there is a way jump to fixpack 10a.
1
2412
by: John Wheeler | last post by:
Hi, We upgraded the Windows ADC V8.1 to fixpack 5 on some Windows 2000 (Dutch Version) professional machines and something strange happened. When we select decimal columns in our queries the decimal separator of the decimal columns has become a comma while it was a dot. Example resultset : Before Fixpack 5:
4
6015
by: David | last post by:
Dear ALL, I had a problem when I restore a db2 V7 EE Fixpack 5 on AIX 4.3.3 to db2 V8 ESE Fixpack 3 on AIX 5.1. Once I restored db2 db (PRD) to V8 and tried to connect to DB, I had the following problem: $db2 connect to PRD SQL5035N The database requires migration to the current release.
4
7792
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2, Modification: 5, Service Level: WR21294 Querying the system... Windows 2000 Version
2
1760
by: bastb | last post by:
Hi, We've been using the perl DBD::DB2 driver on Perl version 5.8.0 (aix_thread_multi) for a project we're working on without any problems until now. We've been using DBD::DB2 version 0.78 on DB2 Version 8.1 (the db2 cli reports 8.1.0) and we've recently updated DB2 using FixPack 7. The project we're working on uses the DB2 driver for some webpages and a couple of daemon scripts. On the DB2 version without the FixPack the
1
4898
by: graju80 | last post by:
Hello Gurus, Question.. I tried to restore a backup AIX's DB2 db in Linux's DB2 same version and fixpack... but get error saying... SQL2570N A database cannot be restore on a platform that does not match the platform on which the backup image was created Is there a better or alternate ways to do this??
0
1689
by: shiva359 | last post by:
Hi Looking for a quick safest way of rollback plan for fixpack (version 8 fixpack 14 ) upgraded Instance on windows from verison 8 ( no fixpack ) level . one approach is take ixf dumps using db2move
0
9718
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
9596
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,...
0
10364
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...
0
9186
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
7649
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
6876
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
5545
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...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3849
muto222
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.