Seperating Data and Logging on a 8.03.4xx server

Thanks Ned.




________________________________
From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Monday, June 1, 2009 4:20:38 PM
Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server





Well, in terms of moving a DB, I would never just copy and paste the files
to move them. I would always reccomend doing a backup and restore instead.
That way the .b1 and other files move along with it.

Appserver logs are just a matter of either doing a change in the 2 spots
within the Appserver Properties, or you can also shutdown Progress
completely and do a find + Replace in the ubroker.properties file within the
oe101b\properties folder, a lot less clicks that way.

A similar find + Replace could be done in the Conmgr.properties file as well
when moving the DB as well, instead of clicking on each DB properties.

Alwaysmake a backup of those prior to making any changes that way if you
choose to, they can be tricky.

That .pf file should be the only other change you need to make.

You always need to be careful with any changes in OpenEdge because it is
very Case Sensative and sometimes even an extra space somewhere can cause a
problem.

This is the much simpler seperation of the possibilities, since it is
technically possible to split up the b1, a1, lg, db, and d1 files onto
seperate volumes(and even multiple files) as well, but that takes a lot more
work and can be fairly tricky at times, with rarely not much actual
performance gain other than personal piece of mind.

----- Original Message -----
From: "Ken Cary" <kencary@rocketmail. com>
To: <vantage@yahoogroups .com>
Sent: Monday, June 01, 2009 4:00 PM
Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server

> Ned,
>
> I figured out how to move the dbase. I moved the mfgsys.lg with it to the
> same directory. Otherwise, it follows it anyway. I moved the Appserver
> logs as well finally. That was alot easier than I was making it. So, my
> dbase is on the "Data Volume" I created. Now my AppServer, Task Server
> and Process Server Logs are located on the "Log Volume". I did have to
> change the database path in the Mfgsys.pf. Can you think of anything else
> I may need to change?
>
> Thanks Again for your responses
>
> Ken
>
>
>
>
> ____________ _________ _________ __
> From: Ned <TechnoBabbly@ gmail.com>
> To: vantage@yahoogroups .com
> Sent: Monday, June 1, 2009 3:14:39 PM
> Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server
>
>
>
>
>
> Which logging are you talking about? Appserver logs or database
> transaction
> logs?
>
> ----- Original Message -----
> From: "Ken Cary" <kencary@rocketmail . com>
> To: <vantage@yahoogroup s .com>
> Sent: Monday, June 01, 2009 1:54 PM
> Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server
>
>>I am running Vantage 8.03.4xx. We recently purchased a new server with
>>the
>>intention of being able to run RAID 10 and RAID 1 together. We created
>>multiple volumes. I now have
>>
>> Raid 1 C:\ OS
>> Raid 1 E:\ Apps
>> Raid 10 F:\ Data
>> Raid 1 G:\ Logging
>>
>> I installed Vantage on "E:\ Apps". Do any of you know how to now
>> separate
>> the data and logging files? I'm only testing this right now, but can't
>> seem to see where I can move these around.
>>
>> Your thoughts are much appreciated
>>
>> Ken
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------ --------- --------- ------
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>> have already linked your email address to a yahoo id to enable access. )
>> (1) To access the Files Section of our Yahoo!Group for Report Builder and
>> Crystal Reports and other 'goodies', please goto:
>> http://groups. yahoo.com/ group/vantage/ files/.
>> (2) To search through old msg's goto:
>> http://groups. yahoo.com/ group/vantage/ messages
>> (3) To view links to Vendors that provide Vantage services goto:
>> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>>
>>
>>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto:
> http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
>
>







[Non-text portions of this message have been removed]
I am running Vantage 8.03.4xx. We recently purchased a new server with the intention of being able to run RAID 10 and RAID 1 together. We created multiple volumes. I now have

Raid 1 C:\ OS
Raid 1 E:\ Apps
Raid 10 F:\ Data
Raid 1 G:\ Logging

I installed Vantage on "E:\ Apps". Do any of you know how to now separate the data and logging files? I'm only testing this right now, but can't seem to see where I can move these around.

Your thoughts are much appreciated

Ken





[Non-text portions of this message have been removed]
The disk layout looks good. I can tell you how to deal with MSSQL, but not Progress.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Cary
Sent: Monday, June 01, 2009 1:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server

I am running Vantage 8.03.4xx. We recently purchased a new server with the intention of being able to run RAID 10 and RAID 1 together. We created multiple volumes. I now have

Raid 1 C:\ OS
Raid 1 E:\ Apps
Raid 10 F:\ Data
Raid 1 G:\ Logging

I installed Vantage on "E:\ Apps". Do any of you know how to now separate the data and logging files? I'm only testing this right now, but can't seem to see where I can move these around.

Your thoughts are much appreciated

Ken





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Thanks Brian, but we are Progress. I have found several of the locations that reference the db path, but have been unsuccessful in getting the P.E.T to cooperate with a different path. Thanks for responding.

Ken




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Monday, June 1, 2009 2:37:47 PM
Subject: RE: [Vantage] Seperating Data and Logging on a 8.03.4xx server





The disk layout looks good. I can tell you how to deal with MSSQL, but not Progress.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Ken Cary
Sent: Monday, June 01, 2009 1:54 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server

I am running Vantage 8.03.4xx. We recently purchased a new server with the intention of being able to run RAID 10 and RAID 1 together. We created multiple volumes. I now have

Raid 1 C:\ OS
Raid 1 E:\ Apps
Raid 10 F:\ Data
Raid 1 G:\ Logging

I installed Vantage on "E:\ Apps". Do any of you know how to now separate the data and logging files? I'm only testing this right now, but can't seem to see where I can move these around.

Your thoughts are much appreciated

