Sybase

  Numeric data type SAP IQ – supports up to (126, 38) MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/ ISNULL vs IFNULL SAP IQ – supports isnull memSQL – …

  Pre-Migration : Questionnaire That need to ask from the client before planning to migrate SAP Sybase ASE database servers from physical machines to virtual. This following questionnaire is necessary …

  We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database named : testdb. It comprises …

  Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles dbspace is more like segment …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which plays a vital role in …

It will display current running processes: [crayon-5f6d26718a04d938044160/]   It will display processes which is running by “dbmaint” user id: [crayon-5f6d26718a052540068019/]   It will display databases names available on Server: [crayon-5f6d26718a054856358188/] …

  1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database device usages. try with sp_configure …

Introduction A principal component of a protected system is accountability. One way to ensure accountability is to examine events on the system. Many events that occur in SAP ASE can …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-5f6d26718a86a376476847/] 3.dum tran with truncate only if still full than.. 4.dump tran with …