SQL1091C The release number of the database is not valid. SQLSTATE=08004
in [DB2]
|
Prev: DB2WSUE License grief. (Permanent license is said the have expiredafter upgrade to FP8.2.6)
Next: problem for db2cc : db2javit not found
From: Mikeland on 10 Jan 2007 03:50 Thanks a lot, and, exist a tool with which i migrate a backup image db 7.1 in version 7.2 or this backup image is unusable? If not, which is the procedure/software that i have use for upgrading to V8 and migrating a database? Mikeland Phil Sherman ha scritto: > Did you look up the error message? > db2 "? SQL1091" > > It looks like your 7.1 database needs to be migrated to the 7.2 level > before you can use it from the 7.2 software. > > Version 7.x went out of service at the end of March, 2004. Version 9 is > the current version. You might consider upgrading to V8 and migrating > your databases before you loose the capability to migrate to a currently > supported version. > > Phil Sherman > > > Mikeland wrote: > > 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 > >
From: Phil Sherman on 10 Jan 2007 13:02 The fixpak that makes the change from 7.1 to 7.2 installation instructions explain how to migrate the database to the new level. In version 8 this involves running the "migrate database" command; I don't recall if this is what was done in V7. All upgrades I can recall have always performed an automatic upgrade during a restore of a backup. Assuming this works, you would just need to restore your 7.1 backup on the 7.2 system. Migrating to V8 involves the same steps. You need to review the migration process in the: "Quick Beginnings for DB2 Servers" manual. Phil Sherman Mikeland wrote: > Thanks a lot, > and, exist a tool with which i migrate a backup image db 7.1 in version > 7.2 or this backup image is unusable? > If not, which is the procedure/software that i have use for upgrading > to V8 and migrating a database? > > Mikeland > > Phil Sherman ha scritto: > >> Did you look up the error message? >> db2 "? SQL1091" >> >> It looks like your 7.1 database needs to be migrated to the 7.2 level >> before you can use it from the 7.2 software. >> >> Version 7.x went out of service at the end of March, 2004. Version 9 is >> the current version. You might consider upgrading to V8 and migrating >> your databases before you loose the capability to migrate to a currently >> supported version. >> >> Phil Sherman >> >> >> Mikeland wrote: >>> 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 >>> >
From: Gert van der Kooij on 10 Jan 2007 13:07 In article <iS9ph.13534$ZT3.9033(a)newssvr19.news.prodigy.com>, psherman(a)ameritech.net says... > The fixpak that makes the change from 7.1 to 7.2 installation > instructions explain how to migrate the database to the new level. In > version 8 this involves running the "migrate database" command; I don't > recall if this is what was done in V7. > If I do remember well the db2updv7 command needs to be runned against each database.
From: Mikeland on 11 Jan 2007 11:37 Thank you for reply, but a command db2updv7 return this error: C:\PROGRA~1\SQLLIB\BIN>db2updv7 -d domzte Connect to database 'domzte' failed with sqlcode = -1091. DB2UPDV7 processing failed for database 'domzte'. Gert van der Kooij ha scritto: > In article <iS9ph.13534$ZT3.9033(a)newssvr19.news.prodigy.com>, > psherman(a)ameritech.net says... > > The fixpak that makes the change from 7.1 to 7.2 installation > > instructions explain how to migrate the database to the new level. In > > version 8 this involves running the "migrate database" command; I don't > > recall if this is what was done in V7. > > > > If I do remember well the db2updv7 command needs to be runned against > each database.
From: Mikeland on 12 Jan 2007 06:15
Yeahhh, i resolve the error!! I install a fixpack 14 of db2 7.2 and is all right! For download file, go to: http://www-306.ibm.com/software/data/db2/udb/support/downloadv7.html#WINDOWS Thanks & Bye Mike Phil Sherman ha scritto: > The fixpak that makes the change from 7.1 to 7.2 installation > instructions explain how to migrate the database to the new level. In > version 8 this involves running the "migrate database" command; I don't > recall if this is what was done in V7. > > All upgrades I can recall have always performed an automatic upgrade > during a restore of a backup. Assuming this works, you would just need > to restore your 7.1 backup on the 7.2 system. > > Migrating to V8 involves the same steps. You need to review the > migration process in the: "Quick Beginnings for DB2 Servers" manual. > > Phil Sherman > > > Mikeland wrote: > > Thanks a lot, > > and, exist a tool with which i migrate a backup image db 7.1 in version > > 7.2 or this backup image is unusable? > > If not, which is the procedure/software that i have use for upgrading > > to V8 and migrating a database? > > > > Mikeland > > > > Phil Sherman ha scritto: > > > >> Did you look up the error message? > >> db2 "? SQL1091" > >> > >> It looks like your 7.1 database needs to be migrated to the 7.2 level > >> before you can use it from the 7.2 software. > >> > >> Version 7.x went out of service at the end of March, 2004. Version 9 is > >> the current version. You might consider upgrading to V8 and migrating > >> your databases before you loose the capability to migrate to a currently > >> supported version. > >> > >> Phil Sherman > >> > >> > >> Mikeland wrote: > >>> 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 > >>> > > |