Uncategorized

Database performance can be defined as the efficiency of your database when responding to demands for information (queries).  These data queries might represent online transactions, business intelligence, system utilities, etc.  When examined from this perspective, one can see how database performance directly corresponds to business performance.  It is essential to understand and maximize your database …

5 Ways to Improve Your Database System Performance Read More »

These Examples assume your using Linux (2.6.32-220.el6.x86_64 GNU/Linux) and Sybase IQ 15.4 Sybase IQ can create CIS connections to ASE, for example to access ASE data through an Sybase IQ-to-ASE proxy table. This can be done in two ways: through JDBC and ODBC. JDBC is easier to set up, but ODBC tends to be significantly …

Creating Sybase IQ Connections to Sybase ASE to Import Data Read More »

This post contains a step by step instruction on how to setup a warm standby replication with Sybase Replication Server. Preparation of the Sybase ASE-servers Create a maintenance user on both ASE’s The maintenance user is used by the replication server to apply transactions. Make sure that the name and password of the maintenance user …

Install a Warm Standby With Sybase Replication Server Read More »

Sybase IQ officially only supports Red Hat Linux and SuSe Linux. However, it will run on CentOS just fine. There are a couple of things that need to be configured to make this happen. After installing CentOS you need to install these additional rpm packages. libXext libXtst You can find the latest download versions for …

Installation Errors with Sybase IQ 15.4 on CentOS Read More »

One of the most important parts of database migration is having a full understanding of the current systems and the business applications that they support. Without this fundamental knowledge, you will not only run the risk of missing key components in the system, but you will also not be able to strategically improve the performance …

Oracle to Sybase Database Migration Tips Read More »

For Sybase IQ it is sometimes handy to reverse engineer the statements that were used to create the various IQ dbspaces. You can do this with Power Designer but not everybody has access to the tool. Below you will find a script that does a basic attempt to reverse engineer the statements for the “create …

Reverse Engineer Sybase IQ dbspaces Without an ER Tool! Read More »

SAP IQ 16.0 is yet another milestone in the evolution of SAP’s analytical engine that originated from Sybase IQ. SAP created entire series of how to tutorials on SAP IQ. They reach from 15.4 to 16.0 and also include SCC 3.3. Below are a list of YouTube videos, created by SAP engineers to bring you …

SAP IQ 16.0 – How To Tutorials Read More »

The first and most basic question is “What is a spinlock?” The following is from The August 1995 issue of the Sybase Technical News (Vol 4, Number 3): That particular article used the term ‘SQL Server’ to refer to Sybase ASE. Spinlock Defined The lowest level of synchronization in a multiprocessor SQL Server is the …

Spinlock Detection and Correction Read More »

Part 2 of the 5 part series on the step by step installation post focuses on the setup of VMWare Server and the SuSe Linux system. Part 1 has a list and links to the download pages for this software. The 5 parts of this series are: Part 1: System Requirements and Test Setup Concept …

Sybase ASE 15 Cluster Edition Step-By-Step Installation – Part 2 Linux Read More »

Most Sybase IQ indexes use a bitmap to store data compared to other indexes like B-trees .e.t.c,  Bitmap indexes can be built very fast in IQ and even faster when using the “Parallel IQ” function” which I posted the syntax on a previous blog. This also speeds up data loading and extraction as you don’t have to drop, …

Sybase IQ 15.x Fast Projection Index Overview and Practical Usage Read More »