Saturday, October 23, 2010

Chipworks in silicon art


Should be on Bunnies name that ware ;)



Where have these kind of ads gone in "I.T" , "ICT" IT&IM ETC LOLz

Sun SPARC Enterprise T3

Sun SPARC Enterprise T3 is out:

16 cores and good Siebel 8.1.1 benchmark results

Thursday, September 30, 2010

Getting ETL from redo log data

I'm designing an Inmon G.I.F like data warehouse and need to source data from a OLTP CRM like bespke app that I don't want to mess with. I've been investigating tools that can do changed data capture (CDC) from redo logs,no need to use Oracle's CDC. Using some kind of CDC reduces your data warehouse load sizes as you can just grab the deltas, Oracle RDBMS has built in CDC that comes in the Ent.Ed but may need DBMS streams and other configuration
Attunity CDC can be installed where the staging area is (no installation required on the machine where Oracle lives) Access to the redo log is through a SQL*Net connection.

Check out Attunity CDC and GoldenGate(now Oracle), superior to built in Oracle CDC. Still need to set the DB to add a supplemental log destination


Attunity Pricing is based on the h/w config of the ETL platform where Attunity is installed; i.e. #cpu's and how many Oracle DB's get connected to from the ETL platform

Tuesday, September 14, 2010

bashreduce : mapreduce in a bash script

erikfrey's bashreduce at master - GitHub: "bashreduce : mapreduce in a bash script

- Sent using Google Toolbar"

POWER7 models and AIX (from IBM dW)

These are the minimums but higher service packs are recommended.
POWER7 Systems Power 750, 755 (Jan) Power 770,780 (March) Blade 700, 701,702 (June) Power 710, 720, 730, 740, 795 (Sept)
AIX 5.3 TL9 SP7 SP7 - -
AIX 5.3 TL10 SP4 SP4 SP5 SP5
AIX 5.3 TL11 SP2 SP2 SP5 SP5
AIX 5.3 TL12 * * * SP1
POWER7 Systems Power 750, 755 (Jan) Power 770,780 (March) Blade 700, 701,702 (June) Power 710, 720, 730, 740, 795 (Sept)
AIX 6.1 TL02 SP8 SP8 - -
AIX 6.1 TL03 SP5 SP5 SP7 SP7
AIX 6.1 TL04 SP2 SP3 SP7 SP7
AIX 6.1 TL05 * * * SP3
AIX 6.1 TL06 * * * *
POWER7 Systems Power 750, 755 (Jan) Power 770,780 (March) Blade 700, 701,702 (June) Power 710, 720, 730, 740, 795 (Sept)
AIX 7.1 TL00 * * * *
  1. AIX 6 is highly recommended as the default install to ensure simple updates (you will then avoid the upgrade to 6.1, as AIX 5.3 is eventually phased out).
  2. - means this combination is not supported.
  3. * means no service pack needed ... but I always recommend adding the first service pack (as soon as it is available) to avoid early problems that are already fixed.
  4. AIX 5.2 TL10 SP8 is supported via AIX7, POWER7 and Versioned WPARs.
  5. Other AIX releases and Technology Levels are not supported.

alphaWorks : IBM Bluetooth Remote Invocation Tool : Overview

alphaWorks : IBM Bluetooth Remote Invocation Tool : Overview: "- Sent using Google Toolbar"

Five secret data storage and data management vendors

Five secret data storage and data management vendors: "- Sent using Google Toolbar"

Oracle Reintroduces Solaris Support for non-Oracle x86 Hardware (IDEAS Insights)

Oracle Reintroduces Solaris Support for non-Oracle x86 Hardware (IDEAS Insights): "- Sent using Google Toolbar"

Porting Perl To Python and the nose Unit Testing Framework.

Porting Perl To Python: "- Sent using Google Toolbar"

Open source IQ test | Open Source - InfoWorld

Open source IQ test | Open Source - InfoWorld: "Open source IQ test

- Sent using Google Toolbar"

Oracle Siebel 8 support on IBM AIX6

AIX 6 and Siebel version will play together,AIX 6 and Siebel version or below will not, AIX 5.3 TL12 may be the best option for support longevity.

Friday, August 13, 2010

Remote hack for modern cars!

DOS attack a car's ECU via its RF links to the tire pressure sensors - nice hack vector

better vector than the apple keyboard firmware hack from a few years back or the pre infected DELL mobo BIOS/firmware

SAP augmented corporate reality

kinda interesting - use your mobile device to 'see' business data overladed on real world objects eg stock items or locations/adresses

Marry this up with RFIDs and google goggles and imagine.....

......wont cure population problems or war

Tuesday, July 27, 2010

free pressos from CA on the Cloud

to me CA brand seems the furthest from the Cloud...

Google code university

Back in the days before Google, I was pretty good at picking up new skills because I was good at these 2 things....
1) finding information: every time I went to a new town I would find librarys and go to 621 and 500 etc in the Dewey Decimal and copy or make notes on new books I found on electronics/technology and math/science

2)Then I would take away my notes and learn it, or try it, or test it, or make it...

Its seems
Skill (1) is gone.....the information is available to everyone thanks to Google (I guess thats their vision eh)

Check this out, I was looking for python courses on youtube and came across this
free comp sci uni! 4 that A55!

Monday, July 19, 2010

RAT for all

One of the nice features of Oracle 11g is Real Application testing, basically you can record and playback database loads - and with a bit of opatch'n you can also record loads from older version and playback (with and 11g installation) retro fit that shi7!

Saturday, July 3, 2010

Cosmic Rays and ECC

Sun,IBM and Cisco have given me the cosmic ray excuse a few times over the years but having a bit of a read of the Sci papers its seems to be a bit of an issue

ECC used to be a high end feature, now as ram becomes more dense you can expect errors in your systems almost daily

Here is a project to log the ECCs with Linux

there was a patent in 2007 to build detectors into RAM ICs,309,866.PN.&OS=PN/7,309,866&RS=PN/7,309,866

Tuesday, June 29, 2010

help increase your h-index!

SCIgen - An Automatic CS Paper Generator phunny.... this gizmo makes scientific( compsci) publications for you! (or a friend) reminds me of the automatic complaint generator

Saturday, June 19, 2010

gov requests to google for data and data/site takedowns

Google are tracking gov requests for data and data/site takedowns - probably born out of the great firewall of China incident - interesting to see Australia is in the top 10 - more than all of Russia!

.....then again not that surprising....

google cli cool tool!!

Just installed the googlecl cli tool on FC12 with the FC13 .rpm file ( ...and I made this post with it!

Thursday, June 17, 2010

Chatroulette's Penis Problem: Solved

Chatroulette's Penis Problem Solved

Q:so what did you do when you graduated top of your class in AI after
all of those years of study?

A:I was hired by a web 2.0 startup company!

Q:What was your major project?

A:Developing bleeding edge software to spot coc7s,dic7s,knobs and wan7ing!

LOL put that on ya CV

A decade to forget - how Microsoft lost its mojo • Channel Register

A decade to forget - how Microsoft lost its mojo • Channel Register

IBM preps AIX 7.1 for autumn Power7 harvest • Channel Register

IBM preps AIX 7.1 for autumn Power7 harvest • Channel Register

How good is this Prezi

Playing to Learn? by Maria Andersen on Prezi

How good is this way of presenting!!!! it makes sense to me - I've never liked slide packs - I've been looking for something like this for months - it reminds me of the ABC beast files e.g. Best file:Google and I've always thought that was a great way to keep people engaged
I've been looking for a tool to do that

The tool Hans Rosling uses is now open source and a great way to present data too

Thursday, June 10, 2010

cloverfield monsters

YouTube - Street Art: Joshua Allen Harris' Inflatable Bag Monsters:

Air from the NYC subway or HVAC inflates these bag monsters - good idea and well executed

....more intrusiveness than negative graffiti eg however somewhat interesting!

Tuesday, June 8, 2010

Internets live under the sea you see....

Asia seems to miss out a bit in places

I guess we should (as a people) worry more about food than internets ...or space ...or 4g iphones ...or DBS v12

Linux fast boot

Just looking for a place to put these links for a pet project Im working on

Over and above the n00by obvious stuff like disable unused services and devices ...

software to benchmark the boot

An article about it at LWN (parallelism and read ahead)

The read-ahead code

Embedded solid-state

Tuesday, June 1, 2010

Apple's weak tech-fu | ZDNet

Apple's weak tech-fu | ZDNet

Creating an ASM duplicate database from a non-ASM database « Oracle DBA – Tips and Techniques

Creating an ASM duplicate database from a non-ASM database « Oracle DBA – Tips and Techniques

CORAID EtherDrive ATA-over-Ethernet ( SAN for Virtualization, Cloud, and Enterprise Storage

CORAID EtherDrive: Ethernet SAN for Virtualization, Cloud, and Enterprise Storage

10Gb Ethernet will be ubiquitous soon and this EtherDrive stuff has a great price/performance ratio

AIX has been able to boot iSCSI since v5 and support for NAS(ATA-over-Ethernet) has been in the Linux kernel circa. 2005

I'm mean, seriously when is storage going to `converge`?

Seagate gets hybrid SSD/HDD right

Seagate gets hybrid SSD/HDD right

Transition technology hybrids....
....A bit like that magic period when you could by a VCR/DVD combo!

Linux Logical Volume Manager Walkthrough – Stephen Foskett, Pack Rat

Linux Logical Volume Manager Walkthrough – Stephen Foskett, Pack Rat

IBM Redbooks | SAP Applications on IBM PowerVM

IBM Redbooks | SAP Applications on IBM PowerVM
just putting it here so I can find it quickly....

IBM PowerVM Active Memory Sharing

This technology is a bit immature on PowerVM compared to say VMWare.

IBM AMS on PowerVM

Oracle on VMWare

Why do Oracle hate VMWare so? all this proprietary commercial licensed bullshit has to go...Viva la Revolution!

Support Position for Oracle Products Running on VMWare Virtualized Environments [ID 249212.1]

Modified 16-NOV-2007 Type ANNOUNCEMENT Status PUBLISHED

Explain to customers how Oracle supports our products when running on VMware

Scope & Application
For Customers running Oracle products on VMware virtualized environments.
No limitation on use or distribution.

Support Status for VMware Virtualized Environments
Oracle has not certified any of its products on VMware virtualized
environments. Oracle Support will assist customers running Oracle products
on VMware in the following manner: Oracle will only provide
support for issues that either are known to occur on the native OS, or
can be demonstrated not to be as a result of running on VMware.

If a problem is a known Oracle issue, Oracle support will recommend the
appropriate solution on the native OS. If that solution does not work in
the VMware virtualized environment, the customer will be referred to VMware
for support. When the customer can demonstrate that the Oracle solution
does not work when running on the native OS, Oracle will resume support,
including logging a bug with Oracle Development for investigation if required.

If the problem is determined not to be a known Oracle issue, we will refer
the customer to VMware for support. When the customer can demonstrate
that the issue occurs when running on the native OS, Oracle will resume
support, including logging a bug with Oracle Development for investigation
if required.

NOTE: Oracle has not certified any of its products on VMWare, and use of
Oracle products in the RAC environment is also not supported.

Saturday, May 15, 2010

this oil spill is getting scary

lots of links - very worrying - what state are we leaving the planet in to our children and the other living things here

Im sure BP are playing the size of this down

How Shazam Works

I got that shazam on my iphone and started right away with the most obscure songs I could think of, It gets the old flyingnun kiwi 80's stuff but it did not get Dr Demento Kinko the clown.

What I needed to know is HOW it matches so fast,one bit of a song across so many - its all here, the algorithm uses a spectral frequency fingerprint hash

"Big O 1" [constant time O(1)] which is why its so fast!

How Shazam Works

Friday, May 14, 2010

why criminals love big pHaT BanK NoTES!!

BBC News - 500 euro note - why criminals love it so

Was it a deliberate ploy by the eurozone chiefs to make a bank note that criminals would surely use to help support the currency in the beginning?

And now that the currency is established - get rid of the big notes!!!

'Give me control of a nations money supply, and I care not who makes it’s laws.'
-M A Rothschild, founder of the Rothschild banking dynasty.

Thursday, May 13, 2010

GFS: Evolution

GFS: Evolution on Fast-forward at ACM Queue:
Q: GFS was already good, so what do Google do in addiction to GFS's evolutionary improvements?

A: They do revolutionary improvement to GFS2

-I like that!

Eucalyptus -- an open-source implementation of cloud computing that can emulate Amazon's EC2

Eucalyptus | Your environment. Our industry leading cloud computing software.: "- Sent using Google Toolbar"

ElasticVapor :: Life in the Cloud: Unlocking the Value of IaaS

ElasticVapor :: Life in the Cloud: Unlocking the Value of IaaS: "- Sent using Google Toolbar"

Made in IBM Labs: IBM Researchers Develop Energy Efficient Method to Analyze the Quality of Data at Record Speeds - Yahoo! Finance

Made in IBM Labs: IBM Researchers Develop Energy Efficient Method to Analyze the Quality of Data at Record Speeds - Yahoo! Finance

Uncertainty quantification in risk analysis has become a key application. In this context, computing the diagonal of inverse covariance matrices is of paramount importance. Standard techniques, that employ matrix factorizations, incur a cubic cost which quickly becomes intractable with the current explosion of data sizes. In this work we reduce this complexity to quadratic with the synergy of two algorithms that gracefully complement each other and lead to a radically different approach. First, we turned to stochastic estimation of the diagonal. This allowed us to cast the problem as a linear system with a relatively small number of multiple right hand sides. Second, for this linear system we developed a novel, mixed precision, iterative refinement scheme, which uses iterative solvers instead of matrix factorizations. We demonstrate that the new framework not only achieves the much needed quadratic cost but in addition offers excellent opportunities for scaling at massively parallel environments. We based our implementation on BLAS 3 kernels that ensure very high processor performance. We achieved a peak performance of 730 TFlops on 72 BG/P racks, with a sustained performance 73% of theoretical peak. We stress that the techniques presented in this work are quite general and applicable to several other important applications.

HP's Memristor tech - better than flash? • The Register

HP's Memristor tech - better than flash? • The Register: "Memristor technology to equal the switching speed and endurance shown by current NAND flash cells.

The Memristor or memory resistor is said to be a fundamental electrical circuit element, along with the resistor, capacitor and inductor. Its electrical state remains unaltered between a device being switched on and off - just like flash memory, for which it is a follow-on candidate. In this it competes with Phase-Change Memory (PCM)

- Sent using Google Toolbar"

Forget the GPad - is Google building a server chip? • The Register

Forget the GPad - is Google building a server chip? • The Register: "ese servers need chips. But the thing to remember about the ever-expanding Googlenet is that it's designed to process tasks that are broken into tiny little pieces. Google isn't interested in running the fastest processors on the planet. It's interested in running efficient chips that suit its pathological obsession with distributed computing.

- Sent using Google Toolbar"

This Changes Everything - Chuck's Blog

This Changes Everything - Chuck's Blog: "
EMC's global storage cloud plans

High Court rules software liability clause not 'reasonable' • Channel Register

High Court rules software liability clause not 'reasonable' • Channel Register: "- Sent using Google Toolbar"

Nice power7 vs the rest rundowns from The Register

Power7 v Power6 - its all about the cache • The Register Forums

Tuesday, May 11, 2010

Latest Articles from Cheat Sheets |

Latest Articles from Cheat Sheets |

Nice way to package up new technology topics

DBMS2 Database management and analytic technologies

DBMS2--Database management and analytic technologies in a changing world
One of the best sources of information I have found about all aspects of high-performance analytic data processing/BI/DW/DSS etc

Greenplum Single-Node Edition — sometimes free is a real cool price | DBMS2 -- DataBase Management System Services

Greenplum Single-Node Edition — sometimes free is a real cool price | DBMS2 -- DataBase Management System Services: "free, terabyte-scale data warehousing software

Oracle to Postgres Conversion

Im not getting a good feeling from what's happening at Sun since Oracle took over,lots of good people seem to have left, Solaris now needs a support contract to use after 90 days(read the download T&Cs)who knows how open MySQL will be? oh well there is always open Solaris and hopefully ZFS will go into more OSs likse it did into freeBSD
I personally get a bad feeling from ALL CLOSED STANDARD COMMERCIAL PROPERTY software.
At the end of the day Oracle's #1 job is to make money, databases ,applications,hardware ,software and services are all tools to achieve this

postgeSQL looks like the likely candidate due to is support in apache hadoop and even a variant in commercial products like Greenplums data warehouse cloud

anyway here is a spot to put Oracle to postgreSQL links, I think downreved ORA to latest PG is a doable migration. Just a straight DB is good, PLSQL makes it harder but there are conversion tools

Oracle to Postgres Conversion - PostgreSQL Wiki
Orafce Project - Oracle functions
Oracle to PostgreSQL

Achieving Near-Linear Scalability Using Solaris OS on NUMA Architectures

Achieving Near-Linear Scalability Using Solaris OS on NUMA Architectures: "- Sent using Google Toolbar"

Monday, May 10, 2010


Articles written

Mostly common sense, career related I guess

Good electronics

Instant Python : Instant Python
Good Python 101

I know I should use python more but I keep using perl
I know I should use perl more but I keep using shell script
I know I should automate more but ....

Randal L. Schwartz's page

Randal L. Schwartz: "Randal L. Schwartz

Perl'n stuff

Avenger's handbook

The Avenger's Front Page: "The avenger's handbook

Never really had it in for anyone enough warrant using this stuff, but its funny none the less ;P

Good ideas for practical jokes perhaps



The UNIX/LINUX BC program is actually a pretty useful calculation tool

Electronics Lab - Home

Electronics Lab - Home: "- Sent using Google Toolbar"

Circuit Cellar - Digital Library

Circuit Cellar - Digital Library

Lots of good circuit and PIC examples

Fun With Prime Numbers

Fun With Prime Numbers
Great C programs for primes
Basically works through better and better divisor methods up to a Eratosthenes' seleve in a memory array then bits

Pretty old page but would be great to compile and see how fast this goes on modern hardware

Sunday, May 9, 2010

RH Fedora core (lucky) 13 and Cirtix on FC 12

Fedora Core 13 is out soon, I use fedora on my laptop to keep current with the RedHat way of doing things as most tasks,commands and file locations are also the same in RHEL/CentOS etc
And there is always RDP (rdesktop) or ICA for visio/trim/exchange and other windows stuff

Nice guide - lets see if it works on FC13

Wednesday, May 5, 2010


Happy 1st Birthday, Wolfram|Alpha Blog!

Wolfram Alpha will come of age IMO when it can answer this kind of question

How many people are in the air at any given time
At any given time how many people are in aeroplanes
On average how many people are airborne

From info on the net and some basic arithmetic it should be able to estimate this

Monday, May 3, 2010

Oracle Security Whitepapers

Oracle Security Whitepapers
Oracle Security, Hardening of Oracle Databases and Oracle Application Server.

Backtrak Oracle info too

Reverse-Engineering a Quantum Compass

Reverse-Engineering a Quantum Compass

How birds (possibly) use the quantum mechanical effect of entanglement to migrate

cooltst: Cool Tools at OpenSPARC T1

cooltst, "CoolThreads Selection Tool", is a perl script that observes a running workload and applies various heuristics to assess whether that workload may be suitable for OpenSPARC ( ) and Oracle/Sun UltraSPARC T1, T2, and T2 Plus based servers.
The purpose of cooltst is to help you determine suitability of a Chip Multithreading (CMT) processor for a workload. Its recommendations should help you judge how much effort to put into a feasibility study which might include porting, prototyping, and/or performance measurement of your applications. cooltst is not a system sizing or capacity planning tool, and the rough approximations used internally in cooltst should not substitute for detailed performance analysis. cooltst runs on Solaris 8 and later, and on many Linux versions. cooltst is a system workload tool. It looks at the workload being executed by the system by all processes. It does not currently look at any particular process

Ref and more here.....
cooltools: Cool Tools at OpenSPARC T1

Download here

EMC AIX Linux HP-UX Oracle etc

Datacentre Support Reference Guides from PCS Computing

Lots of Un*xy doco goodness in one place

Build Your Own Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI

Great detailed step by step to build a good RAC cluster from commodity hardware

Build Your Own Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI: "Build Your Own Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI

by Jeffrey Hunter

Learn how to set up and configure an Oracle RAC 10g Release 2 development cluster on Oracle Enterprise Linux for less than US$2,700.

The information in this guide is not validated by Oracle, is not supported by Oracle, and should only be used at your own risk; it is for educational purposes only.

Sunday, May 2, 2010

SSH passwordless ssh trust

YouTube - passwordless ssh trust: "establish passwordless ssh trust between Linux host a3a and aix(aka busen) for user chris

[chris@a3a ~]$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/chris/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/chris/.ssh/id_rsa.
Your public key has been saved in /home/chris/.ssh/
The key fingerprint is:
bf:10:c1:a7:3b:8a:78:32:20:44:48:65:2b:14:dd:d2 chris@a3a
[chris@a3a ~]$ scp .ssh/ chris@aix:.ssh/authorized_keys
chris@aix's password: 100% 391 0.4KB/s 00:00

[chris@a3a ~]$ ssh aix
AIX 5.3

TA DA! (need this to NIMOL an AIX box from a Linux box)

Solaris 10 zone clone

YouTube - Solaris 10 zone clone

My video of a Solaris 10 zone clone - only took 36 seconds on a crappy ultrasparc2 450Mhz

Art Vs Science & Evidence Based Design

a bit interesting....

EA whitepapers from sparx

One of the best articles Ive read on ICT design

We tell ourselves its a methodology applied with constraints but there are not a lot of degrees of freedom really and in most cases its just tradeoffs - you know the drill : fast,-cheap,reliable-choose any two

Good Zachman EA HL diagram

Posted here so I don't have to look for it on the interwebs ;P

x86 Hypervisors and non hypervisors

Although I spend most of my `virtulsation and consolidation` time in the high end Unix/storage land (IBM PowerVM,VIO,WPAR,WLM- Oracle/Sun LDOMs,Containers/zones... USP-V HDP)

I do also use and keep an eye on developments in the x86 arena and run liveCD images such as network security toolkit ( ) or f5 BIG-IP ( ) its a good quick and dirty way to get tools on your work PC without perverting it from its SOE image

For a good free hypervisor based virtulisation have a look at Xen(Ctrix xenserver) ,VMWare ESXi, Oracle Virtual Box and Microsoft Hyper-V

VMware options considered.....
ESX Server vs. ESXi ( ),289142,sid94_gci1380354,00.html
And there is always VMware player!


MS Hyper-V

Oracle(Sun) Virtual Box

I also like some non hypervisor (ie emulators) eg QEMU and and

Ive used QEMU quite a lot(in Windows to run Linux and via versa) and I would like to get an AIX POWER CHRP image working in it one day.
Some people are having a crack eg

Saturday, May 1, 2010

Whats the difference between Software, hardware or Platform as a service - is it up in the clouds?

Nice cloud computing facilities overview

TOGAF 9 method overivew

Nice quick overview vid of TOGAF9

Get an overview of the TOGAF 9 method and framework given by our Chief Architect, Craig Martin. This exclusive online video will take you through an hour and half of intensive overview of enteprise architecture seen from the TOGAF perspective.

radar tracking of planes getting back in the air after the ash from Eyjafjallajökull clears 's airspace rebooted!

....there are variants that overlay the ash clouds too

AIX 6.1 TL5 and 5.3 TL12 and Systems Director 6.2

I see AIX 6.1 TL5 has just come out and AIX 5.3 TL12 has too - it will be the last Technology level for 5.3 with AIX 7 coming out soon.

IBM Systems Director 6.2 is planned to be GA June 25.
6.1 to 6.2 agents (same agent as Tivoli ITM) can be pushed out but upgrading from 5.x is a fresh install.
5.x is fat client, 6.x is all web and jpnl (has issues with MS IE but sweet with Firefox)


power7 SAPS test results coming in eg 202180 for a p780

Friday, April 23, 2010

35TB Tape!

More big tape tech 20-50TB The cost of High Availability (HA) with Oracle The cost of High Availability (HA) with Oracle

Thursday, April 22, 2010

Oracle 11gR2 on JeOS

I wanna play with Oracle 11gR2 (and swingbench) stuff so Im going to use Oracle Enterprise Linux JeOS in Sun Virtual Box....
...more to come - unless I get bored or sidetracked

OK it would not even boot - shi7

new virtual box is out now v3.2.0b1 - renamed to Oracle Virtual Box
  • Experimental support for Mac OS X guests
  • Memory ballooning to dynamically in- or decrease the amount of RAM used by a VM (64-bit hosts only) (see the manual for more information)
  • CPU hot-plugging for Linux (hot-add and hot-remove) and certain Windows guests (hot-add only) (see the manual for more information)
  • New Hypervisor features: with both VT-x/AMD-V on 64-bit hosts, using large pages can improve performance (see the manual for more information); also, on VT-x, unrestricted guest execution is now supported (if nested paging is enabled with VT-x, real mode and protected mode without paging code runs faster, which mainly speeds up guest OS booting)
  • Support for deleting snapshots while the VM is running
  • Support for multi-monitor guest setups in the GUI (see the manual for more information)
  • USB tablet/keyboard emulation for improved user experience if no Guest Additions are available
  • LsiLogic SAS controller emulation
  • RDP video acceleration
  • NAT engine configuration via API and VBoxManage

MS data mashup tool

Microsoft PowerPivot for Excel - a free tool to download up to 100 million rows of data from different sources

Wednesday, April 21, 2010

Script to draw a circle

$seq 60|awk '{x=int(20+10*cos($1/9));y=int(40+20*sin($1/9));system("tput cup "x" "y";echo X")}'

If you do not have seq you can use #yes|head -99|cat -n

install SSH 5 on AIX 5.3 (get openssl need an IBM login)

#zcat openssl. | tar -xvf -
#zcat openssh-5.0_tcpwrap.tar.Z | tar -xvf -
# /usr/lib/instl/sm_inst installp_cmd -aQd /tmp/openssl. -f _all_latest -cNgXGY

geninstall -I "a -cgNQqwXY -J" -Z -d /tmp/openssl. -f File 2>&1


Pre-installation Verification...
Verifying selections...done
Verifying requisites...done

Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
openssl.base # Open Secure Socket Layer
openssl.license # Open Secure Socket License # Open Secure Socket Layer


BUILDDATE Verification ...
Verifying build dates...done
3 Selected to be installed, of which:
3 Passed pre-installation verification
3 Total to be installed

Installing Software...

installp: APPLYING software for:
------------------------------------------------------------------------------- USR APPLY SUCCESS
openssl.license USR APPLY SUCCESS
openssl.base USR APPLY SUCCESS

# /usr/lib/instl/sm_inst installp_cmd -aQd /tmp/openssh-5.0_tcpwrap -f _all_latest -cNgXGY

geninstall -I "a -cgNQqwXY -J" -Z -d /tmp/openssh-5.0_tcpwrap -f File 2>&1

openssh.base.client USR APPLY SUCCESS
openssh.base.server USR APPLY SUCCESS
openssh.base.client ROOT APPLY SUCCESS
openssh.base.server ROOT APPLY SUCCESS

File /etc/group has been modified.
File /etc/passwd has been modified.

One or more of the files listed in /etc/check_config.files have changed.
See /var/adm/ras/config.diff for details
# openssl version
OpenSSL 0.9.8h 28 May 2008
# ssh -V
OpenSSH_5.0p1, OpenSSL 0.9.8h 28 May 2008
# ps -ef|grep ssh
root 159882 270364 0 15:57:06 pts/1 0:00 grep ssh
root 250034 131178 0 15:54:01 - 0:00 /usr/sbin/sshd

# lssrc -s sshd
Subsystem Group PID Status
sshd ssh 250034 active

How to replace dead hard disk in Solaris using SVM/SDS

For this example, consider the following 2 disks

# format < /dev/null

Searching for disks...done

0. c1t0d0
1. c1t1d0

Specify disk (enter its number):

# metastat -p
d300 -m d310 d320 1
d310 1 1 c3t1d0s0
d320 1 1 c3t2d0s0
d3 -m d13 d23 1
d13 1 1 c1t0d0s3
d23 1 1 c1t1d0s3
d5 -m d15 d25 1
d15 1 1 c1t0d0s5
d25 1 1 c1t1d0s5
d1 -m d11 d21 1
d11 1 1 c1t0d0s1
d21 1 1 c1t1d0s1
d0 -m d10 d20 1
d10 1 1 c1t0d0s0
d20 1 1 c1t1d0s0

The failed disk for this example will be c1t1d0 which is a mirrored copy of c1t0d0. The first thing we need to do is determine if this disk had any metadb replicas on it:

# metadb -i

flags first blk block count
a m p luo 16 8192 /dev/dsk/c1t0d0s6
a p luo 8208 8192 /dev/dsk/c1t0d0s6
a p luo 16 8192 /dev/dsk/c1t0d0s7
a p luo 8208 8192 /dev/dsk/c1t0d0s7
a p luo 16 8192 /dev/dsk/c1t1d0s6
a p luo 8208 8192 /dev/dsk/c1t1d0s6
a p luo 16 8192 /dev/dsk/c1t1d0s7
a p luo 8208 8192 /dev/dsk/c1t1d0s7

There are 2 metadb’s on the failed disk slices s6 & s7. We can delete these records.

# metadb -d /dev/dsk/c1t1d0s6 /dev/dsk/c1t1d0s7

The metadb records should now be deleted off the failed disk.(this is not actually deleting them off the disk - the disk is busted - its just saying they dont live there anymore)

# metadb -i
flags first blk block count
a m p luo 16 8192 /dev/dsk/c1t0d0s6
a p luo 8208 8192 /dev/dsk/c1t0d0s6
a p luo 16 8192 /dev/dsk/c1t0d0s7
a p luo 8208 8192 /dev/dsk/c1t0d0s7

Next we need to unconfigure the device to do this run a ‘cfgadm –al’

# cfgadm -al | grep c1t1d0
c1::dsk/c1t1d0 disk connected configured unknown

# cfgadm -c unconfigure c1::dsk/c1t1d0

The disk should now be unconfigured from the system

# cfgadm -al | grep c1t1d0

c1::dsk/c1t1d0 disk connected unconfigured unknown

You can go ahead with the physical replace of the drive.

Now, we will need to configure the drive.

# cfgadm -c configure c1::dsk/c1t1d0

To check it has been configured run:

# cfgadm -al | grep c1t1d0
c1::dsk/c1t1d0 disk connected configured unknown

now copy the partition table (VTOC) across from the working disk to the new disk. Prvtvtoc will print the VTOC to fmthard that will format the new disk

#prtvtoc /dev/rdsk/c1t0d0s2 |fmthard -s - /dev/rdsk/c1t1d0s2

The next step is to run metareplace on all the meta devices which lay on the dead disk c1t1d0. To identify these you can run ‘metastat -p’ again

# metastat -p
d300 -m d310 d320 1
d310 1 1 c3t1d0s0
d320 1 1 c3t2d0s0
d3 -m d13 d23 1
d13 1 1 c1t0d0s3
d23 1 1 c1t1d0s3 <-----HERE
d5 -m d15 d25 1
d15 1 1 c1t0d0s5
d25 1 1 c1t1d0s5 <-----HERE
d1 -m d11 d21 1
d11 1 1 c1t0d0s1
d21 1 1 c1t1d0s1 <-----HERE
d0 -m d10 d20 1
d10 1 1 c1t0d0s0
d20 1 1 c1t1d0s0 <----and HERE

As you can see from the above, c1t1d0 had mirrors in d0, d1, d3 and d5.

Do the following:

# metareplace -e d0 c1t1d0s0
# metareplace -e d1 c1t1d0s1
# metareplace -e d3 c1t1d0s3
# metareplace -e d5 c1t1d0s5

The disks should now start resyncronising, when this is complete all of the devices will be in the OK state.

#while :; do metastat -p | grep -i stale; sleep 5; done

hand and finger workout

went indoor rock climbing here last night for a couple of hours - taxes the fingers and hands pretty hard- its fair cardio too
The guys from my work who go are so much better than me its good motivation to try harder

HMCs for power7

IBM pSeries power7 hardware needs at least a CR3 HMC . CR5 (7042-CR5) is recommended - because it the most expensive?? - IBMs job (like almost all company's) is to make money - consulting, systems and software are just the tools to do that job is as far as CR2's can go
7.710 is what you need to manage power7

Sparks and fire - eruptions with lighting

How fugen weird are these, I had to check snopes to see if they were BS -as best as I can tell they were taken by a guy called Lucas Jackson

Friday, April 16, 2010

scary hands!

Do an image search for Russian arm wrestler Denis Cyplenkov, look at those paws

mkdvd vs mksysb in AIX for bare metal restore

mksys is a good tool but is a hangover from tape days, these days we like dvds and images - most machine dont even come with a tape drive (eg DAT) anymore but they do have DVDRAMs or DVD RO of some type
mkdvd is a wrapper for mksysb that will make a DVD image of your mksysb eg

#mkdvd -SI /dvd_backup_images/

This will create the image file into /dvd_backup_images/ with a name like cd_image_*
then you can use something like

#cdrecord -dao -speed=2 -dev=/dev/dvd /dvd_backup_images/cd_image_*
#burn_cd -d /dev/cd0 /dvd_backup_images/cd_image_*

(really you should NIM this shi7 but this is a stand alone example say)

wakko aix/pssp terms

smitty skulker efence worm hats hags supper

don't forget amd(fan) , ipl (boot) ,dasd(disk), purr and spurr

this list will grow as I remember stuff

Thursday, April 15, 2010

Old skool scripting

In this world of HTML5/CSS3 and python sometimes I forget the power of the simple 2 letter UNIX utilities like dd,od,tr..

this one saved me today..saved me time that is ;)
tr [:upper:] [:lower:] ....too easy!

deadlift bench press descending super set experiment

My gym membership ran out last month so I paid for a casual today and I wanted to do a lot as I may only exercise once this month!

Did a deadlift/bench press descending super set, Ive tryed a squat deadlift super set and just died - too much work and hits the same posterior chain too hard so I gave DL+BP a go, BP does not tax me too much
Went ok started the deadlifts at 405lbs x3(I got 5 in me for that) and benchpress about 290 (x5) and keept dropping down to 100kg on both (DL stiff leg)

Lets see if I'm sore tomorrow it was a good time-economical workout

Tuesday, April 13, 2010


AIX 7 is coming!

.......more generally

$echo AIX $(($(date +"%Y")-2003)) on POWER $(($(date +"%Y")-2003))

I saw on that NCSA/IBM dont run AIX on there biggest POWER7 HPC cluster systems anymore, eg Blue Waters


A client is looking at moving from Oracle 10g on AIX5.3, all JFS2 file systems to ASM. The SAN is HDS: USP-V fronting USP and AMS arrays. HDS supports Thin provisioning with Oracle ASM based storage so it would be nice to have for migrations,they wont need to have all of the storage up front and according to Oracle its OK Page 22 is a little worrying based on Oracle's testing, there is a potential of 8-25% adverse performance impact when thin provisioning is used. I guess thats when ASM is striping AND HDS is striping in the background too - ASM must be told external RAID is being used basically.

As long as they do as recommended, ie all RAID Groups and Parity Groups in a pool are taken from multiple/different back end adapters, same disk size/speed, same RAID levels they should hit the performance statistics mentioned under "ASM on HDP - Recommended configuration".

RAID Groups and Parity Groups are just terminology for the group of disks configured in a RAID set in HDS Modular(AMS) & Enterprise(USP) arrays respectively.

Saturday, April 10, 2010

Stamp collecting is a hobby,"not stamp collecting" is not

Richard Feynman on doubt, uncertainty: the "everything is possibly wrong" statement that Feynman says is a tenant of scientific thinking resonates with me and got me thinking about about what I fundamentally believe, not what I've been told but what are my core beliefs based on experience and my own thinking

1) A truth [and all true things] can be questioned and when you have A truth no matter which line of questioning you approach it from a truth will be re-enforced.
2) Its wrong to do something to someone else you would not want done to yourself
3) Question authority

