| Author |
Message
|
| rajmq |
 Posted: Thu Nov 22, 2007 2:32 pm Post subject: Linux broker -db2 issue |
 |
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
Hi All,
i am unable to start the broker and able to see the following error in the syslog
Nov 22 16:41:10 uk5lab-rhmb308 WebSphere Broker v6003[24230]: (TESTBK)[-1243765056]BIP2322E: Database error: SQL State '58005'; Native Error Code '-902'; Error Text '[IBM][CLI Driver] SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 '. : TESTBK.agent: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
Nov 22 16:41:10 uk5lab-rhmb308 WebSphere Broker v6003[24230]: (TESTBK)[-1243765056]BIP2053E: The broker made an unsuccessful attempt to access its database TESTBK with userid db2inst1. : TESTBK.agent: /build/S600_P/src/AdminAgent/ImbAdminAgent.cpp: 569: ImbAdminAgent::instanceOfAdminAgent: :
Nov 22 16:41:10 uk5lab-rhmb308 WebSphere Broker v6003[24225]: (TESTBK)[-1228367296]BIP2013E: The broker was unable to access its database. : TESTBK.service: /build/S600_P/src/AdminAgent/ControlProcess/Linux/ImbControlService.cpp: 424: ImbControlService::GetAAexitCode: :
Environment details :
Messsage broker Version: 6003
db2 : v8.1 fixpack 11
OS : Linux
db2diag logs
2007-11-22-22.25.42.250297+000 E2622600163G414 LEVEL: Error (OS)
PID : 13186 TID : 3086763712 PROC : db2agent (TESTBK) 0
INSTANCE: db2inst1 NODE : 000 DB : TESTBK
APPHDL : 0-79 APPID: *LOCAL.db2inst1.071122222542
FUNCTION: DB2 UDB, oper system services, sqloCSemCreate, probe:1
CALLED : OS, -, unspecified_system_function OSERR: ENOSPC (2
2007-11-22-22.25.42.250546+000 I2622600578G386 LEVEL: Severe
PID : 13186 TID : 3086763712 PROC : db2agent (TESTBK) 0
INSTANCE: db2inst1 NODE : 000 DB : TESTBK
APPHDL : 0-79 APPID: *LOCAL.db2inst1.071122222542
FUNCTION: DB2 UDB, buffer pool services, sqlbpfCreateQ, probe:5
MESSAGE : Error creating a counting semaphore
Is it anything related to the system kernal parameters ?
Apologies...i am posted in the wrong forum..Please move it WBI forum
TIA
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
 |
| shalabh1976 |
| Posted: Fri Nov 23, 2007 3:07 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Looks like a password or access issue.
Can you connect to the database through other means?
Has any change been done recently?
Was this ever working?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| rajmq |
| Posted: Fri Nov 23, 2007 5:43 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
No......i am not able to connect database, the same exception
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005
We are using this environment more than two years
TIA
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Nov 23, 2007 5:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
|
| Back to top |
|
|
| rajmq |
| Posted: Fri Nov 23, 2007 8:46 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
Already i asked my network team to change the kernal parameters..will see the results.
Meanwhile i was trying to get anything apart from this.
TIA
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Nov 23, 2007 1:47 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rajmq wrote: |
Already i asked my network team to change the kernal parameters..will see the results.
|
Your network team administer your box? 
Fair enough I suppose....
....hope it helps.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
