| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [SOLVED]Cleanup server question |
« View previous topic :: View next topic » |
| Author |
Message
|
| NewMB |
 Posted: Thu Nov 03, 2005 12:26 pm Post subject: [SOLVED]Cleanup server question |
 |
|
Apprentice
Joined: 05 Jan 2005
Posts: 42
|
Hi, I am having a problem on my cleanup server. When I use fmcautil to start the cleanup server, it returns saying that the server stopped abnormally.
10/28/2005 12:06:12 AM FMC10300I Cleanup server for system group FMCGRP started in system FMCSYS.
10/28/2005 12:06:12 AM FMC12260E The cleanup server for system group FMCGRP stopped abnormally.
On the Windows log, I see:
FmcSQLException, Sqlcode=-818, Sqlerrmc=, Sqlerrp=SQLRAL
DP, Sqlerrd[0]=-2146303874, Sqlerrd[1]=0, Sqlerrd[2]=0, Sqlerrd[3]=0, Sqlerrd[4]
=0, Sqlerrd[5]=0, Sqlwarn= , Sqlstate=51003
I am running V.3.5 on Windows with MQ Series 5.3.
The cleanup server setting:
- Cleanup server settings
- Check interval PT5M
- Start mode Deferred
- Server start time Everyday at 00:00
- Server stop time 06:00
- Cleanup time P1W
- Cleanup delay time PT1H
1. Is it ok to start the server using fmcautil? (I understand that it should be scheduled running in non-peak hours, but I just want to start it to make sure the server is ok. |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Nov 03, 2005 12:46 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
You can easily start with fmcautil.... you just need to remember that the cleanup server does quite a bit of work.... so it may slow down other work that is currently running
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| NewMB |
| Posted: Thu Nov 03, 2005 12:48 pm Post subject: |
|
|
Apprentice
Joined: 05 Jan 2005
Posts: 42
|
| But do you know why it returns saying "Stopped abnormally" and continue "started and stopped"? |
|
| Back to top |
|
|
| karthik |
| Posted: Thu Nov 03, 2005 7:08 pm Post subject: |
|
|
Centurion
Joined: 17 Oct 2003
Posts: 114
|
Can you try a db rebind and see if it fixes it
Karthik |
|
| Back to top |
|
|
| NewMB |
| Posted: Fri Nov 04, 2005 10:47 am Post subject: |
|
|
Apprentice
Joined: 05 Jan 2005
Posts: 42
|
The rebind and reorg work. Now I can start my cleanup server without error. Thank you karthik and jmac.
Here are the steps that I used to do the rebind and reorg.
Running database statistics and rebinding the executables to the DB2 database
To run database statistics and rebind the executables:
1. Use the MQ Workflow administration utility to stop the MQ Workflow Servers. On Windows platforms, you can use the system service commands, for example: net stop "IBM MQ Workflow 3.6 - FMC"
2. On Windows platforms, open a DB2 command window. On UNIX, log on with the DB2 instance administrator user ID.
3. Connect to the MQ Workflow Runtime Database. For example, if FMCDB is the name of the database, type: db2 connect to FMCDB
4. Create the database statistics: db2 reorgchk update statistics on table all
5. Disconnect from the database: db2 connect reset
6. Rebind all the applications using the generated statistics: fmczrdb -o b -y FMC
7. Restart the MQ Workflow Servers. On Windows platforms, you can use the system service commands, for example: net start "IBM MQ Workflow 3.6 - FMC" |
|
| Back to top |
|
|
| NewMB |
| Posted: Fri Nov 04, 2005 10:49 am Post subject: Cleanup Server question - resolved |
|
|
Apprentice
Joined: 05 Jan 2005
Posts: 42
|
| Forgot to mark it as resolved |
|
| 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
|
|
|
|