Have you ever been wrong about something? [everyone - yes!]
Could you possibly be wrong about this?[only reasonable answer from a critical thinker is 'yes' - 'no' shows up an irrational thinker]

which got me thinking about Pascal's wager which lead me to this great vid

mounting CDROMs,ISOs and windows share in un*xs

In general its the mount command then some option for what the cdrom (or other) filesystem then some read-only option, then the device, then the mount point

mount -v cdrfs -o ro /dev/cd0 /mnt/cdrom
##### mount an .iso image ####128M PPs on hdisk2
mklv -y cdlv -s n -L /dev/cdlv vg00 $(du -m dvd1.iso|awk '{print int($1+128)"M"}') hdisk2 ; dd if=dvd.iso of=/dev/cdlv ; mount -v cdrfs -o ro /dev/cdlv /mnt/iso

NB: pretty bad eh and you need enough space on disk2 to copy it to, and it takes ages. I wrote this 1 liner in a post to usenet and I see its all over the net now as the way to mount in AIX 5.3 eg

I guess you should really do it from the VIO server these days

or like this

or in AIX6 like this
loopmount -i cdrom.iso -o "-V cdrfs -o ro" -m /mnt

mount -t iso9660 -r /dev/hdb /mnt/cdrom
##### mount an .iso image ####
mount -o loop dvd.iso /mnt/iso

