Monday 27 June 2011

OVS host preparation

As oracle puts more time and money into it’s virtual servers, it’s going to become more common.  I’ve been dabbling with OVS at a client that is going to be using it in their live environment.  We were having some problems with multipathing, but seemingly because nobody filled out the multipath.conf file with an vendor settings – so everything was vanilla out of the box and would not work.

Once this was rectified, a bit of an audit was performed.  I was doing some research and found references to an RPM (vmpinfo-2.2-3.noarch.rpm), which is available on https://support.oracle.com.  This is an awesome script which does a post installation battery of tests and checks and creates a pretty cool (nerdy cool) HTML based report.

install is trivial:  rpm -i vmpinfo-2.2-3.noarch.rpm

Then just run it, vmpinfo.

There are a couple of example outputs on https://sites.google.com/site/cncninja/file-cabinet, as well as the installation rpm.

This could be used for any generic host checking I think - but is specific for OVS and looks for specific OVS problems.

Thursday 9 June 2011

Load testing, stress testing performance testing JDE

Myriad have uncovered an inexpensive and simple method for load testing web versions of JDE.  It’s always been difficult to find a cost effective method of loading up JDE for stress testing, we think we have the perfect solution.

We’ve been able to perform application load testing down to transactional detail, ensuring that the 2400 sales orders (for example) that were entered in by the load testing scripts actually hit the database.  We are able to ensure that all of the batch jobs were executed. 

We are able to quickly record your core transactions and user interactions with the system and then multiple this load across your EnterpriseOne suite.  This level of testing can stress your batch, interactive and web servers as much or as little as you like.  Myriad can then monitor for any bottlenecks, make recommendations and retest.

Have you ever wondered if OAS is faster than WebLogic?  Should you use weblogic instead of WebSphere?  Myriad can easily create a virtual test environment for you and run load testing over it – so you can compare apples with apples.

What is the average bandwidth use for a modern E1 client?  How many turns are being generated for logging in.  You can quickly get these answers and more with some load testing.

Myriad can VPN into your system and complete all testing remotely and then send you a comprehensive report at the end!

image

Simple graphs like the above can highlight your latency issues and also tell you when your network is going to be saturated.

Did you know that 2400 users logging into your system and running basic queries for < 10 minutes can generate more than 3.4GB of traffic?  You need to ensure that everything is tuned correctly to ensure your JDE environment is as efficient as possible.

Myriad are leading the way for stress and load testing JDE software.

Tuesday 7 June 2011

replace function with SQL, forgotten gem

Oracle/PLSQL: Replace Function


In Oracle/PLSQL, the replace function replaces a sequence of characters in a string with another set of characters.

The syntax for the replace function is:

replace( string1, string_to_replace, [ replacement_string ] )

string1 is the string to replace a sequence of characters with another set of characters.

string_to_replace is the string that will be searched for in string1.

replacement_string is optional. All occurrences of string_to_replace will be replaced with replacement_string in string1. If the replacement_string parameter is omitted, the replace function simply removes all occurrences of string_to_replace, and returns the resulting string.

 

How cool is this for renaming a server and your update statements over the F986101 and the F98611.  Just use:

Note that the AS/400 and oracle have the exact syntax for this string operator (amazing?)

update JDEPLAN900.f986101
set omdatp = replace(omdatp, 'SVR003', 'SVR703')
where omdatp like '%SVR003%'

This will get the – Logic, –XAPI etc etc.

That just made my machine rename scripts MUCH more simple.