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 …
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. …
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 …
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 …
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 …
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 …
Read More »Sybase Server HealthCheck Commands With Explanation
It will display current running processes: [crayon-607d9396c0a3c769644401/] It will display processes which is running by “dbmaint” user id: [crayon-607d9396c0a48721691731/] It will display databases …
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 …
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 …
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-607d9396c2224070357985/] 3.dum tran with truncate only if still …
Read More »