Archive for the ‘News’ Category

ASE database for SAP ERP

December 20th, 2011 No comments

Hello all,

These are copilataion for Sybase ASE on SAP from the Rob’s Blog :

Read Full Story :

  • SAP has released Business Suite on ASE version 15.7.
  • All SAP application data resides in a single ASE database. There is another small database for use by SAP tools.
  • The ASE database uses a 16KB page size.
  • For ERP only (i.e. not counting CRM and the other Business Suite modules), the database contains about 80,000 tables and 170,000 indexes. This is because SAP ERP has many features and functions, all with their own set of tables. SAP customers typically run only a subset of all those functions so in practice a large part of those 80,000 tables will always remain empty.
  • All SAP tables use datarowslocking (there is an interesting historical dimension.
  • All tables names are in uppercase; some table names contain special characters, like the slash character in “/BCV/C_QATTR” (I don’t have a clue what that name means, BTW)
  • Apart from the tables, there are also about 10,000 views. No stored procedures or triggers are used.
  • SAP makes heavy use of dynamic SQL (also known as “prepared statements”).
  • Many tables have a text or image column.
  • All tables are owned by one database user (and that’s not the dbouser).
  • The ASE database is accessed through ODBC.
  • SAP makes frequent use of the built-in ASE Job Scheduler (originally added in ASE 12.5.1).
  • The ASE server uses Unicode with the utf8 character set.

Sybase IQ 15 Best Practices Guide

December 4th, 2011 No comments


November 29th, 2011 No comments

Basic Difference :

Process Kernel:

Pre-15.7 kernel (except Windows)
Each engine is a separate process

Retained in 15.7 for risk mitigation

Threaded Kernel:

Default kernel for 15.7

Each engine is a thread of a single process

Additional threads for handling I/O, etc.

ASE on Windows has always been thread based

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

Survey among Sybase and Oracle customers – Bloor’s Research .

November 17th, 2011 No comments
Survey among Sybase and Oracle customers.


1. License fees: 75% of respondents thought that Sybase ASE was less expensive, by an average of 28%.


2. Support costs: 78% of respondents thought that Sybase ASE was less expensive, by an average of 32%.


3. Number of database administrators: nobody thought that Oracle required fewer DBAs and 61% thought that Sybase required fewer DBAs. On average the saving was 32%.


4. Frequency of security patches: again, nobody thought that this was less frequent in the case of Oracle while 68% thought that this was the case with Sybase, with an average reduction of 22%.


5. Issue resolution: 73% thought that Sybase was faster at resolving issues, typically being 21% faster.



Categories: ASE, News, Start Sybase Tags: , , completed 2 yrs on Oct 31st!

November 2nd, 2011 No comments


Last Monday Oct 31st 2011, has completed 2 years!

Thanks for all your support and wishes!

Happy Sybase Learning !


Categories: ASE, News Tags: ,

RIP Ritchie SIR!

October 18th, 2011 No comments

Jobs used c to devlop the mac , even all the major product has base C language and unix, bt aftr the death Sir Ritchie did nt get such media attention as Jobs got 🙁

He was not the owner of any software giant and was not a buisnessman 🙁

RIP SIR Ritchie..You contribution people will remember ever ..forever…

After a long illness, Dennis Ritchie, father of Unix and an esteemed computer scientist, died last weekend at the age of 70.

Ritchie, also known as “dmr”, is best know for creating the C programming language as well as being instrumental in the development of UNIX along with Ken Thompson. Ritchie spent most of his career at Bell Labs, which at the time of his joining in 1967, was one of the largest phone providers in the U.S. and had one of the most well-known research labs in operation.

Working alongside Thompson (who had written B) at Bell in the late sixties, the two men set out to develop a more efficient operating system for the up-and-coming minicomputer, resulting in the release of Unix (running on a DEC PDP-7) in 1971.

Though Unix was cheap and compatible with just about any machine, allowing users to install a variety of software systems, the OS was written in machine (or assembly) language, meaning that it had a small vocabulary and suffered in relation to memory.

By 1973, Ritchie and Thompson had rewritten Unix in C, developing its syntax, functionality, and beyond to give the language the ability to program an operating system. The kernel was published in the same year.
Today, C remains the second most popular programming language in the world (or at least the language in which the second most lines of code have been written), and ushered in C++ and Java; while the pair’s work on Unix led to, among other things, Linus Torvalds’ Linux. The work has without a doubt made Ritchie one of the most important, if not under-recognized, engineers of the modern era.
His work, specifically in relation to UNIX, led to him becoming a joint recipient of the Turing Award with Ken Thompson in 1983, as well as a recipient of the National Medal of Technology in 1998 from then-president Bill Clinton.

UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity – Dennis Ritchie, who was a genius,

Categories: ASE, News Tags:

Why Software is Soft?

September 22nd, 2011 No comments

why software is soft ,it’s very basis question, worth to know it..

Our computer is designed in layered in architecture, In the core (inner layer) we have all physical component(h/w).

In starting , we were directly interacting with hardware and mainly in 1 & 0 , even you can say in on/off state of a transistor. It was really very difficult process for the user’s interaction.

To reduce the hardness of physical component for interaction, we started layering h/w with piece of code.

Simply saying to remove the hardness of hardware , for making it soft for users, we used layers, as we calling now as Software.

Thanks Prof Raman for clearing my thoughts!

ASE 15.7 for SAP® Business Suite Released in Techwave!!!

September 14th, 2011 No comments

Hi Folks,

Most Awaited Database ASE 15.7 has been released yday in Vegas Techwave:

Extremely good news for Sybase Users!!!!!!!!

ASE 15.7 key features include:

Management of Large Datasets

  • Compression— allows large databases to be stored more compactly and reduces I/O times to ensure high performance on even the largest databases.
  • Reduced Query Latency— helps better handle large data sets, especially those which use dynamic SQL for interactive data retrieval.
  • Replication Performance—increases the performance of Sybase’s industry-leading transaction replication and syncing technology.
  • Enhancements for Parallel Hardware —improves optimization of multi-core/multi-threaded CPU architectures to get the maximum performance out of today’s latest processors

Simplified Administration

  • Online Operations—increases data availability while allowing data to be optimized for application performance.
  • Extended Diagnostics—allows DBAs to quickly pin-point performance bottlenecks and speed customer support requests.
  • Strong Password Encryption—protects the database from external intrusion and hacking
  • Single Sign-on & Login Profiles—makes it easier to manage large numbers of users and simplifies end-user access to the system

Ease of Application Development

  • Efficient Management of Large Objects—inline management of large objects as well as enhanced application development features such as large objects as parameters to stored procedures.
  • Enhanced Application Language Capabilities—many improved TransactSQL&™ language features to increase productivity of application developers as well as support for a variety of popular languages such as Python, PHP and Perl.
  • An Enterprise-Class DB for ISV applications —enhanced business-critical performance for ISV applications out of the box, enabling ISVs to easily write and port their applications to ASE 15.7.
Categories: ASE, News Tags: , , , , ,

SAP HANA & Sybase!

August 2nd, 2011 No comments


HANA, which will be available in appliance form from a number of hardware partners,
places data to be processed in RAM instead of reading it off disks, adding a performance boost.
HANA is built on a superset of technologies with a long history at SAP,
including the MaxDB database and TREX in-memory engine.
Data held in memory by HANA is backed by a persistence layer that logs
transactions and incorporates savepoints that create images of the database,
according to an SAP document. This allows it to be restored in the event of a power outage or other disruption.
HANA is compatible with any BI (business intelligence) application that supports common query languages like SQL and MDX.

by PCWorld

HANA is not a database, it is an appliance (hardware + software). SAP sells these to large customers;
a typical HANA installation has 2 Terabyte of memory.
The database software inside HANA is a custom-developed database engine by SAP,
optimized for in-memory handling of analytic workload patterns. To the best of my knowledge,
it is not available for download.

by – Rob V.

HANA with Sybase ?

As per recent IDC Report, SAP would be pushing this HANA technology in
ASE & IQ and our Rep server would be replicating the data from HANA Appliance.

If HANA is going to be part Sybase ASE/IQ/REP then it will certainly enhance the
ASE functionality and performance. If you want more about HANA , please refer below links :

IDC Report :

Sybase ASE 15.7 getting released in Sep’2011 Techwave!!!

July 17th, 2011 No comments

Source :

This coming September, Sybase will release Adaptive Server Enterprise (ASE) 15.7 which provides a huge number of enhancements across a broad range of areas.

Developers will see significant new and improved Text & Image support, new Concurrency options, new DML support for a streamlined MERGE / UPSERT, among many other things. DBA’s will benefit from a focus on Operational Scalability with enhancements like Compression, support for Alter Table that defers changes to be “Just-in-Time”, On-line REORG REBUILD, and many other useful features. ASE 15.7 will also be first version certified to run SAP’s Business Suite ERP and CRM applications.

Some New Features : Read more…

Categories: ASE, News Tags: , , , ,