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 – …
Read More »Sybase
Sybase ASE Migration from Physical to Virtual Machine
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 …
Read More »SAP Sybase ASE Warm Standby Database using Replication Server
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 …
Read More »EMC flash drive as Temp database device
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 …
Read More »Adding Space to Sybase IQ server
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 …
Read More »Sybase IQ Architecture
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 …
Read More »Sybase Server HealthCheck Commands With Explanation
It will display current running processes: [crayon-601250950c499887607317/] It will display processes which is running by “dbmaint” user id: [crayon-601250950c49e946613744/] It will display databases names available on Server: [crayon-601250950c4a0263358997/] …
Read More »Sybase Questions
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 …
Read More »Tracking configuration changes in SAP ASE 16
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 …
Read More »IN SYBASE Tempdb Full
1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-601250950cd5e342667446/] 3.dum tran with truncate only if still full than.. 4.dump tran with …
Read More »