http://goo.gl/EmKxy0

Archive

Archive for May, 2011

Warm Standby Setup without rs_init utlity

May 23rd, 2011 No comments

Active Dataserver : PROD_ASE_DS1

Standby Dataserver : PRDO_ASE_DS2

Replication Server : PROD_REP1

Database : odb

Create Active and Standby Database with same name and logical devices and segments
===============================================================================================

[sybase@localhost ~]$ isql -Usa -SPROD_ASE_DS1 -w999 Read more…

Categories: ASE Tags:

Sybase Replication Server: Warm Standby Setup using rs_int

May 19th, 2011 No comments

Guys,

Please find attached pdf for WS Setup using rs_init:

Sybase Replication Warm Standby Setup
In Next post we will be creating WS without rs_init, till then bbye.

SAP and Sybase Unveil Plans for Combined ERP, Data Management Solution

May 18th, 2011 No comments

Good News for ASE Folks!!!!!!!!!!!

SAP AG (NYSE: SAP) and Sybase, Inc., an SAP company and industry leader in enterprise and mobile software, today announced plans Read more…

Categories: ASE Tags:

Sybase frequently used system tables

May 17th, 2011 No comments

System tables in master
=======================
syscharsets –> One row for each character set or sort order
sysconfigures –> One row for each configuration parameter that can be set by users
syscurconfigs –> Information about configuration parameters currently being used by Adaptive Server
sysdatabases –> One row for each database on Adaptive Server
sysdevices –> One row for each tape dump device, disk dump device, disk for databases, and disk partition Read more…

Categories: ASE Tags:

Sybase frequently used system stored procedures

May 17th, 2011 No comments

===================
sp_foreignkey
————-
defines a foreign key on a table or view in the current database

Syntax – sp_foreignkey tabname, pktabname, col1 [, col2] ..[, col8]

Example
——–
sp_foreignkey titles, publishers, pub_id

sp_foreignkey orders, parts, part, subpart

Usage — sp_foreignkey adds the key to the syskeys table. Keys make explicit a logical relationship that is implicit in your database design. sp_foreignkey does not enforce referential integrity constraints; use the foreign key clause of the create table or alter table command to enforce a foreign key relationship.

— To display a report on the keys that Read more…

Categories: ASE Tags: