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.

ASA 32 bit to 64 bit

17 posts in General Discussion (old) Last posting was on 2010-01-28 11:44:39.0Z
Adi B. Wiratmo Posted on 2009-11-19 04:08:21.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
Subject: ASA 32 bit to 64 bit
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b04c4b5@forums-1-dub>
Date: 18 Nov 2009 20:08:21 -0800
X-Trace: forums-1-dub 1258603701 10.22.241.152 (18 Nov 2009 20:08:21 -0800)
X-Original-Trace: 18 Nov 2009 20:08:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:320
Article PK: 866747

Hi All, is there a link (information) about the difference of ASA 32 bit and
64 bit ? Right know we still using ASA 32 bit but want to change to 64 bit
because the new server is compatible. What I have to do ? Must I konvert,
upgrade, or something like that ?

regards,
-adi-


"Nick Elson [Sybase iAnywhere]" < Posted on 2009-11-19 15:29:01.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub>
In-Reply-To: <4b04c4b5@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 46
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b05643d@forums-1-dub>
Date: 19 Nov 2009 07:29:01 -0800
X-Trace: forums-1-dub 1258644541 10.22.241.152 (19 Nov 2009 07:29:01 -0800)
X-Original-Trace: 19 Nov 2009 07:29:01 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:321
Article PK: 866748

There should be very few differences for the server. Database files are
binarily compatable (as always) so there should be no conversion
requirements
and the biggest differences will mostly be isolated to the amount of
cache/memory
you can utilize and possibly performance.

Some client side issues (say with the 32bit verses 64bit ODBC driver
managers
on Windows for example) may be a little different than you are use to so you
might
want to be aware of that possibility as well.

All in all, though, it is basically the same product just compiled with a
different
instruction set. There may be a possibility of a minimum OS version or
a minimum EBF requirement so check out this link

http://www.sybase.com/detail?id=1002288

and follow any 64bit specific footnotes (if any) for the fine print on
anything that has one.

Also be certain to click on the "More Info" links for your specific
release/version/ebf at
and that will take to a 'Components by Platform' page

http://www.sybase.com/detail?id=1062080#SA

to see if there are specific features affected (for example in
some cases only the 32bit JRE is available/supported/included).


HTH

"Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
news:4b04c4b5@forums-1-dub...
> Hi All, is there a link (information) about the difference of ASA 32 bit
> and 64 bit ? Right know we still using ASA 32 bit but want to change to 64
> bit because the new server is compatible. What I have to do ? Must I
> konvert, upgrade, or something like that ?
>
> regards,
> -adi-
>


Adi B. Wiratmo Posted on 2009-11-28 19:13:45.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b117669@forums-1-dub>
Date: 28 Nov 2009 11:13:45 -0800
X-Trace: forums-1-dub 1259435625 10.22.241.152 (28 Nov 2009 11:13:45 -0800)
X-Original-Trace: 28 Nov 2009 11:13:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:323
Article PK: 866750

Hi Nick, thanks for the respon. We still run the 32bit database version.
Three days ago we switch to the new server. But after middle night there is
always an error when try to make a new connection to the database. With the
old server we never found trouble like this. The trouble always be solved
after we restart the dbsrv9 engine. But for the client that still connect to
the database there is no problem, still connect, also can update the data.
(We still run ASA 9.02 eventhough we have bought ASA 11.00).

Here the new server spesification :

HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
DDR3-1333, HT, Turbo 2/2/3/3)
Cache Memory 8Mb (1x8Mb) level 3 cache
Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
Etc. ...

And we put this parameter for the dbsrv9 engine :
-c 9Gb -cw ....

What's the error cause ? Thanks for the answer.

regards,
-adi-

"Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
in message news:4b05643d@forums-1-dub...
> There should be very few differences for the server. Database files are
> binarily compatable (as always) so there should be no conversion
> requirements
> and the biggest differences will mostly be isolated to the amount of
> cache/memory
> you can utilize and possibly performance.
>
> Some client side issues (say with the 32bit verses 64bit ODBC driver
> managers
> on Windows for example) may be a little different than you are use to so
> you might
> want to be aware of that possibility as well.
>
> All in all, though, it is basically the same product just compiled with a
> different
> instruction set. There may be a possibility of a minimum OS version or
> a minimum EBF requirement so check out this link
>
> http://www.sybase.com/detail?id=1002288
>
> and follow any 64bit specific footnotes (if any) for the fine print on
> anything that has one.
>
> Also be certain to click on the "More Info" links for your specific
> release/version/ebf at
> and that will take to a 'Components by Platform' page
>
> http://www.sybase.com/detail?id=1062080#SA
>
> to see if there are specific features affected (for example in
> some cases only the 32bit JRE is available/supported/included).
>
>
> HTH
>
> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
> news:4b04c4b5@forums-1-dub...
>> Hi All, is there a link (information) about the difference of ASA 32 bit
>> and 64 bit ? Right know we still using ASA 32 bit but want to change to
>> 64 bit because the new server is compatible. What I have to do ? Must I
>> konvert, upgrade, or something like that ?
>>
>> regards,
>> -adi-
>>
>


"Nick Elson [Sybase iAnywhere]" < Posted on 2009-12-02 21:37:56.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub>
In-Reply-To: <4b117669@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 101
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b16de34$1@forums-1-dub>
Date: 2 Dec 2009 13:37:56 -0800
X-Trace: forums-1-dub 1259789876 10.22.241.152 (2 Dec 2009 13:37:56 -0800)
X-Original-Trace: 2 Dec 2009 13:37:56 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:324
Article PK: 866752

I'm not certain why that should be the case but since you
were not having that issue with the old hardware it may
not be our software. But do make sure you are running
a recent build of 9.0.2 if you don't go to 11.0.1 instead.

Since it is connectivity that is affected, you should identify
if TCP/IP vs shared memory connections behave differently
and if one type still works then this could be related to
the stack/facility that is not working.

You may have just ran too low on some resource. Maybe
even memory since you were using AWE and a cache size
of 9GB. Not enough hard RAM might be an issue. Not
enough availble RAM may be another (is this system overloaded
with multiple VM sessions whereas the older machine
had more bare hardware dedicated to this function?).

If you are not be getting all the cache you were used
to (there should be indications in the console (-o) log
concerning that) then extremely slow performance can
result making it appear like a hang.

"Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
news:4b117669@forums-1-dub...
> Hi Nick, thanks for the respon. We still run the 32bit database version.
> Three days ago we switch to the new server. But after middle night there
> is always an error when try to make a new connection to the database. With
> the old server we never found trouble like this. The trouble always be
> solved after we restart the dbsrv9 engine. But for the client that still
> connect to the database there is no problem, still connect, also can
> update the data. (We still run ASA 9.02 eventhough we have bought ASA
> 11.00).
>
> Here the new server spesification :
>
> HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
> Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
> DDR3-1333, HT, Turbo 2/2/3/3)
> Cache Memory 8Mb (1x8Mb) level 3 cache
> Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
> Etc. ...
>
> And we put this parameter for the dbsrv9 engine :
> -c 9Gb -cw ....
>
> What's the error cause ? Thanks for the answer.
>
> regards,
> -adi-
>
> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
> in message news:4b05643d@forums-1-dub...
>> There should be very few differences for the server. Database files are
>> binarily compatable (as always) so there should be no conversion
>> requirements
>> and the biggest differences will mostly be isolated to the amount of
>> cache/memory
>> you can utilize and possibly performance.
>>
>> Some client side issues (say with the 32bit verses 64bit ODBC driver
>> managers
>> on Windows for example) may be a little different than you are use to so
>> you might
>> want to be aware of that possibility as well.
>>
>> All in all, though, it is basically the same product just compiled with a
>> different
>> instruction set. There may be a possibility of a minimum OS version or
>> a minimum EBF requirement so check out this link
>>
>> http://www.sybase.com/detail?id=1002288
>>
>> and follow any 64bit specific footnotes (if any) for the fine print on
>> anything that has one.
>>
>> Also be certain to click on the "More Info" links for your specific
>> release/version/ebf at
>> and that will take to a 'Components by Platform' page
>>
>> http://www.sybase.com/detail?id=1062080#SA
>>
>> to see if there are specific features affected (for example in
>> some cases only the 32bit JRE is available/supported/included).
>>
>>
>> HTH
>>
>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>> news:4b04c4b5@forums-1-dub...
>>> Hi All, is there a link (information) about the difference of ASA 32 bit
>>> and 64 bit ? Right know we still using ASA 32 bit but want to change to
>>> 64 bit because the new server is compatible. What I have to do ? Must I
>>> konvert, upgrade, or something like that ?
>>>
>>> regards,
>>> -adi-
>>>
>>
>
>


Adi B. Wiratmo Posted on 2009-12-04 03:57:55.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 112
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b1888c3@forums-1-dub>
Date: 3 Dec 2009 19:57:55 -0800
X-Trace: forums-1-dub 1259899075 10.22.241.152 (3 Dec 2009 19:57:55 -0800)
X-Original-Trace: 3 Dec 2009 19:57:55 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:325
Article PK: 866751

Nick, thank you, you're right. It was an hardware problem. And the problem
was solved. As soon as possible I will implement the 11.01 version. What
should I consider before implementing the new version ?

regards,
-adi-

"Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
in message news:4b16de34$1@forums-1-dub...
> I'm not certain why that should be the case but since you
> were not having that issue with the old hardware it may
> not be our software. But do make sure you are running
> a recent build of 9.0.2 if you don't go to 11.0.1 instead.
>
> Since it is connectivity that is affected, you should identify
> if TCP/IP vs shared memory connections behave differently
> and if one type still works then this could be related to
> the stack/facility that is not working.
>
> You may have just ran too low on some resource. Maybe
> even memory since you were using AWE and a cache size
> of 9GB. Not enough hard RAM might be an issue. Not
> enough availble RAM may be another (is this system overloaded
> with multiple VM sessions whereas the older machine
> had more bare hardware dedicated to this function?).
>
> If you are not be getting all the cache you were used
> to (there should be indications in the console (-o) log
> concerning that) then extremely slow performance can
> result making it appear like a hang.
>
> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
> news:4b117669@forums-1-dub...
>> Hi Nick, thanks for the respon. We still run the 32bit database version.
>> Three days ago we switch to the new server. But after middle night there
>> is always an error when try to make a new connection to the database.
>> With the old server we never found trouble like this. The trouble always
>> be solved after we restart the dbsrv9 engine. But for the client that
>> still connect to the database there is no problem, still connect, also
>> can update the data. (We still run ASA 9.02 eventhough we have bought ASA
>> 11.00).
>>
>> Here the new server spesification :
>>
>> HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
>> Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
>> DDR3-1333, HT, Turbo 2/2/3/3)
>> Cache Memory 8Mb (1x8Mb) level 3 cache
>> Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
>> Etc. ...
>>
>> And we put this parameter for the dbsrv9 engine :
>> -c 9Gb -cw ....
>>
>> What's the error cause ? Thanks for the answer.
>>
>> regards,
>> -adi-
>>
>> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
>> wrote in message news:4b05643d@forums-1-dub...
>>> There should be very few differences for the server. Database files are
>>> binarily compatable (as always) so there should be no conversion
>>> requirements
>>> and the biggest differences will mostly be isolated to the amount of
>>> cache/memory
>>> you can utilize and possibly performance.
>>>
>>> Some client side issues (say with the 32bit verses 64bit ODBC driver
>>> managers
>>> on Windows for example) may be a little different than you are use to so
>>> you might
>>> want to be aware of that possibility as well.
>>>
>>> All in all, though, it is basically the same product just compiled with
>>> a different
>>> instruction set. There may be a possibility of a minimum OS version or
>>> a minimum EBF requirement so check out this link
>>>
>>> http://www.sybase.com/detail?id=1002288
>>>
>>> and follow any 64bit specific footnotes (if any) for the fine print on
>>> anything that has one.
>>>
>>> Also be certain to click on the "More Info" links for your specific
>>> release/version/ebf at
>>> and that will take to a 'Components by Platform' page
>>>
>>> http://www.sybase.com/detail?id=1062080#SA
>>>
>>> to see if there are specific features affected (for example in
>>> some cases only the 32bit JRE is available/supported/included).
>>>
>>>
>>> HTH
>>>
>>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>>> news:4b04c4b5@forums-1-dub...
>>>> Hi All, is there a link (information) about the difference of ASA 32
>>>> bit and 64 bit ? Right know we still using ASA 32 bit but want to
>>>> change to 64 bit because the new server is compatible. What I have to
>>>> do ? Must I konvert, upgrade, or something like that ?
>>>>
>>>> regards,
>>>> -adi-
>>>>
>>>
>>
>>
>


Adi B. Wiratmo Posted on 2010-01-08 05:49:46.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 124
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b46c77a@forums-1-dub>
Date: 7 Jan 2010 21:49:46 -0800
X-Trace: forums-1-dub 1262929786 10.22.241.152 (7 Jan 2010 21:49:46 -0800)
X-Original-Trace: 7 Jan 2010 21:49:46 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:332
Article PK: 866759

Nick, sorry I still have a trouble with my ASA server. Sometimes there is a
"memory exhausted" error. With the prior server the trouble never found
after we upgrade ASA 9.00 to ASA 9.02. Is the error caused by the hardware,
operating system, or the sybase ASA ? Thanks.

regard,
-adi-

"Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
news:4b1888c3@forums-1-dub...
> Nick, thank you, you're right. It was an hardware problem. And the problem
> was solved. As soon as possible I will implement the 11.01 version. What
> should I consider before implementing the new version ?
>
> regards,
> -adi-
>
> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
> in message news:4b16de34$1@forums-1-dub...
>> I'm not certain why that should be the case but since you
>> were not having that issue with the old hardware it may
>> not be our software. But do make sure you are running
>> a recent build of 9.0.2 if you don't go to 11.0.1 instead.
>>
>> Since it is connectivity that is affected, you should identify
>> if TCP/IP vs shared memory connections behave differently
>> and if one type still works then this could be related to
>> the stack/facility that is not working.
>>
>> You may have just ran too low on some resource. Maybe
>> even memory since you were using AWE and a cache size
>> of 9GB. Not enough hard RAM might be an issue. Not
>> enough availble RAM may be another (is this system overloaded
>> with multiple VM sessions whereas the older machine
>> had more bare hardware dedicated to this function?).
>>
>> If you are not be getting all the cache you were used
>> to (there should be indications in the console (-o) log
>> concerning that) then extremely slow performance can
>> result making it appear like a hang.
>>
>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>> news:4b117669@forums-1-dub...
>>> Hi Nick, thanks for the respon. We still run the 32bit database version.
>>> Three days ago we switch to the new server. But after middle night there
>>> is always an error when try to make a new connection to the database.
>>> With the old server we never found trouble like this. The trouble always
>>> be solved after we restart the dbsrv9 engine. But for the client that
>>> still connect to the database there is no problem, still connect, also
>>> can update the data. (We still run ASA 9.02 eventhough we have bought
>>> ASA 11.00).
>>>
>>> Here the new server spesification :
>>>
>>> HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
>>> Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
>>> DDR3-1333, HT, Turbo 2/2/3/3)
>>> Cache Memory 8Mb (1x8Mb) level 3 cache
>>> Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
>>> Etc. ...
>>>
>>> And we put this parameter for the dbsrv9 engine :
>>> -c 9Gb -cw ....
>>>
>>> What's the error cause ? Thanks for the answer.
>>>
>>> regards,
>>> -adi-
>>>
>>> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
>>> wrote in message news:4b05643d@forums-1-dub...
>>>> There should be very few differences for the server. Database files are
>>>> binarily compatable (as always) so there should be no conversion
>>>> requirements
>>>> and the biggest differences will mostly be isolated to the amount of
>>>> cache/memory
>>>> you can utilize and possibly performance.
>>>>
>>>> Some client side issues (say with the 32bit verses 64bit ODBC driver
>>>> managers
>>>> on Windows for example) may be a little different than you are use to
>>>> so you might
>>>> want to be aware of that possibility as well.
>>>>
>>>> All in all, though, it is basically the same product just compiled with
>>>> a different
>>>> instruction set. There may be a possibility of a minimum OS version or
>>>> a minimum EBF requirement so check out this link
>>>>
>>>> http://www.sybase.com/detail?id=1002288
>>>>
>>>> and follow any 64bit specific footnotes (if any) for the fine print on
>>>> anything that has one.
>>>>
>>>> Also be certain to click on the "More Info" links for your specific
>>>> release/version/ebf at
>>>> and that will take to a 'Components by Platform' page
>>>>
>>>> http://www.sybase.com/detail?id=1062080#SA
>>>>
>>>> to see if there are specific features affected (for example in
>>>> some cases only the 32bit JRE is available/supported/included).
>>>>
>>>>
>>>> HTH
>>>>
>>>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>>>> news:4b04c4b5@forums-1-dub...
>>>>> Hi All, is there a link (information) about the difference of ASA 32
>>>>> bit and 64 bit ? Right know we still using ASA 32 bit but want to
>>>>> change to 64 bit because the new server is compatible. What I have to
>>>>> do ? Must I konvert, upgrade, or something like that ?
>>>>>
>>>>> regards,
>>>>> -adi-
>>>>>
>>>>
>>>
>>>
>>
>
>


"Nick Elson [Sybase iAnywhere]" < Posted on 2010-01-08 17:38:56.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub>
In-Reply-To: <4b46c77a@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 146
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b476db0$1@forums-1-dub>
Date: 8 Jan 2010 09:38:56 -0800
X-Trace: forums-1-dub 1262972336 10.22.241.152 (8 Jan 2010 09:38:56 -0800)
X-Original-Trace: 8 Jan 2010 09:38:56 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:333
Article PK: 866760

In my experience that is usually it is a function of usage.

But depending upon the exact conditions, bigger tables,
more complex queries, more connections, not enough
cache, not enough physical RAM, swap/paging file too small
(especially if on a new machine that is configured differently)
and even the bit-ness of the binary vs platform can all be
contributing factors.

You may need to work directly with technical support to
help narrow this down.

Do make sure your command line is specifying the correct
amount of cache and you are just not reaching the limits
of a 32bit binary.

"Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
news:4b46c77a@forums-1-dub...
> Nick, sorry I still have a trouble with my ASA server. Sometimes there is
> a "memory exhausted" error. With the prior server the trouble never found
> after we upgrade ASA 9.00 to ASA 9.02. Is the error caused by the
> hardware, operating system, or the sybase ASA ? Thanks.
>
> regard,
> -adi-
>
> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
> news:4b1888c3@forums-1-dub...
>> Nick, thank you, you're right. It was an hardware problem. And the
>> problem was solved. As soon as possible I will implement the 11.01
>> version. What should I consider before implementing the new version ?
>>
>> regards,
>> -adi-
>>
>> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
>> wrote in message news:4b16de34$1@forums-1-dub...
>>> I'm not certain why that should be the case but since you
>>> were not having that issue with the old hardware it may
>>> not be our software. But do make sure you are running
>>> a recent build of 9.0.2 if you don't go to 11.0.1 instead.
>>>
>>> Since it is connectivity that is affected, you should identify
>>> if TCP/IP vs shared memory connections behave differently
>>> and if one type still works then this could be related to
>>> the stack/facility that is not working.
>>>
>>> You may have just ran too low on some resource. Maybe
>>> even memory since you were using AWE and a cache size
>>> of 9GB. Not enough hard RAM might be an issue. Not
>>> enough availble RAM may be another (is this system overloaded
>>> with multiple VM sessions whereas the older machine
>>> had more bare hardware dedicated to this function?).
>>>
>>> If you are not be getting all the cache you were used
>>> to (there should be indications in the console (-o) log
>>> concerning that) then extremely slow performance can
>>> result making it appear like a hang.
>>>
>>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>>> news:4b117669@forums-1-dub...
>>>> Hi Nick, thanks for the respon. We still run the 32bit database
>>>> version. Three days ago we switch to the new server. But after middle
>>>> night there is always an error when try to make a new connection to the
>>>> database. With the old server we never found trouble like this. The
>>>> trouble always be solved after we restart the dbsrv9 engine. But for
>>>> the client that still connect to the database there is no problem,
>>>> still connect, also can update the data. (We still run ASA 9.02
>>>> eventhough we have bought ASA 11.00).
>>>>
>>>> Here the new server spesification :
>>>>
>>>> HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
>>>> Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
>>>> DDR3-1333, HT, Turbo 2/2/3/3)
>>>> Cache Memory 8Mb (1x8Mb) level 3 cache
>>>> Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
>>>> Etc. ...
>>>>
>>>> And we put this parameter for the dbsrv9 engine :
>>>> -c 9Gb -cw ....
>>>>
>>>> What's the error cause ? Thanks for the answer.
>>>>
>>>> regards,
>>>> -adi-
>>>>
>>>> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
>>>> wrote in message news:4b05643d@forums-1-dub...
>>>>> There should be very few differences for the server. Database files
>>>>> are
>>>>> binarily compatable (as always) so there should be no conversion
>>>>> requirements
>>>>> and the biggest differences will mostly be isolated to the amount of
>>>>> cache/memory
>>>>> you can utilize and possibly performance.
>>>>>
>>>>> Some client side issues (say with the 32bit verses 64bit ODBC driver
>>>>> managers
>>>>> on Windows for example) may be a little different than you are use to
>>>>> so you might
>>>>> want to be aware of that possibility as well.
>>>>>
>>>>> All in all, though, it is basically the same product just compiled
>>>>> with a different
>>>>> instruction set. There may be a possibility of a minimum OS version
>>>>> or
>>>>> a minimum EBF requirement so check out this link
>>>>>
>>>>> http://www.sybase.com/detail?id=1002288
>>>>>
>>>>> and follow any 64bit specific footnotes (if any) for the fine print on
>>>>> anything that has one.
>>>>>
>>>>> Also be certain to click on the "More Info" links for your specific
>>>>> release/version/ebf at
>>>>> and that will take to a 'Components by Platform' page
>>>>>
>>>>> http://www.sybase.com/detail?id=1062080#SA
>>>>>
>>>>> to see if there are specific features affected (for example in
>>>>> some cases only the 32bit JRE is available/supported/included).
>>>>>
>>>>>
>>>>> HTH
>>>>>
>>>>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>>>>> news:4b04c4b5@forums-1-dub...
>>>>>> Hi All, is there a link (information) about the difference of ASA 32
>>>>>> bit and 64 bit ? Right know we still using ASA 32 bit but want to
>>>>>> change to 64 bit because the new server is compatible. What I have to
>>>>>> do ? Must I konvert, upgrade, or something like that ?
>>>>>>
>>>>>> regards,
>>>>>> -adi-
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
>


Jeff Albion [Sybase iAnywhere] Posted on 2010-01-08 21:15:47.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: ASA 32 bit to 64 bit
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub>
In-Reply-To: <4b476db0$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b47a083$1@forums-1-dub>
Date: 8 Jan 2010 13:15:47 -0800
X-Trace: forums-1-dub 1262985347 10.22.241.152 (8 Jan 2010 13:15:47 -0800)
X-Original-Trace: 8 Jan 2010 13:15:47 -0800, vip152.sybase.com
Lines: 32
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:334
Article PK: 866761

Hi Adi,

FWIW, I have also seen this error in cases where a customer has set
their "-gn" switch way too high and each connection has a very small
window of memory to perform queries. The algorithm we use to form soft
and hard limits for memory allocation based on the -gn switch can be
found here:
http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html

Have you changed the -gn switch to something other than the default (20)?

---

Also, since I can't seem to find the reference in the thread - which OS
version (and bitness) are you running? Did you go from a 32-bit OS to a
64-bit OS when moving machines as well?

Regards,

On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
> You may need to work directly with technical support to
> help narrow this down.

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Adi B. Wiratmo Posted on 2010-01-09 01:11:12.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b47d7b0@forums-1-dub>
Date: 8 Jan 2010 17:11:12 -0800
X-Trace: forums-1-dub 1262999472 10.22.241.152 (8 Jan 2010 17:11:12 -0800)
X-Original-Trace: 8 Jan 2010 17:11:12 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:335
Article PK: 866762

Nick and Jeff, thanks for the respon. I put the database parameter like this
:

"c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G -cw
d:\dbserver\immanuel.db

Something wrong with the parameter ? I use no -gn switch. The capacity of
RAM is 12 Gb. And both the windows and sybase ASA 9.02 still use 32 bit.
Also we use fiber optic for the network backbone. Jeff, I still reading your
link. Thanks.

regards,
-adi-

"Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com> wrote in
message news:4b47a083$1@forums-1-dub...
> Hi Adi,
>
> FWIW, I have also seen this error in cases where a customer has set their
> "-gn" switch way too high and each connection has a very small window of
> memory to perform queries. The algorithm we use to form soft and hard
> limits for memory allocation based on the -gn switch can be found here:
> http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html
>
> Have you changed the -gn switch to something other than the default (20)?
>
> ---
>
> Also, since I can't seem to find the reference in the thread - which OS
> version (and bitness) are you running? Did you go from a 32-bit OS to a
> 64-bit OS when moving machines as well?
>
> Regards,
>
> On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
>> You may need to work directly with technical support to
>> help narrow this down.
>
> --
> Jeff Albion, Sybase iAnywhere
>
> iAnywhere Developer Community :
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> SQL Anywhere Patches and EBFs :
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case : http://case-express.sybase.com/cx/


R. Pods Posted on 2010-01-11 09:03:15.0Z
From: "R. Pods" <r.pods@gmx.net>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: ASA 32 bit to 64 bit
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub>
In-Reply-To: <4b47d7b0@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4ae953@forums-1-dub>
Date: 11 Jan 2010 01:03:15 -0800
X-Trace: forums-1-dub 1263200595 10.22.241.152 (11 Jan 2010 01:03:15 -0800)
X-Original-Trace: 11 Jan 2010 01:03:15 -0800, vip152.sybase.com
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:337
Article PK: 841542

Adi,

AFAIK a 32 bit process is limited to 4 GB virtual memory size. According
to the documentation of the -cw switch it looks like the maximum cache
size is 2.7 GB. You might want to try starting the engine with that
value (or even less and incrementing later) to see if the problem persists.