Ken

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]
Which logging are you talking about? Appserver logs or database transaction
logs?


----- Original Message -----
From: "Ken Cary" <kencary@...>
To: <vantage@yahoogroups.com>
Sent: Monday, June 01, 2009 1:54 PM
Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server


>I am running Vantage 8.03.4xx. We recently purchased a new server with the
>intention of being able to run RAID 10 and RAID 1 together. We created
>multiple volumes. I now have
>
> Raid 1 C:\ OS
> Raid 1 E:\ Apps
> Raid 10 F:\ Data
> Raid 1 G:\ Logging
>
> I installed Vantage on "E:\ Apps". Do any of you know how to now separate
> the data and logging files? I'm only testing this right now, but can't
> seem to see where I can move these around.
>
> Your thoughts are much appreciated
>
> Ken
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
Ned,

I figured out how to move the dbase. I moved the mfgsys.lg with it to the same directory. Otherwise, it follows it anyway. I moved the Appserver logs as well finally. That was alot easier than I was making it. So, my dbase is on the "Data Volume" I created. Now my AppServer, Task Server and Process Server Logs are located on the "Log Volume". I did have to change the database path in the Mfgsys.pf. Can you think of anything else I may need to change?

Thanks Again for your responses

Ken




________________________________
From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Monday, June 1, 2009 3:14:39 PM
Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server





Which logging are you talking about? Appserver logs or database transaction
logs?

----- Original Message -----
From: "Ken Cary" <kencary@rocketmail. com>
To: <vantage@yahoogroups .com>
Sent: Monday, June 01, 2009 1:54 PM
Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server

>I am running Vantage 8.03.4xx. We recently purchased a new server with the
>intention of being able to run RAID 10 and RAID 1 together. We created
>multiple volumes. I now have
>
> Raid 1 C:\ OS
> Raid 1 E:\ Apps
> Raid 10 F:\ Data
> Raid 1 G:\ Logging
>
> I installed Vantage on "E:\ Apps". Do any of you know how to now separate
> the data and logging files? I'm only testing this right now, but can't
> seem to see where I can move these around.
>
> Your thoughts are much appreciated
>
> Ken
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto:
> http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
>
>







[Non-text portions of this message have been removed]
Well, in terms of moving a DB, I would never just copy and paste the files
to move them. I would always reccomend doing a backup and restore instead.
That way the .b1 and other files move along with it.

Appserver logs are just a matter of either doing a change in the 2 spots
within the Appserver Properties, or you can also shutdown Progress
completely and do a find + Replace in the ubroker.properties file within the
oe101b\properties folder, a lot less clicks that way.

A similar find + Replace could be done in the Conmgr.properties file as well
when moving the DB as well, instead of clicking on each DB properties.

Alwaysmake a backup of those prior to making any changes that way if you
choose to, they can be tricky.

That .pf file should be the only other change you need to make.

You always need to be careful with any changes in OpenEdge because it is
very Case Sensative and sometimes even an extra space somewhere can cause a
problem.

This is the much simpler seperation of the possibilities, since it is
technically possible to split up the b1, a1, lg, db, and d1 files onto
seperate volumes(and even multiple files) as well, but that takes a lot more
work and can be fairly tricky at times, with rarely not much actual
performance gain other than personal piece of mind.



----- Original Message -----
From: "Ken Cary" <kencary@...>
To: <vantage@yahoogroups.com>
Sent: Monday, June 01, 2009 4:00 PM
Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server


> Ned,
>
> I figured out how to move the dbase. I moved the mfgsys.lg with it to the
> same directory. Otherwise, it follows it anyway. I moved the Appserver
> logs as well finally. That was alot easier than I was making it. So, my
> dbase is on the "Data Volume" I created. Now my AppServer, Task Server
> and Process Server Logs are located on the "Log Volume". I did have to
> change the database path in the Mfgsys.pf. Can you think of anything else
> I may need to change?
>
> Thanks Again for your responses
>
> Ken
>
>
>
>
> ________________________________
> From: Ned <TechnoBabbly@...>
> To: vantage@yahoogroups.com
> Sent: Monday, June 1, 2009 3:14:39 PM
> Subject: Re: [Vantage] Seperating Data and Logging on a 8.03.4xx server
>
>
>
>
>
> Which logging are you talking about? Appserver logs or database
> transaction
> logs?
>
> ----- Original Message -----
> From: "Ken Cary" <kencary@rocketmail. com>
> To: <vantage@yahoogroups .com>
> Sent: Monday, June 01, 2009 1:54 PM
> Subject: [Vantage] Seperating Data and Logging on a 8.03.4xx server
>
>>I am running Vantage 8.03.4xx. We recently purchased a new server with
>>the
>>intention of being able to run RAID 10 and RAID 1 together. We created
>>multiple volumes. I now have
>>
>> Raid 1 C:\ OS
>> Raid 1 E:\ Apps
>> Raid 10 F:\ Data
>> Raid 1 G:\ Logging
>>
>> I installed Vantage on "E:\ Apps". Do any of you know how to now
>> separate
>> the data and logging files? I'm only testing this right now, but can't
>> seem to see where I can move these around.
>>
>> Your thoughts are much appreciated
>>
>> Ken
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------ --------- --------- ------
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>> have already linked your email address to a yahoo id to enable access. )
>> (1) To access the Files Section of our Yahoo!Group for Report Builder and
>> Crystal Reports and other 'goodies', please goto:
>> http://groups. yahoo.com/ group/vantage/ files/.
>> (2) To search through old msg's goto:
>> http://groups. yahoo.com/ group/vantage/ messages
>> (3) To view links to Vendors that provide Vantage services goto:
>> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>>
>>
>>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>