http://goo.gl/EmKxy0

Archive

Archive for August, 2011

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
permissions.

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

SAP HANA & Sybase!

August 2nd, 2011 No comments

SAP HANA?

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 : http://www.sybase.com/files/White_Papers/IDC_SAP_Sybase_DatabaseHeaven_report.pdf

http://www.computerworld.com/s/article/9199059/SAP_s_HANA_will_speed_real_time_data_analytics

http://www.itworld.com/software/175885/saps-hana-memory-analytics-engine-now-available

http://www.pcworld.com/businesscenter/article/228315/faq_saps_hana_inmemory_computing_platform.html