About former_member197516

former_member197516

Using VMWare HANA Express. When going from HANA Cockpit to SQL Console .... Screen comes up but when the screen accesses HANA SYSTEM and Tenant databases I get the following error: SQL Error: Connection failed (RTE:[300010] ...

former_member197516

Recently I was asked a question by my Customer's Management during our cut-over from Primary to Standby in a warm standby production environment. They asked me to ensure that the data was the same and that the number of stored procedures matched exa...

former_member197516

Most of you that will read this blog entry are SAP SRS (Replication Server) technical knowledgeable and like myself have found tricks that involve changing system tables to create quick fixes. All this is based on our in-depth understanding of the u...

former_member197516

Lets assume for the sake of arguement that ASE version 16.0 is out ......My Client wants to migrate to the latest and greatest ASE Server from the current version of 15.5 on linux. Additionally they want to go from 2K pages to either 4K or 8K. I onl...

former_member197516

Recently a colleague of mine posed the question of the pros and cons of having the tempdb database partially on the master device. By default, during the installation of an ASE Server, a small fragment of tempdb is placed on the master device (a dev...

former_member197516

You know - I like the idea of parallelizing bcp over sybmigrate - especially when we are talking increasing the underlying page size. This has to be really fast. The only 'gotcha' - and it should not be a big one is that the Client should have a co...

former_member197516

Yes - you are right. Changes underway.

former_member197516

Hi Mark...Good to hear from you! And yes - disabling the automated dump database/tran must be done as we want to control this 100%. Thanks for your comments.

former_member197516

True enough and thats also fine. I'll just add to your info and say if one wants to look at any of the monitoring tables you need "mon_role" rights. Thanks for adding your tip to this topic...JWJ

former_member197516

Thanks Raymond for that extensive reply to my post. Some excellent points. Yes - I agree in some cases where we are using char fields that are near the maximum and we switch to nchar we need to increase the length. Perhaps now application code chan...

User Statistics

User Activity

Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

Consultant Field Note - Data Assurance methods in a replication environment

Consultant Field Note - Recovering from a Warm Standby failure

Migrating from ASE 15.5 to 16.0 (when its out) + page size change...

Consultant Field Note - the great tempdb on master device debate

Re: Migrating from ASE 15.5 to 16.0 (when its out) + page size change...

Re: Consultant Field Note - the great tempdb on master device debate

Re: Consultant Field Note: Resyncing methods for MSA-aware databases

Re: Consultant Field Note: Determining your SAP ASE license type

Re: Best Practices for Migrating to ASE - Should you go unicode?