Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Powerdynamo for ASA 6.0.1 vs ASE 11.9.2

23 posts in General Discussion (old) Last posting was on 2000-03-22 20:16:52.0Z
Brad McLeod Posted on 2000-03-18 01:16:34.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Fri, 17 Mar 2000 19:16:34 -0600
Lines: 29
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: 153.tulsa-03-04rs.ok.dial-access.att.net 12.74.161.153
Message-ID: <347_yGKbKhHk$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26150
Article PK: 154387

We have recently migrated our backend database from ASA 6.0.1 to ASE 11.9.2.
We are running a web-based application that uses a PowerDynamo database
under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
retrieval. Since this migration of the ASA database to ASE, we have been
experiencing some REALLY FLACKY issues under this configuration. ODBC
connections that were previously working unattended under a straight ASA
environment, now tend to become unavailable under the ASA/ASE configuration
and have caused us to either (1) reboot, or (2) delete the ASE ODBC
connection and rebuild the ASE ODBC connection in order to access the 11.9.2
backend.

My question is in two parts: (1) is there a difference between the PD
component that is supplied with ASA and that which is supplied with ASE?
(2) Should we move our current PD website database from ASA into ASE so that
the website database and the data database are on the same connection or is
what we are doing - read that as the PD database and existing connection
within an ASA environment and the actual data db existing within an ASE
environment -should work without connectivity issues?

I realize that there are some really quirky issues regarding component
integration that Sybase is aware of so if we need to establish the PD
database under the same ASE database world...I'll understand.

TIA

Brad McLeod


Carson Hager[Team Sybase] Posted on 2000-03-19 17:59:21.0Z
Newsgroups: sybase.public.easerver
From: chager@dyn-data.com (Carson Hager[Team Sybase])
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Sun, 19 Mar 2000 17:59:21 GMT
Organization: Dynamic Data Solutions, Inc.
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 68
NNTP-Posting-Host: user-33qs0hq.dialup.mindspring.com 199.174.2.58
Message-ID: <347_38d5152b.2237968@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26112
Article PK: 156114

Brad,

Have you tried an OpenClient connection to the ASE data db ( as
opposed to site content db )?

As Larry mentioned, unless you are using scheduled scripts or you need
to replicate the content, a dynamic file site is a much better choice.
Dynamic file sites simply have the .stm/.ssc files on the file system
instead of in the database.


Carson

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training
http://www.dyn-data.com

DDS is now hiring EAServer consultants
to support its exploding EAServer business!
Please submit your resume to
hr@dyn-data.com!


On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"

<brad.mcleod@worldnet.att.net> wrote:

>We have recently migrated our backend database from ASA 6.0.1 to ASE 11.9.2.
>We are running a web-based application that uses a PowerDynamo database
>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>retrieval. Since this migration of the ASA database to ASE, we have been
>experiencing some REALLY FLACKY issues under this configuration. ODBC
>connections that were previously working unattended under a straight ASA
>environment, now tend to become unavailable under the ASA/ASE configuration
>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>connection and rebuild the ASE ODBC connection in order to access the 11.9.2
>backend.
>
>My question is in two parts: (1) is there a difference between the PD
>component that is supplied with ASA and that which is supplied with ASE?
>(2) Should we move our current PD website database from ASA into ASE so that
>the website database and the data database are on the same connection or is
>what we are doing - read that as the PD database and existing connection
>within an ASA environment and the actual data db existing within an ASE
>environment -should work without connectivity issues?
>
>I realize that there are some really quirky issues regarding component
>integration that Sybase is aware of so if we need to establish the PD
>database under the same ASE database world...I'll understand.
>
>TIA
>
>Brad McLeod
>
>
>

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training

DDS Enterprise Application Framework
Available Now as Open Source!
http://www.dyn-data.com


Brad McLeod Posted on 2000-03-19 22:20:26.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Sun, 19 Mar 2000 16:20:26 -0600
Lines: 115
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: 13.tulsa-01-02rs.ok.dial-access.att.net 12.74.160.13
Message-ID: <347_tjrsRIfk$GA.285@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26108
Article PK: 156110

Carson -

No, we have not attempted a connection via Open Client as our previous ODBC
connection worked just fine under ASA. As we ported the application over to
the new backend (ASE 11.9.2) we experienced some rather weird conditions in
PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
are experiencing similiar issues again. Here's what happens:

We establish an ODBC connection in Jaguar which works for about 24 hours and
then - due to the ASE database locking - we reboot and then the previously
established connection is gone!! We re-establish the connection and
everything seems to be OK until all of a sudden, access to the web pages in
PowerDynamo (which are stored in ASA) become unavailable. There is nothing
in any of the logs that point to whats happened. We then go in, delete the
PowerDynamo connection, re-establish the connection via ODBA Admin, and the
things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!

We are all really confused and, at time, I feel that we are grasping at
straw!! All of our development staff are up to speed with the various
Sybase components we are using and nobody has seen anything like this before
in their professional careers.

So, back to my previous questions, should we move our PowerDynamo website
database into an ASE environment? Is the PowerDynamo component delivered
with ASE different than the one deployed with ASA?

I'd appreciate any input at this point. This application is now scheduled
to move into production at the end of the month - we have been delayed due
to the various issues we've already had with Sybase's products.

TIA

Brad McLeod

Carson Hager[Team Sybase] wrote in message
<38d5152b.2237968@forums.sybase.com>...
>Brad,
>
>Have you tried an OpenClient connection to the ASE data db ( as
>opposed to site content db )?
>
>As Larry mentioned, unless you are using scheduled scripts or you need
>to replicate the content, a dynamic file site is a much better choice.
>Dynamic file sites simply have the .stm/.ssc files on the file system
>instead of in the database.
>
>
>Carson
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
><brad.mcleod@worldnet.att.net> wrote:
>
>>We have recently migrated our backend database from ASA 6.0.1 to ASE
11.9.2.
>>We are running a web-based application that uses a PowerDynamo database
>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>retrieval. Since this migration of the ASA database to ASE, we have been
>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>connections that were previously working unattended under a straight ASA
>>environment, now tend to become unavailable under the ASA/ASE
configuration
>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>connection and rebuild the ASE ODBC connection in order to access the
11.9.2
>>backend.
>>
>>My question is in two parts: (1) is there a difference between the PD
>>component that is supplied with ASA and that which is supplied with ASE?
>>(2) Should we move our current PD website database from ASA into ASE so
that
>>the website database and the data database are on the same connection or
is
>>what we are doing - read that as the PD database and existing connection
>>within an ASA environment and the actual data db existing within an ASE
>>environment -should work without connectivity issues?
>>
>>I realize that there are some really quirky issues regarding component
>>integration that Sybase is aware of so if we need to establish the PD
>>database under the same ASE database world...I'll understand.
>>
>>TIA
>>
>>Brad McLeod
>>
>>
>>
>
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Carson Hager[Team Sybase] Posted on 2000-03-20 20:45:39.0Z
Newsgroups: sybase.public.easerver
From: chager@dyn-data.com (Carson Hager[Team Sybase])
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 20:45:39 GMT
Organization: Dynamic Data Solutions, Inc.
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 141
NNTP-Posting-Host: charon.lifescape.com 63.86.26.130
Message-ID: <347_38d68ddd.14489464@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26066
Article PK: 156070

My recommendation is to use a dynamic file site and Open Client
connection to your data.


Carson

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training
http://www.dyn-data.com

DDS is now hiring EAServer consultants
to support its exploding EAServer business!
Please submit your resume to
hr@dyn-data.com!


On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"

<brad.mcleod@worldnet.att.net> wrote:

>Carson -
>
>No, we have not attempted a connection via Open Client as our previous ODBC
>connection worked just fine under ASA. As we ported the application over to
>the new backend (ASE 11.9.2) we experienced some rather weird conditions in
>PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
>are experiencing similiar issues again. Here's what happens:
>
>We establish an ODBC connection in Jaguar which works for about 24 hours and
>then - due to the ASE database locking - we reboot and then the previously
>established connection is gone!! We re-establish the connection and
>everything seems to be OK until all of a sudden, access to the web pages in
>PowerDynamo (which are stored in ASA) become unavailable. There is nothing
>in any of the logs that point to whats happened. We then go in, delete the
>PowerDynamo connection, re-establish the connection via ODBA Admin, and the
>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>
>We are all really confused and, at time, I feel that we are grasping at
>straw!! All of our development staff are up to speed with the various
>Sybase components we are using and nobody has seen anything like this before
>in their professional careers.
>
>So, back to my previous questions, should we move our PowerDynamo website
>database into an ASE environment? Is the PowerDynamo component delivered
>with ASE different than the one deployed with ASA?
>
>I'd appreciate any input at this point. This application is now scheduled
>to move into production at the end of the month - we have been delayed due
>to the various issues we've already had with Sybase's products.
>
>TIA
>
>Brad McLeod
>
>Carson Hager[Team Sybase] wrote in message
><38d5152b.2237968@forums.sybase.com>...
>>Brad,
>>
>>Have you tried an OpenClient connection to the ASE data db ( as
>>opposed to site content db )?
>>
>>As Larry mentioned, unless you are using scheduled scripts or you need
>>to replicate the content, a dynamic file site is a much better choice.
>>Dynamic file sites simply have the .stm/.ssc files on the file system
>>instead of in the database.
>>
>>
>>Carson
>>
>>___________________________________________________________
>>
>>Carson Hager
>>Team Sybase
>>Dynamic Data Solutions, Inc.
>>Enterprise Application Studio 3.0 Consulting and Training
>>http://www.dyn-data.com
>>
>> DDS is now hiring EAServer consultants
>> to support its exploding EAServer business!
>> Please submit your resume to
>> hr@dyn-data.com!
>>
>>
>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>><brad.mcleod@worldnet.att.net> wrote:
>>
>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
>11.9.2.
>>>We are running a web-based application that uses a PowerDynamo database
>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>>retrieval. Since this migration of the ASA database to ASE, we have been
>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>>connections that were previously working unattended under a straight ASA
>>>environment, now tend to become unavailable under the ASA/ASE
>configuration
>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>>connection and rebuild the ASE ODBC connection in order to access the
>11.9.2
>>>backend.
>>>
>>>My question is in two parts: (1) is there a difference between the PD
>>>component that is supplied with ASA and that which is supplied with ASE?
>>>(2) Should we move our current PD website database from ASA into ASE so
>that
>>>the website database and the data database are on the same connection or
>is
>>>what we are doing - read that as the PD database and existing connection
>>>within an ASA environment and the actual data db existing within an ASE
>>>environment -should work without connectivity issues?
>>>
>>>I realize that there are some really quirky issues regarding component
>>>integration that Sybase is aware of so if we need to establish the PD
>>>database under the same ASE database world...I'll understand.
>>>
>>>TIA
>>>
>>>Brad McLeod
>>>
>>>
>>>
>>
>>
>>___________________________________________________________
>>
>>Carson Hager
>>Team Sybase
>>Dynamic Data Solutions, Inc.
>>Enterprise Application Studio 3.0 Consulting and Training
>>
>> DDS Enterprise Application Framework
>> Available Now as Open Source!
>> http://www.dyn-data.com
>>
>
>

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training

DDS Enterprise Application Framework
Available Now as Open Source!
http://www.dyn-data.com


Brad McLeod Posted on 2000-03-20 21:57:56.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 15:57:56 -0600
Lines: 178
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Message-ID: <347_6R7mMgrk$GA.201@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26051
Article PK: 156055

Carson -

One other point. Since we are using the HTML DataWindow provided with EA
Studio, why would we want to go back and modify all of our PD scripts? As I
mentioned, this application is heavy into the various EA Studio components
and we also use alot of the PD scripting in our various pages so for what
reason should we go to a dynamic web-based file system?

TIA

Brad McLeod

Carson Hager[Team Sybase] wrote in message
<38d68ddd.14489464@forums.sybase.com>...
>My recommendation is to use a dynamic file site and Open Client
>connection to your data.
>
>
>Carson
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
>On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
><brad.mcleod@worldnet.att.net> wrote:
>
>>Carson -
>>
>>No, we have not attempted a connection via Open Client as our previous
ODBC
>>connection worked just fine under ASA. As we ported the application over
to
>>the new backend (ASE 11.9.2) we experienced some rather weird conditions
in
>>PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
>>are experiencing similiar issues again. Here's what happens:
>>
>>We establish an ODBC connection in Jaguar which works for about 24 hours
and
>>then - due to the ASE database locking - we reboot and then the previously
>>established connection is gone!! We re-establish the connection and
>>everything seems to be OK until all of a sudden, access to the web pages
in
>>PowerDynamo (which are stored in ASA) become unavailable. There is
nothing
>>in any of the logs that point to whats happened. We then go in, delete
the
>>PowerDynamo connection, re-establish the connection via ODBA Admin, and
the
>>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>>
>>We are all really confused and, at time, I feel that we are grasping at
>>straw!! All of our development staff are up to speed with the various
>>Sybase components we are using and nobody has seen anything like this
before
>>in their professional careers.
>>
>>So, back to my previous questions, should we move our PowerDynamo website
>>database into an ASE environment? Is the PowerDynamo component delivered
>>with ASE different than the one deployed with ASA?
>>
>>I'd appreciate any input at this point. This application is now scheduled
>>to move into production at the end of the month - we have been delayed due
>>to the various issues we've already had with Sybase's products.
>>
>>TIA
>>
>>Brad McLeod
>>
>>Carson Hager[Team Sybase] wrote in message
>><38d5152b.2237968@forums.sybase.com>...
>>>Brad,
>>>
>>>Have you tried an OpenClient connection to the ASE data db ( as
>>>opposed to site content db )?
>>>
>>>As Larry mentioned, unless you are using scheduled scripts or you need
>>>to replicate the content, a dynamic file site is a much better choice.
>>>Dynamic file sites simply have the .stm/.ssc files on the file system
>>>instead of in the database.
>>>
>>>
>>>Carson
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>http://www.dyn-data.com
>>>
>>> DDS is now hiring EAServer consultants
>>> to support its exploding EAServer business!
>>> Please submit your resume to
>>> hr@dyn-data.com!
>>>
>>>
>>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>>><brad.mcleod@worldnet.att.net> wrote:
>>>
>>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
>>11.9.2.
>>>>We are running a web-based application that uses a PowerDynamo database
>>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>>>retrieval. Since this migration of the ASA database to ASE, we have
been
>>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>>>connections that were previously working unattended under a straight ASA
>>>>environment, now tend to become unavailable under the ASA/ASE
>>configuration
>>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>>>connection and rebuild the ASE ODBC connection in order to access the
>>11.9.2
>>>>backend.
>>>>
>>>>My question is in two parts: (1) is there a difference between the PD
>>>>component that is supplied with ASA and that which is supplied with ASE?
>>>>(2) Should we move our current PD website database from ASA into ASE so
>>that
>>>>the website database and the data database are on the same connection or
>>is
>>>>what we are doing - read that as the PD database and existing
connection
>>>>within an ASA environment and the actual data db existing within an ASE
>>>>environment -should work without connectivity issues?
>>>>
>>>>I realize that there are some really quirky issues regarding component
>>>>integration that Sybase is aware of so if we need to establish the PD
>>>>database under the same ASE database world...I'll understand.
>>>>
>>>>TIA
>>>>
>>>>Brad McLeod
>>>>
>>>>
>>>>
>>>
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>
>>> DDS Enterprise Application Framework
>>> Available Now as Open Source!
>>> http://www.dyn-data.com
>>>
>>
>>
>
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Larry Cermak[Team Sybase] Posted on 2000-03-20 22:26:03.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 16:26:03 -0600
Lines: 212
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_e6AFxyrk$GA.201@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26047
Article PK: 154382

Brad,

If you switch to a dynamic file site it has no effect on your PD scripts.
All that a dynamic file site does is store the server-side scripts and
resources on the file system instead of a database.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Brad McLeod" <brad.mcleod@worldnet.att.net> wrote in message
news:6R7mMgrk$GA.201@forums.sybase.com...
> Carson -
>
> One other point. Since we are using the HTML DataWindow provided with EA
> Studio, why would we want to go back and modify all of our PD scripts? As
I
> mentioned, this application is heavy into the various EA Studio components
> and we also use alot of the PD scripting in our various pages so for what
> reason should we go to a dynamic web-based file system?
>
> TIA
>
> Brad McLeod
>
> Carson Hager[Team Sybase] wrote in message
> <38d68ddd.14489464@forums.sybase.com>...
> >My recommendation is to use a dynamic file site and Open Client
> >connection to your data.
> >
> >
> >Carson
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >http://www.dyn-data.com
> >
> > DDS is now hiring EAServer consultants
> > to support its exploding EAServer business!
> > Please submit your resume to
> > hr@dyn-data.com!
> >
> >
> >On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
> ><brad.mcleod@worldnet.att.net> wrote:
> >
> >>Carson -
> >>
> >>No, we have not attempted a connection via Open Client as our previous
> ODBC
> >>connection worked just fine under ASA. As we ported the application
over
> to
> >>the new backend (ASE 11.9.2) we experienced some rather weird conditions
> in
> >>PowerDyamo and Jaguar. We had thought that these issues were fixed yet
we
> >>are experiencing similiar issues again. Here's what happens:
> >>
> >>We establish an ODBC connection in Jaguar which works for about 24 hours
> and
> >>then - due to the ASE database locking - we reboot and then the
previously
> >>established connection is gone!! We re-establish the connection and
> >>everything seems to be OK until all of a sudden, access to the web pages
> in
> >>PowerDynamo (which are stored in ASA) become unavailable. There is
> nothing
> >>in any of the logs that point to whats happened. We then go in, delete
> the
> >>PowerDynamo connection, re-establish the connection via ODBA Admin, and
> the
> >>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
> >>
> >>We are all really confused and, at time, I feel that we are grasping at
> >>straw!! All of our development staff are up to speed with the various
> >>Sybase components we are using and nobody has seen anything like this
> before
> >>in their professional careers.
> >>
> >>So, back to my previous questions, should we move our PowerDynamo
website
> >>database into an ASE environment? Is the PowerDynamo component
delivered
> >>with ASE different than the one deployed with ASA?
> >>
> >>I'd appreciate any input at this point. This application is now
scheduled
> >>to move into production at the end of the month - we have been delayed
due
> >>to the various issues we've already had with Sybase's products.
> >>
> >>TIA
> >>
> >>Brad McLeod
> >>
> >>Carson Hager[Team Sybase] wrote in message
> >><38d5152b.2237968@forums.sybase.com>...
> >>>Brad,
> >>>
> >>>Have you tried an OpenClient connection to the ASE data db ( as
> >>>opposed to site content db )?
> >>>
> >>>As Larry mentioned, unless you are using scheduled scripts or you need
> >>>to replicate the content, a dynamic file site is a much better choice.
> >>>Dynamic file sites simply have the .stm/.ssc files on the file system
> >>>instead of in the database.
> >>>
> >>>
> >>>Carson
> >>>
> >>>___________________________________________________________
> >>>
> >>>Carson Hager
> >>>Team Sybase
> >>>Dynamic Data Solutions, Inc.
> >>>Enterprise Application Studio 3.0 Consulting and Training
> >>>http://www.dyn-data.com
> >>>
> >>> DDS is now hiring EAServer consultants
> >>> to support its exploding EAServer business!
> >>> Please submit your resume to
> >>> hr@dyn-data.com!
> >>>
> >>>
> >>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
> >>><brad.mcleod@worldnet.att.net> wrote:
> >>>
> >>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
> >>11.9.2.
> >>>>We are running a web-based application that uses a PowerDynamo
database
> >>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
> >>>>retrieval. Since this migration of the ASA database to ASE, we have
> been
> >>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
> >>>>connections that were previously working unattended under a straight
ASA
> >>>>environment, now tend to become unavailable under the ASA/ASE
> >>configuration
> >>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
> >>>>connection and rebuild the ASE ODBC connection in order to access the
> >>11.9.2
> >>>>backend.
> >>>>
> >>>>My question is in two parts: (1) is there a difference between the
PD
> >>>>component that is supplied with ASA and that which is supplied with
ASE?
> >>>>(2) Should we move our current PD website database from ASA into ASE
so
> >>that
> >>>>the website database and the data database are on the same connection
or
> >>is
> >>>>what we are doing - read that as the PD database and existing
> connection
> >>>>within an ASA environment and the actual data db existing within an
ASE
> >>>>environment -should work without connectivity issues?
> >>>>
> >>>>I realize that there are some really quirky issues regarding component
> >>>>integration that Sybase is aware of so if we need to establish the PD
> >>>>database under the same ASE database world...I'll understand.
> >>>>
> >>>>TIA
> >>>>
> >>>>Brad McLeod
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>___________________________________________________________
> >>>
> >>>Carson Hager
> >>>Team Sybase
> >>>Dynamic Data Solutions, Inc.
> >>>Enterprise Application Studio 3.0 Consulting and Training
> >>>
> >>> DDS Enterprise Application Framework
> >>> Available Now as Open Source!
> >>> http://www.dyn-data.com
> >>>
> >>
> >>
> >
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >
> > DDS Enterprise Application Framework
> > Available Now as Open Source!
> > http://www.dyn-data.com
> >
>
>


