To go back to my original point that I mentioned before, if you are running
SQL on a separate box from Epicor or Vantage, then you should be setting up
your SQL Server as your admin workstation and using a local Schema holder
and not using TCP at all to connect to them, this has shown anywhere from a
10-25% increase in overall speed for conversions from my experience.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Greg Payne
Sent: Monday, May 28, 2012 10:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: 9.05.700 from 9.05.607a Upgrade Question
There is one for each database.
I made mine by copying mfgsys.pf and changing one line. There is also a set
on the SQL server.
Greg
This line from mfgsys.pf -db
"E:\Epicor905\\db\newdb\mfgsyssh" -RO
Changes to this in TCP. -db mfgsyssh -H SVR-EAPP -S 9400
referencing the application server and the port number for that db.
mfgsys.pf
-Mm 1024 -mmax 65534 -B 200000 -Bt 8192 -s 8000 -yy 1970 -stsh 31 -inp 32000
-tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8
-rereadnolock -lkwtmo 180
-disabledeltrig
-T "E:\EpicorData\"
-db "E:\Epicor905\\db\newdb\mfgsyssh" -RO -db Epicor905 -dt MSS -ld mfgsys
-Dsrv
PRGRS_CONNECT,DSN=Epicor905,TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGR
S_NOWAIT_OVERRIDE,1
mfgsysTCP.pf
-Mm 1024 -mmax 65534 -B 200000 -Bt 8192 -s 8000 -yy 1970 -stsh 31 -inp 32000
-tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8
-rereadnolock -lkwtmo 180 -T "E:\EpicorData\"
-disabledeltrig
-db mfgsyssh -H SVR-EAPP -S 9400
-db Epicor905 -dt MSS -ld Mfgsys -Dsrv
PRGRS_CONNECT,DSN=Epicor905,TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGR
S_NOWAIT_OVERRIDE,1
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joshua
Sent: Monday, May 28, 2012 7:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 9.05.700 from 9.05.607a Upgrade Question
Can someone put a copy of what the TCP files look like. The instructions
only list a partial. Are there multiple TCP files or just one for each
database (Pilot, Live, test) ect.
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Tim
Vonderhaar" <tvonderhaar@...<mailto:tvonderhaar@...>> wrote:
with Epicor, the update instructions will be changed at some point to
reflect what needs done for an upgrade scenario.
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is
privileged and confidential. It is intended only for the exclusive use of
the addressee. If the reader of this message is not the intended recipient,
or the employee or agent responsible for delivering it to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify us at (727) 578-6258 and
immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the
International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of
this material is restricted by the Arms Export Control Act (22 U.S.C. 2751
et seq.) and may not be exported to foreign persons without prior approval
form the U.S. Department of State."
[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
SQL on a separate box from Epicor or Vantage, then you should be setting up
your SQL Server as your admin workstation and using a local Schema holder
and not using TCP at all to connect to them, this has shown anywhere from a
10-25% increase in overall speed for conversions from my experience.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Greg Payne
Sent: Monday, May 28, 2012 10:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: 9.05.700 from 9.05.607a Upgrade Question
There is one for each database.
I made mine by copying mfgsys.pf and changing one line. There is also a set
on the SQL server.
Greg
This line from mfgsys.pf -db
"E:\Epicor905\\db\newdb\mfgsyssh" -RO
Changes to this in TCP. -db mfgsyssh -H SVR-EAPP -S 9400
referencing the application server and the port number for that db.
mfgsys.pf
-Mm 1024 -mmax 65534 -B 200000 -Bt 8192 -s 8000 -yy 1970 -stsh 31 -inp 32000
-tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8
-rereadnolock -lkwtmo 180
-disabledeltrig
-T "E:\EpicorData\"
-db "E:\Epicor905\\db\newdb\mfgsyssh" -RO -db Epicor905 -dt MSS -ld mfgsys
-Dsrv
PRGRS_CONNECT,DSN=Epicor905,TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGR
S_NOWAIT_OVERRIDE,1
mfgsysTCP.pf
-Mm 1024 -mmax 65534 -B 200000 -Bt 8192 -s 8000 -yy 1970 -stsh 31 -inp 32000
-tok 4000 -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8
-rereadnolock -lkwtmo 180 -T "E:\EpicorData\"
-disabledeltrig
-db mfgsyssh -H SVR-EAPP -S 9400
-db Epicor905 -dt MSS -ld Mfgsys -Dsrv
PRGRS_CONNECT,DSN=Epicor905,TXN_ISOLATION,1,PRGRS_NATIVE_LOCKWAIT,30000,PRGR
S_NOWAIT_OVERRIDE,1
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joshua
Sent: Monday, May 28, 2012 7:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 9.05.700 from 9.05.607a Upgrade Question
Can someone put a copy of what the TCP files look like. The instructions
only list a partial. Are there multiple TCP files or just one for each
database (Pilot, Live, test) ect.
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Tim
Vonderhaar" <tvonderhaar@...<mailto:tvonderhaar@...>> wrote:
>the install is new. They do not get created during an upgrade. After talking
>
>
> Thanks Ned.
>
> To close the loop, the TCP files are new to 700 and are not created unless
with Epicor, the update instructions will be changed at some point to
reflect what needs done for an upgrade scenario.
><TechnoBabbly@> wrote:
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Ned C."
> >this?
> > The best solution I have found, is to have OpenEdge on your SQL
> > server, and install the client from your Epicor Server, and allow it
> > to create the Admin Tool and Schema Change Icons for you.
> >
> > Then, as an extra step, change the -db line in the .pf files to not
> > use the TCP settings.
> >
> > Instead, take a backup of the schema holder from your epicor server,
> > restore it to the SQL server somewhere, and use that as a reference
> > instead, then everything will run locally on the SQL server since
> > that's where your data is located anyway.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]
> > On Behalf Of Tim Vonderhaar
> > Sent: Monday, May 14, 2012 11:56 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] 9.05.700 from 9.05.607a Upgrade Question
> >
> > I have begun upgrading out test environment with the 700 release and
> > have run into a snag with the documentation. In our case, we have
> > SQL on a different server than Epicor. According to the upgrade
> > instructions, section 5.2, Update Parameter File for Multi-Server
> > Configuration, calls to update mfg*TCP.pf files in the Server\Config
> > folder. In our case, I cannot find any *TCP.pf in that folder or
> > anywhere else on the server. I called support and they aren't sure
> > if they are created during a fresh install only or should have been
> > created during the upgrade. Either way, they are looking into it and
> > I'm waiting for a response before I continue. Anyone with experience on
> >________________________________
> > Tim
> >
> >
> >
> > ------------------------------------
> >
> > 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/.<http://groups.yahoo.co
> > m/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
> >
>
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is
privileged and confidential. It is intended only for the exclusive use of
the addressee. If the reader of this message is not the intended recipient,
or the employee or agent responsible for delivering it to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify us at (727) 578-6258 and
immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the
International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of
this material is restricted by the Arms Export Control Act (22 U.S.C. 2751
et seq.) and may not be exported to foreign persons without prior approval
form the U.S. Department of State."
[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