Cara Melakukan Stress Test Database PostgreSQL atau EnterpriseDB menggunakan pgbench

Berikut ini adalah langkah demi langkah untuk melakukan Stress Test database PostgreSQL dan EnterpriseDB di LINUX RedHat. 1. Jalankan PostgreSQL atau EnterpriseDB 2. Download paket pgbench (http://www.westnet.com/~gsmith/content/postgresql/pgbench-tools.htm) 3. Unzip pgbench 4. Change Owner dari direktori hasil ekstrak ke enterprisedb:enterprisedb, jika tadi anda melakukan ekstraksi menggunakan user root 5. login menggunakan user enterprisedb atau postgres (tergantung) […]

IBM Flex System Manager VMControl Standard vs Standard vs Enterprise Edition

IBM Flex System Manager VMControl Express Edition includes features that were formerly part of IBM Flex System Manager virtualization manager. With VMControl Express Edition, you can complete the following tasks: Create virtual servers. Edit virtual servers. Manage virtual servers. Relocate virtual servers. Discover virtual server, storage, and network resources and visualize the physical-to-virtual relationships. IBM Flex […]

Oracle RMAN Cheat Sheet

RMAN> CONNECT TARGET / RMAN> SHOW ALL; CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/rmanbackup/%F’; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE […]

Cara Singkat untuk Instalasi Oracle11gR2 on AIX 7.1

           Berikut ini adalah mekanisme untuk melakukan Instalasi Oracle11gR2 di AIX 7.1. Mekanisme untuk instalasi Oracle di AIX ini lebih simple daripada instalasi di RedHat atau SUSE (http://bicarait.com/2013/04/28/step-by-step-cara-instalasi-database-oracle-10g-atau-11g-di-linux-red-hat-atau-fedora/). Anyway, here you go : (saya belum sempat rapihkan tulisannya, jadi silahkan disimak dengan baik2) 1. Check real memory dan processor : /usr/sbin/lsattr […]

SAP Sizing Mechanisme on IBM PureFlex with Reference Architecture

SAP Standard Application Benchmarks help customers and partners find the appropriate hardware configuration for their IT solutions. Working in concert, SAP and our hardware partners developed the SAP Standard Application Benchmarks to test the hardware and database performance of SAP applications and components. SAP Standard Application Benchmarks test the hardware and database performance of SAP […]

IBM PureFlex Systems and SAP Work Together to Deliver Outstanding TCO

International Technology Group (ITG) titled Value Proposition for IBM PureFlex System:  Case for IBM PureFlex System for Cloud-Enabled SAP Enterprise Environments.  SAP Infrastructure can include x86, UNIX, System i, Linux, and Windows platforms, to name a few.  For SAP, there can be many  modules for BI, ERP, and CRM.  And for each of these production […]