Carson Hager[Team Sybase] Posted on 2000-03-21 01:27:05.0Z
Newsgroups: sybase.public.easerver
From: chager@dyn-data.com (Carson Hager[Team Sybase])
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Tue, 21 Mar 2000 01:27:05 GMT
Organization: Dynamic Data Solutions, Inc.
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 185
NNTP-Posting-Host: charon.lifescape.com 63.86.26.130
Message-ID: <347_38d6cfd3.31375105@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26043
Article PK: 156050

This requires no change. Why move to a dynamic file site? Better
performance.


Carson

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training
http://www.dyn-data.com

DDS is now hiring EAServer consultants
to support its exploding EAServer business!
Please submit your resume to
hr@dyn-data.com!


On Mon, 20 Mar 2000 15:57:56 -0600, "Brad McLeod"

<brad.mcleod@worldnet.att.net> wrote:

>Carson -
>
>One other point. Since we are using the HTML DataWindow provided with EA
>Studio, why would we want to go back and modify all of our PD scripts? As I
>mentioned, this application is heavy into the various EA Studio components
>and we also use alot of the PD scripting in our various pages so for what
>reason should we go to a dynamic web-based file system?
>
>TIA
>
>Brad McLeod
>
>Carson Hager[Team Sybase] wrote in message
><38d68ddd.14489464@forums.sybase.com>...
>>My recommendation is to use a dynamic file site and Open Client
>>connection to your data.
>>
>>
>>Carson
>>
>>___________________________________________________________
>>
>>Carson Hager
>>Team Sybase
>>Dynamic Data Solutions, Inc.
>>Enterprise Application Studio 3.0 Consulting and Training
>>http://www.dyn-data.com
>>
>> DDS is now hiring EAServer consultants
>> to support its exploding EAServer business!
>> Please submit your resume to
>> hr@dyn-data.com!
>>
>>
>>On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
>><brad.mcleod@worldnet.att.net> wrote:
>>
>>>Carson -
>>>
>>>No, we have not attempted a connection via Open Client as our previous
>ODBC
>>>connection worked just fine under ASA. As we ported the application over
>to
>>>the new backend (ASE 11.9.2) we experienced some rather weird conditions
>in
>>>PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
>>>are experiencing similiar issues again. Here's what happens:
>>>
>>>We establish an ODBC connection in Jaguar which works for about 24 hours
>and
>>>then - due to the ASE database locking - we reboot and then the previously
>>>established connection is gone!! We re-establish the connection and
>>>everything seems to be OK until all of a sudden, access to the web pages
>in
>>>PowerDynamo (which are stored in ASA) become unavailable. There is
>nothing
>>>in any of the logs that point to whats happened. We then go in, delete
>the
>>>PowerDynamo connection, re-establish the connection via ODBA Admin, and
>the
>>>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>>>
>>>We are all really confused and, at time, I feel that we are grasping at
>>>straw!! All of our development staff are up to speed with the various
>>>Sybase components we are using and nobody has seen anything like this
>before
>>>in their professional careers.
>>>
>>>So, back to my previous questions, should we move our PowerDynamo website
>>>database into an ASE environment? Is the PowerDynamo component delivered
>>>with ASE different than the one deployed with ASA?
>>>
>>>I'd appreciate any input at this point. This application is now scheduled
>>>to move into production at the end of the month - we have been delayed due
>>>to the various issues we've already had with Sybase's products.
>>>
>>>TIA
>>>
>>>Brad McLeod
>>>
>>>Carson Hager[Team Sybase] wrote in message
>>><38d5152b.2237968@forums.sybase.com>...
>>>>Brad,
>>>>
>>>>Have you tried an OpenClient connection to the ASE data db ( as
>>>>opposed to site content db )?
>>>>
>>>>As Larry mentioned, unless you are using scheduled scripts or you need
>>>>to replicate the content, a dynamic file site is a much better choice.
>>>>Dynamic file sites simply have the .stm/.ssc files on the file system
>>>>instead of in the database.
>>>>
>>>>
>>>>Carson
>>>>
>>>>___________________________________________________________
>>>>
>>>>Carson Hager
>>>>Team Sybase
>>>>Dynamic Data Solutions, Inc.
>>>>Enterprise Application Studio 3.0 Consulting and Training
>>>>http://www.dyn-data.com
>>>>
>>>> DDS is now hiring EAServer consultants
>>>> to support its exploding EAServer business!
>>>> Please submit your resume to
>>>> hr@dyn-data.com!
>>>>
>>>>
>>>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>>>><brad.mcleod@worldnet.att.net> wrote:
>>>>
>>>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
>>>11.9.2.
>>>>>We are running a web-based application that uses a PowerDynamo database
>>>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>>>>retrieval. Since this migration of the ASA database to ASE, we have
>been
>>>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>>>>connections that were previously working unattended under a straight ASA
>>>>>environment, now tend to become unavailable under the ASA/ASE
>>>configuration
>>>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>>>>connection and rebuild the ASE ODBC connection in order to access the
>>>11.9.2
>>>>>backend.
>>>>>
>>>>>My question is in two parts: (1) is there a difference between the PD
>>>>>component that is supplied with ASA and that which is supplied with ASE?
>>>>>(2) Should we move our current PD website database from ASA into ASE so
>>>that
>>>>>the website database and the data database are on the same connection or
>>>is
>>>>>what we are doing - read that as the PD database and existing
>connection
>>>>>within an ASA environment and the actual data db existing within an ASE
>>>>>environment -should work without connectivity issues?
>>>>>
>>>>>I realize that there are some really quirky issues regarding component
>>>>>integration that Sybase is aware of so if we need to establish the PD
>>>>>database under the same ASE database world...I'll understand.
>>>>>
>>>>>TIA
>>>>>
>>>>>Brad McLeod
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>___________________________________________________________
>>>>
>>>>Carson Hager
>>>>Team Sybase
>>>>Dynamic Data Solutions, Inc.
>>>>Enterprise Application Studio 3.0 Consulting and Training
>>>>
>>>> DDS Enterprise Application Framework
>>>> Available Now as Open Source!
>>>> http://www.dyn-data.com
>>>>
>>>
>>>
>>
>>
>>___________________________________________________________
>>
>>Carson Hager
>>Team Sybase
>>Dynamic Data Solutions, Inc.
>>Enterprise Application Studio 3.0 Consulting and Training
>>
>> DDS Enterprise Application Framework
>> Available Now as Open Source!
>> http://www.dyn-data.com
>>
>
>

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training

DDS Enterprise Application Framework
Available Now as Open Source!
http://www.dyn-data.com


Lance Andersen Posted on 2000-03-21 12:55:09.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 21 Mar 2000 07:55:09 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D7712D.753FD97@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26033
Article PK: 156040


"Carson Hager[Team Sybase]" wrote:
>
> This requires no change. Why move to a dynamic file site? Better
> performance.

I am not sure I agree 100% with this. Yes, initially you will have a
slight performance edge from a dynamic file site because it does not
have to load the scripts from the db. However, if you size your dynamo
cache properly and you make use of the cache timeout parameter within
your scripts, you will not see a performance difference.

I tested this during our SybaseOpen pre-launch and saw no differences
once the scripts hit the cache.

Regards,
Lance
--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Carson Hager[Team Sybase] Posted on 2000-03-21 18:19:24.0Z
Newsgroups: sybase.public.easerver
From: chager@dyn-data.com (Carson Hager[Team Sybase])
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Tue, 21 Mar 2000 18:19:24 GMT
Organization: Dynamic Data Solutions, Inc.
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 52
NNTP-Posting-Host: charon.lifescape.com 63.86.26.130
Message-ID: <347_38d7bd04.92096447@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26006
Article PK: 156020

That's interesting. We've always seen better performance but perhaps
this was due to improperly configured PD cache settings.


Carson

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training
http://www.dyn-data.com

DDS is now hiring EAServer consultants
to support its exploding EAServer business!
Please submit your resume to
hr@dyn-data.com!


On Tue, 21 Mar 2000 07:55:09 -0500, Lance Andersen <lancea@sybase.com>

wrote:

>"Carson Hager[Team Sybase]" wrote:
>>
>> This requires no change. Why move to a dynamic file site? Better
>> performance.
>
>
>I am not sure I agree 100% with this. Yes, initially you will have a
>slight performance edge from a dynamic file site because it does not
>have to load the scripts from the db. However, if you size your dynamo
>cache properly and you make use of the cache timeout parameter within
>your scripts, you will not see a performance difference.
>
>I tested this during our SybaseOpen pre-launch and saw no differences
>once the scripts hit the cache.
>
>Regards,
>Lance
>--
>===============================================================================
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===============================================================================

___________________________________________________________

Carson Hager
Team Sybase
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.0 Consulting and Training

DDS Enterprise Application Framework
Available Now as Open Source!
http://www.dyn-data.com


Lance Andersen Posted on 2000-03-22 11:50:30.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 06:50:30 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D8B386.234918E9@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25945
Article PK: 155974


"Carson Hager[Team Sybase]" wrote:
>
> That's interesting. We've always seen better performance but perhaps
> this was due to improperly configured PD cache settings.

Yes if the cache is constantly getting flushed, then that would make
things worse with the extra IO to the DB.

Regards,
Lance
--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Sem Kazazic Posted on 2000-03-22 13:41:03.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@ica.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Wed, 22 Mar 2000 08:41:03 -0500
Lines: 36
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: max2-net131-ip073-toronto.ica.net 209.151.131.73
Message-ID: <347_8#E6bVAl$GA.111@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25939
Article PK: 155967

It's very interesting discussion.
After all we have to reconsider what has been repeated here several times,
"dynamic file site is much faster" than db one.
It would be very useful if Lance can add more info like:
- if you want to use ASE for both , web site and primary data, what you
would setup - two ase server, one ase server two database or..?
- when you say openclient is that openclient under jaguar or ase openclient?
- is there some samples somewhere for ase website, cache settings etc..?
Thanks.
Regards,
Sem.

Lance Andersen wrote in message <38D8B386.234918E9@sybase.com>...
>"Carson Hager[Team Sybase]" wrote:
>>
>> That's interesting. We've always seen better performance but perhaps
>> this was due to improperly configured PD cache settings.
>
>Yes if the cache is constantly getting flushed, then that would make
>things worse with the extra IO to the DB.
>
>Regards,
>Lance
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====


Lance Andersen Posted on 2000-03-22 20:16:52.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 15:16:52 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 55
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D92A34.767D648E@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com> <347_8#E6bVAl$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25899
Article PK: 154353


Brad McLeod wrote:
>
> I must say, this has to be the hottest discussion on this forum at this
> time. I don't know whether to apologize or give thanks. When I open this
> line of questioning, all I wanted to know was if anyone else had experienced
> the same issues as we were experiencing under a similar configuration (PD
> website in ASA, primary database in ASE) and the disappearance or
> reconfiguration of current PD ODBC connections without any known human
> intervention. As of this writing, and based upon the various comments from
> 'TeamSybase' members, we are going ahead with the OpenClient connection and
> moving our ASA PD database into ASE. Before closing, I do have 2 'new'
> questions that have come to light since the original thread. (1) It has
> been mentioned to place the web DB on a separate device - other than the
> device that holds the primary database. Do you mean a separate physical
> device (i.e. another physical hard drive or another logical partition?).

My line of commenting was in regards to making sure you are not
thrashing the same disks for both databases. A common mistake folks
have made over the years is they will put all of their databases on the
same series of disks and all of their non-db work on a separate set of
disks. What will then happen is that you will saturate the disks where
your DBs reside causing an IO bottleneck. There are many ways to avoid
this based on your OS. Just something to keep in mind.
(2)
> When describing the PD cache settings....what are you referencing?

Each site (URL mapping) allows you to configure a document and java
cache. Out of the box, this is 2k which is obviously way too small.


Hope this helps.

Lance
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Sem Kazazic Posted on 2000-03-22 19:06:17.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Wed, 22 Mar 2000 14:06:17 -0500
Lines: 119
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_#DGxnJDl$GA.34@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com> <347_8#E6bVAl$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25905
Article PK: 154358

Hi Brad,
I can understand your situation, but please think what would happen to all
of us without very good people in this group.
For the "device", I think here it's the ASE term, does not mean always
physical hard drive.
Regards,
Sem.

Brad McLeod wrote in message ...
>I must say, this has to be the hottest discussion on this forum at this
>time. I don't know whether to apologize or give thanks. When I open this
>line of questioning, all I wanted to know was if anyone else had
experienced
>the same issues as we were experiencing under a similar configuration (PD
>website in ASA, primary database in ASE) and the disappearance or
>reconfiguration of current PD ODBC connections without any known human
>intervention. As of this writing, and based upon the various comments from
>'TeamSybase' members, we are going ahead with the OpenClient connection and
>moving our ASA PD database into ASE. Before closing, I do have 2 'new'
>questions that have come to light since the original thread. (1) It has
>been mentioned to place the web DB on a separate device - other than the
>device that holds the primary database. Do you mean a separate physical
>device (i.e. another physical hard drive or another logical partition?).
(2)
>When describing the PD cache settings....what are you referencing? The PD
>cache settings or the cache settings for the html datawindows in PD?
>
>TIA
>
>Brad McLeod
>
>Lance Andersen wrote in message <38D8DC1D.3FAD1481@sybase.com>...
>>Sem Kazazic wrote:
>>>
>>> It's very interesting discussion.
>>> After all we have to reconsider what has been repeated here several
>times,
>>> "dynamic file site is much faster" than db one.
>>> It would be very useful if Lance can add more info like:
>>
>>ASE can easily handle multiple DBs. Things you would consider to help
>>improve access, is to make sure you DBs use different devices, you
>>consider binding the web db to a named cache allocating enough memory
>>to hold the db. If you are running ASE on an SMP box, use multiple
>>engines. The ASE tuning is not really anything different from what you
>>would do for any DB to optimize it for ASE.
>>
>>Try and determine the size needed for your PD cache and adjust
>>accordingly. The default is 2k of the document and java cache. The
>>document cache is obviously way too small out of the box.
>>
>>Also try as much as possible to create cachable documents.
>>
>>And use the CACHED_OUTPUT_TIMEOUT tags as much as possible. Sometimes
>>you may feel there is more work involved because you may have to have
>>some repetative scripts. However if you code your scripts so that you
>>can take advantage of imports then you will have minimal work to do.
>>
>>We did this quite successfully for the SybaseOpen. The db and webdb
>>were on one ASE server which sat inside our firewall. Just about every
>>script was cachable and I used a 100mb document cache.
>>
>>Regards,
>>Lance
>>
>>The openclient I am refering to is what ships with ASE/PD.
>>> - if you want to use ASE for both , web site and primary data, what you
>>> would setup - two ase server, one ase server two database or..?
>>> - when you say openclient is that openclient under jaguar or ase
>openclient?
>>> - is there some samples somewhere for ase website, cache settings etc..?
>>> Thanks.
>>> Regards,
>>> Sem.
>>>
>>> Lance Andersen wrote in message <38D8B386.234918E9@sybase.com>...
>>> >"Carson Hager[Team Sybase]" wrote:
>>> >>
>>> >> That's interesting. We've always seen better performance but perhaps
>>> >> this was due to improperly configured PD cache settings.
>>> >
>>> >Yes if the cache is constantly getting flushed, then that would make
>>> >things worse with the extra IO to the DB.
>>> >
>>> >Regards,
>>> >Lance
>>> >--
>>>
>>==========================================================================
=
>>> ====
>>> >Lance J. Andersen Email: lancea@sybase.com
>>> >Sybase Product Support Engineering Phone:(781) 564-6336
>>> >77 South Bedford Street Fax: (781) 564-7001
>>> >Burlington, MA 01803
>>> >
>>> >The Dark Knight Returns!!! Let's Go Penguins!!!
>>>
>>==========================================================================
=
>>> ====
>>
>>--
>>==========================================================================
=
>====
>>Lance J. Andersen Email: lancea@sybase.com
>>Sybase Product Support Engineering Phone:(781) 564-6336
>>77 South Bedford Street Fax: (781) 564-7001
>>Burlington, MA 01803
>>
>>The Dark Knight Returns!!! Let's Go Penguins!!!
>>==========================================================================
=
>====
>
>


Brad McLeod Posted on 2000-03-22 16:23:55.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Wed, 22 Mar 2000 10:23:55 -0600
Lines: 102
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Message-ID: <347_a##L7uBl$GA.298@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com> <347_8#E6bVAl$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25925
Article PK: 155953

I must say, this has to be the hottest discussion on this forum at this
time. I don't know whether to apologize or give thanks. When I open this
line of questioning, all I wanted to know was if anyone else had experienced
the same issues as we were experiencing under a similar configuration (PD
website in ASA, primary database in ASE) and the disappearance or
reconfiguration of current PD ODBC connections without any known human
intervention. As of this writing, and based upon the various comments from
'TeamSybase' members, we are going ahead with the OpenClient connection and
moving our ASA PD database into ASE. Before closing, I do have 2 'new'
questions that have come to light since the original thread. (1) It has
been mentioned to place the web DB on a separate device - other than the
device that holds the primary database. Do you mean a separate physical
device (i.e. another physical hard drive or another logical partition?). (2)
When describing the PD cache settings....what are you referencing? The PD
cache settings or the cache settings for the html datawindows in PD?

TIA

Brad McLeod

Lance Andersen wrote in message <38D8DC1D.3FAD1481@sybase.com>...
>Sem Kazazic wrote:
>>
>> It's very interesting discussion.
>> After all we have to reconsider what has been repeated here several
times,
>> "dynamic file site is much faster" than db one.
>> It would be very useful if Lance can add more info like:
>
>ASE can easily handle multiple DBs. Things you would consider to help
>improve access, is to make sure you DBs use different devices, you
>consider binding the web db to a named cache allocating enough memory
>to hold the db. If you are running ASE on an SMP box, use multiple
>engines. The ASE tuning is not really anything different from what you
>would do for any DB to optimize it for ASE.
>
>Try and determine the size needed for your PD cache and adjust
>accordingly. The default is 2k of the document and java cache. The
>document cache is obviously way too small out of the box.
>
>Also try as much as possible to create cachable documents.
>
>And use the CACHED_OUTPUT_TIMEOUT tags as much as possible. Sometimes
>you may feel there is more work involved because you may have to have
>some repetative scripts. However if you code your scripts so that you
>can take advantage of imports then you will have minimal work to do.
>
>We did this quite successfully for the SybaseOpen. The db and webdb
>were on one ASE server which sat inside our firewall. Just about every
>script was cachable and I used a 100mb document cache.
>
>Regards,
>Lance
>
>The openclient I am refering to is what ships with ASE/PD.
>> - if you want to use ASE for both , web site and primary data, what you
>> would setup - two ase server, one ase server two database or..?
>> - when you say openclient is that openclient under jaguar or ase
openclient?
>> - is there some samples somewhere for ase website, cache settings etc..?
>> Thanks.
>> Regards,
>> Sem.
>>
>> Lance Andersen wrote in message <38D8B386.234918E9@sybase.com>...
>> >"Carson Hager[Team Sybase]" wrote:
>> >>
>> >> That's interesting. We've always seen better performance but perhaps
>> >> this was due to improperly configured PD cache settings.
>> >
>> >Yes if the cache is constantly getting flushed, then that would make
>> >things worse with the extra IO to the DB.
>> >
>> >Regards,
>> >Lance
>> >--
>>
>===========================================================================
>> ====
>> >Lance J. Andersen Email: lancea@sybase.com
>> >Sybase Product Support Engineering Phone:(781) 564-6336
>> >77 South Bedford Street Fax: (781) 564-7001
>> >Burlington, MA 01803
>> >
>> >The Dark Knight Returns!!! Let's Go Penguins!!!
>>
>===========================================================================
>> ====
>
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====


Sem Kazazic Posted on 2000-03-22 16:13:02.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@ica.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Wed, 22 Mar 2000 11:13:02 -0500
Lines: 87
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: max4-net132-ip023-toronto.ica.net 209.151.132.23
Message-ID: <347_4vCwZqBl$GA.111@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com> <347_8#E6bVAl$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25927
Article PK: 155955

Thanks Lance.
It's great value having people like you in this group.
Regards,
Sem.

