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 can't start

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-14-04, 11:18
eDB2 eDB2 is offline
Registered User
 
Join Date: Feb 2004
Location: beijing
Posts: 1
Unhappy db2 can't start

environment:AIX5.1+HACMP+DB28.1
host2 is standby of host1

only one instance is running
when host2 take over host1's application(db2),db2 can't run.i found the message in db2diag

SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition". The
number of processors on this machine is "4". You should purchase additional
processor based entitlements from your IBM representative or authorized dealer
and update your license using the License Center or the db2licm command line
utility. For more information on updating processor based licenses, refer to
the Quick Beginnings manual for your platform. For more information on the
db2licm utility, refer to the DB2 Command Reference.


2004-02-15-00.00.27.768574 Instance:db2inst1 Node:000
PID:884828(db2star2) TID:1 Appid:none
oper system services sqloqwait2 Probe:80

Unexpected system error 0x23 has occurred.
This has been mapped to ZRC 0x83000023.

PID:884828 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
The specified message type does not exist on a message queue.
2004-02-15-00.00.27.880075 Instance:db2inst1 Node:000
PID:884828(db2star2) TID:1 Appid:none
oper system services sqloqwait2 Probe:90

Message number 0 is unavailable.

PID:884828 TID:1 Node:000 Title: sqloqwait WaitPostQueueId:
0034 0009 .4..

PID:884828 TID:1 Node:000 Title: sqloqwait waitpost ptr:
3001 4068 0.@h

PID:884828 TID:1 Node:000 Title: sqloqwait waitpost:
1000 0000 0001 0000 0000 0000 0000 0002 ................
0000 0000 ....

PID:884828 TID:1 Node:000 Title: sqloqwait timeout:
0000 0000 ....

PID:884828 TID:1 Node:000 Title: sqloqwait global Waitlist ptr:
0000 0000 ....

2004-02-15-00.00.28.232738 Instance:db2inst1 Node:000
PID:884828(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:500


i need your help ,thank you!
Reply With Quote
  #2 (permalink)  
Old 02-16-04, 01:22
nitingm nitingm is offline
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
Error Explanation

hi,

The licencing policy with db2 is per processor based, so now what has happened is that you have the license for 1 processor where as your box has 4 processors, hence you are getting this error.

I was reading on the db2licm command and this is what i suggest from the db2 command execute the below command.

db2licm -l

This should give you the DB2 Product password and the number of processors entitled.

Please provide us this information so that we can advise further.

Regards

Nitin.
__________________
HTH

Nitin

Ask the experienced rather than the learned
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