Posts Tagged ‘News’

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. 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: ,

Isolation Level – Summarized.

October 10th, 2011 No comments

Isolation Level ??

Data concurrency: means that many users can access data at the same time.

Data consistency: means that each user sees a consistent view of the data, including visible changes made by the user’s own transactions and transactions of other users.

Isolation : is a property that defines how/when the changes made by one operation become visible to other concurrent operations. Isolation is one of the ACID property.

Lower isolation levels increase transaction concurrency at the risk of allowing transactions to observe a fuzzy or incorrect database state. These incorrect state you need to manage at application design.

4 Isolation Levels:

The ANSI/ISO SQL-92 specifications define four isolation levels:


Lower Isolation level —> Higher concurrency, Data consistancy low, Reducing the locking overhead.
Higher Isolation Level —> Lower Concurrency, High Data Consistancy, Possible More Deadlock in multi user enviorment.

Three preventable phenomena

P1 (Dirty Read): Transaction T1 modifies a data item. Another transaction T2 then reads that data item before T1 performs a COMMIT or ROLLBACK. If T1 then performs a ROLLBACK, T2 has read a data item that was never committed and so never really existed.

P2 (Non-repeatable or Fuzzy Read): Transaction T1 reads a data item. Another transaction T2 then modifies or
deletes that data item and commits. If T1 then attempts to reread the data item, it receives a modified value or discovers
that the data item has been deleted.

P3 (Phantom): Transaction T1 reads a set of data items satisfying some . Transaction T2
then creates data items that satisfy T1’s and commits. If T1 then repeats its read with the
same , it gets a set of data items different from the first read.

Isolation Level Dirty Read Nonrepeatable Read Phantom Read
Read uncommitted Possible Possible Possible
Read committed Not possible Possible Possible
Repeatable read Not possible Not possible Possible
Serializable Not possible Not possible Not possible

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: , , , , ,

bcp copy in failed

August 17th, 2011 No comments

Hi Folks,

Few days back , we  have faced the issue regarding bcp in,  message was bcp copy in failed. Although Rows were inserting successfully.  The user which We were using that was dbo of database and had all

We tried with other login id and it was working fine, that was dbo alias.

We tried to remove user, added as  dbo alias, given explicit permission,but it didn’t work out.

It was totally weried as there was no problem at all , or you can say the issue which we were not able to
investigate as error is not much explanatory.

Also I would like to mention , we have refreshed this database from 12.5.4 to 15.0.3 env.

Finally we dropped the user, dropped login account and added again , means we craeted new login account
with same name  and after that added in db as a dbo alias. It worked fine now.
I am still not sure why this caused the issue.

Categories: ASE Tags: , , , ,

If failures is my Destiny, I would like to top in failures!!

August 7th, 2011 No comments

–If 100 plans fail, will make 200 next day!

— If failures is my Destiny, I would like to top in failures!!

Categories: ASE Tags: , , , ,

Sybase: PowerBuilder and PowerDesigner

July 27th, 2011 No comments
  • Sybase PowerBuilder is a RAD tool that lets you develop rich GUI applications,

based on the DataWindow concept.I’ve been told that part of the

SAP POS module is actually developed  with PowerBuilder.

  • Sybase PowerDesigner is a modeling tool that lets you handle anything from a 

data model to a full enterprise architecture, and is widely seen as

one of the best such tools around.

Source :
Both PowerBuilder and PowerDesigner are not tied to any specific database and will work with most common database brands.

Categories: ASE Tags: , , , ,

17700 + Hits in!

July 26th, 2011 No comments

Hi Guys,

Today your blog crossed the  17700+ hits!!

I would like to congratulate and thanks for your continued support !!!

Thanks once again!



Categories: ASE Tags: , , , ,

New Parallel Distributed Query And Advanced Workload Management Capabilities in IQ15.3

July 11th, 2011 No comments

Source :

Sybase, Inc., an SAP® company (NYSE: SAP) and industry leader in enterprise and mobile software, today announced the general availability of Sybase® IQ 15.3, powered by a new generation of shared everything Massively Parallel Processing (MPP) technology. With this release, enterprise IT departments can overcome scalability limitations of today’s data warehouses in many industries including financial services, telecommunications, information providers, healthcare and insurance. By implementing a business analytics information solution that allows sharing of computing and data resources with the innovative Sybase IQ PlexQ™ technology, enterprises can lead the next wave of data warehouse transformation by breaking down user and information silos to drive analytics adoption throughout the entire organization.

Sybase IQ 15.3 key new features include: Read more…

Happy Holi to All of you!

March 19th, 2011 No comments

Happy Holi to All of you!

Categories: ASE Tags: , , , ,