Archive for the ‘ASE’ Category

Sybase vs. Oracle: 10 reasons to use Sybase on Linux

December 15th, 2012 No comments

By Mich Talebzedah,

Sybase products are generally perceived within the database administrator (DBA) community as very reliable and easy to maintain, particularly compared to Oracle. Any move from Sybase to other DBMS (database management system) have got to be justified in terms of the current level of dissatisfaction with Sybase and the level of desire to use other. I cannot recall anywhere where this is valid.

  1. The latest Sybase flagship product, ASE 15, has filled much of the perceived functionality gap between ASE and other databases.
  2. Linux is an ideal and cost-effective platform for development teams and many companies. With the availability of heterogeneous dump and load of Sybase databases across different operating systems, Sybase — by virtue of its modularity and ease of use — is an ideal DBMS for Linux. This needs to be contrasted with Oracle which is, pound for pound, a far heavier beast and resource-hungry.
  3. Sybase has a well-established and skilled workforce, offering infrastructure and development teams who are fully familiar with database architectures and Sybase products.
  4. Applications developed using Sybase have been running for a while and providing adequate service. There is absolutely no guarantee that migrating these applications to another DBMS will result in the same level of service. I know of no case where a migration from Sybase to Oracle or otherwise has resulted in a noticeable performance gain.
  5. The exit barriers from Sybase and the entry barriers to others are high. For a medium-to-large application, it will take an average of 10 years for investment for ROI. A simple cost/benefit analysis will verify this statement.
  6. Check our Sybase ASE 15’s total cost of ownership (TCO) compared to Oracle. Based on my clients’ experience, one requires 2.5 Oracle DBAs to provide the same level of service as a single Sybase DBA.
  7. Sybase is fairly modular and has a simple syntax. Contrast this with Oracle where, in most cases, you require a third-party product to allow the DBA to reduce his/her workload. Perhaps that may be a reason why TOAD, a non-Oracle product, is the most popular GUI interface for Oracle!
  8. Since Sybase is a very secure database. In fact, it is a favourite with the U.S. Department of Defense and Central Intelligence Agency. Sybase is quickly bringing the security features — such as extensive Kerberos support, programmable authentication and data encryption — to the market.
  9. SAP’s release of its lightway product for Sybase on Linux and IBM’s steps towards selling their line of P5 Linux servers with ASE, while they have DB2 and Informix themselves, are pretty strong statements about the future of Sybase.
  10. The future of Sybase is secure, largely because it is well entrenched in its core marketplace, the financial services market. More than half of Wall Street runs on Sybase. The majority of complex trading systems and banks use sophisticated replication technology to provide publisher-subscriber or peer-to-peer replication. At this juncture, none of the competitors can provide the same degree of functionality that Sybase Replication Server provides.

Source :

SAP HANA: A Real-Time Challenge to the Oracle empire

December 15th, 2012 No comments

When Tom Cruise’s character in Top Gun exclaimed “I feel the need, the need for speed”, you’d be forgiven for mistaking it for a soundbite from a CIO discussing their transactional databases.

Read Full Article @

Planning to move Oracle to Sybase , You must Know !

December 11th, 2012 No comments

Oracle products vs. Sybase products

Both Oracle and Sybase provide a range of database-related products. The following list illustrates how the main high-level Oracle products compared to Sybase products. While this list is deliberately kept brief, it provides some basic guidance on how Oracle and Sybase can be aligned.

Oracle SAP Sybase
Oracle Database Server Sybase ASE (Adaptive Server Enterprise)
Oracle OLAP and DW Sybase IQ
Oracle Analytics Sybase IQ
Oracle RAC Sybase ASE Cluster Edition
Oracle Times Ten Sybase ASE In-Memory Database
Oracle Streams/Golden Gate Sybase Replication Server
Oracle Data Guard Sybase Mirror Activator/Sybase Replication Server

About Sybase ASE
Sybase ASE is the database that powers Wall Street. ASE has been delivering rock-solid reliability and top-level performance for the past 25 years. Sybase ASE has a lower total cost of ownership than Oracle, and delivers better performance on the same hardware. Sybase ASE is ready to be the database in any application that runs on Oracle today.

SAP D&T Academy Video: How to install sybsyntax db in ASE server

November 22nd, 2012 2 comments

Please follow the following video for installing the sybsyntax db in ASE server.



SAP D&T Academy Video:How to create login in Sybase ASE

November 22nd, 2012 No comments

Please follow the following video for creating login in Sybase ASE


SAP D&T Academy Video :How to set database options in sybase ASE

