17 Sep
by Rey Wang
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 – supports ifnull Not Any subquery SAP allows ANY subquery syntax select a.* from Sales.table1 a where exists (select 1 from Sales.order b where not b.ord_date = […]
6 Sep
by Engr. Mohammad Rizwan Yasin
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 for mission critical systems in-order to safeguard post migration issues related to performance glitches and service interruptions. Complete version of SAP Sybase ASE & Operating System with service […]
5 Sep
by Engr. Mohammad Rizwan Yasin
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 to the following 15 steps. Pre-Requisites : a) 2 Sybase ASE instances b)1 replication server instance c)1 database named testdb Step 1: Enable Replication Agent on […]
31 Aug
by Rey Wang
Tags: temp database linux
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 way over 25TB, and we run very bizarre over 20 table joins, outer join/self join. Mainly for financial risk reporting; the reporting tools are SAP business […]
23 Aug
by Bhaskara Vasamsetti
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 in ASE . if IQ_USER_MAIN is out of space we can see these messages in iqmsg log file . 10/12 02:54:08. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN […]
22 Aug
by Bhaskara Vasamsetti
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 Sybase IQ server. 1) Catalog Store –> Stores Metadata in system tables that is needed to run the database. –> Catalog Store is always recommended to […]
21 Aug
by Gagan Sharma
It will display current running processes: [crayon-5bf18c79b2d2f914358786/] It will display processes which is running by “dbmaint” user id: [crayon-5bf18c79b2d37749946344/] It will display databases names available on Server: [crayon-5bf18c79b2d39634072342/] It will display the cpu details: [crayon-5bf18c79b2d3a079804156/] It will display the max memory available. We need to check usually when we are going to […]
14 Aug
by Vaibhav Krishna
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 ‘memory” for memory utilization and memory available sp_helpdevice – for device space utilization and free space. 2) log space requirements for reorg rebuild We have […]
13 Aug
by Marc Daccache
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 be recorded, such as – but not limited to – DMLs and DDLs. Auditing is an important part of security in any RDBMS. By probing […]
8 Aug
by Sibasish Satyapriya
Tags: Tempdb Full
1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-5bf18c79b37c3488440515/] 3.dum tran with truncate only if still full than.. 4.dump tran with no_log still full than.. 5.Find process from syslogshold/sysprocesses. inform user about condition ask for killing if he says yes then 6 kill the process If […]
