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
    15 Aug, 2020
    Replicate Minimal Column in Sybase Replication 0 (0)
    Sybase Replication Sybase Replication Minimal column

    Replicate minimal column property plays important role in Sybase replication performance. if this property is not defined within replication definition, replication server will replicate all columns for a modified row, even those values that have not been modified, thus it … Read the rest

    15 Aug, 2020
    Sybase tempdb binding 0 (0)
    Sybase ASE #Sybase tempdb binding

    In high OLTP nature environment we have seen many times that tempdb gets full due to bad query run by the user and it affects entire server as tempb is common area for sorting user data in the database server.… Read the rest

    15 Aug, 2020
    Sybase tempdb 100% full 0 (0)
    Sybase ASE Sybase tempdb 100% full

    Error Description:

    Failed to allocate disk space for a work table in database 'tempdb'.  You may be able to free up space by using the DUMP TRANsaction command, or you may want to extend the size of the database by … Read the rest

    15 Aug, 2020
    Query to check autocorrection property on RSSD 0 (0)
    Sybase Replication Sybase autocorrection

    Login to RSSD Dataserver and run below command

    1use SYB_RSSD
    2go

    3>SELECT obj.objname AS RepDef
    , db.dsname replicate_dataserver
    , db.dbname replicate_database
    , 'Yes' AS AutoCorrectionEnabled
    FROM rs_repobjs repobj
    JOIN rs_objects obj ON ((repobj.attributes & 0x1) = 0x1 AND

    … Read the rest
    15 Aug, 2020
    Autocorrection in SAP Sybase ASE 0 (0)
    Sybase Replication Sybase autocorrection
    • Autocorrection can be used to bring up the replication server when it is down due to duplicate insert error and mostly used when number of transaction records captured in exception log are more.
    • When autocorrection is on, Replication Server converts each update
    … Read the rest
    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

    Posts pagination

    1 … 11 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