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. ( Page3 )
    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
    1 Aug, 2020
    Using multiple variables from a file and loop in shell scripts 0 (0)
    Linux

    There are several ways to read a file in loop, here are few of them with examples

    consider my input file is as below

    FileName: file1

    File Content:

    A B C
    D E F
    G H I
    J … Read the rest

    1 Aug, 2020
    How to replace all white space with comma in a text file 0 (0)
    Linux

    for example, i have a text file like below

    test1 test2
    test3 test4
    test5 test6

    i want my text file to look like as below

    test1,test2
    test3,test4
    test5,test6

    use below sed function to achieve the result.

    sed -e 's/\s+/,/g' old … Read the rest

    1 Aug, 2020
    How to remove spaces between lines from a file 0 (0)
    Linux

    for example, i have a file like below

    test1 test2

    test3 test4

    test5 test6

    i want my output to look like as below

    test1 test2
    test3 test4
    test5 test6

    use below sed function to achieve the result.

    sed '/^ *$/d'

    … Read the rest
    1 Aug, 2020
    Splitting one file into multiple and running them in parallel. 0 (0)
    Linux

    Syntax:

    split -d -l <no. of lines> <input file> <prefix name>

    Example:

    split -d -l 3 testsplit.txt testsplit.txt.

    here, '-d' option will split files with numeric suffix like x00, x01, … x0n

    here, '-l' is used to split a file … 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