Lance Andersen wrote in message <38D8DC1D.3FAD1481@sybase.com>...
>Sem Kazazic wrote:
>>
>> It's very interesting discussion.
>> After all we have to reconsider what has been repeated here several
times,
>> "dynamic file site is much faster" than db one.
>> It would be very useful if Lance can add more info like:
>
>ASE can easily handle multiple DBs. Things you would consider to help
>improve access, is to make sure you DBs use different devices, you
>consider binding the web db to a named cache allocating enough memory
>to hold the db. If you are running ASE on an SMP box, use multiple
>engines. The ASE tuning is not really anything different from what you
>would do for any DB to optimize it for ASE.
>
>Try and determine the size needed for your PD cache and adjust
>accordingly. The default is 2k of the document and java cache. The
>document cache is obviously way too small out of the box.
>
>Also try as much as possible to create cachable documents.
>
>And use the CACHED_OUTPUT_TIMEOUT tags as much as possible. Sometimes
>you may feel there is more work involved because you may have to have
>some repetative scripts. However if you code your scripts so that you
>can take advantage of imports then you will have minimal work to do.
>
>We did this quite successfully for the SybaseOpen. The db and webdb
>were on one ASE server which sat inside our firewall. Just about every
>script was cachable and I used a 100mb document cache.
>
>Regards,
>Lance
>
>The openclient I am refering to is what ships with ASE/PD.
>> - if you want to use ASE for both , web site and primary data, what you
>> would setup - two ase server, one ase server two database or..?
>> - when you say openclient is that openclient under jaguar or ase
openclient?
>> - is there some samples somewhere for ase website, cache settings etc..?
>> Thanks.
>> Regards,
>> Sem.
>>
>> Lance Andersen wrote in message <38D8B386.234918E9@sybase.com>...
>> >"Carson Hager[Team Sybase]" wrote:
>> >>
>> >> That's interesting. We've always seen better performance but perhaps
>> >> this was due to improperly configured PD cache settings.
>> >
>> >Yes if the cache is constantly getting flushed, then that would make
>> >things worse with the extra IO to the DB.
>> >
>> >Regards,
>> >Lance
>> >--
>>
>===========================================================================
>> ====
>> >Lance J. Andersen Email: lancea@sybase.com
>> >Sybase Product Support Engineering Phone:(781) 564-6336
>> >77 South Bedford Street Fax: (781) 564-7001
>> >Burlington, MA 01803
>> >
>> >The Dark Knight Returns!!! Let's Go Penguins!!!
>>
>===========================================================================
>> ====
>
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====


Lance Andersen Posted on 2000-03-22 14:43:41.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 09:43:41 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 78
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D8DC1D.3FAD1481@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_38D7712D.753FD97@sybase.com> <347_38d7bd04.92096447@forums.sybase.com> <347_38D8B386.234918E9@sybase.com> <347_8#E6bVAl$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25935
Article PK: 155963


Sem Kazazic wrote:
>
> It's very interesting discussion.
> After all we have to reconsider what has been repeated here several times,
> "dynamic file site is much faster" than db one.
> It would be very useful if Lance can add more info like:

ASE can easily handle multiple DBs. Things you would consider to help
improve access, is to make sure you DBs use different devices, you
consider binding the web db to a named cache allocating enough memory
to hold the db. If you are running ASE on an SMP box, use multiple
engines. The ASE tuning is not really anything different from what you
would do for any DB to optimize it for ASE.

Try and determine the size needed for your PD cache and adjust
accordingly. The default is 2k of the document and java cache. The
document cache is obviously way too small out of the box.

Also try as much as possible to create cachable documents.

And use the CACHED_OUTPUT_TIMEOUT tags as much as possible. Sometimes
you may feel there is more work involved because you may have to have
some repetative scripts. However if you code your scripts so that you
can take advantage of imports then you will have minimal work to do.

We did this quite successfully for the SybaseOpen. The db and webdb
were on one ASE server which sat inside our firewall. Just about every
script was cachable and I used a 100mb document cache.

Regards,
Lance

The openclient I am refering to is what ships with ASE/PD.
> - if you want to use ASE for both , web site and primary data, what you
> would setup - two ase server, one ase server two database or..?
> - when you say openclient is that openclient under jaguar or ase openclient?
> - is there some samples somewhere for ase website, cache settings etc..?
> Thanks.
> Regards,
> Sem.
>
> Lance Andersen wrote in message <38D8B386.234918E9@sybase.com>...
> >"Carson Hager[Team Sybase]" wrote:
> >>
> >> That's interesting. We've always seen better performance but perhaps
> >> this was due to improperly configured PD cache settings.
> >
> >Yes if the cache is constantly getting flushed, then that would make
> >things worse with the extra IO to the DB.
> >
> >Regards,
> >Lance
> >--
> >===========================================================================
> ====
> >Lance J. Andersen Email: lancea@sybase.com
> >Sybase Product Support Engineering Phone:(781) 564-6336
> >77 South Bedford Street Fax: (781) 564-7001
> >Burlington, MA 01803
> >
> >The Dark Knight Returns!!! Let's Go Penguins!!!
> >===========================================================================
> ====

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Brad McLeod Posted on 2000-03-21 01:37:56.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 19:37:56 -0600
Lines: 260
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: 88.tulsa-01-02rs.ok.dial-access.att.net 12.74.160.88
Message-ID: <347_k0nwHbtk$GA.111@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26041
Article PK: 156048

Carson/Larry -

Although my development team disagrees - their main contention is about
security - I'm going to at least 'test' your recommendation regarding Open
Client and the Dynamic website. I would ask you, however, is there anything
else we need to know prior to making this change? Our past experience with
these types of modifications - modifications that are not necessarily
addressed by Sybase as they tend to say that what we have should work - is
that it's not as straightforward as it seems. Based upon this discussion,
all I should have to do is modify the current ODBC connection to use Open
Client instead, and then point the PD mapping to a 'Dynamic' file-based
configuration instead of a database web configuration. No scripting within
the html pages/html datawindows will need to occur.

Please let me know now if there is anything else that I should be made aware
of....we are in the final straight and I cannot afford anymore 'Oh! I
forgot to tell you about this, this and this OR Oh! You also need to do
this, this and this.....!'

Given the fact that both of you have provided us with EXCELLENT
recommendations in the past is the only reason that I'm agreeing to this
modification!!

TIA

Brad McLeod

Carson Hager[Team Sybase] wrote in message
<38d6cfd3.31375105@forums.sybase.com>...
>This requires no change. Why move to a dynamic file site? Better
>performance.
>
>
>Carson
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
>On Mon, 20 Mar 2000 15:57:56 -0600, "Brad McLeod"
><brad.mcleod@worldnet.att.net> wrote:
>
>>Carson -
>>
>>One other point. Since we are using the HTML DataWindow provided with EA
>>Studio, why would we want to go back and modify all of our PD scripts? As
I
>>mentioned, this application is heavy into the various EA Studio components
>>and we also use alot of the PD scripting in our various pages so for what
>>reason should we go to a dynamic web-based file system?
>>
>>TIA
>>
>>Brad McLeod
>>
>>Carson Hager[Team Sybase] wrote in message
>><38d68ddd.14489464@forums.sybase.com>...
>>>My recommendation is to use a dynamic file site and Open Client
>>>connection to your data.
>>>
>>>
>>>Carson
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>http://www.dyn-data.com
>>>
>>> DDS is now hiring EAServer consultants
>>> to support its exploding EAServer business!
>>> Please submit your resume to
>>> hr@dyn-data.com!
>>>
>>>
>>>On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
>>><brad.mcleod@worldnet.att.net> wrote:
>>>
>>>>Carson -
>>>>
>>>>No, we have not attempted a connection via Open Client as our previous
>>ODBC
>>>>connection worked just fine under ASA. As we ported the application
over
>>to
>>>>the new backend (ASE 11.9.2) we experienced some rather weird conditions
>>in
>>>>PowerDyamo and Jaguar. We had thought that these issues were fixed yet
we
>>>>are experiencing similiar issues again. Here's what happens:
>>>>
>>>>We establish an ODBC connection in Jaguar which works for about 24 hours
>>and
>>>>then - due to the ASE database locking - we reboot and then the
previously
>>>>established connection is gone!! We re-establish the connection and
>>>>everything seems to be OK until all of a sudden, access to the web pages
>>in
>>>>PowerDynamo (which are stored in ASA) become unavailable. There is
>>nothing
>>>>in any of the logs that point to whats happened. We then go in, delete
>>the
>>>>PowerDynamo connection, re-establish the connection via ODBA Admin, and
>>the
>>>>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>>>>
>>>>We are all really confused and, at time, I feel that we are grasping at
>>>>straw!! All of our development staff are up to speed with the various
>>>>Sybase components we are using and nobody has seen anything like this
>>before
>>>>in their professional careers.
>>>>
>>>>So, back to my previous questions, should we move our PowerDynamo
website
>>>>database into an ASE environment? Is the PowerDynamo component
delivered
>>>>with ASE different than the one deployed with ASA?
>>>>
>>>>I'd appreciate any input at this point. This application is now
scheduled
>>>>to move into production at the end of the month - we have been delayed
due
>>>>to the various issues we've already had with Sybase's products.
>>>>
>>>>TIA
>>>>
>>>>Brad McLeod
>>>>
>>>>Carson Hager[Team Sybase] wrote in message
>>>><38d5152b.2237968@forums.sybase.com>...
>>>>>Brad,
>>>>>
>>>>>Have you tried an OpenClient connection to the ASE data db ( as
>>>>>opposed to site content db )?
>>>>>
>>>>>As Larry mentioned, unless you are using scheduled scripts or you need
>>>>>to replicate the content, a dynamic file site is a much better choice.
>>>>>Dynamic file sites simply have the .stm/.ssc files on the file system
>>>>>instead of in the database.
>>>>>
>>>>>
>>>>>Carson
>>>>>
>>>>>___________________________________________________________
>>>>>
>>>>>Carson Hager
>>>>>Team Sybase
>>>>>Dynamic Data Solutions, Inc.
>>>>>Enterprise Application Studio 3.0 Consulting and Training
>>>>>http://www.dyn-data.com
>>>>>
>>>>> DDS is now hiring EAServer consultants
>>>>> to support its exploding EAServer business!
>>>>> Please submit your resume to
>>>>> hr@dyn-data.com!
>>>>>
>>>>>
>>>>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>>>>><brad.mcleod@worldnet.att.net> wrote:
>>>>>
>>>>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
>>>>11.9.2.
>>>>>>We are running a web-based application that uses a PowerDynamo
database
>>>>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>>>>>retrieval. Since this migration of the ASA database to ASE, we have
>>been
>>>>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>>>>>connections that were previously working unattended under a straight
ASA
>>>>>>environment, now tend to become unavailable under the ASA/ASE
>>>>configuration
>>>>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>>>>>connection and rebuild the ASE ODBC connection in order to access the
>>>>11.9.2
>>>>>>backend.
>>>>>>
>>>>>>My question is in two parts: (1) is there a difference between the
PD
>>>>>>component that is supplied with ASA and that which is supplied with
ASE?
>>>>>>(2) Should we move our current PD website database from ASA into ASE
so
>>>>that
>>>>>>the website database and the data database are on the same connection
or
>>>>is
>>>>>>what we are doing - read that as the PD database and existing
>>connection
>>>>>>within an ASA environment and the actual data db existing within an
ASE
>>>>>>environment -should work without connectivity issues?
>>>>>>
>>>>>>I realize that there are some really quirky issues regarding component
>>>>>>integration that Sybase is aware of so if we need to establish the PD
>>>>>>database under the same ASE database world...I'll understand.
>>>>>>
>>>>>>TIA
>>>>>>
>>>>>>Brad McLeod
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>___________________________________________________________
>>>>>
>>>>>Carson Hager
>>>>>Team Sybase
>>>>>Dynamic Data Solutions, Inc.
>>>>>Enterprise Application Studio 3.0 Consulting and Training
>>>>>
>>>>> DDS Enterprise Application Framework
>>>>> Available Now as Open Source!
>>>>> http://www.dyn-data.com
>>>>>
>>>>
>>>>
>>>
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>
>>> DDS Enterprise Application Framework
>>> Available Now as Open Source!
>>> http://www.dyn-data.com
>>>
>>
>>
>
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Lance Andersen Posted on 2000-03-21 12:58:07.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 21 Mar 2000 07:58:07 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 259
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D771DF.9FEC36B5@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com> <347_6R7mMgrk$GA.201@forums.sybase.com> <347_38d6cfd3.31375105@forums.sybase.com> <347_k0nwHbtk$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26032
Article PK: 156039

