Beta testers needed for MQ Channel Throttler

All,

Capitalware is ready for beta testers for a new solution called: MQ Channel Throttler.

MQ Channel Throttler provides the ability to control/throttle the messages that flow over a channel. It operates with Sender, Receiver, Server, Requestor, Cluster-Sender, Cluster-Receiver, Server Connection and Client Connection channels of the WMQ queue managers.

Companies or users may have a need to restrict the number of messages or bytes flowing over a channel for particular testing scenarios. The user can control the message flow by either byte count or message count. The time value can be in either seconds or minutes. For CLNTCONN/SVRCONN channel, the user can also control the flow by MQPut, MQGet or both.

I plan on building MQ Channel Throttler for AIX, HP-UX (RISC & IA64), Solaris (SPARC & x86_64), Linux (x86, x86_64, POWER & zSeries), Windows and IBM i (OS/400). MQ Channel Throttler will support WMQ v6.0, v7.0, v7.1, v7.5 and v8.0.

There will also be a version for z/OS called: MQ Channel Throttler for z/OS. MQ Channel Throttler for z/OS will support WMQ v6.0, v7.0, v7.1 and v8.0.

Beta testing MQ Channel Throttler and MQ Channel Throttler for z/OS is absolutely free including support (no strings attached).

If you interesting in trying out either products, please send an email to support@capitalware.com to request a trial of MQ Channel Throttler and/or MQ Channel Throttler for z/OS.

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, IBM i (OS/400), Linux, MQ, Unix, Windows, z/OS Leave a comment

MQVB, MQVE & MQBT JRE Cipher Spec Issue

A customer was using MQ Visual Browse (MQVB) and configuring MQVB to use SSL to connect to a remote queue manger (WMQ v7.5.0.2). They said:

I am getting error “Reason Code = 2400”, when specifying TLS_RSA_WITH_AES_256_CBC_SHA as the SSL Cipher Spec Name.

They also said:

We have other MQ Java using SSL working with TLS_RSA_WITH_AES_128_CBC_SHA and TLS_RSA_WITH_AES_256_CBC_SHA using the IBM JRE.

Due to security standards here, there are 3 acceptable cipher specs we are allowed to use. Of the three, only the weakest (TRIPLE_DES_SHA_US) will work with MQ Visual Browse

Cipher Spec Cipher Suite Results
TLS_RSA_WITH_AES_256_CBC_SHA SSL_RSA_WITH_AES_256_CBC_SHA Did not work
TLS_RSA_WITH_AES_128_CBC_SHA SSL_RSA_WITH_AES_128_CBC_SHA Did not work
TRIPLE_DES_SHA_US SSL_RSA_WITH_3DES_EDE_CBC_SHA Worked

Currently, MQ Visual Browse (MQVB), MQ Visual Edit (MQVE) and MQ Batch Toolkit (MQBT) are build and deployed using Excelsior JET v7.6 (which is based on Oracle’s JRE v1.6.0_41).

My first thought was that the JRE needed the 256-bit JCE policy. I had the customer deploy the 256-bit JCE policy but it did not make any difference.

Next, I did a build and deployment of MQVB using Oracle’s JRE v1.6.0_41 but it resulted in the same issue for the customer.

Since, the customer has IBM’s JRE v1.6.0 installed on their PC, I had them rename the embedded Oracle JRE, so that MQVB would use the installed IBM JRE. This time everything worked.

Therefore, if you are using MQVB, MQVE or MQBT and are having issues trying to use certain MQ SSL Cipher Specs then let us know and we will get it sorted out.

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, IBM i (OS/400), Java, Linux, Mac OS X, MQ, Security, Unix, Windows, z/OS Leave a comment

MQ Batch Toolkit and Limiting the Messages Retrieved

I don’t write about MQ Batch Toolkit (MQBT) very often, so when I got an MQBT support email today, I thought that the question and answer would make a good blog item.

Question:

In MQ Batch Toolkit, what command can be issued, for exporting messages to a file, to retrieve all messages on a queue except in the case where there are more than 1000 messages (and cannot wait more than 30 seconds for the MQGET). i.e. Retrieve up to 1000 messages at any given time without waiting a long period of time for more messages to arrive. The reason for the 1000 message limit, is to limit network traffic in any given period of time.

Current, MQBT Export command used:

mqbt.exe Export -p {profile} -q {queue_name} -f {filename} -c {num_files} -C -D 

Answer:

When the ‘-c’ parameter is used in the Export function then MQBT will issue MQGET with unlimited wait. If you use ‘-c 1000′ then MQBT will wait until it receives 1000 messages. MQBT is attempting to accomplish the task of retrieving 1000 messages and it could wait for many minutes or even hours.

The simplest solution is to write a script to first check the queue depth using the MQBT’s QDepth function and then perform the Export function based on whether or not the queue depth is above a particular value

@echo off
setlocal

if [%1]==[] echo Queue Manager Profile was not specified && goto Usage
if [%2]==[] echo Queue Name was not specified && goto Usage
if [%3]==[] echo Output filename was not specified && goto Usage

SET /A MAX_MSG=1000

cd /D C:\Capitalware\MQBT\
mqbt.exe QLIST -p %1 -k %2 -t L -f qdepth.txt -D
FOR /F "tokens=1,2" %%A in (qdepth.txt) DO (

   if '%%A'=='%2' (
      if %%B GTR %MAX_MSG% (
         mqbt.exe Export -p %1 -q %2 -f %3 -c %MAX_MSG% -C -D
      ) else (
         mqbt.exe Export -p %1 -q %2 -f %3 -C -D
      )
   )
)
del qdepth.txt
goto :DONE

:Usage
echo Usage: %0 Profile_Name Queue_Name Ouput_File_Name
goto :DONE

:DONE
endlocal

Breakdown of the script:

The script expects 3 parameters:
- Queue Manager Profile
- Queue Name
- Output file name

Line # 8 is where you set the maximum number of messages to be retrieved.

Line # 11 issues the QDepth function to retrieve the depth of the queue and writes it to a file called ‘qdepth.txt’.

Line # 12 loops over the file ‘qdepth.txt’ and tokenizes the values of each line.

Line # 14 checks that it has the correct queue name.

Line # 15 checks if current queue depth is greater than the maximum queue depth,
- if true then issue Export function with ‘-c’ keyword to limit the number of messages retrieved
- else issue Export function without ‘-c’ keyword to retrieve all of the messages on the queue.

Hopefully, this blog posting will give people ideas on how to extend the use of MQBT.

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, IBM i (OS/400), Java, Linux, Mac OS X, MQ, Unix, Windows Leave a comment

5 Weeks until MQ Technical Conference

MQ Technical Conference v2.0.1.4 (MQTC) is only 5 weeks away – September 29 to October 1, 2014 at Kalahari Resorts in Sandusky, Ohio.

MQTC will offer 85+ sessions that are designed to enhance the skills of IT professionals who are using IBM’s WebSphere MQ on AIX, HP-UX, IBM i (OS/400), Linux, Solaris, Windows and z/OS.

The regular price for the conference is only $399.00 which includes 3 days of MQ sessions, breakfast, lunch and coffee breaks!!! That’s $133 a day to be feed and trained.

    Reasons to attend:

  • 85 technical sessions – 44 unique technical sessions
  • 15 vendor sessions
  • 18 MQ speakers – 8 from IBM
  • MQ Sessions for all major platforms including z/OS
  • Breakfast, lunch and coffee breaks are included
  • Hor d’oeuvres served between 5:30PM and 7:30PM in the Vendor Pavilion
  • Regular price is $399.00 per attendee
  • Group pricing (5+) is $299.00 per attendee

For more information, please go to: www.mqtechconference.com

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, Education, MQ, MQ Technical Conference Leave a comment

New: Universal File Mover v1.1.0