Regards
Reimer

Adi B. Wiratmo wrote:
> Nick and Jeff, thanks for the respon. I put the database parameter like this
> :
>
> "c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G -cw
> d:\dbserver\immanuel.db
>
> Something wrong with the parameter ? I use no -gn switch. The capacity of
> RAM is 12 Gb. And both the windows and sybase ASA 9.02 still use 32 bit.
> Also we use fiber optic for the network backbone. Jeff, I still reading your
> link. Thanks.
>
> regards,
> -adi-
>
> "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com> wrote in
> message news:4b47a083$1@forums-1-dub...
>> Hi Adi,
>>
>> FWIW, I have also seen this error in cases where a customer has set their
>> "-gn" switch way too high and each connection has a very small window of
>> memory to perform queries. The algorithm we use to form soft and hard
>> limits for memory allocation based on the -gn switch can be found here:
>> http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html
>>
>> Have you changed the -gn switch to something other than the default (20)?
>>
>> ---
>>
>> Also, since I can't seem to find the reference in the thread - which OS
>> version (and bitness) are you running? Did you go from a 32-bit OS to a
>> 64-bit OS when moving machines as well?
>>
>> Regards,
>>
>> On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
>>> You may need to work directly with technical support to
>>> help narrow this down.
>> --
>> Jeff Albion, Sybase iAnywhere
>>
>> iAnywhere Developer Community :
>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>> iAnywhere Documentation :
>> http://www.ianywhere.com/developer/product_manuals
>> SQL Anywhere Patches and EBFs :
>> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>> Report a Bug/Open a Case : http://case-express.sybase.com/cx/
>
>
>


"Nick Elson [Sybase iAnywhere]" < Posted on 2010-01-11 14:56:48.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub> <4b4ae953@forums-1-dub>
In-Reply-To: <4b4ae953@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 84
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="ISO-8859-15"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4b3c30$1@forums-1-dub>
Date: 11 Jan 2010 06:56:48 -0800
X-Trace: forums-1-dub 1263221808 10.22.241.152 (11 Jan 2010 06:56:48 -0800)
X-Original-Trace: 11 Jan 2010 06:56:48 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:338
Article PK: 866765

You should be able to go up the limit supported by the platform.
[see the docs for the -cw switch] 2.7GB is not an AWE
limit but the limit for the non-AWE /3GB boot.ini limit for
32bit OSs from Microsoft, so your -c 8GB should be fine with
your hardware if the OS supports it.

But now that we know you are running with AWE (-cw), maybe
this is a function of the undocumented -cm switch. Try adding this
switch setting to your server cmdline

-cm 1G

[currently you are running with the equivalent of -cm 512M and
that 1/2 GB is probably the memory being exhausted]

P.S. this is documented in the V10+ docs if you want to read up
on it.

"R. Pods" <r.pods@gmx.net> wrote in message news:4b4ae953@forums-1-dub...
> Adi,
>
> AFAIK a 32 bit process is limited to 4 GB virtual memory size. According
> to the documentation of the -cw switch it looks like the maximum cache
> size is 2.7 GB. You might want to try starting the engine with that value
> (or even less and incrementing later) to see if the problem persists.
>
> Regards
> Reimer
>
> Adi B. Wiratmo wrote:
>> Nick and Jeff, thanks for the respon. I put the database parameter like
>> this
>> :
>>
>> "c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G -cw
>> d:\dbserver\immanuel.db
>>
>> Something wrong with the parameter ? I use no -gn switch. The capacity of
>> RAM is 12 Gb. And both the windows and sybase ASA 9.02 still use 32 bit.
>> Also we use fiber optic for the network backbone. Jeff, I still reading
>> your
>> link. Thanks.
>>
>> regards,
>> -adi-
>>
>> "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com> wrote
>> in
>> message news:4b47a083$1@forums-1-dub...
>>> Hi Adi,
>>>
>>> FWIW, I have also seen this error in cases where a customer has set
>>> their
>>> "-gn" switch way too high and each connection has a very small window of
>>> memory to perform queries. The algorithm we use to form soft and hard
>>> limits for memory allocation based on the -gn switch can be found here:
>>> http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html
>>>
>>> Have you changed the -gn switch to something other than the default
>>> (20)?
>>>
>>> ---
>>>
>>> Also, since I can't seem to find the reference in the thread - which OS
>>> version (and bitness) are you running? Did you go from a 32-bit OS to a
>>> 64-bit OS when moving machines as well?
>>>
>>> Regards,
>>>
>>> On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
>>>> You may need to work directly with technical support to
>>>> help narrow this down.
>>> --
>>> Jeff Albion, Sybase iAnywhere
>>>
>>> iAnywhere Developer Community :
>>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>>> iAnywhere Documentation :
>>> http://www.ianywhere.com/developer/product_manuals
>>> SQL Anywhere Patches and EBFs :
>>> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>>> Report a Bug/Open a Case : http://case-express.sybase.com/cx/
>>
>>


Adi B. Wiratmo Posted on 2010-01-12 00:47:39.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub> <4b4ae953@forums-1-dub> <4b4b3c30$1@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 97
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4bc6ab@forums-1-dub>
Date: 11 Jan 2010 16:47:39 -0800
X-Trace: forums-1-dub 1263257259 10.22.241.152 (11 Jan 2010 16:47:39 -0800)
X-Original-Trace: 11 Jan 2010 16:47:39 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:340
Article PK: 866764

Reimer and Nick thank you for the respons. You are right Nick, I use AWE. I
will do what Nick suggestion, use the -cm switch. Hope this solve the error.
Thank you.

regards,
-adi-

"Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
in message news:4b4b3c30$1@forums-1-dub...
> You should be able to go up the limit supported by the platform.
> [see the docs for the -cw switch] 2.7GB is not an AWE
> limit but the limit for the non-AWE /3GB boot.ini limit for
> 32bit OSs from Microsoft, so your -c 8GB should be fine with
> your hardware if the OS supports it.
>
> But now that we know you are running with AWE (-cw), maybe
> this is a function of the undocumented -cm switch. Try adding this
> switch setting to your server cmdline
>
> -cm 1G
>
> [currently you are running with the equivalent of -cm 512M and
> that 1/2 GB is probably the memory being exhausted]
>
> P.S. this is documented in the V10+ docs if you want to read up
> on it.
>
> "R. Pods" <r.pods@gmx.net> wrote in message news:4b4ae953@forums-1-dub...
>> Adi,
>>
>> AFAIK a 32 bit process is limited to 4 GB virtual memory size. According
>> to the documentation of the -cw switch it looks like the maximum cache
>> size is 2.7 GB. You might want to try starting the engine with that value
>> (or even less and incrementing later) to see if the problem persists.
>>
>> Regards
>> Reimer
>>
>> Adi B. Wiratmo wrote:
>>> Nick and Jeff, thanks for the respon. I put the database parameter like
>>> this
>>> :
>>>
>>> "c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G -cw
>>> d:\dbserver\immanuel.db
>>>
>>> Something wrong with the parameter ? I use no -gn switch. The capacity
>>> of
>>> RAM is 12 Gb. And both the windows and sybase ASA 9.02 still use 32 bit.
>>> Also we use fiber optic for the network backbone. Jeff, I still reading
>>> your
>>> link. Thanks.
>>>
>>> regards,
>>> -adi-
>>>
>>> "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
>>> wrote in
>>> message news:4b47a083$1@forums-1-dub...
>>>> Hi Adi,
>>>>
>>>> FWIW, I have also seen this error in cases where a customer has set
>>>> their
>>>> "-gn" switch way too high and each connection has a very small window
>>>> of
>>>> memory to perform queries. The algorithm we use to form soft and hard
>>>> limits for memory allocation based on the -gn switch can be found here:
>>>> http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html
>>>>
>>>> Have you changed the -gn switch to something other than the default
>>>> (20)?
>>>>
>>>> ---
>>>>
>>>> Also, since I can't seem to find the reference in the thread - which OS
>>>> version (and bitness) are you running? Did you go from a 32-bit OS to a
>>>> 64-bit OS when moving machines as well?
>>>>
>>>> Regards,
>>>>
>>>> On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
>>>>> You may need to work directly with technical support to
>>>>> help narrow this down.
>>>> --
>>>> Jeff Albion, Sybase iAnywhere
>>>>
>>>> iAnywhere Developer Community :
>>>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>>>> iAnywhere Documentation :
>>>> http://www.ianywhere.com/developer/product_manuals
>>>> SQL Anywhere Patches and EBFs :
>>>> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>>>> Report a Bug/Open a Case : http://case-express.sybase.com/cx/
>>>
>>>


Adi B. Wiratmo Posted on 2010-01-28 07:27:50.0Z
From: "Adi B. Wiratmo" <adi_bangun@yahoo.com>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub> <4b4ae953@forums-1-dub> <4b4b3c30$1@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b613c76@forums-1-dub>
Date: 27 Jan 2010 23:27:50 -0800
X-Trace: forums-1-dub 1264663670 10.22.241.152 (27 Jan 2010 23:27:50 -0800)
X-Original-Trace: 27 Jan 2010 23:27:50 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:341
Article PK: 866767

Hi Nick, there is still error after we put -cm switch. I also seen
performance warning when restart dbsrv engine. Here is the statements :

Running on Windows 2003 Build 3790 Service Pack 2
6291456K of memory used for caching
Physical memory allocated : 2865880K
Using a maximun page size 8192 bytes
Starting database "immanuel" (d:\dbserver\immanuel.db) at Thu Jan 28 2010
14:06
Performance warning: Database file "d:\dbserver\immanuel.db" consitst of
5105 disk frafments

Is the performance warning caused the memory exhausted ? The size of
database is about 14 Gb in one database file. Must we make dbspace to
improve the performance ? Thanks for your responds.

regards,
-adi-

"Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
in message news:4b4b3c30$1@forums-1-dub...
> You should be able to go up the limit supported by the platform.
> [see the docs for the -cw switch] 2.7GB is not an AWE
> limit but the limit for the non-AWE /3GB boot.ini limit for
> 32bit OSs from Microsoft, so your -c 8GB should be fine with
> your hardware if the OS supports it.
>
> But now that we know you are running with AWE (-cw), maybe
> this is a function of the undocumented -cm switch. Try adding this
> switch setting to your server cmdline
>
> -cm 1G
>
> [currently you are running with the equivalent of -cm 512M and
> that 1/2 GB is probably the memory being exhausted]
>
> P.S. this is documented in the V10+ docs if you want to read up
> on it.
>
> "R. Pods" <r.pods@gmx.net> wrote in message news:4b4ae953@forums-1-dub...
>> Adi,
>>
>> AFAIK a 32 bit process is limited to 4 GB virtual memory size. According
>> to the documentation of the -cw switch it looks like the maximum cache
>> size is 2.7 GB. You might want to try starting the engine with that value
>> (or even less and incrementing later) to see if the problem persists.
>>
>> Regards
>> Reimer
>>
>> Adi B. Wiratmo wrote:
>>> Nick and Jeff, thanks for the respon. I put the database parameter like
>>> this
>>> :
>>>
>>> "c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G -cw
>>> d:\dbserver\immanuel.db
>>>
>>> Something wrong with the parameter ? I use no -gn switch. The capacity
>>> of
>>> RAM is 12 Gb. And both the windows and sybase ASA 9.02 still use 32 bit.
>>> Also we use fiber optic for the network backbone. Jeff, I still reading
>>> your
>>> link. Thanks.
>>>
>>> regards,
>>> -adi-
>>>
>>> "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
>>> wrote in
>>> message news:4b47a083$1@forums-1-dub...
>>>> Hi Adi,
>>>>
>>>> FWIW, I have also seen this error in cases where a customer has set
>>>> their
>>>> "-gn" switch way too high and each connection has a very small window
>>>> of
>>>> memory to perform queries. The algorithm we use to form soft and hard
>>>> limits for memory allocation based on the -gn switch can be found here:
>>>> http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-3713576.html
>>>>
>>>> Have you changed the -gn switch to something other than the default
>>>> (20)?
>>>>
>>>> ---
>>>>
>>>> Also, since I can't seem to find the reference in the thread - which OS
>>>> version (and bitness) are you running? Did you go from a 32-bit OS to a
>>>> 64-bit OS when moving machines as well?
>>>>
>>>> Regards,
>>>>
>>>> On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
>>>>> You may need to work directly with technical support to
>>>>> help narrow this down.
>>>> --
>>>> Jeff Albion, Sybase iAnywhere
>>>>
>>>> iAnywhere Developer Community :
>>>> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>>>> iAnywhere Documentation :
>>>> http://www.ianywhere.com/developer/product_manuals
>>>> SQL Anywhere Patches and EBFs :
>>>> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>>>> Report a Bug/Open a Case : http://case-express.sybase.com/cx/
>>>
>>>


