| Author |
Message
|
| vedbhat |
 Posted: Tue Oct 08, 2002 9:43 pm Post subject: DB2 backup and Recovery |
 |
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi,
I am working at a client site and found a strange problems. The environment is MQWF 3.3.2, MQ 5.2.1 CSD 5.0 and DB2 7.2 CSD 5.0 on Windows 2000.
1) Whenever any user connects to MQWF either to buildtime or runtime the corresponding database status is changed to inconsistent. Is this the expected behaviour. Does anybody have any idea about this?
2) I have also scheduled the database for backup from the DB2 control center. The journal shows successful but when I try to restore, it give various error message. Has anybody encountered similiar error in these environments.
Any answers or suggestion is highle appreciated.
Thanks in advance and Regards
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Oct 09, 2002 4:42 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I remember I have seen something similar to this. After applying the CSDs I had to rebind the DB2 bind files to the Workflow databases. If you didn't, do it, that may solve the problem. Use fmczutil to rebind rather than DB2 utilities.
---
Venny |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Oct 09, 2002 5:58 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Venny is right on here....
With every CSD you should rebind the databse using fmczutil
| Code: |
E:\>fmczutil
FMC33201I Configuration Commands Menu:
l ... List
s ... Select
c ... Create
d ... Change default configuration
x ... Exit Configuration Commands Menu
s
Configuration identifier : [FMC]
FMC33202I Selected Configuration Commands Menu:
Selected configuration : FMC (Default configuration)
c ... Configuration Settings Menu
d ... Delete
b ... Buildtime Database Commands Menu
r ... Runtime Database Commands Menu
q ... Queue Manager Commands Menu
x ... Exit Selected Configuration Commands Menu
r
FMC33206I Selected Runtime Database Commands Menu:
Selected Runtime database : FMCDB
d ... Drop
b ... Bind packages
f ... Import topology FDL
p ... Change password
x ... Exit Selected Runtime Database Commands Menu
b |
It has gotten to the point that I always do this automatically now. However, if you check the "readme" file that comes with a CSD you will see that it contains a step to have you rebind the DB using the above procedure.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| vedbhat |
| Posted: Wed Oct 09, 2002 5:31 pm Post subject: |
|
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi,
I have done all the binding of DB2 packages as well as MQWF packages before I even did the backup. Everything looks fine as there are no problems with MQ, DB2 or MQWF. Only problem I suspect is the backup because it takes approximately 1.5 min to write 110MB file.
I guess this could be problem with MQWF/DB2.
Anyone encounteres similar problems or anything else need to look into?
Thanks and Waiting for replies
Regards
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Oct 09, 2002 9:22 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
The rebind generally solves the problem of inconsistency.
I am not sure if the database state turns inconsistent if we logon to the WF Databases.
How do check the state of the DB's ? Tell me the procedure and I will see what my databases state is when I logon to them.
---
Venny |
|
| Back to top |
|
|
| vedbhat |
| Posted: Wed Oct 09, 2002 10:01 pm Post subject: |
|
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi,
Goto the control centre and click on the "Databases" (high level and not the database itself), this will display all the databases and its status.
Regards
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Oct 10, 2002 5:15 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
hmmm.... I can't
Somebody on a Windows platform should do this. Meanwhile I will get in touch with our DB2 DBA
---
Venny |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Oct 10, 2002 5:24 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Ved:
I don't know much about DB2, but this is what I have observed:
I start mqwf and all the dependent services. If I then look at the control center as you describe, the database state is inconsistent.
I shutdown the MQWF service (i.e fmcamain) but leave DB2 and MQSeries running.
Now the state column is blank when I go to the control center.
I start the mqwf service again and the DB state is back to inconsistent
SO, it seems to me that when MQWF is up and running the state will always be inconsistent.
Does this make sense to someone with a knowledge of DB2?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| vedbhat |
| Posted: Thu Oct 10, 2002 10:45 pm Post subject: |
|
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi John,
Yes, What you said is what I have observed. I was confused when I saw this information. When we encountered the DB2 backup and restore problem, we thought it might me because of this inconsistent state of DB2, but later found that this is the state whenever WF connects to DB. The backup and restore problem was something else.
Anyway, both the problems are now solved. Thanks for all your replies.
Regards
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
|
| mqwf |
| Posted: Fri Oct 11, 2002 12:31 am Post subject: |
|
|
Acolyte
Joined: 10 Oct 2002
Posts: 62
|
vedbhat
you say the problem is solved but how did u solve the problem.
How did u solve the inconsistency problem |
|
| Back to top |
|
|
| vedbhat |
| Posted: Sun Oct 13, 2002 5:25 pm Post subject: |
|
|
Disciple
Joined: 19 Mar 2002
Posts: 186
Location: Singapore
|
Hi,
This is a bug in DB2, it shows the status as Inconsistent whenever a MQWF application is connected to DB2.
Regards
Ved
_________________
IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
| Back to top |
|
|
|
|
