Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    Category Archives: Sybase Replication

    1. Home  - 
    2. Archive by category "Sybase Replication"
    3. ( Page3 )
    2 Aug, 2020
    Sybase Rep Agent not coming up 0 (0)
    Sybase Replication Sybase error 692

    Problem Description:

    00:0004:00000:00408:2012/01/15 11:42:57.08 server Error: 692, Severity: 20, State: 1
    00:0004:00000:00408:2018/01/15 11:42:57.08 server Uninitialized logical page '654321' was read while accessing database 'DB' (4), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8). Please contact Sybase Technical Support.… Read the rest

    2 Aug, 2020
    ReConfigure/Reset Rep agent in Sybase 0 (0)
    Sybase Replication rep agent, Sybase

    Pre-Requisite:
    Sybase Server: SYB_ASE
    Sybase database: DB1
    Replication Server: SYB_RS

    Login to SYB_ASE and run below command

    use DB1
    go
    sp_stop_rep_agent DB1
    go
    sp_config_rep_agent "DB1","disable"
    go
    sp_config_rep_agent "DB1","enable","SYB_RS","SYB_RS_ra","SYB_RS_ra_ps"
    go
    dbcc settrunc(ltm,ignore)
    go

    Login to Replication server and get RSSD details… Read the rest

    2 Aug, 2020
    Sybase Warm Standby Replication setup: step by step 0 (0)
    Sybase Replication #Sybase DR, #Warm standby replication

    Pre-requisite:

    • Sybase Primary server.database:PROD_ASE.DB (version 15.7)
    • Sybase Seconday server.database:DR_ASE.DB (version 15.7)
    • Replication Server:PROD_RS (version 15.7)

    High Level steps:

    • Step 1: Ensure maintenance login is already created and has replication role on primary and standby database. If not, follow below
    … Read the rest
    1 Aug, 2020
    Sybase replication thread down due to duplicate key 0 (0)
    Sybase Replication Replication, Sybase

    Error Description:

    Message from server: Message: 2601, State 1, Severity 14 — 'Attempt to insert duplicate key row in object 'table1' with unique index 'ind1'

    Steps to be followed for fixing this issue.

    1. login to replication server and
    … Read the rest
    30 Jul, 2020
    Sybase Replication Thread down issue:Foreign key constraint violation occurred 0 (0)
    Sybase Replication #foreign key constraint, #sybase replication

    Error Code Description: Message: 546, State 1, Severity 16 — 'Foreign key constraint violation occurred, dbname = 'db2', table name = 'table1', constraint name = 'constraint1'

    Cause:This issue occurs when data inserted into a foreign key does not … Read the rest

    30 Jul, 2020
    Sybase Replication Thread down issue: Trigger Disabled 0 (0)
    Sybase Replication Sybase, trigger

    Error Code Description: Message: 4986, State 1, Severity 10 — 'Warning: trigger 'TestTrigger' is already disabled.

    Cause: This issue occurs when someone tries to disable a trigger on production database table and then warm standby replication tries to … Read the rest

    30 Jul, 2020
    What is latency in Sybase database: 0 (0)
    Sybase Replication Sybase Latency

    Latency is the time it takes for the data to replicate at the subscriber once it updates the primary.

    Reason for latency

    1. When DSI thread is down
    2. When huge batch jobs running on the primary database.
    3. When blocking at replicate
    … Read the rest

    Posts pagination

    1 2 3
    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2025 | Powered by Neom