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:

    Monthly Archives: August 2020

    1. Home  - 2020  - 
    2. August
    3. ( Page2 )
    15 Aug, 2020
    Sybase Replication Server shuts down due to Insufficient number of threads 0 (0)
    Sybase Replication Sybase Replication

    If you increase the number of client connections and did not increase the number of SAP Open Server threads that the SAP Replication Server can use, Replication Server may shut down.

    Steps to be followed for fixing this issue:… Read the rest

    13 Aug, 2020
    SAP Sybase IQ useful commands 5 (4)
    Sybase IQ Sybase IQ useful commands
    • How to create new user in Sybase IQ
      create user <username> identified by <password> ;
      grant connect to <username> identified by <password> ;
    • How to change/reset user password in Sybase IQ
      Alter user <username> identified by <password>
    • How to check
    … Read the rest
    12 Aug, 2020
    How to check if Sybase database is offline 0 (0)
    Sybase ASE #database offline, #offline, #sybase

    1Select name from sysdatabases where status2 & 48 0
    2go

    name

    —————-

    testdb

    (1 row affected)

    … Read the rest

    11 Aug, 2020
    How to check zombie process in Sybase ASE 0 (0)
    Sybase ASE #sybase, #zombie

    Zombie process is a process that shows up in syslocks but not in sysprocesses table. we need to either reboot the sybase server or use dbcc lock_release option to clear the process(to be done very carefully), else it can cause … Read the rest

    9 Aug, 2020
    How to Upgrade SYBASE ASE from 12.5 to 15.7 by using Inplace Upgradation. 0 (0)
    Sybase ASE Sybase database upgrade

    Pre-Upgradation Tasks –

    1. Make sure the Unix SA's have installed the correct Package ASE 15.7
    2. Keep the srvbuild sample resource files ready for the current ASE and Backup server
    3. RUN DBCC for all the databases to make sure no database
    … Read the rest
    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

    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