MySQL/MemSQL/SAP sqlanywhere/SAP IQ – 3 migration issues, isnull & any subquery
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/
Category: 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
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
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
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
Sybase IQ Architecture
Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores
Sybase Server HealthCheck Commands With Explanation
It will display current running processes:
|
1 2 |
sp_who go |
It will display processes which is running by “dbmaint” user id:
|
1 2 |
sp_who 'dbmaint' go |
Sybase Questions
1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate
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
IN SYBASE Tempdb Full
1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using
|
1 |
select lct_admin(‘logsegment_freepages’dbid) |
3.dum tran