Thursday, February 14, 2008

Sybase RPC between different servers

local server: A
remote server: B

1. login to A
2. add server B records at A's interfaces file
3. isql to A's Sybase
4. sp_addserver [server name],[remote server network name (e.g. same as interfaces file)]
  • sp_addserver B,B
  • go
5. create proxy table [table_name] at "[server.db.dbo.table]"
  • use master
  • go

  • create proxy_table proxy_tb_a at "B.db_a.dbo.tb_a"
  • go

  • insert into proxy_tb_a values(....)
  • go

Monday, February 04, 2008

solaris 5.8 notes 3

large file maintenance:
cp large.log large.log.20080204.bak
cat /dev/null > large.log