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)
6. $ export PATH=$PATH:/opt/PostgresPlus/9.2AS/bin

Notes:
Agar tidak ditanyakan terus mengenai password dari user enterprisedb/postgres, maka Continue reading Cara Melakukan Stress Test Database PostgreSQL atau EnterpriseDB menggunakan pgbench

IBM Flex System Manager VMControl Standard vs Standard vs Enterprise Edition

webinar-pureflex

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 System Manager VMControl Standard Edition is a licensed feature of VMControl. With VMControl Standard Edition, you can Continue reading IBM Flex System Manager VMControl Standard vs Standard vs Enterprise Edition

Oracle RMAN Cheat Sheet

rmancommandoverview

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 BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   ‘/u01/app/rmanbackup/%U’;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.1/dbs/snapcf_ibm.f’; # default

RMAN> backup database plus Continue reading Oracle RMAN Cheat Sheet

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 -E -l sys0 -a realmem

prtconf  | grep proc

2. Check swap dan tmp :
/usr/sbin/lsps -a
df -gh

if RAM Between 1 GB and 2 GB then Swap Space 1.5 times the size of the RAM
if RAM Between 2 GB and 16 GB then Equal to the size of the RAM
if RAM More than 16 GB then 16 GB

# df -g

perubahan swap caranya :

Determine the current amount of paging space available to the server by issuing the following command. Continue reading Cara Singkat untuk Instalasi Oracle11gR2 on AIX 7.1

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 applications and components. Access the two-tier and three-tier results for the Sales and Distribution (SD) Benchmark.

SD three-tier results ›

SD two-tier results ›

We now have the very first SAP Standard Application Benchmarks using the HANA database certified using the Enhanced Mixed Load (BW-EML) benchmark. Access the results here:

BW-EML Internet configuration, SAP NetWeaver ›

 

Berikut ini adalah beberapa mekanisme Sizing dan Referensi Arsitektur untuk melakukan Deployment SAP ke mesin IBM PureFlex. Continue reading SAP Sizing Mechanisme on IBM PureFlex with Reference Architecture

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 modules, development, test, and quality assurance modules are required.

What if I told you there was a solution that ties all of this together in an easy-to-manage environment from both a hardware and software perspective?  What if It also costs less to acquire, manage, and operate?

Well, you know what they say, “If it looks too good to be true, it probably is…”  That is why we Architects and Technologists out there say, “trust but verify.”  And that is just what the ITG has done for us.  ITG presents use cases drawn from an IT services company, two manufacturing companies, a retail company, and a diversified company.  Starting with the PureFlex System architecture, ITG describes how each of the components are technologically more advanced.  Each of the components — servers, storage, and networking — are capable of driving deeper consolidation.   When combined in a single platform, and managed with a single management interface called IBM Flex System Manager (FSM)   you are now poised to deliver greater consolidation than ever before.  The perfect basis for the SAP Cloud-Enabled  Enterprise. Continue reading IBM PureFlex Systems and SAP Work Together to Deliver Outstanding TCO