Capitalware is pleased to announce the release of Universal File Mover v1.1.0. It is a free open source project.

Universal File Mover is more than a simple tool to manage the transfer of files. It allows the user to combine business processes into a workflow. The user combines a series of Action commands to create the UFM Workflow XML file. UFM is supported on AIX, HP-UX, IBM i (OS/400), Linux, Mac OS X, Solaris and Windows.

    Changes:

  • Added Actions element to the MQReceive action
  • Added ReplyToQName element to MQ element in the Global section
  • Added ReplyToQName element to MQ element for MQSend action
  • Fixed a bug for Delete and Touch actions when they fail and onErrorFail is N
  • Fixed a bug for MQSend action where it was requiring the file to exist at the start of the UFM Workflow
  • Fixed a bug for Status queue manager name not being tokenized

For more information on Universal File Mover, please go to:
http://www.capitalware.com/ufm_overview.html

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, IBM i (OS/400), Java, Linux, Mac OS X, MQ, Open Source, Universal File Mover, Unix, Windows Leave a comment

MQTC v2.0.1.4 Schedule Posted

The MQTC v2.0.1.4 schedule has posted to www.mqtechconference.com/schedule.html

MQTC will be the largest conference in the world solely dedicated to IBM’s WebSphere MQ.

For more information, please go to: http://www.mqtechconference.com

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, Education, MQ, MQ Technical Conference Leave a comment

SQLite v3.8.6 Released

D. Richard Hipp has just released SQLite v3.8.6.
http://www.sqlite.org/news.html

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

Regards,
Roger Lacroix
Capitalware Inc.

C, Database, IBM i (OS/400), Linux, Mac OS X, Open Source, Programming, Unix, Windows Leave a comment

IBM’s New Super Conference: InterConnect 2015

IBM has announced a new super conference called InterConnect 2015

InterConnect will connect three popular IBM conferences – Impact, Innovate and Pulse – and combine the best in education and networking, into one of the most comprehensive software events ever. Cloud. Security. Mobile. DevOps. IT optimization. Internet of Things. Application Infrastructure.

Many years ago, MQ used to be front and center at the Transaction and Messaging Technical Conference. In 2007, IBM combined several conferences into Impact 2007 which was basically, a giant WebSphere conference where MQ was a small component. Now, IBM plans to merge 3 large conferences into 1 super conference with 20,000 attendees. InterConnect 2015 will take place February 22-26, 2015 at both the MGM Grand and Mandalay Bay in Las Vegas, Nevada. The conference will be so big that it cannot be held at a single location.

So, what does this mean for IBM MQ (aka WebSphere MQ/MQSeries) at the InterConnect 2015 conference? I have no idea, but you can be assured that it is not front and center like it used to be.

Of course, if you want lots of MQ content, at a single location, presented in a relaxed atmosphere then please have a look at the Capitalware’s MQ Technical Conference v2.0.1.4.

Regards,
Roger Lacroix
Capitalware Inc.

Education, MQ Leave a comment

Suganya Rane will be Speaking at MQTC

Suganya Rane of Prolifics will be speaking at Capitalware’s MQ Technical Conference v2.0.1.4 (MQTC). Suganya Rane will be presenting the following sessions at MQTC:

  • Migrate from older versions of MQ to MQV7.1/7.5/8.0
  • An Overview of MQ Clustering

For more information about MQTC, please go to:
http://www.mqtechconference.com

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, Education, MQ, MQ Technical Conference Leave a comment

Glen Brumbaugh’s Sessions for MQTC

Glen Brumbaugh will be presenting the following sessions at MQTC:

  • IBM MQ Performance Analysis
  • SSL and TLS Explained: A User Perspective
  • IBM MQ “Golden Image” Queue Managers

For more information about MQTC, please go to:
http://www.mqtechconference.com

Regards,
Roger Lacroix
Capitalware Inc.

Capitalware, Education, MQ, MQ Technical Conference Leave a comment