Skip to main content

Proxy Table in ASE

Proxy_Table…………….Amol P Ingle

Proxy tables
Proxy tables are the key to location transparency. A proxy table is a local table containing metadata which points to a remote object. The remote table is mapped to the proxy table to make it appear as if it were a local table.


If there are two servers such as Server A and Server B and user want to create proxy table from server A to Server B.
Then please do the following Steps:
In Server A:
1. Make the entry of interfaces file of server B into server A.
2. Add server sp_addserver “Server B”
3. Create one table in master/or any db for testing.
4. suppose create table amol.
5 Insert Values Into table amol
6. Check with the select command
1> select * from amol
2> go
name
--------------------
amol

Login into server B
1. Make the entry of interfaces file of server A into server B.
2. Add server sp_addserver “Server A”
3. Create table amol at "Server_A.db_name.dbo.amol"
go
4. Check with the select command
1> select * from amol
2> go
name
--------------------
amol

For

Comments

  1. UnknownAugust 25, 2015 at 11:06 AM

    Thank you so much for sharing your sybase experience to all of us with your easy to understand language....it helps me a lot

    ReplyDelete

Post a Comment

Popular posts from this blog

Replication Server Quick Ref Guide

Replication Server Guide : • Replication Server Commands • ASE commands and system stored procedures • ASE RSSD stored procedures • RSSD tables • Replication Server System Functions • Troubleshooting Tips Abbreviations Some abbreviations which are used in this Quick Reference Guide: ASE Adaptive Server Enterprise DSI DataServer Interface - RS thread for a connection to a replicate database DIST Distributor - RS thread per primary database LTM Log Transfer Manager; synonym for RepAgent RS, RepServer Replication Server RepAgent Replication Agent (in primary dataserver) RepDef Replication Definition RSI Replication Server Interface - RS thread related to a route to another RepServer RSM Replication Server Manager (a DBA tool normally used in combination with Sybase Central) RSSD Replication Server System Database SQM Stable Queue Manager - RS thread managing a queue SQT Stable Queue Manager - RS thread assembling transactions Replication Server Commands The following commands can only be ...
Post a Comment
Read more

Interesting Notes on ASE

Some hidden things about ASE Different States of SLEEP When all processes are shown as SLEEPING by sp_who except the one, which issued the sp_who command, how can a user tell the difference between hangings versus running processes? Definitions In pre-4.9.2 SQL Servers, the output of sp_who could be difficult to interpret. Processes showed only one type of SLEEP status, "sleeping". In System 10, and 4.9.2 Rollup 2115 and above, sp_who shows four types of sleep along with the other possible statuses: Value Meaning Infected The server erred with a stack trace, and the process got an error that would normally kill it. The process is infected instead of killed. Background This process is in the background recv sleep The process is waiting for input from the client Send sleep The process is waiting for a write to the client to complete alarm sleep The process is waiting for an alarm (usually means the process is waiting for a wait for command to complete). Lock sleep The process i...
Post a Comment
Read more

How to set data cache,procedure cahe in ASE

1> sp_cacheconfig "default data cache","1G" 2> go Msg 10879, Level 16, State 1: Server 'SPICE_BIAPPS', Procedure 'sp_cacheconfig', Line 1167: The current 'max memory' value '58368', is not sufficient to change the size of cache 'default data cache' to '1G' (1048576 KB). 'max memory' should be greater than 'total logical memory' '579786' required for the configuration. (return status = 1) 1> sp_configure "max memory" 2> go Parameter Name Default Memory Used Config Value Run Value Unit Type ------------------------------ ----------- ----------- ------------ ------------ -------------------- ---------- max memory 58368 116736 58368 58368 memory pages(2k) dynamic (1 row affected) (return status = 0) 1> sp_configure "max memory","1G" 2>...
1 comment
Read more