To use Open Client, is a matter of switching your connections and that
is it. ODBC will also use Open Client but it is one additional hop.

Again, I see no need to use a Dynamic file site. It is more important
to make your scripts cachable and also make sure that you adjust the PD
caches.

The only script changes you might need is if you create Connections
within your script.

Brad McLeod wrote:
>
> Carson/Larry -
>
> Although my development team disagrees - their main contention is about
> security - I'm going to at least 'test' your recommendation regarding Open
> Client and the Dynamic website. I would ask you, however, is there anything
> else we need to know prior to making this change? Our past experience with
> these types of modifications - modifications that are not necessarily
> addressed by Sybase as they tend to say that what we have should work - is
> that it's not as straightforward as it seems. Based upon this discussion,
> all I should have to do is modify the current ODBC connection to use Open
> Client instead, and then point the PD mapping to a 'Dynamic' file-based
> configuration instead of a database web configuration. No scripting within
> the html pages/html datawindows will need to occur.
>
> Please let me know now if there is anything else that I should be made aware
> of....we are in the final straight and I cannot afford anymore 'Oh! I
> forgot to tell you about this, this and this OR Oh! You also need to do
> this, this and this.....!'
>
> Given the fact that both of you have provided us with EXCELLENT
> recommendations in the past is the only reason that I'm agreeing to this
> modification!!
>
> TIA
>
> Brad McLeod
>
> Carson Hager[Team Sybase] wrote in message
> <38d6cfd3.31375105@forums.sybase.com>...
> >This requires no change. Why move to a dynamic file site? Better
> >performance.
> >
> >
> >Carson
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >http://www.dyn-data.com
> >
> > DDS is now hiring EAServer consultants
> > to support its exploding EAServer business!
> > Please submit your resume to
> > hr@dyn-data.com!
> >
> >
> >On Mon, 20 Mar 2000 15:57:56 -0600, "Brad McLeod"
> ><brad.mcleod@worldnet.att.net> wrote:
> >
> >>Carson -
> >>
> >>One other point. Since we are using the HTML DataWindow provided with EA
> >>Studio, why would we want to go back and modify all of our PD scripts? As
> I
> >>mentioned, this application is heavy into the various EA Studio components
> >>and we also use alot of the PD scripting in our various pages so for what
> >>reason should we go to a dynamic web-based file system?
> >>
> >>TIA
> >>
> >>Brad McLeod
> >>
> >>Carson Hager[Team Sybase] wrote in message
> >><38d68ddd.14489464@forums.sybase.com>...
> >>>My recommendation is to use a dynamic file site and Open Client
> >>>connection to your data.
> >>>
> >>>
> >>>Carson
> >>>
> >>>___________________________________________________________
> >>>
> >>>Carson Hager
> >>>Team Sybase
> >>>Dynamic Data Solutions, Inc.
> >>>Enterprise Application Studio 3.0 Consulting and Training
> >>>http://www.dyn-data.com
> >>>
> >>> DDS is now hiring EAServer consultants
> >>> to support its exploding EAServer business!
> >>> Please submit your resume to
> >>> hr@dyn-data.com!
> >>>
> >>>
> >>>On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
> >>><brad.mcleod@worldnet.att.net> wrote:
> >>>
> >>>>Carson -
> >>>>
> >>>>No, we have not attempted a connection via Open Client as our previous
> >>ODBC
> >>>>connection worked just fine under ASA. As we ported the application
> over
> >>to
> >>>>the new backend (ASE 11.9.2) we experienced some rather weird conditions
> >>in
> >>>>PowerDyamo and Jaguar. We had thought that these issues were fixed yet
> we
> >>>>are experiencing similiar issues again. Here's what happens:
> >>>>
> >>>>We establish an ODBC connection in Jaguar which works for about 24 hours
> >>and
> >>>>then - due to the ASE database locking - we reboot and then the
> previously
> >>>>established connection is gone!! We re-establish the connection and
> >>>>everything seems to be OK until all of a sudden, access to the web pages
> >>in
> >>>>PowerDynamo (which are stored in ASA) become unavailable. There is
> >>nothing
> >>>>in any of the logs that point to whats happened. We then go in, delete
> >>the
> >>>>PowerDynamo connection, re-establish the connection via ODBA Admin, and
> >>the
> >>>>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
> >>>>
> >>>>We are all really confused and, at time, I feel that we are grasping at
> >>>>straw!! All of our development staff are up to speed with the various
> >>>>Sybase components we are using and nobody has seen anything like this
> >>before
> >>>>in their professional careers.
> >>>>
> >>>>So, back to my previous questions, should we move our PowerDynamo
> website
> >>>>database into an ASE environment? Is the PowerDynamo component
> delivered
> >>>>with ASE different than the one deployed with ASA?
> >>>>
> >>>>I'd appreciate any input at this point. This application is now
> scheduled
> >>>>to move into production at the end of the month - we have been delayed
> due
> >>>>to the various issues we've already had with Sybase's products.
> >>>>
> >>>>TIA
> >>>>
> >>>>Brad McLeod
> >>>>
> >>>>Carson Hager[Team Sybase] wrote in message
> >>>><38d5152b.2237968@forums.sybase.com>...
> >>>>>Brad,
> >>>>>
> >>>>>Have you tried an OpenClient connection to the ASE data db ( as
> >>>>>opposed to site content db )?
> >>>>>
> >>>>>As Larry mentioned, unless you are using scheduled scripts or you need
> >>>>>to replicate the content, a dynamic file site is a much better choice.
> >>>>>Dynamic file sites simply have the .stm/.ssc files on the file system
> >>>>>instead of in the database.
> >>>>>
> >>>>>
> >>>>>Carson
> >>>>>
> >>>>>___________________________________________________________
> >>>>>
> >>>>>Carson Hager
> >>>>>Team Sybase
> >>>>>Dynamic Data Solutions, Inc.
> >>>>>Enterprise Application Studio 3.0 Consulting and Training
> >>>>>http://www.dyn-data.com
> >>>>>
> >>>>> DDS is now hiring EAServer consultants
> >>>>> to support its exploding EAServer business!
> >>>>> Please submit your resume to
> >>>>> hr@dyn-data.com!
> >>>>>
> >>>>>
> >>>>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
> >>>>><brad.mcleod@worldnet.att.net> wrote:
> >>>>>
> >>>>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
> >>>>11.9.2.
> >>>>>>We are running a web-based application that uses a PowerDynamo
> database
> >>>>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
> >>>>>>retrieval. Since this migration of the ASA database to ASE, we have
> >>been
> >>>>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
> >>>>>>connections that were previously working unattended under a straight
> ASA
> >>>>>>environment, now tend to become unavailable under the ASA/ASE
> >>>>configuration
> >>>>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
> >>>>>>connection and rebuild the ASE ODBC connection in order to access the
> >>>>11.9.2
> >>>>>>backend.
> >>>>>>
> >>>>>>My question is in two parts: (1) is there a difference between the
> PD
> >>>>>>component that is supplied with ASA and that which is supplied with
> ASE?
> >>>>>>(2) Should we move our current PD website database from ASA into ASE
> so
> >>>>that
> >>>>>>the website database and the data database are on the same connection
> or
> >>>>is
> >>>>>>what we are doing - read that as the PD database and existing
> >>connection
> >>>>>>within an ASA environment and the actual data db existing within an
> ASE
> >>>>>>environment -should work without connectivity issues?
> >>>>>>
> >>>>>>I realize that there are some really quirky issues regarding component
> >>>>>>integration that Sybase is aware of so if we need to establish the PD
> >>>>>>database under the same ASE database world...I'll understand.
> >>>>>>
> >>>>>>TIA
> >>>>>>
> >>>>>>Brad McLeod
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>___________________________________________________________
> >>>>>
> >>>>>Carson Hager
> >>>>>Team Sybase
> >>>>>Dynamic Data Solutions, Inc.
> >>>>>Enterprise Application Studio 3.0 Consulting and Training
> >>>>>
> >>>>> DDS Enterprise Application Framework
> >>>>> Available Now as Open Source!
> >>>>> http://www.dyn-data.com
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>___________________________________________________________
> >>>
> >>>Carson Hager
> >>>Team Sybase
> >>>Dynamic Data Solutions, Inc.
> >>>Enterprise Application Studio 3.0 Consulting and Training
> >>>
> >>> DDS Enterprise Application Framework
> >>> Available Now as Open Source!
> >>> http://www.dyn-data.com
> >>>
> >>
> >>
> >
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >
> > DDS Enterprise Application Framework
> > Available Now as Open Source!
> > http://www.dyn-data.com
> >

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Brad McLeod Posted on 2000-03-20 21:27:56.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 15:27:56 -0600
Lines: 186
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Message-ID: <347_lAfcbPrk$GA.201@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38d68ddd.14489464@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26056
Article PK: 156061

