I'm in the process of replacing a VM (old=SUSE 11 / new=Ubuntu 20.04).
I've been able to get all but one of my SAP/Sybase software installations migrated successfully:
ASE 15.7 SP140 # failure (more below)
ASE 16.0 SP03 PL0...
Trying to get ASE 16 up and running on a new Ubuntu host but generating a signal 11 stack trace during initial build/startup of the instance.
The stack trace looks (to me) like the same one mentioned in KBA 3018138:
- stack trace commences right ...
Since my last blog posts re: Data Assurance (DA) - see here, here and here - most of my work (at an assortment of clients) has been a mix of Adaptive Server Enterprise (ASE) and Sybase SAP Replication Server (SRS), with a healthy dose of DA thrown in...
I'm trying to figure out how to edit the command buffer in my hdbsql session.
I've read (in several places) that I need to use the \e command/shortcut, but I'm not having any luck pulling the command buffer into a vi/editor session.
Here's an exa...
update (29 Nov 2021):
tl:dr
Along with quietly discontinuing the ASE Express Edition, SAP has now quietly discontinued public access to the trial version of Replication Server.
Details ...
A few months ago the download link on the Replication Ser...
I'm running ASE 16.0 SP04 PL04 on a home (linux) server.My total logical memory matches up (within a couple % points) with the totals from monMemoryUsage + total data cache.If I were seeing this kind of discrepancy (while waiting for feedback from te...
Where are you reading total logical memory from? (sp_configure?)What are your settings for configs max memory and allocate max shared memory? (I know, that shouldn't affect total logical memory but I'm interested in that large Global Block Pool as I'...
Ahhh, you updated your comment while I was typing mine.-------------In OP's case I'd opt for set statement_cache off; select ...; set statement_cache on.Disabling configs (eg, literal autoparam) at the server level should be thoroughly tested as said...
runs more slowly is because the plan says "Positioning at index start", whereas running the same query in sqsh says "Positioning by key".Positioning by key means the index was used to quickly zero in on the desired row(s) based on a distinct search v...