mount -F hsfs -r /dev/dsk/c0t6d0s2 /mnt/cdrom
##### mount an .iso image ####
lofiadm -a dvd.iso; mkdir /mnt/sol ; mount -t hfs /dev/lofi/1 /mnt/iso
mount -t cdfs -o ro /dev/dsk/cqd1s0 /mnt/cdrom

Windows!!! you can mount SMB/(Windows shares) to Linux with just the mount command:
### Linux
mount -t smbfs -o username=billy,password=apple22,workgroup=CORP //fileserver/fileshare /mnt/windowsdrive

### AIX

root@[scatst]/>mount -v cifs -n scadc01/temp02/temp02 -o wrkgrp=sca01,uid=205,fmode=750 /Sapinterface /scadc01

This basically says put the CIFS(windows SMB) share /Sapinterface from node scadc01 with login user=temp02 and password=temp02 with domain=sca01 on the AIX box as /scadc01 with read, write and execute permission for the user with UID=205

The Microsoft Services for Unix (SFU) help has all of this information and step by step howtos but basically on your side you need to:-

Log on as a member of the Domain Admins group of the server's domain
Install Server for NFS Authentication (and SFU etc)
[Server for NFS Authentication must be installed on every domain
controller in any domain containing users who will access files
through Server for NFS]
Log on as a member of the (local) Administrators group.
Install Server for NFS
Configure user authentication. Install "User Name Mapping" on at least
one server in the network and then specify the User Name Mapping
server that Server for NFS should use for authentication.