Carson -

Although I can understand your recommendation and, if that's what it takes
to get this site up on stable ground, that's what we will do! However,
since we had no issues when running strictly on ASA, the question becomes
why? We use the ASA db to store our various web pages - including the html
datawindows that we deploy from PowerSite and some ActiveX/OCX pages - and
did not have ANY problems until we upgraded the backend to ASE 11.9.2.
Further, I could understand deploying to a dynamic file site IF we were in
production and all of the various 'quirks' had been worked out but this is
not the case. We go into beta in 10 days and now this might need to be
re-evaluated. I hope that you understand that our entire application has
been built using EA Studio 3.0.1 and that we use Jaguar-CTS, PowerDynamo
(ASA) and ASE. I thought that we were using these products 'as designed' so
if we are not.....please let me know!

TIA

Brad McLeod

Carson Hager[Team Sybase] wrote in message
<38d68ddd.14489464@forums.sybase.com>...
>My recommendation is to use a dynamic file site and Open Client
>connection to your data.
>
>
>Carson
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>http://www.dyn-data.com
>
> DDS is now hiring EAServer consultants
> to support its exploding EAServer business!
> Please submit your resume to
> hr@dyn-data.com!
>
>
>On Sun, 19 Mar 2000 16:20:26 -0600, "Brad McLeod"
><brad.mcleod@worldnet.att.net> wrote:
>
>>Carson -
>>
>>No, we have not attempted a connection via Open Client as our previous
ODBC
>>connection worked just fine under ASA. As we ported the application over
to
>>the new backend (ASE 11.9.2) we experienced some rather weird conditions
in
>>PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
>>are experiencing similiar issues again. Here's what happens:
>>
>>We establish an ODBC connection in Jaguar which works for about 24 hours
and
>>then - due to the ASE database locking - we reboot and then the previously
>>established connection is gone!! We re-establish the connection and
>>everything seems to be OK until all of a sudden, access to the web pages
in
>>PowerDynamo (which are stored in ASA) become unavailable. There is
nothing
>>in any of the logs that point to whats happened. We then go in, delete
the
>>PowerDynamo connection, re-establish the connection via ODBA Admin, and
the
>>things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>>
>>We are all really confused and, at time, I feel that we are grasping at
>>straw!! All of our development staff are up to speed with the various
>>Sybase components we are using and nobody has seen anything like this
before
>>in their professional careers.
>>
>>So, back to my previous questions, should we move our PowerDynamo website
>>database into an ASE environment? Is the PowerDynamo component delivered
>>with ASE different than the one deployed with ASA?
>>
>>I'd appreciate any input at this point. This application is now scheduled
>>to move into production at the end of the month - we have been delayed due
>>to the various issues we've already had with Sybase's products.
>>
>>TIA
>>
>>Brad McLeod
>>
>>Carson Hager[Team Sybase] wrote in message
>><38d5152b.2237968@forums.sybase.com>...
>>>Brad,
>>>
>>>Have you tried an OpenClient connection to the ASE data db ( as
>>>opposed to site content db )?
>>>
>>>As Larry mentioned, unless you are using scheduled scripts or you need
>>>to replicate the content, a dynamic file site is a much better choice.
>>>Dynamic file sites simply have the .stm/.ssc files on the file system
>>>instead of in the database.
>>>
>>>
>>>Carson
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>http://www.dyn-data.com
>>>
>>> DDS is now hiring EAServer consultants
>>> to support its exploding EAServer business!
>>> Please submit your resume to
>>> hr@dyn-data.com!
>>>
>>>
>>>On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>>><brad.mcleod@worldnet.att.net> wrote:
>>>
>>>>We have recently migrated our backend database from ASA 6.0.1 to ASE
>>11.9.2.
>>>>We are running a web-based application that uses a PowerDynamo database
>>>>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>>>>retrieval. Since this migration of the ASA database to ASE, we have
been
>>>>experiencing some REALLY FLACKY issues under this configuration. ODBC
>>>>connections that were previously working unattended under a straight ASA
>>>>environment, now tend to become unavailable under the ASA/ASE
>>configuration
>>>>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>>>>connection and rebuild the ASE ODBC connection in order to access the
>>11.9.2
>>>>backend.
>>>>
>>>>My question is in two parts: (1) is there a difference between the PD
>>>>component that is supplied with ASA and that which is supplied with ASE?
>>>>(2) Should we move our current PD website database from ASA into ASE so
>>that
>>>>the website database and the data database are on the same connection or
>>is
>>>>what we are doing - read that as the PD database and existing
connection
>>>>within an ASA environment and the actual data db existing within an ASE
>>>>environment -should work without connectivity issues?
>>>>
>>>>I realize that there are some really quirky issues regarding component
>>>>integration that Sybase is aware of so if we need to establish the PD
>>>>database under the same ASE database world...I'll understand.
>>>>
>>>>TIA
>>>>
>>>>Brad McLeod
>>>>
>>>>
>>>>
>>>
>>>
>>>___________________________________________________________
>>>
>>>Carson Hager
>>>Team Sybase
>>>Dynamic Data Solutions, Inc.
>>>Enterprise Application Studio 3.0 Consulting and Training
>>>
>>> DDS Enterprise Application Framework
>>> Available Now as Open Source!
>>> http://www.dyn-data.com
>>>
>>
>>
>
>
>___________________________________________________________
>
>Carson Hager
>Team Sybase
>Dynamic Data Solutions, Inc.
>Enterprise Application Studio 3.0 Consulting and Training
>
> DDS Enterprise Application Framework
> Available Now as Open Source!
> http://www.dyn-data.com
>


Lance Andersen Posted on 2000-03-20 12:19:38.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 20 Mar 2000 07:19:38 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 147
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D6175A.E6386C99@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26098
Article PK: 156103

You can store your PD website in ASA or ASE equally well. We used ASE
for the storage for the SybaseOpen website which consisted of PD and
Jaguar components.

It sounds like you are hitting some blocking issues on ASE. I would
certainly avoid the ODBC layer and just use Open Client for ASE.

If you reboot ASE, then yes PD will have problems with the Connection.
It currently does not appear to check the validity of a connection
(though I have not specfically walked the codeline on this yet).

When you state that PD is not returning pages, what is the status of the
PD connections from an ASe point of view.

Brad McLeod wrote:
>
> Carson -
>
> No, we have not attempted a connection via Open Client as our previous ODBC
> connection worked just fine under ASA. As we ported the application over to
> the new backend (ASE 11.9.2) we experienced some rather weird conditions in
> PowerDyamo and Jaguar. We had thought that these issues were fixed yet we
> are experiencing similiar issues again. Here's what happens:
>
> We establish an ODBC connection in Jaguar which works for about 24 hours and
> then - due to the ASE database locking - we reboot and then the previously
> established connection is gone!! We re-establish the connection and
> everything seems to be OK until all of a sudden, access to the web pages in
> PowerDynamo (which are stored in ASA) become unavailable. There is nothing
> in any of the logs that point to whats happened. We then go in, delete the
> PowerDynamo connection, re-establish the connection via ODBA Admin, and the
> things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>
> We are all really confused and, at time, I feel that we are grasping at
> straw!! All of our development staff are up to speed with the various
> Sybase components we are using and nobody has seen anything like this before
> in their professional careers.
>
> So, back to my previous questions, should we move our PowerDynamo website
> database into an ASE environment? Is the PowerDynamo component delivered
> with ASE different than the one deployed with ASA?
>
> I'd appreciate any input at this point. This application is now scheduled
> to move into production at the end of the month - we have been delayed due
> to the various issues we've already had with Sybase's products.
>
> TIA
>
> Brad McLeod
>
> Carson Hager[Team Sybase] wrote in message
> <38d5152b.2237968@forums.sybase.com>...
> >Brad,
> >
> >Have you tried an OpenClient connection to the ASE data db ( as
> >opposed to site content db )?
> >
> >As Larry mentioned, unless you are using scheduled scripts or you need
> >to replicate the content, a dynamic file site is a much better choice.
> >Dynamic file sites simply have the .stm/.ssc files on the file system
> >instead of in the database.
> >
> >
> >Carson
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >http://www.dyn-data.com
> >
> > DDS is now hiring EAServer consultants
> > to support its exploding EAServer business!
> > Please submit your resume to
> > hr@dyn-data.com!
> >
> >
> >On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
> ><brad.mcleod@worldnet.att.net> wrote:
> >
> >>We have recently migrated our backend database from ASA 6.0.1 to ASE
> 11.9.2.
> >>We are running a web-based application that uses a PowerDynamo database
> >>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
> >>retrieval. Since this migration of the ASA database to ASE, we have been
> >>experiencing some REALLY FLACKY issues under this configuration. ODBC
> >>connections that were previously working unattended under a straight ASA
> >>environment, now tend to become unavailable under the ASA/ASE
> configuration
> >>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
> >>connection and rebuild the ASE ODBC connection in order to access the
> 11.9.2
> >>backend.
> >>
> >>My question is in two parts: (1) is there a difference between the PD
> >>component that is supplied with ASA and that which is supplied with ASE?
> >>(2) Should we move our current PD website database from ASA into ASE so
> that
> >>the website database and the data database are on the same connection or
> is
> >>what we are doing - read that as the PD database and existing connection
> >>within an ASA environment and the actual data db existing within an ASE
> >>environment -should work without connectivity issues?
> >>
> >>I realize that there are some really quirky issues regarding component
> >>integration that Sybase is aware of so if we need to establish the PD
> >>database under the same ASE database world...I'll understand.
> >>
> >>TIA
> >>
> >>Brad McLeod
> >>
> >>
> >>
> >
> >
> >___________________________________________________________
> >
> >Carson Hager
> >Team Sybase
> >Dynamic Data Solutions, Inc.
> >Enterprise Application Studio 3.0 Consulting and Training
> >
> > DDS Enterprise Application Framework
> > Available Now as Open Source!
> > http://www.dyn-data.com
> >

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Brad McLeod Posted on 2000-03-20 21:08:59.0Z
Newsgroups: sybase.public.easerver
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Mon, 20 Mar 2000 15:08:59 -0600
Lines: 195
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Message-ID: <347_SSDW5Erk$GA.290@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38D6175A.E6386C99@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26059
Article PK: 156068

Lance -

