Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2015
    Posts
    1

    Unanswered: Sybase going down when ETL opration running

    Hi All,

    when we running ETL our DB Sybase IQ going down suddenly without any error log. It happening at same position and when we check the error log nothing posted related to this error.

    We increased the TEMP memory to 80 GB but still issue continuing. Our source and Target are Sybase.

    What could be the reason for this behavior?

    Thanks in Advance.

    Regards,
    JP

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    what about hardware? maybe you have already a hardware issue. check your hardware logs for any suspicious event that triggered the problem.

  3. #3
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    JP,

    what is the version of Sybase IQ which you are using?

    Recently we migrated our Sybase IQ 15.4 to Sybase IQ 16.0 and we are experiencing the same issue of DB Server is going down when some copmplex queries are running.

    What do you mean by your ETL jobs?

    Is it only include Load Statements ??
    How many connections being there when ETL jobs were running ?
    Does it involve DML ?

    Thanks,
    Yuvaraj Subramani
    Yuvaraj Subramani

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •