| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Unknown SQLState / HY010?? |
« View previous topic :: View next topic » |
| Author |
Message
|
| RAIQ |
 Posted: Thu Feb 06, 2003 5:33 am Post subject: Unknown SQLState / HY010?? |
 |
|
Novice
Joined: 06 Feb 2003
Posts: 23
Location: Switzerland
|
hi
knows anybody the following exception, db2-error?
when we are generating a lot of 'stress' on wmqi, it can be, that the broker/db2-connection in a node locks. so the whole broker is locking. only solution -> restart the broker.
system: wmqi 2.1 on zOS, DB2 V7
fixes? patches? ideas?
thanx!
regards
björn
<ITIP_ERROR>
<EXCEPTION>
<RecoverableException>
<File>/build/S210P/src/DataFlowEngine/ImbComputeNode.cpp</File>
<Line>390</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>2ffdbac6-ef00-0000-0080-f6cbd061578b.6c1fa582-ee00-0000-0080-f6cbd061578b</Name>
<Label>ITIP_Transformation_01.32.ITIP_RR_01.21.GET RBCode, Timestamp</Label>
<Text>Caught exception and rethrowing</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<DatabaseException>
<File>/build/S210P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>143</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Text>Root SQL exception</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2321</Number>
<Insert>
<Type>2</Type>
<Text>-1</Text>
</Insert>
<DatabaseException>
<File>/build/S210P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>234</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Text>Child SQL exception</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
<Insert>
<Type>5</Type>
<Text>HY010</Text>
</Insert>
<Insert>
<Type>2</Type>
<Text>-99999</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>{DB2 for OS/390}{ODBC Driver} SQLSTATE=HY010 ERRLOC=2:218:4</Text>
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</EXCEPTION>
<SEVERITY>CRITICAL</SEVERITY>
<REASON></REASON>
<FLOW>Subflow RR</FLOW>
<NODE></NODE>
</ITIP_ERROR> |
|
| Back to top |
|
 |
| KingMoonMan |
| Posted: Thu Feb 06, 2003 7:33 am Post subject: Unknown SQLState / HY010?? |
|
|
Newbie
Joined: 31 Jan 2003
Posts: 5
|
We have a similar problem with our db2(7.1 broker, 6.1 updates) and are currently attempting to find a fix. We can reproduce your error by doing a select and an insert on a single table from within one compute node, or mutiple table operations from a single node under load. It can also be encountered periodically by calling two selects from a single compute.
Please post any resolutions you may find, we will do the same. Our error message:
<DatabaseException>
<File>F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp</File>
<Line>247</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type />
<Name />
<Label />
<Text>Child SQL exception</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
- <Insert>
<Type>5</Type>
<Text>HY010</Text>
</Insert>
- <Insert>
<Type>2</Type>
<Text>-99999</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010</Text>
</Insert>
</DatabaseException> |
|
| Back to top |
|
|
| RAIQ |
| Posted: Thu Feb 06, 2003 11:57 pm Post subject: RE: Unknown SQLState / HY010?? |
|
|
Novice
Joined: 06 Feb 2003
Posts: 23
Location: Switzerland
|
hi
hooray, we got a pre-release patch form ibm hursley  . but we have still problems to install this patch  , so i can't say anything about the effect of it.
i will post further informations...
regards
björn |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