Although we are researching what would be needed to switch out our current
ODBC connections to Open Client, there is another issue that no one seems to
be able to respond to. In order for me to ensure that you have all relevant
info, here we go:

(1) We are currently running NT Server 4.0 w/SP 5.
(2) Our database's are ASE 11.9.2 (our primary database) and ASA 6.0.1 for
our website database.
(3) We have created an application using EA Studio 3.0.1 utilizing PowerSite
3.0 (HTML datawindows, ActiveX components, etc. ) and Jaguar-CTS 3.0.1.
(4) We deploy our HTML datawindows from PowerSite into the ASA website db
which then access the ASE database for the requested data.
(5) We recently migrated our primary database backend from ASA 6.0.1 to ASE
11.9.2 but kept intact out website database in ASA.
(6) Since that time, ODBC connections from IIS to PD (website db) to ASE
(primary database) have been failing and the physical PD connections have
been disappearing from site - READ THAT gone!
(7) When this occurs, we rebuild the PD ASA connection and then things
work - for awhile - and then disappear again with nothing in the logs to
show why this happened.

When we were running under a strictly ASA environment - the PD db was in ASA
and the primary db was within ASA, everything was pretty stable. Since the
migration, I can't remember the last time we had a stable system for longer
than 6 hours!!!

Any insight, info, etc you may have would be extremely appreciated as we are
attempting to prepare to deploy for beta testing within the next 10 days!!

Lance Andersen wrote in message <38D6175A.E6386C99@sybase.com>...
>You can store your PD website in ASA or ASE equally well. We used ASE
>for the storage for the SybaseOpen website which consisted of PD and
>Jaguar components.
>
>It sounds like you are hitting some blocking issues on ASE. I would
>certainly avoid the ODBC layer and just use Open Client for ASE.
>
>If you reboot ASE, then yes PD will have problems with the Connection.
>It currently does not appear to check the validity of a connection
>(though I have not specfically walked the codeline on this yet).
>
>When you state that PD is not returning pages, what is the status of the
>PD connections from an ASe point of view.
>
>
>
>Brad McLeod wrote:
>>
>> Carson -
>>
>> No, we have not attempted a connection via Open Client as our previous
ODBC
>> connection worked just fine under ASA. As we ported the application over
to
>> the new backend (ASE 11.9.2) we experienced some rather weird conditions
in
>> PowerDyamo and Jaguar. We had thought that these issues were fixed yet
we
>> are experiencing similiar issues again. Here's what happens:
>>
>> We establish an ODBC connection in Jaguar which works for about 24 hours
and
>> then - due to the ASE database locking - we reboot and then the
previously
>> established connection is gone!! We re-establish the connection and
>> everything seems to be OK until all of a sudden, access to the web pages
in
>> PowerDynamo (which are stored in ASA) become unavailable. There is
nothing
>> in any of the logs that point to whats happened. We then go in, delete
the
>> PowerDynamo connection, re-establish the connection via ODBA Admin, and
the
>> things seem to be back on course - UNTIL WE ARE FORCED TO REBOOT!!
>>
>> We are all really confused and, at time, I feel that we are grasping at
>> straw!! All of our development staff are up to speed with the various
>> Sybase components we are using and nobody has seen anything like this
before
>> in their professional careers.
>>
>> So, back to my previous questions, should we move our PowerDynamo website
>> database into an ASE environment? Is the PowerDynamo component delivered
>> with ASE different than the one deployed with ASA?
>>
>> I'd appreciate any input at this point. This application is now
scheduled
>> to move into production at the end of the month - we have been delayed
due
>> to the various issues we've already had with Sybase's products.
>>
>> TIA
>>
>> Brad McLeod
>>
>> Carson Hager[Team Sybase] wrote in message
>> <38d5152b.2237968@forums.sybase.com>...
>> >Brad,
>> >
>> >Have you tried an OpenClient connection to the ASE data db ( as
>> >opposed to site content db )?
>> >
>> >As Larry mentioned, unless you are using scheduled scripts or you need
>> >to replicate the content, a dynamic file site is a much better choice.
>> >Dynamic file sites simply have the .stm/.ssc files on the file system
>> >instead of in the database.
>> >
>> >
>> >Carson
>> >
>> >___________________________________________________________
>> >
>> >Carson Hager
>> >Team Sybase
>> >Dynamic Data Solutions, Inc.
>> >Enterprise Application Studio 3.0 Consulting and Training
>> >http://www.dyn-data.com
>> >
>> > DDS is now hiring EAServer consultants
>> > to support its exploding EAServer business!
>> > Please submit your resume to
>> > hr@dyn-data.com!
>> >
>> >
>> >On Fri, 17 Mar 2000 19:16:34 -0600, "Brad McLeod"
>> ><brad.mcleod@worldnet.att.net> wrote:
>> >
>> >>We have recently migrated our backend database from ASA 6.0.1 to ASE
>> 11.9.2.
>> >>We are running a web-based application that uses a PowerDynamo database
>> >>under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
>> >>retrieval. Since this migration of the ASA database to ASE, we have
been
>> >>experiencing some REALLY FLACKY issues under this configuration. ODBC
>> >>connections that were previously working unattended under a straight
ASA
>> >>environment, now tend to become unavailable under the ASA/ASE
>> configuration
>> >>and have caused us to either (1) reboot, or (2) delete the ASE ODBC
>> >>connection and rebuild the ASE ODBC connection in order to access the
>> 11.9.2
>> >>backend.
>> >>
>> >>My question is in two parts: (1) is there a difference between the PD
>> >>component that is supplied with ASA and that which is supplied with
ASE?
>> >>(2) Should we move our current PD website database from ASA into ASE so
>> that
>> >>the website database and the data database are on the same connection
or
>> is
>> >>what we are doing - read that as the PD database and existing
connection
>> >>within an ASA environment and the actual data db existing within an ASE
>> >>environment -should work without connectivity issues?
>> >>
>> >>I realize that there are some really quirky issues regarding component
>> >>integration that Sybase is aware of so if we need to establish the PD
>> >>database under the same ASE database world...I'll understand.
>> >>
>> >>TIA
>> >>
>> >>Brad McLeod
>> >>
>> >>
>> >>
>> >
>> >
>> >___________________________________________________________
>> >
>> >Carson Hager
>> >Team Sybase
>> >Dynamic Data Solutions, Inc.
>> >Enterprise Application Studio 3.0 Consulting and Training
>> >
>> > DDS Enterprise Application Framework
>> > Available Now as Open Source!
>> > http://www.dyn-data.com
>> >
>
>--
>===========================================================================
====
>Lance J. Andersen Email: lancea@sybase.com
>Sybase Product Support Engineering Phone:(781) 564-6336
>77 South Bedford Street Fax: (781) 564-7001
>Burlington, MA 01803
>
>The Dark Knight Returns!!! Let's Go Penguins!!!
>===========================================================================

====


Lance Andersen Posted on 2000-03-21 13:03:28.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 21 Mar 2000 08:03:28 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 54
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38D77320.5EB3D8CB@sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com> <347_38d5152b.2237968@forums.sybase.com> <347_tjrsRIfk$GA.285@forums.sybase.com> <347_38D6175A.E6386C99@sybase.com> <347_SSDW5Erk$GA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26031
Article PK: 156038


Brad McLeod wrote:

>
> (1) We are currently running NT Server 4.0 w/SP 5.
> (2) Our database's are ASE 11.9.2 (our primary database) and ASA 6.0.1 for
> our website database.

This should be ok, though I would probably use ASE for the website
database as well.

> (3) We have created an application using EA Studio 3.0.1 utilizing PowerSite
> 3.0 (HTML datawindows, ActiveX components, etc. ) and Jaguar-CTS 3.0.1.
> (4) We deploy our HTML datawindows from PowerSite into the ASA website db
> which then access the ASE database for the requested data.
> (5) We recently migrated our primary database backend from ASA 6.0.1 to ASE
> 11.9.2 but kept intact out website database in ASA.
> (6) Since that time, ODBC connections from IIS to PD (website db) to ASE
> (primary database) have been failing and the physical PD connections have
> been disappearing from site - READ THAT gone!

I have not seen this before. Are there any errors in the ASE log?


> (7) When this occurs, we rebuild the PD ASA connection and then things
> work - for awhile - and then disappear again with nothing in the logs to
> show why this happened.

So you go an delete the PD ASA connection and re-add it?
>
> When we were running under a strictly ASA environment - the PD db was in ASA
> and the primary db was within ASA, everything was pretty stable. Since the
> migration, I can't remember the last time we had a stable system for longer
> than 6 hours!!!

I must admit I have not tried the combination that you are using but I
see no reason that it should not work. When you see your access
problems via ODBC to ASE, can you still view the scripts in ASA (that is
get a directory listing?)


--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Larry Cermak[Team Sybase] Posted on 2000-03-18 05:38:11.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Powerdynamo for ASA 6.0.1 vs ASE 11.9.2
Date: Fri, 17 Mar 2000 23:38:11 -0600
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_w1sIE2Jk$GA.285@forums.sybase.com>
References: <347_yGKbKhHk$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26137
Article PK: 156816

In production is there a specific reason you want your web site in the
database? A dynamic file system is going to be faster.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Brad McLeod" <brad.mcleod@worldnet.att.net> wrote in message
news:yGKbKhHk$GA.111@forums.sybase.com...
> We have recently migrated our backend database from ASA 6.0.1 to ASE
11.9.2.
> We are running a web-based application that uses a PowerDynamo database
> under ASA 6.0.1 while accessing the new ASE 11.9.2 database for data
> retrieval. Since this migration of the ASA database to ASE, we have been
> experiencing some REALLY FLACKY issues under this configuration. ODBC
> connections that were previously working unattended under a straight ASA
> environment, now tend to become unavailable under the ASA/ASE
configuration
> and have caused us to either (1) reboot, or (2) delete the ASE ODBC
> connection and rebuild the ASE ODBC connection in order to access the
11.9.2
> backend.
>
> My question is in two parts: (1) is there a difference between the PD
> component that is supplied with ASA and that which is supplied with ASE?
> (2) Should we move our current PD website database from ASA into ASE so
that
> the website database and the data database are on the same connection or
is
> what we are doing - read that as the PD database and existing connection
> within an ASA environment and the actual data db existing within an ASE
> environment -should work without connectivity issues?
>
> I realize that there are some really quirky issues regarding component
> integration that Sybase is aware of so if we need to establish the PD
> database under the same ASE database world...I'll understand.
>
> TIA
>
> Brad McLeod
>
>
>