Arthur Hefti Posted on 2010-01-28 11:44:39.0Z
From: "Arthur Hefti" <arthur@catsoft.ch>
Subject: Re: ASA 32 bit to 64 bit
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub> <4b4ae953@forums-1-dub> <4b4b3c30$1@forums-1-dub> <4b613c76@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b6178a7@forums-1-dub>
Date: 28 Jan 2010 03:44:39 -0800
X-Trace: forums-1-dub 1264679079 10.22.241.152 (28 Jan 2010 03:44:39 -0800)
X-Original-Trace: 28 Jan 2010 03:44:39 -0800, vip152.sybase.com
Lines: 122
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:342
Article PK: 841543

The performance warning tells you that your database file consists of
5105 chunks scattered all over your disk. This means that for pages not
in memory the database engine does a lot of reading on the disk with is
very time consuming. I would suggest that you defragment the hard
drive. Then you can either pre allocate DB space or defragment the hard
drive regulary.

Regards
Arthur

--

Adi B. Wiratmo wrote:

> Hi Nick, there is still error after we put -cm switch. I also seen
> performance warning when restart dbsrv engine. Here is the statements
> :
>
> Running on Windows 2003 Build 3790 Service Pack 2
> 6291456K of memory used for caching
> Physical memory allocated : 2865880K
> Using a maximun page size 8192 bytes
> Starting database "immanuel" (d:\dbserver\immanuel.db) at Thu Jan 28
> 2010 14:06 Performance warning: Database file
> "d:\dbserver\immanuel.db" consitst of 5105 disk frafments
>
> Is the performance warning caused the memory exhausted ? The size of
> database is about 14 Gb in one database file. Must we make dbspace to
> improve the performance ? Thanks for your responds.
>
> regards,
> -adi-
>
> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
> wrote in message news:4b4b3c30$1@forums-1-dub...
> > You should be able to go up the limit supported by the platform.
> > [see the docs for the -cw switch] 2.7GB is not an AWE
> > limit but the limit for the non-AWE /3GB boot.ini limit for
> > 32bit OSs from Microsoft, so your -c 8GB should be fine with
> > your hardware if the OS supports it.
> >
> > But now that we know you are running with AWE (-cw), maybe
> > this is a function of the undocumented -cm switch. Try adding this
> > switch setting to your server cmdline
> >
> > -cm 1G
> >
> > [currently you are running with the equivalent of -cm 512M and
> > that 1/2 GB is probably the memory being exhausted]
> >
> > P.S. this is documented in the V10+ docs if you want to read up
> > on it.
> >
> >"R. Pods" <r.pods@gmx.net> wrote in message
> news:4b4ae953@forums-1-dub...
> > > Adi,
> > >
> > > AFAIK a 32 bit process is limited to 4 GB virtual memory size.
> > > According to the documentation of the -cw switch it looks like
> > > the maximum cache size is 2.7 GB. You might want to try starting
> > > the engine with that value (or even less and incrementing later)
> > > to see if the problem persists.
> > >
> > > Regards
> > > Reimer
> > >
> > > Adi B. Wiratmo wrote:
> > > > Nick and Jeff, thanks for the respon. I put the database
> > > > parameter like this :
> > > >
> > > > "c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe" -c 8G
> > > > -cw d:\dbserver\immanuel.db
> > > >
> > > > Something wrong with the parameter ? I use no -gn switch. The
> > > > capacity of RAM is 12 Gb. And both the windows and sybase ASA
> > > > 9.02 still use 32 bit. Also we use fiber optic for the network
> > > > backbone. Jeff, I still reading your link. Thanks.
> > > >
> > > > regards,
> > > > -adi-
> > > >
> >>>"Jeff Albion [Sybase iAnywhere]"
> <firstname.lastname@ianywhere.com> wrote in
> > > > message news:4b47a083$1@forums-1-dub...
> > > > > Hi Adi,
> > > > >
> > > > > FWIW, I have also seen this error in cases where a customer
> > > > > has set their "-gn" switch way too high and each connection
> > > > > has a very small window of memory to perform queries. The
> > > > > algorithm we use to form soft and hard limits for memory
> > > > > allocation based on the -gn switch can be found here:
> > > > > http://dcx.sybase.com/index.php#html/dbdaen10/da-running-s-371
> > > > > 3576.html
> > > > >
> > > > > Have you changed the -gn switch to something other than the
> > > > > default (20)?
> > > > >
> > > > > ---
> > > > >
> > > > > Also, since I can't seem to find the reference in the thread
> > > > > - which OS version (and bitness) are you running? Did you go
> > > > > from a 32-bit OS to a 64-bit OS when moving machines as well?
> > > > >
> > > > > Regards,
> > > > >
> > > > > On 1/8/2010 12:38 PM, Nick Elson [Sybase iAnywhere] wrote:
> > > > > > You may need to work directly with technical support to
> > > > > > help narrow this down.
> > > > > -- Jeff Albion, Sybase iAnywhere
> > > > >
> > > > > iAnywhere Developer Community :
> > > > > http://www.sybase.com/developer/library/sql-anywhere-techcorne
> > > > > r iAnywhere Documentation :
> > > > > http://www.ianywhere.com/developer/product_manuals
> > > > > SQL Anywhere Patches and EBFs :
> > > > > http://downloads.sybase.com/swd/summary.do?baseprod=144&client
> > > > > =ianywhere&timeframe=0 Report a Bug/Open a Case :
> > > > > http://case-express.sybase.com/cx/
> > > >
> > > >


Breck Carter [TeamSybase] Posted on 2010-01-09 09:15:19.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Re: ASA 32 bit to 64 bit
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <f5igk595dfiukhqs75av4i8jpp3eh04bql@4ax.com>
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub> <4b46c77a@forums-1-dub> <4b476db0$1@forums-1-dub> <4b47a083$1@forums-1-dub> <4b47d7b0@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Jan 2010 01:15:19 -0800
X-Trace: forums-1-dub 1263028519 10.22.241.152 (9 Jan 2010 01:15:19 -0800)
X-Original-Trace: 9 Jan 2010 01:15:19 -0800, vip152.sybase.com
Lines: 20
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:336
Article PK: 866763

On 8 Jan 2010 17:11:12 -0800, "Adi B. Wiratmo" <adi_bangun@yahoo.com>

wrote:

>"c:\program files\sybase\sql anywhere9\win32\dbsrv9.exe"

If you trying to launch the 64-bit version, I think that's the wrong
folder. I don't have 64-bit installed for V9 but I *think* it's in the
win64 folder, or something like that... sorry for the vagueness, but
vague is all you'll probably get on Saturday :)

Breck

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

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail


"Nick Elson [Sybase iAnywhere]" < Posted on 2010-01-11 15:00:22.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
Newsgroups: sybase.public.sqlanywhere
References: <4b04c4b5@forums-1-dub> <4b05643d@forums-1-dub> <4b117669@forums-1-dub> <4b16de34$1@forums-1-dub> <4b1888c3@forums-1-dub>
In-Reply-To: <4b1888c3@forums-1-dub>
Subject: Re: ASA 32 bit to 64 bit
Lines: 131
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4b3d06$1@forums-1-dub>
Date: 11 Jan 2010 07:00:22 -0800
X-Trace: forums-1-dub 1263222022 10.22.241.152 (11 Jan 2010 07:00:22 -0800)
X-Original-Trace: 11 Jan 2010 07:00:22 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:339
Article PK: 866766

> What should I consider before implementing the new version ?

Test it first before migrating. The first hurtle most people
run into is the requirement to upgrade the database; which
in this case means a complete rebuild. While this is a very
good thing, it does represent a barrier to going backwards
if you ever decide to back out.

By testing with all your applicaitons you can verify no SQL
standard change nor feature evolution will conflict with
your existing design and usage. You will also want to
evaluate performance. It is not uncommon to address
a couple of small things and find it important to retune
a little bit, but all in all your upgrade should be pretty
smooth.

"Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
news:4b1888c3@forums-1-dub...
> Nick, thank you, you're right. It was an hardware problem. And the problem
> was solved. As soon as possible I will implement the 11.01 version. What
> should I consider before implementing the new version ?
>
> regards,
> -adi-
>
> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@> wrote
> in message news:4b16de34$1@forums-1-dub...
>> I'm not certain why that should be the case but since you
>> were not having that issue with the old hardware it may
>> not be our software. But do make sure you are running
>> a recent build of 9.0.2 if you don't go to 11.0.1 instead.
>>
>> Since it is connectivity that is affected, you should identify
>> if TCP/IP vs shared memory connections behave differently
>> and if one type still works then this could be related to
>> the stack/facility that is not working.
>>
>> You may have just ran too low on some resource. Maybe
>> even memory since you were using AWE and a cache size
>> of 9GB. Not enough hard RAM might be an issue. Not
>> enough availble RAM may be another (is this system overloaded
>> with multiple VM sessions whereas the older machine
>> had more bare hardware dedicated to this function?).
>>
>> If you are not be getting all the cache you were used
>> to (there should be indications in the console (-o) log
>> concerning that) then extremely slow performance can
>> result making it appear like a hang.
>>
>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>> news:4b117669@forums-1-dub...
>>> Hi Nick, thanks for the respon. We still run the 32bit database version.
>>> Three days ago we switch to the new server. But after middle night there
>>> is always an error when try to make a new connection to the database.
>>> With the old server we never found trouble like this. The trouble always
>>> be solved after we restart the dbsrv9 engine. But for the client that
>>> still connect to the database there is no problem, still connect, also
>>> can update the data. (We still run ASA 9.02 eventhough we have bought
>>> ASA 11.00).
>>>
>>> Here the new server spesification :
>>>
>>> HP DL380 G6 Model Quad Core Model HP DL380G6 X5550.
>>> Processor : (2) intel xeon processor x5550 (2.6 Ghz, 8MB L3 Cache, 95W,
>>> DDR3-1333, HT, Turbo 2/2/3/3)
>>> Cache Memory 8Mb (1x8Mb) level 3 cache
>>> Memory 12 Gb (6x2 Gb) PC3-10600R (DDR3-1333) Registered DIMMs.
>>> Etc. ...
>>>
>>> And we put this parameter for the dbsrv9 engine :
>>> -c 9Gb -cw ....
>>>
>>> What's the error cause ? Thanks for the answer.
>>>
>>> regards,
>>> -adi-
>>>
>>> "Nick Elson [Sybase iAnywhere]" <@nick@dot@elson@at@sybase@dot@com@>
>>> wrote in message news:4b05643d@forums-1-dub...
>>>> There should be very few differences for the server. Database files are
>>>> binarily compatable (as always) so there should be no conversion
>>>> requirements
>>>> and the biggest differences will mostly be isolated to the amount of
>>>> cache/memory
>>>> you can utilize and possibly performance.
>>>>
>>>> Some client side issues (say with the 32bit verses 64bit ODBC driver
>>>> managers
>>>> on Windows for example) may be a little different than you are use to
>>>> so you might
>>>> want to be aware of that possibility as well.
>>>>
>>>> All in all, though, it is basically the same product just compiled with
>>>> a different
>>>> instruction set. There may be a possibility of a minimum OS version or
>>>> a minimum EBF requirement so check out this link
>>>>
>>>> http://www.sybase.com/detail?id=1002288
>>>>
>>>> and follow any 64bit specific footnotes (if any) for the fine print on
>>>> anything that has one.
>>>>
>>>> Also be certain to click on the "More Info" links for your specific
>>>> release/version/ebf at
>>>> and that will take to a 'Components by Platform' page
>>>>
>>>> http://www.sybase.com/detail?id=1062080#SA
>>>>
>>>> to see if there are specific features affected (for example in
>>>> some cases only the 32bit JRE is available/supported/included).
>>>>
>>>>
>>>> HTH
>>>>
>>>> "Adi B. Wiratmo" <adi_bangun@yahoo.com> wrote in message
>>>> news:4b04c4b5@forums-1-dub...
>>>>> Hi All, is there a link (information) about the difference of ASA 32
>>>>> bit and 64 bit ? Right know we still using ASA 32 bit but want to
>>>>> change to 64 bit because the new server is compatible. What I have to
>>>>> do ? Must I konvert, upgrade, or something like that ?
>>>>>
>>>>> regards,
>>>>> -adi-
>>>>>
>>>>
>>>
>>>
>>
>
>


Breck Carter [TeamSybase] Posted on 2009-11-19 16:56:13.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Re: ASA 32 bit to 64 bit
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <e2uag5p5fhnmstee7o9vsk23tgqopo8gg0@4ax.com>
References: <4b04c4b5@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 19 Nov 2009 08:56:13 -0800
X-Trace: forums-1-dub 1258649773 10.22.241.152 (19 Nov 2009 08:56:13 -0800)
X-Original-Trace: 19 Nov 2009 08:56:13 -0800, vip152.sybase.com
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:322
Article PK: 866749

Also, some components exist in both 32 and 64 bit versions (bin32 and
bin64 folders) and some exist only in 32-bit versions... like dbisql

It just takes some getting used to, is all.

Breck

On 18 Nov 2009 20:08:21 -0800, "Adi B. Wiratmo" <adi_bangun@yahoo.com>

wrote:

>Hi All, is there a link (information) about the difference of ASA 32 bit and
>64 bit ? Right know we still using ASA 32 bit but want to change to 64 bit
>because the new server is compatible. What I have to do ? Must I konvert,
>upgrade, or something like that ?
>
>regards,
>-adi-
>

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

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail