Posts tagged Rep
Implementation of Function String in Sybase Replication Server(SRS)
0These experience shared by Senior DBAs as name mentioned, Hope this will help you to understand more about function string from implementation point of view in a Replication environment:
Craig Oakley , Senior DBA.
—————————--
We used function strings when we wanted to replicate all columns to some servers, and only selected columns to other (web-facing) servers. This was particularly useful before Rep Server allowed multiple RepDefs on the same table. One concern was text columns which were not being replicated to the web-facing server: we had to create a function string to get a text pointer (we used a one-row table and just update all the text columns on top of each other, as the value was not needed on that server): failure to get a text pointer cause the DSI to go down, and we could not specify that as a condition to ignore.
Beyond this, I would imagine function strings could help specify how you want the update to be done, which could be a performance improvement. It would also allow for a different implementation at the replicate than there is at the primary (such as a table at the primary being two joined tables at the replicate).
Sukhesh Nair, Senior Sybase DBA
———————————–
We used to have a setup where data was replicated from sybase to oracle as also to a warm standby sybase server. Rep Server function strings helped in filtering data that would need to be passed to Oracle. It helped immensely in streamlining the data flow to targets by manipulating the incoming data through function string. I feel it is one of the most advanced and useful yet very less used capabilities of Sybase Rep Server.
The deterrent could be because of the complexity it would introduce to the replication system. The setup we had worked wonderfully and never gave us any major problems. Without proper monitoring (which needs to be scripted by DBAs) it used to be hard to maintain. Many of the current Rep Server administrators I see do not have adequate knowledge or experience of handling function strings.
Rey Wang , Senior Sybase DBA
————————-
You can map the delete to no op with functional string.
Partha Gogoi Senior DBA
————————-
We use function strings to transform data at the replicate..We have databases being replicated from Toronto and New York to London, Sydney and Singapore and the client ids are transformed at the replicate because, as per business requirements, the client ids are different at each site.. Of course , having a Universal client id would simplify things , but the systems and databases at each site grew independently until replication was set up and it would be a lot of rework to change all the client ids at the replicate sites
Øystein Grinaker Senior DBA
—————————
A Function String could be used to change default behaviour.
Say you delete a row in a table on PDB, but you do not want to delete the row on the RDB. Then make a change in rs_delete. You may make the rs delete just to make a logical delete by updateing a deletemarker for that spesific row.
Source : Linkedin.com
What’s in YOUR Architecture?
0What’s in your architecture?
Probably not enough if you’re using just data modeling to integrate all the components of your enterprise, especially your information. To lay the
foundation of this paper, let’s start from the same level of understanding: the need for a common approach to managing all the aspects of information to
enable rapid business performance in the 21st century economy.
Competition in the marketplace is always fierce. To stay abreast, organizations must constantly analyze their customer needs and expectations, enhance
or innovate their business processes, and deliver products and services that create exceptional customer value. Organizations also need to be customercentric to forge long-term relationships with clients and consumers. Only organizations that are agile enough to respond to volatile market conditions
with innovation, expedited time-to-market processes, and reduced costs can differentiate themselves from the competition. Such agility occurs when a
company’s IT operations are closely aligned with its business operations. IT needs to understand business to implement technologies and applications that
support the current and future business goals.
Read Full Article @ http://www.sybase.com/files/White_Papers/Sybase_Whats_in_Your_Architecture_WP.pdf
bcp copy in failed
0Hi 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.
If failures is my Destiny, I would like to top in failures!!
0–If 100 plans fail, will make 200 next day!
– If failures is my Destiny, I would like to top in failures!!
Sybase: PowerBuilder and PowerDesigner
0- 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 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25286 Both PowerBuilder and PowerDesigner are not tied to any specific database and will work with most common database brands. (more...)
Recent Comments