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