Check Server for NFS service, is running
On windows Services For unix shell:-
nfsshare scadev=C:/sharefolder root=

Then on AIX we can:-
mount -v nfs3 -n /share /mnt/share

wont go into samba - its all over the net and

Thursday, April 8, 2010

All new power7 p770s

We bought 3 3CEC IBM pSeries p770s a few weeks back- first in Australia me thinks

Its the end of model run out sale!!

Upgrading power5 p595s to power6+ 5Ghz ,power 595s (9119-FHA ) has got to be a great bang for buck upgrade.

P595's have no end of life against them yet and the power6+ processor books have dropped in price almost 50% (eg ) and a 64 core p595 upgraded with 5GHz p6+'s is about as powerful as a new power7 3.5Ghz 64 core p770
System Name SPECint_rate20063 SPECfp_rate2006
IBM Power 595 2160 2180
IBM Power 770 2013 1689

(so you can still consolidate a lot more eggs into the same basket if thats your aim) and p595 has better RAS eg no single p5ioc chip handling both GX++ ports ie loosing the wron p5ioc kills all IO on the CEC - this was the case with the p570's too)

power6+ can do all the multiple shared pools(oracle savings), VIO, AIX6.1, WPAR, live partition mobility, micropatitoning, active memory sharing (not active memory expansion(Trade CPU for RAM) or max/turbo/intelli core that all sound a bit multimedia cdrom come MMX technology to me)

p595s can be upgraded to power 595s with just new power6+ books - no need to change anything else its what Auspost did - just by adding the new power6+ books you can free up lots of space (consolidating) and gain all of the good power7 features without increasing your footprint 1RU (Chris Gibsons experience)


I've been thinking about how well meaning IT architect/designer types [such as myself] over engineer solutions because we are propeller heads at heart.
At the end of the day most solutions/system are just filing cabinets - sure they are huge and relational and have business-logic and stuff in there but at the end of the day a query comes from a user or web and some data comes back, or goes in - you get the picture - Its a records system - focus on that more than the technology(CPU/OS/DB/Stroage/ETC) that the filing cabent is composed of

ANYWHO I see so much downtime due to over engineering features to reduce downtime so I started trying to write basic rules on how to design simple systems and keep propeller tendencies in-check. I personally think we should try and find non IT solutions to problems some - seriously it would be cheaper to use filing cabinets and clerks sometimes that some 'enterprise ready HA CRM/ERP system etc metats perhaps? How old is the NE555 IC or BC546 transitor - they have their place

Unless otherwise absolutely unavoidable...

No NIC shall be teamed/bonded/aggregated or trunked unless there is insufficient BW - added complexity and cost does not out weigh cheap simplicity

No servers shall be HA clustered within the same site, DR should be site by site

