I need instructions to bring a DB from V11 to V9 fast please

#11

Just to repeat Paul Horan's question:

If you
a) have the V9 databases from the state just before you did the upgrade
- by backing up or just be stopping the V9 system - (and you ought have
them, methinks)
b) and you have all the V11 log(s),
it might be easier to use DBTRAN to generate the SQL statements that
have been applied on the V11 line, and run them against the V9 database.

Not easy and maybe error-prone but doable, I hope.

Regards
Volker

Robert Paresi wrote:

Quote:

Breck,

I don't know what your position is with Sybase or if your information is
an 'official' source.

I have two entire systems (production and internal) we went to V11 with.
Now, we are in a panic because we have two big issues - internal
customers having issues and external customers having issues.

You may be here to 'help' - but right now, we are in a predictement
where this whole thing is completely frustrating. I'm highly doubting
it's fragmentation issues because it's two database, two entirely
different systems all behaving in the same manner. It may be changes in
the way the database handles things because of our application
development tool. Getting support for that tool is worse and close to
being unsupported - and you really don't know where they stand on anything.

It's far easier to put everything back to the way it was and just leave
it alone. My problem is that V9 GPF's when using WIN7 so now I'm in a
catch - 22.

We give Sybase close to 100K a year in sales --- I'm not going to be
placed in some support tree and go through some help line tree.

I curse the day I went to V11. But, the issues are probably a
combination of our compiler application and something new that Sybase
V11 is doing, and the way it is fetching records.

For example ... the compiler (RAD TOOL) does a select x from y order by
keyfield desc - to find the next primary key. It was extremely fast in
V9, but it seems like it is 1 to 5 seconds on V11. I know that "select
first" is sub-second, but we do not control what the driver does in the
application - again, it is a RAD tool. I have no clue why SQA 11 would
handle this different than SQA 9 but it does ... with a huge lag.
There are other screens which have slowed to a crawl.

There has got to be a way to migrate a DB back to V9.

I'm trying it now - but now my SCJVIEW is GPF'ing adn not even allowing
me to create an empty database.

Why can't I just create an empty database.
Run the unload statements over it and it puts it all back.

I tried it and my tables are fine, my security is fine, everything is
fine - the ONLY problem is the FORMAT TEXT statement is wrong.

I went through the file with ULEDIT and pulled that all out. Then I
went to recreate the file and SCJVIEW GPF's and won't create an empty
database.

It's yet another issue now I'm dealing with - and I shouldn't for the
price of Sybase SQL Anywhere.

-Robert

#12

Please show us the exact commands causing the problem, and the exact
error message.

We are trying you help, but I WILL BE FRANK... you are not giving us
to work with.

Please make up your mind... do you want to sit back and complain, or
do you actually want a solution?

If it is the former then please call tech support, they are paid to
listen to crap. Here, we are all volunteers... if you want help HERE
then you have to participate in the process.

IMO this flailing panic mode is out of character for you.

Breck

On 23 Oct 2009 08:55:19 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

Quote:

Hi,

It doesn't like this:

FORMAT TEXT

Meaning, when it loads the data, it doesn't like that.

I tried it with unload statements, and it didn't like QUOTE

I tried it with SQL statements, and it doesn't like "FORMAT TEXT"

-Robert

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

#13

If Sybase Central is crashing, then stop using it. Chances are good
there is some environmental problem associated with two different Java
setups, IMO. Use command line utilities.

The above advice is a shortcut to get you working, as opposed to
flailing... there is no absolute reason V9 Sybase Central can't
coexist with V10 and V11, but you don't HAVE to fix that problem now,
you have this alternative...

REM -e simple encryption
REM -p page size; e.g., 4096, 8192
REM -s use checksums when writing pages

"%ASANY9%\win32\dbinit.exe" -s ddd.db
PAUSE

On 23 Oct 2009 09:11:37 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

Quote:

Hi,

I really don't want to be placed on hold or sit there and explain my issues.
My nerves are already shot.

Now its more issues. I am creating the V9 database and when it does it,
SCJVIEW GPF's on my WIN2008 server.

I do utilities / create database, put in all the parms, press Finish. It
creates the .db files and then it says "initializing ultralite" something or
other, and then just GPF's on my box. So, I can't even create a blank
database.

