| Author |
Message
|
| vinodsasidharan |
 Posted: Fri May 09, 2003 8:03 pm Post subject: Errors running fmczrdb .any resolutions . |
 |
|
Apprentice
Joined: 25 Apr 2003
Posts: 47
Location: Norwich
|
Hi all, 
I am trying to re org and re bind the fmcdb database .
The seps followed is as follows :
1)stopped the workflow servers
2)connect to fmcdb
3)reorgchk update statistics on table all
4)connect reset
5)THEN FINALLY
FMCZRDB -O B -Y FMC .
BUT THIS POINT I GET ERROR AS FOLLOWS
--------------------------------------------------
cwrs2:/4c/fmc >fmczrdb -o b -y fmc
DB2 user ID : fmc
DB2 password :
FMC33150E File /var/fmc/cfgs/fmc/log/@fmczrt.log.fmc could not be opened.
FMC33141I Setup of database completed with errors.
----------------------------------------------------
I HAVE LOGGED IN AS FMC SO HE HAS ALL RIGHTS . WHY IS THIS ERROR DUE TO .ANY GUIDEANCE ???NEED A QUICK REPLY PLEASE.
_________________
Vinod sasidharan
Ibm Certfied MQ Admin 5.3
Ibm Certfied MQ Admin 6.0
Ibm Certfied WAS Admin 6.0
Ibm Certfied WMB Admin 5.0
Ibm Certfied Db2 Specialist.
Sun certified Java Programmer.
"Ai carte, ai parte ....................." |
|
| Back to top |
|
 |
| vennela |
| Posted: Fri May 09, 2003 9:59 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Vinod:
I am not sure why you have used that command to rebind databases.
You have to use either db2 commands or fmczutil to rebind the databases. The recommended way is to use fmczutil to rebind the packages (or whatever that is in DB2 parlance).
| Code: |
C:\>fmczutil
FMC33201I Configuration Commands Menu:
l ... List
s ... Select
c ... Create
x ... Exit Configuration Commands Menu
l
- FMC33611I The following configurations are defined:
FMC (Default configuration)
FMC33201I Configuration Commands Menu:
l ... List
s ... Select
c ... Create
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 : FMCDB3
d ... Drop
b ... Bind packages
f ... Import topology FDL
p ... Change password
x ... Exit Selected Runtime Database Commands Menu
|
If you select b here it would do everything for you.
I am not sure what the other command does but it is not documented any where and it's better to abstain from using such commands I guess.
The reply may be was not as quick as you expected....
Let us know if you have any more problems.
-------
Venny |
|
| Back to top |
|
|
| Ratan |
| Posted: Sat May 10, 2003 5:58 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
fmczrdb -o b -y fmc
|
Venny,
That is the command I use all the time and never had a problem. It is the documented in the "Production roll out" support pac.
I think he is getting that error because of some authorization issue.
-Ratan |
|
| Back to top |
|
|
| vennela |
| Posted: Mon May 12, 2003 6:43 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I stand corrected.
Thanks
Also, I wonder if there is any difference between the both. |
|
| Back to top |
|
|
| jmac |
| Posted: Mon May 12, 2003 6:45 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Venny:
I bet that this is the command that fmczutil enters "under the covers".
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Mon May 12, 2003 8:23 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
| I bet that this is the command that fmczutil enters "under the covers". |
I agree. We shoould be able to use either and have the same result. I am not sure if fmczutil has the play back feature to be able to write scripts.
-Ratan. |
|
| Back to top |
|
|
| vennela |
| Posted: Mon May 12, 2003 9:59 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
From the manual:
If you want to use the input that was previously saved to a file named SavedFilename, enter the command: fmczutil -f SavedFilename The input values contained in the file will appear in fmczutil as the default values which you can accept or modify. If you do not specify a file name, the help information is displayed.
I guess we can. But we don't have to take the pain while there is an easier way to do it. |
|
| Back to top |
|
|
| Ratan |
| Posted: Mon May 12, 2003 10:42 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
fmczutil -f SavedFilename
|
It is not possible to use the "-f" option in a script, because it takes the input from the file and prompts for the user to verify.
-Ratan. |
|
| Back to top |
|
|
|
|