Choose vertical redundancy over horizontal redundancy i.e. in a muliti tired application rather than having multiple layers of multiple database, app and web servers have multiple servers but design so each server has database app and web- if possible

No software or OS shall be upgraded or patched if its working fine (bird in hand rule + if it isn't broke don't fix rule)

Never adopt the latest version of any software under any circumstance just to keep current

Invest design effort in quick restores after incidents, do not waste time trying to fix

In all security vs. functionally trade-offs functionality must win

In any hardware vs. skills trade-off for performance tuning go hardware as skills cost more than ram

No OS shall be customised or tweaked from default installation options for performance reasons, only for functionality

Purchase hardware that gives the best bang for buck, not absolute performance

For any system that requires HA or failover of some type - the failover mechanism should reside as high as possible up the hard/software stack(e.g. like dns - one host down try the next , application over RAC rack, RAC over OS level cluster)

Wednesday, April 7, 2010

Single threaded CPU benchmark

Every time I get on a new un*x/linux box I like to run this primes.c calculator, its no specint or swingbench but hey, its simple and I'M RUNNING IT - I like to see the results myself and encourage everyone to run there own tests - seldom trust web tests and never trust vendor tests!

I'm often surpised that the cheap commodity intel/amd cpus outperform the expensive enterprise RISC CPUs. Sure there are arguments about workload,cache,exacution pipelines,out of order execution and and holistic system balance (search usenet for my posts about this) but I would expect a $20,000.00 CPU to kick ass on a $2000.00 IN EVERY LOAD and it does not....

