This might be the biggest announcement from SAP you never heard of. After dropping the name Sybase from its product names last year, SAP is quietly reshaping its database platform offerings. And I mean this in a good way. Read More
Tampa, Fl., February 28, 2013
A growing number of Oracle and SQL Server database administrators want to learn about Sybase SAP Sybase ASE to be competitive in all database management areas. To meet these challenges, Dobler Consulting, a leader in SAP Sybase, SQL Server, and Oracle technology, is offering a new training curriculum starting in the spring of 2013. The curriculum is designed for seasoned Oracle and SQL Server database professionals to gain knowledge in SAP Sybase ASE Server management (www.doblerconsulting.com/what-we-do/database-training-programs/).
We hope your holidays were happy and relaxing. 2013 promises to be a stellar year for Dobler Consulting. We have several new projects in the works, and are continuing to solve the latest challenges and database technology issues. Our team of consultants is providing a wide variety of project assistance for our clients. Read More
Install the Sybase ASE Cluster Edition Software
With the new Sybase ASE 15.5 version, you have to option to install the software either as shared installation or private installation. If you use the shared installation, you need to have access to a shared filesystem that is accessible from every node in the cluster. Although the shared installation is more convenient, it presents other risks like a single point of failure if the shared filesystem goes offline.
The private installation provides a dependency separation between nodes for added stability and protection. The private installation installs the Sybase software on each node, and does not require a shared filesystem. You need to maintain a strict file structure and placement discipline, because every node must access the software identically.
Once you completed the prerequisites, you need to shift your focus to preparing the databases, and the database server.
- If you are upgrading Adaptive Server, the previously installed version of the server must be running. If you are upgrading Backup Server, Historical Server, Monitor Server, or XP Server, those servers must not be running.
- Stored procedure text in the syscomments table is required for the upgrade. If you deleted the text, you must add it back again.Note: As a best practice: if you don’t want to display the text, hide it by using the sp_hide_text stored procedure instead of deleting it.
- Resolve reserved words using quoted identifiers. This is a simple check by installing the upgrade package and then executing sp_checkreswords.Caution: This step is simple enough, but if omitted, can lead to serious issues during the upgrade process.
Back in the 90’s, a group of German engineers put together the world’s first grid computing network. When putting together this network, they used over 100 PCs running on the first version of the Linux operating system. It was a great success, and everybody called it the dawn of a new technology that would change the computing world forever.