473,373 Members | 1,207 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,373 software developers and data experts.

SQL1088W - V7 to V8 database migration failure.


Running UDB V7 FP10a and 8.1 .4 on Windows 2000.

Did full offline backups of three V7 databases. Restored two databases
to V8 instance successfully.

Third restore ended with:

SQL2517W The restored database was migrated to the current release.
Migration
returned sqlcode "1088" and tokens "C:\IBM\SQLLIB\bnd\db2schema.bnd".

SQL1088W The database was created, but an error occurred while
binding the utilities. The utilities are not bound to
the database.

Cannot connect to database so cannot bind utilities. Connect fails with;

SQL5035N The database requires migration to the current release.

Tried manual migration. Ended with:

SQL0456N In the definition of routine "SYSPROC.SNAPSHOT_DBM", the SPECIFIC
name "SNAPSHOT_DBM" already exists in the schema. LINE NUMBER=1.
SQLSTATE=42710

SQL0456N In the definition of routine "<routine-name>", the
SPECIFIC name "<specific-name>" already exists in the
schema.

Explanation:

The user has supplied an explicit SPECIFIC name
"<specific-name>" in the definition of routine
"<routine-name>", but this name already exists as the SPECIFIC
name for a function, method, or procedure in the schema.

User Response:

Choose a new SPECIFIC name and try again.

sqlcode : -456

sqlstate : 42710

Should I drop the event monitors in the V7 database before offline backup?

Nov 12 '05 #1
0 2844

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

Similar topics

5
by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for...
18
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...
11
by: Jep | last post by:
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. - - - -...
1
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...
4
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the...
1
by: greg.scharlemann | last post by:
Does anyone know where I could find a complete city and state database for MySQL? I've looked at the Zip Code data on the census website, but don't know the best approach to get a .dbf file into...
0
by: Rodolfo | last post by:
Hi everybody! I have migrated some tables from a database in Informix to a database in SQL Server 2000 using the DTS via ODBC. I installed the Informix Client SDK in order to make my conection....
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
2
by: Alex | last post by:
Hi, Probably a simple question :-) I've got a few xml aware databases on a 9.1.2 db2 server running on RHEL 4. As db2 V9.5 doesn't run on RHEL 4 I've set up a new server running RHEL5.1 with...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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:
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.