November 22nd, 2012 No comments

Please follow the following video for setting sybase database options.


Procter&Gamble’s plan to migrate their SAP ERP systems from Oracle to ASE

November 22nd, 2012 No comments


In the vein, SAP also announced Wednesday that high-profile customer Procter & Gamble is “planning to migrate its existing SAP ERP environment to ASE database.” P&G currently runs SAP on Oracle, and it also uses Oracle Exadata for data warehousing. If P&G follows through with this plan, it would be a financial blow and, more significantly, a big symbolic blow to the industry’s biggest database supplier.


They have migrated their SAP based Oracle driven Analytical Servers on to Sybase ASE 15.7. The POC has been done for migrating 13 TB of data and more to happen yet.


Source :


Categories: ASE, Database, HANA, News, SAP Tags: , , , ,

Sybase CEO John Chen Left SAP After Successful Integration of Sybase

November 1st, 2012 1 comment

SAP AG (SAP) is losing a top executive from Sybase Inc., the largest acquisition in the German software company’s history, after fully integrating the maker of mobile applications for business management

Some Comments :

Chen, i started my career in 1999 as a Sybase consultant and from that time i am following Sybase and still continuing. You have  made a great company and it is a classic story of  rebirth. You deserve full credit to what Sybase is today. I still remember the stock price from $2 when you took over and reaching a peak of mid $30 and then subsequent sales to SAP. I am a optimimist and still believes “SAP & Sybase marriage is made in heaven” . All the best for you Chen ” You are a great leader , innovator , strategist  and a game changert and your story with Sybase  will be remembered in the history books as one of the classics”.  Good luck for your next venture.


Source :

Categories: ASE, News, SAP Tags: , , , , ,

To Get all index size in a Database :sp__getallindexsize

October 17th, 2012 No comments

You can get all index size in a Database by using sp__getallindexsize as below :

I used the posted method to calculate index size : Calculating Table & Index Usage in ASE

Down load the stored proc here: sp_getallindexsize.sql (34)

1> use pubs3
2> go
1> sp__getallindexsize
2> go
table_name      index_name            size  reserved unused
————— ——————— —– ——– ——
authors         aunmind               2 KB  32 KB    30 KB
roysched        titleidind            2 KB  32 KB    30 KB
titleauthor     auidind               2 KB  32 KB    30 KB
salesdetail     titleidind            2 KB  32 KB    30 KB
titleauthor     titleidind            2 KB  32 KB    30 KB
salesdetail     salesdetailind        2 KB  32 KB    30 KB
titles          titleind              2 KB  30 KB    28 KB
blurbs          tblurbs               14 KB 16 KB    2 KB
sales           sales_8320029642      2 KB  16 KB    14 KB
stores          stores_7840027932     2 KB  16 KB    14 KB
titles          titles_6720023942     2 KB  16 KB    14 KB
authors         authors_5760020522    2 KB  16 KB    14 KB
publishers      publishers_6240022232 2 KB  16 KB    14 KB
store_employees store_empl_8960031922 2 KB  16 KB    14 KB

(14 rows affected)
(return status = 0)

Calculating Table & Index Usage in ASE

October 17th, 2012 No comments

sysindexes Contains

  • one row for each clustered index ( ie no row for table if CI is available)
  • one row for each nonclustered index,
  • one row for each table that has no clustered index,
  • one row for each table that contains text or image columns.
  • one row for each function-based index or index created on a computed column.

For Caluluating the size for each index and table we can use below table

First Row (indid >1) : For NCI , we will calculate index and reserved usage as below , it will not contain table size.
Second Row (indid=0) : For a table only, we can calculate usage as specified in below table
Third Row (indid =1) : As we know, CI resides tigtly couple with table so its size will also include table size.


indid Data Pages Index Page Reserved Pages
>1(NCI) data_pages(db_id(), tabid,indid) reserved_pages(db_id(), tabid, indid)
0(TBL) data_pages(db_id(), tabid,indid) reserved_pages(db_id(), tabid, indid)
1(CI) data_pages(db_id(), tabid,0) data_pages(db_id(), tabid,1) reserved_pages(db_id(), tabid, indid)+reserved_pages(db_id(), tabid, 0)

For calulating the Table size

1. If the table has CI

Add All NCI usages for each columns with CI usages i.e. Calulate row 1st for all NCI and add all with  3 rd row .

2. If the table does not has CI :

Add All NCI usages for each columns with Table Usage i.e Calulate 1st row for all NCI and add all with 2nd row.

Categories: ASE Tags: