db2diag is follows:
2006-08-22-14.33.17.706017 +300 I5916580C354 LEVEL: Severe
PID : 569366 TID : 1 PROC : db2hmon 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerFmpOneTime Init,
probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF22650 : FFFF FBEE ....
2006-08-22-14.35.58.574759 +300 I5916935C311 LEVEL: Event
PID : 569412 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCf gParam, probe:30
CHANGE : CFG DBM: "Instance_Memor y" <automaticFro m: "4724" To:
"4724"
2006-08-22-14.35.58.593624 +300 E5917247C920 LEVEL: Warning
PID : 569412 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, LicCheckProcess ors, probe:20
MESSAGE : ADM12017E 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-08-22-14.35.59.815986 +300 I5918168C357 LEVEL: Warning
PID : 548880 TID : 1 PROC : db2spmrsy 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-6
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : errno:
DATA #1 : Hexdump, 4 bytes
0x2FF19390 : 0000 0011 ....
2006-08-22-14.35.59.816564 +300 I5918526C280 LEVEL: Warning
PID : 548880 TID : 1 PROC : db2spmrsy 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-6
MESSAGE : Path/Filename
DATA #1 : String, 38 bytes
/u02/db2inst1/sqllib/spmlog/SPMLOG.LCF
2006-08-22-14.35.59.867674 +300 E5918807C973 LEVEL: Event
PID : 569412 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", FixPak
"7".
DATA #2 : System Info, 184 bytes
System: AIX arrow 3 5 0058241F4C00
CPU: total:2 online:2
Physical Memory: total:4096 free:2481
Virtual Memory: total:10624 free:8999
Swap Memory: total:6528 free:6518
Kernel Params: msgMaxMessageSi ze:4194304 msgMaxQueueSize :4194304
shmMax:21474836 48 shmMin:1 shmIDs:131072
shmSegments:16
semIDs:131072 semNumPerID:655 35 semOps:1024
semMaxVal:32767
semAdjustOnExit :16384
Any idea?
Gert van der Kooij wrote:
In article <11************ **********@h48g 2000cwc.googleg roups.com>,
ga********@gmai l.com says...
Can i send the details your personal email -id?
-Ganesh
Gert van der Kooij wrote:
In article <11************ **********@m73g 2000cwd.googleg roups.com>,
ga********@gmai l.com says...
The user has read privilage to /etc/services. I am able to attach to
the instance, start and stop the db server. The problem is while
connecting to db. I also changed the port number and tried it out.
still the problem persists.
>
Maybe the db2diag file gives you some more info?
It shouldn't be that much info so it's better to post it to the group.
Others can jump into the problem also.