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:

    1. Home
    9 Aug, 2020
    Sybase replication thread down due to cross-database referential constraint 0 (0)
    Sybase Replication Sybase Replication

    Error Description:

        Message from server: Message: 435, State 1, Severity 16 -- 'Database 'db3' is not available.  The 'delete' statement will not be executed because the cross-database referential constraint on table 'table1' cannot be enforced. Contact your System Administrator 
    … Read the rest
    3 Aug, 2020
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. 0 (0)
    Sybase ASE #drop user, #sp_dropuser, #sybase

    Error Description:

    Msg 17549, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 3:
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. The user has granted the following privileges:

    Resolution:

    Step1: … Read the rest

    2 Aug, 2020
    cannot drop user because user owns objects in database 0 (0)
    Sybase ASE #drop user, #object ownership

    Error Description:

    Msg 17545, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 267:
    You cannot drop user because user 'testuser' owns objects in database.

    Resolution:

    Step1: First find out uid of user

    1> select uid from sysusers where … Read the rest

    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
    1 Aug, 2020
    Useful Find command in Unix 0 (0)
    Linux

    #Search the file with its name

    $ find ./test -name "1.txt"
    ./test/subdir/1.txt

    #to search for specific files from specific directories/sub directories.

    $ find /home1/test -type f -exec grep -l 1.html {} \;

    wildcards can be used to search for specific

    … Read the rest
    1 Aug, 2020
    How to get top space consuming files and directories in Linux and Sun Solaris 0 (0)
    Linux

    As a DBA, many a times we need to know what files and directories are consuming more space on our unix file system.

    In this article, i will try to share to share the commands that are used to achieve … Read the rest

    1 Aug, 2020
    Display Nth line of a file in Linux 0 (0)
    Linux

    There are multiple ways to get the Nth line of a file but below are the most used commands.

    1. Sed

    Let's consider the below input file

    $ cat file1

    mango
    apple
    grapes
    banana
    strawberry
    papaya
    orange
    cherry

    #to print 4th

    … Read the rest

    Posts pagination

    1 … 12 13 14
    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