I don't feel like discussing this with someone from Sybase Support Center.
They aren't programmers.

-Robert

"Volker Barth" <No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote in message
news:4ae1d2d6$1 (AT) forums-1-dub (DOT) ..
V9 uses FORMAT ASCII instead of FORMAT TEXT.

I would recommend tech support, too, if you have the time and nerves...

Regards
Volker

Robert Paresi wrote:
Hi,

It doesn't like this:

FORMAT TEXT

Meaning, when it loads the data, it doesn't like that.

I tried it with unload statements, and it didn't like QUOTE

I tried it with SQL statements, and it doesn't like "FORMAT TEXT"

-Robert

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

#14

Hi,

Could you please look at this and tell me if this shows an issue.

This is a database which has an index both DESC and ASC order of Invoice
Number:

SELECT * FROM BILLDET ORDER BY INVOICENUMBER

RunTime

Estimate: 0.32643
Actual: 1.4581

SELECT * FROM BILLDET ORDER BY INVOICENUMBER DESC

RunTime

Estimate: 2.5823
Actual: 4.098

Would there be a setting or a change from V9 to V11 which slows down
DESCENDING result sets?

That's my first question.

-Robert

#15

DESC and ASC in this case should make no difference, it really is the
same sort, effectively.

BUT... the differences in the estimates and actuals indicate that
different plans are being used. Actually *seeing* the plans might help
a lot (see the blog post I made just for you, today
http://sqlanywhere.blogspot.com/2009...ical-plan.html

Send plans to breck dot carter at gmail dot com

Also, if you want me to look at your schema in general, do a
schema-only dbunload and send the reload.sql to me. I promise not to
share the schema with anyone else.

Do you really have two indexes, DESC and ASC? on just that one column?
That is not required, but should not hurt.

When upgrading from one version of DBMS to another (this applies to
ALL products), some queries may behave much worse even though most are
better. Everyone hates these queries, of course. In my experience,
there aren't many of these, there are different explanations for all
of them, and they can all be fixed.

On 23 Oct 2009 11:00:23 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

Quote:

Hi,

Could you please look at this and tell me if this shows an issue.

This is a database which has an index both DESC and ASC order of Invoice
Number:

SELECT * FROM BILLDET ORDER BY INVOICENUMBER

RunTime

Estimate: 0.32643
Actual: 1.4581

SELECT * FROM BILLDET ORDER BY INVOICENUMBER DESC

RunTime

Estimate: 2.5823
Actual: 4.098

Would there be a setting or a change from V9 to V11 which slows down
DESCENDING result sets?

That's my first question.

-Robert

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

#16

FWIW, if you panic persists through the weekend, I will be online both
days. Email is best, then, I don't usually check the newsgroup as
often as today.

Oh, the second Martinsville race is Sunday so forget me after about
3PM EST

Breck

On 23 Oct 2009 11:00:23 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

Quote:

Hi,

Could you please look at this and tell me if this shows an issue.

This is a database which has an index both DESC and ASC order of Invoice
Number:

SELECT * FROM BILLDET ORDER BY INVOICENUMBER

RunTime

Estimate: 0.32643
Actual: 1.4581

SELECT * FROM BILLDET ORDER BY INVOICENUMBER DESC

RunTime

Estimate: 2.5823
Actual: 4.098

Would there be a setting or a change from V9 to V11 which slows down
DESCENDING result sets?

That's my first question.

-Robert

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

#17

Hi,

Thank you - but you don't want to hear this. :-)

We have more issues unrelated so even if this is fixed, there are other
unrelated issues.

We have IIS which runs an old ASP. That ASP called a VB 6.0 object. That
VB6.0 object calls a Clarion (Pascal written) DLL. When we changed to the
V11 database, the objects are no longer related from memory on the file
sever. I was just alerted there were 22 objects on our file server
processes that I had to kill.

I put some tracing in the EXE's and it seems like the VB object are freezing
when it goes to uninitialized the DLL's - usual cause is a unresolved
release (free) of some pointer or some memory leak somewhere. These things
have been running and not touched for years.

It's quite odd because it's still using the same drivers.

If the IIS > ASP > VB 6 > Clarion DLL is executed and never opens a
connection to the database ... the object is released without issue. (ie: I
put a return prior to the connection to the database)

If the IIS > ASP > VB6 > Clarion DLL is executed and it opens a connection
to the V11 database ... the program runs fine, the writes and updates are
fine to the database, the program goes all the way to the end, exits, goes
back to the VB6 object - but is never released from memory and it sits as a
working process on the server.

If the IIS > ASP > VB6 > Clarion DLL is executed, and opens a connection to
the V9 database ... everything works fine and there are no objects
(processes) running on the server.

So ... with all that said, the performance issue, and now the objects not
releasing from the server once it makes a connection ... we need to stick to
the old Sybase SQL Anywhere 9.02 --- even if the performance issues are
resolved, now there are these issues too.

I don't think Sybase wants to deal with IIS or ASP or VB6 or Clarion for
that matter. Too many flavors of people involved.

(SV,MS and Sybase)

-Robert

#18

Hi Robert,

Robert Paresi wrote:

Quote:

I don't know what your position is with Sybase or if your information is
an 'official' source.

Breck Certer is not a Sybase employee - but he does have signficant
experience with our product and is part of "TeamSybase":
http://www.sybase.com/support/newsgroups/teamsybase

Quote:

You may be here to 'help' - but right now, we are in a predictement
where this whole thing is completely frustrating.

This is understandable, but please remember that Breck is here as a
generous volunteer. Working with technical support is the official
channel to use if "you're in a predicament" since we can dedicate
resources to work with you one-on-one and focus on your problem.

Quote:

I'm highly doubting
it's fragmentation issues because it's two database, two entirely
different systems all behaving in the same manner. It may be changes in
the way the database handles things because of our application
development tool. Getting support for that tool is worse and close to
being unsupported - and you really don't know where they stand on anything.

Sybase obviously cannot speak to the internals of the Clarion driver,
but we can try to recommend optimizations to the queries that the driver
gives us if Clarion is interested in making these optimizations in newer
versions. Otherwise, we can only optimize the queries as we get them
from the database side - any alteration to the behaviour in the middle
would require Clarion to step in.

Quote:

It's far easier to put everything back to the way it was and just leave
it alone. My problem is that V9 GPF's when using WIN7 so now I'm in a
catch - 22.

We have not released official support for Windows 7 as of yet, not even
for the 'latest and greatest' versions. Windows 7 went GA only
yesterday. If there are unexpected issues on Windows 7, we would advise
moving to a supported OS until our QA department has confirmed support
on a recommended build.

Quote:

We give Sybase close to 100K a year in sales --- I'm not going to be
placed in some support tree and go through some help line tree.

Our technical support staff (including myself) still do not have a 'help
line tree' to work off of:

http://groups.google.com/group/sybas...5544a78fc8510c

We work very hard to diagnose and fix all sorts of issues, across all
sorts of operating systems (Windows, UNIX, Mac OS, and mobile
platforms), for all sorts of APIs. Each customer problem is unique and a
new challenge.

Quote:

For example ... the compiler (RAD TOOL) does a select x from y order by
keyfield desc - to find the next primary key. It was extremely fast in
V9, but it seems like it is 1 to 5 seconds on V11. I know that "select
first" is sub-second, but we do not control what the driver does in the
application - again, it is a RAD tool. I have no clue why SQA 11 would
handle this different than SQA 9 but it does ... with a huge lag.

As is the case with your other thread, this is best diagnosed with a
graphical plan to see what the optimizer is now doing differently and
where the time is being used up.

Quote:

There has got to be a way to migrate a DB back to V9.

We do not supply such a mechanism, since there are many changes between
those versions and many features that were introduced that would break
such a mechanism if those features are not there in earlier versions.
Our expectation is that developers only move to a new database version
after their own QA tests have confirmed no introduced issues with the
new software version.

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

I need instructions to bring a DB from V11 to V9 fast please

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 11:49 AM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 12:02 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 12:08 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 01:00 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 01:22 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 01:24 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 01:34 PM

Re: I need instructions to bring a DB from V11 to V9 fast please - 10-23-2009 , 05:11 PM