| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSI Insert Node Giving Problem | Urgent |
« View previous topic :: View next topic » |
| Author |
Message
|
| Deepak Batra |
 Posted: Fri Mar 15, 2002 3:41 am Post subject: |
 |
|
Apprentice
Joined: 25 Feb 2002
Posts: 31
|
Hi
I had made small workflow using Database insert node . I am using DB2 as database , and MQSI 2.0 on windows NT .
I had configured DSN in ODBC and specified all MQSI workflow parameters required in database insert node (like database name , table name , column ) .
is it possible to trace errors on MQSI .please do help me .
Thanks in advance .
Deepak |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Mar 15, 2002 9:11 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Did you check Event Viewer on WIN NT? In case of failure, MQSI error will be logged there.
Kiran
|
|
| Back to top |
|
|
| Naftalanja |
| Posted: Fri Mar 15, 2002 4:05 pm Post subject: |
|
|
Acolyte
Joined: 30 Jan 2002
Posts: 63
Location: Los Angeles
|
Hi sorry for late re, but you can use the trace statements in MQSI, its quite easy to use. Just type the following
D:Program FilesIBMMQSeries Integrator 2.0logs>mqsichangetrace <BROKERNAME>
-u -e <Execution Group Name> -f <Message FlowName> -l debug -r
D:Program FilesIBMMQSeries Integrator 2.0logs>mqsireadlog <BROKERNAME> -u -e
<EXECUTION GROUP> -o <filename>
D:Program FilesIBMMQSeries Integrator 2.0logs>mqsiformatlog -i <filename>
-o <filename.txt>
Note file name in Formatlog statement should be the same as mqsireadlog.
Steps:
01) Run the firstcommand, to refrsh the exisiting logs on the broker.
02) put a message in the message flow
03) wait for the completion of execution
04) run the mqsi readlog
05) run mqsi format log.
Should you have any questions further let me know. thanx  |
|
| Back to top |
|
|
| Naftalanja |
| Posted: Fri Mar 15, 2002 4:07 pm Post subject: |
|
|
Acolyte
Joined: 30 Jan 2002
Posts: 63
Location: Los Angeles
|
Sorry forgot to mention 2 points
a) The directory logs is ma own directory under MQSI installation directories
b) All are case sensitive please
thanx |
|
| Back to top |
|
|
| bmccarty |
| Posted: Fri Apr 05, 2002 3:38 pm Post subject: |
|
|
Apprentice
Joined: 18 Dec 2001
Posts: 43
|
You can also trace the ODBC activity from the Windows DataSource administrator.
There is a tab called tracing.
Brian |
|
| 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
|
|
|
|
