If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 license problem?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-21-10, 09:27
itsonlyme44 itsonlyme44 is offline
Registered User
 
Join Date: Dec 2007
Posts: 261
DB2 license problem?

Running three Databases on the following DB2 Instance:
(this is on a Windows 2003 Enterprise edition Server)

Code:
C:\>db2levelDB21085I  Instance "DB2" uses "32" bits and DB2 code release "SQL08028" with
level identifier "03090106".
Informational tokens are "DB2 v8.1.15.254", "s070720", "WR21383", and FixPak
"15".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

Code:
C:\db2licm -l on 8.1.15.254
Product Name                            = "DB2 Workgroup Server Edition"
Product Identifier                      = "DB2WSE"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Concurrent User Policy                  = "Disabled"
Registered User Policy                  = "Disabled"
Enforcement Policy                      = "Soft Stop"
Number of processors                    = "1"
Number of licensed processors           = "4"
Annotation                              = ""
Other information                       = ""
This instance of DB2 has been running fine and we have not made any changes to Fixpack level etc...
This morning we cannot connect to any of the databases in the Instance.
Getting the following error:

Code:
[IBM][CLI Driver] SQL1091C  The release number of the database is 
not valid.  SQLSTATE=08004
When I google this error it is usually an error that occurs after a fixpack update when the databases aren't migrated properly.. Did our license expire or something??
Reply With Quote
  #2 (permalink)  
Old 06-21-10, 15:16
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by itsonlyme44 View Post
we have not made any changes to Fixpack level etc...
So, what changes did you make?

Quote:
Originally Posted by itsonlyme44 View Post
Did our license expire or something??
I don't think that follows from the error message.

You may want to check db2diag.log
Reply With Quote
  #3 (permalink)  
Old 06-21-10, 21:32
mrallison mrallison is offline
Registered User
 
Join Date: Jun 2010
Location: near Ottawa
Posts: 2
Your server shows:
Informational tokens are "DB2 v8.1.15.254",

but you show:
Version Information = "8.2"

I'm not sure as I don't have this particular problem, but I'm wondering whether these versions might need to be the same?
Reply With Quote
  #4 (permalink)  
Old 06-22-10, 00:03
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by mrallison View Post
Your server shows:
Informational tokens are "DB2 v8.1.15.254",

but you show:
Version Information = "8.2"

I'm not sure as I don't have this particular problem, but I'm wondering whether these versions might need to be the same?
DB2 8.1 Fixpack 15 is the same as 8.2 Fixpack 8.

DB2 V8.1 Fixpack 7 was the first release of 8.2.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old 06-22-10, 22:29
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Sounds like the db directory got "migrated". Did you recently install another version (higher) of db2?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On