| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| moving FMCDB to new path |
« View previous topic :: View next topic » |
| Author |
Message
|
| ramires |
 Posted: Fri Apr 29, 2005 7:28 am Post subject: moving FMCDB to new path |
 |
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Hello,
I need to move FMDB from dthe default directory where it was created. This is: <wf dir>\rt_db\db2
I want do put it on a new drive (new drive letter and path) with more space. I'm note a DBA  but...I'm MQA, WFA and all the others admin roles. 
Op system is w2k. I know this can be done, is there a guide to do this?
Thanks!
Ramires |
|
| Back to top |
|
 |
| karthik |
| Posted: Fri Apr 29, 2005 4:36 pm Post subject: |
|
|
Centurion
Joined: 17 Oct 2003
Posts: 114
|
HI Ramires,
This is not something i have done before , but has asked a DBA on how we can do it. He suggested me somethings .. so i will put it here.
1) shutdown your workflow server.
2) There is a db2relocate command .. which will take care of most of the stuff .. but u have to know the details of the container locations , tablespaces etc;
Here is the link
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0004500.htm
3) Retstart ur workflow server.
You can try this on a test system and see if it works.
Please let us know , if it works.
Thanks
Karthik |
|
| Back to top |
|
|
| karthik |
| Posted: Sun May 01, 2005 4:30 pm Post subject: |
|
|
Centurion
Joined: 17 Oct 2003
Posts: 114
|
Hi Ramires
I have tried to test the same and it seems to be working.
This is the way i did it
1) Stop MQ workflow server
2) stop db2 ( db2stop)
3) Copy the folders in the location
C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB
to the New Location where you want these. These are the table space containers.
4) Run the db2relocatedb command.
Eg: db2relocatedb -f Migrate.conf ( Migrate.conf has the following entries
DB_NAME = FMCDB
DB_PATH = C:
INSTANCE = DB2
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\template",D:\template
5) In the .conf file you can have more than one CONT_PATH statement.
6) After the db2relocatedb is successful , start db2 (db2start)
and start MQWF.
7) Try to run some test instances in your workflow client.
Go to the new path of your table space containers and and you should be see modified time of those files to be the current time
 If thats the case , you can delete your old table space containers.
Hope , it helps.
Thanks
Karthik |
|
| Back to top |
|
|
| ramires |
| Posted: Mon May 02, 2005 7:13 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Thanks Karthik!
I did not try yet. But I'll follow your suggestion on move FMCDB to the a new path.
Regards,
ramires. |
|
| Back to top |
|
|
| ramires |
| Posted: Tue May 03, 2005 2:03 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
It didn't work. I have to investigate more. What i did was:
1) create a folder E:\DB2\FMCDB
2) copy all files and folders from D:\IBM\WMQ Workflow\rt_db\db2\FMCDB to E:\DB2\FMCDB
3) create a Migrate.conf like this
DB_NAME = FMCDB
DB_PATH = D:
INSTANCE = DB2
CONT_PATH = "D:\IBM\WMQ Workflow\rt_db\db2\FMCDB\template",E:\DB2\FMCDB\template
4) run db2relocatedb
db2relocatedb -f Migrate.conf
No changes to files or control structures were required.
DBT1000I The tool completed successfully.
5) delete files (i did a zip first) from D:\IBM\WMQ Workflow\rt_db\db2\FMCDB
6) start DB2 and try to connect to FMCDB. Fails with
db2 connect to fmcdb
SQL2036N The path for the file or device "d:\ibm\WMQ
Workflow\rt_db\DB2\FMCDB\NODE0000\" is not valid.
I guess missed some parameters. |
|
| Back to top |
|
|
| karthik |
| Posted: Tue May 03, 2005 10:00 pm Post subject: |
|
|
Centurion
Joined: 17 Oct 2003
Posts: 114
|
Hi Ramires ,
Sorry , I made a mistake of assuming lot of things and not going through the complete migration process in my last post.Looked like i was happy to see that the db2relocatedb works and tested in just one table space container.
I did a complete migration again using the db2relocatedb. Here is what i did ..
Only few things changed though.
1) Stopped MQWF
2) Stopped DB2
3) Zipped up all the files in <MQWF Dir>/rt_db/db2/FMCDB (saved them) and
then copied all the folders which looked like table spaces containers for MQWF to a new Drive.
This meant i copied all the folders except , tmp32 , NODE0000 ( This is in my case .. I am assuming these are not table spaces in my case)
4) ran the db2relocatedb with the following configuration file
DB_NAME = FMCDB
DB_PATH = C:
INSTANCE = DB2
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\actwi",D:\actwi
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\admin",D:\admin
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\adttrail",D:\adttrail
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\block",D:\block
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\blockact",D:\blockact
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\containr",D:\containr
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\gcontain",D:\gcontain
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\instindx",D:\instindx
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\list",D:\list
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\model",D:\model
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\ntfyitem",D:\ntfyitem
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\procact",D:\procact
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\process",D:\process
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\progact",D:\progact
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\staff",D:\staff
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\template",D:\template
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\topology",D:\topology
CONT_PATH = "C:\Program Files\IBM WebSphere MQ Workflow\rt_db\db2\FMCDB\workitem",D:\workitem
This is according to what i mentioned in my previous post
| Quote: |
| 5) In the .conf file you can have more than one CONT_PATH statement |
Also these containers may change based on what version of MQWF you are using.
5) After i saw the db2relocatedb command is successful , i started the db2 and MQWF later , and then checked for connectivity .. and it worked fine for me.
6) I also logged into my MQWF client , ran some test process instances and checked for which files got modified .. and i saw the files in the new drive and path are modified.
This is when i decided to delete the old files in the old path (except NODE0000 and tmp32 of course).
Hope it helps.
Please let me know if it works.
Thanks
Karthik |
|
| Back to top |
|
|
| ramires |
| Posted: Wed May 04, 2005 5:07 pm Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Thanks Karthik
But I've to investigate more. My FMCDB is under the default path, I managed to move the table space containers, using "*.*" as file mask in CONT_PATH.
But there are other directories belonging to FMCDB. I do a "db2 list tablespaces" and the result is 21 tbl spaces.
Then a "db2 list tablespace containers for 0" (for example) and it shows
container in "D:\DB2\NODE0000\SQL00004\"
This means there are data going to a default DB2 path because some DB2 instance defaults.
What I really want is to move all data related to FMCDB to a new physical drive (my case E)
I'll do more testing a post results after.
Regards,
ramires |
|
| Back to top |
|
|
| karthik |
| Posted: Thu May 05, 2005 7:52 am Post subject: |
|
|
Centurion
Joined: 17 Oct 2003
Posts: 114
|
Hi Ramires ,
I haven't tried to move the whole DB , but just the MQWF specific tablespace containers , which i assumed will grow more than anyother thing regarding a DB.
Since now you already know how to do it , please let us know how you moved the complete DB to the new path.
I also heard that you can take a backup of your DB and while restoring, it would ask the path where you want to put it.(We can enter the new path here).
Thanks
Karthik |
|
| Back to top |
|
|
| ramires |
| Posted: Thu May 05, 2005 2:28 pm Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Yes Karthik,
backup is a solution, but doing it with the db2relocatedb is an opportunity to learn more about db2 and FMCDB and other aspects related with wf management 
Not the easy way, but... I've the time to try.
Regards,
ramires |
|
| 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
|
|
|
|