### THE TEST ###

cat <<> primes.c
main(int argc, char *argv[])
int I1 = 1;
int I2 = 100000;
int I3;
int I4;
int I5;
int I6 = 0;
int I7;
printf("N primes up to ");
printf("%d", I2);
printf(" is: ");
I3 = 2;
I4 = I1 / 2;
I5 = I1 % I3;
if (I5) {goto OK;}
goto NEXT;
if (I3 <= I4) {goto LOOP;}
I7 = I1;
if (I1 <= I2) {goto REDO;}
printf("%d\n", I6);
printf("last is: %d\n", I7);
return 0;
gcc primes.c -o primes
time ./primes
N primes up to 100000 is: 9592
last is: 99991

real 0m X
user 0m Y
sys 0m Z

#### THE RESULTS #####

UltraSPARC-2i 450Mhz
real 0m46.27s
user 0m46.24s
sys 0m0.01s
UltraSPARC-T1 1.2Ghz
real 0m32.13s
user 0m32.11s
sys 0m0.00s
POWER3 450Mhz
real 0m22.40s
user 0m22.30s
sys 0m0.00s

UltraSPARC-T2 1.2Ghz
time ./primes
N primes up to 100000 is: 9592
last is: 99991

real 0m16.81s
user 0m16.80s
sys 0m0.00s

sparcv9 processor operates at 1167 MHz
cc primes.c -o pri
time pri
N primes up to 100000 is: 9592
last is: 99991

real 0m17.62s
user 0m17.61s
sys 0m0.00s

POWER5 1.65Ghz
real 0m11.60s
user 0m10.57s
sys 0m0.00s
real 0m11.44s
user 0m8.71s
sys 0m0.00s
UltraSPARC-IV+ 1.95Gz
real 0m8.86s
user 0m8.85s
sys 0m0.00s
UltraSPARC-IV+ 2.1Ghz
real 0m8.22s
user 0m8.21s
sys 0m0.00s
real 0m7.97s
user 0m7.88s
sys 0m0.00s
Dual-Core AMD Opteron 2.8Ghz
real 0m3.729s
user 0m3.728s
sys 0m0.004s
Intel(R) P4 1.66GHz
real 0m2.879s
user 0m2.671s
sys 0m0.015s
Intel Pentium M 1.60GHz
real 0m2.710s
user 0m2.694s
sys 0m0.008s
Intel Quad 2.33Ghz
real 0m1.663s
user 0m1.662s
sys 0m0.002s
Intel(R) Core™2 Quad 2.4GHz
real 0m1.638s
user 0m1.625s
sys 0m0.010s
Intel Xeon(R) dual 3Ghz
real 0m1.325s
user 0m1.325s
sys 0m0.001s

Intel(R) Xeon(R) CPU E5450 @ 3.00GHz
real 0m0.82s
user 0m0.80s
sys 0m0.00s