problem with db2start

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lakshmananl - 15 May 2006 12:40 GMT

hi, i have a peculiar problem if i issue the db2start command in a
particular instance with name db2inst1 the whole box is rebooted. But,
there is no same problem with the other instance db2inst2. the
environment is version of db2 udb v8.1 with fixpack 6 on AIX 5.2, this
was working fine till last week when we installed gcc compiler. since,
we used stored procedures i dont know whether this will be the cause
for the problem. Kindly help me in this.

regards
Lakshman

Reply to this Message

Shashi Mannepalli - 15 May 2006 22:09 GMT

hmm....how can a Instance owner can reboot the UNIX host. Only ROOT can
do that.
Can u provide more details...

1. Did u login to the UNIX host as db2inst1 ? Then did a db2start ?
2. what is there in the .profile of the db2inst1 ?
3. Do u see any DB2 error codes in the diag.log ?

cheers...
Shashi Mannepalli

Reply to this Message

lakshmananl - 16 May 2006 06:14 GMT

hi, for your information

1 i logged in as db2inst1 then gav edb2start
2 i checked the .profile file
3 i checked the diag.log and the last two timestamps i have enclosed
below.

2006-05-15-01.09.44.195922 Instance:db2inst1 Node:000

PID:18778(db2star2) TID:1 Appid:none

base sys utilities LicCheckProcessors Probe:20

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 "2". 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.

2006-05-15-01.09.45.866836 Instance:db2inst1 Node:000

PID:21930(db2spmrsy 0) TID:1 Appid:none

oper system services sqloopenp Probe:60

errno:

0x2FF1C910 : 0x00000011 ....

PID:21930 TID:1 Node:000 Title: Path/Filename

/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2006-05-15-01.09.46.038005 Instance:db2inst1 Node:000

PID:18778(db2star2) TID:1 Appid:none

base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.

next thing is that since we had an other instance we created the new db
in db2inst2 and here the same is happening when we start the app srver
(Websphere) as root user.

Kindly put you thoughts in this.

regards
Lakshman

Reply to this Message