Tuesday, 26 November 2013

IBM Notes and Microsoft NTLM Authentication

This is from one of my friends / customers, James, who's a keen Notes/Citrix guru: -

"W3ContextNtlmMode=1" in NOTES.INI works a treat! With the Notes client now able to talk NTLM, we can now have the Notes application in question in-line rendering images from a remote Microsoft IIS server (which stores customer signatures captured on a pad)!

James also pointed out out that there's a useful IBM Technote that outlines some of the challenges with Notes and NTLM, including: -

<snip>
The main point is that Microsoft proxies that use NTLM (Windows domain authentication / Microsoft security's protocol) is not supported. The protocol is a proprietary protocol (much like NRPC) that Microsoft uses in its suite of products (IE, Outlook, Windows login).
</snip>

and: -

<snip>
The only workaround for this is to disable NTLM authentication.
</snip>

IBM Business Process Manager - 8.0.1 - Fixpack 2

I've been maxed out with IBM BPM 7.5.1.1 recently, but did note that Fixpack 2 ( aka 8.0.1.2 ) has been released for IBM BPM 8.0.1.

Here's some more detail about the upgrade and the process: -





Something for the weekend …...

Sunday, 3 November 2013

Applying an iFix to IBM BPM 7.5.1.1 using the Command Line

Following on from this post: -


I've just gone through the process to install the iFix - JR46822 - to one of our IBM BPM Standard 7.5.1.1 Process Center environments.

This is what I did: -

Stop Clusters, Node Agents and Deployment Manager

List What's Installed

/opt/IBM/WAS/wasadmin1/app/InstallationManager/im/eclipse/tools/imcl listInstalledPackages

 returns: -

com.ibm.cic.agent_1.6.2000.20130301_2248
com.ibm.websphere.ND.v70_7.0.25.20120831_0427
com.ibm.websphere.XML.v10_1.0.13.20120814_1806
com.ibm.ws.WBPMSTD_7.5.1001.20120915_1227
7.5.1.1-WS-BPM-IFJR42774_0.0.0.20121016_1300
7.5.1.1-WS-BPM-IFJR43774_0.0.0.20121113_1959
7.5.1.1-WS-BPM-IFJR44032_0.0.0.20130308_1342
7.5.1.1-WS-BPM-IFJR44086_0.0.0.20121206_2324
7.5.1.1-WS-BPM-IFJR44199_0.0.0.20130104_2055
7.5.1.1-WS-BPM-IFJR44357_0.0.0.20130719_1130
7.5.1.1-WS-BPM-IFJR44397_0.0.0.20121106_1740
7.5.1.1-WS-BPM-IFJR44413_0.0.0.20121217_1639
7.5.1.1-WS-BPM-IFJR44428_0.0.0.20121024_1447
7.5.1.1-WS-BPM-IFJR44463_0.0.0.20121221_1452
7.5.1.1-WS-BPM-IFJR44474_0.0.0.20121203_2247
7.5.1.1-WS-BPM-IFJR44503_0.0.0.20121026_1403
7.5.1.1-WS-BPM-IFJR44606_0.0.0.20121108_1605
7.5.1.1-WS-BPM-IFJR44617_0.0.0.20121101_1346
7.5.1.1-WS-BPM-IFJR44690_0.0.0.20121108_1616
7.5.1.1-WS-BPM-IFJR44729_0.0.0.20121116_1736
7.5.1.1-WS-BPM-IFJR45124_0.0.0.20130121_1508
7.5.1.1-WS-BPM-IFJR45222_0.0.0.20130123_0131
7.5.1.1-WS-BPM-IFJR45344_0.0.0.20130116_2314
7.5.1.1-WS-BPM-IFJR45523_0.0.0.20130128_1539
7.5.1.1-WS-BPM-IFJR45532_0.0.0.20130126_0434
7.5.1.1-WS-BPM-IFJR45553_0.0.0.20130131_1507
7.5.1.1-WS-BPM-IFJR45755_0.0.0.20130304_1154
7.5.1.1-WS-BPM-IFJR45931_0.0.0.20130523_1037
7.5.1.1-WS-BPMPC-IFPC42774_0.0.0.20121126_1259
7.5.1.1-WS-BPMPC-IFPD42774_0.0.0.20121126_1517
7.5.1.1-WS-BPMPC-IFPD44032_0.0.0.20130308_1349
7.5.1.1-WS-BPMPC-IFPD44357_0.0.0.20130104_1533
7.5.1.1-WS-BPMPC-IFPD44413_0.0.0.20130719_1420
7.5.1.1-WS-BPMPC-IFPD45755_0.0.0.20130220_1405


List Available Fix(es)

$ /opt/IBM/WAS/wasadmin1/app/InstallationManager/im/eclipse/tools/imcl listAvailableFixes com.ibm.ws.WBPMSTD_7.5.1001.20120915_1227 -repositories /tmp/7.5.1.1\-WS\-BPM\-IFJR46822

returns: -

7.5.1.1-WS-BPM-IFJR46822_0.0.0.20130704_1033

Install the iFix

$ /opt/IBM/WAS/wasadmin1/app/InstallationManager/im/eclipse/tools/imcl install 7.5.1.1-WS-BPM-IFJR46822_0.0.0.20130704_1033 -repositories /tmp/7.5.1.1\-WS\-BPM\-IFJR46822 -installationDirectory /opt/IBM/WAS/wasadmin1/app/WebSphere

returns: -

Installed 7.5.1.1-WS-BPM-IFJR46822_0.0.0.20130704_1033 to the /opt/IBM/WAS/wasadmin1/app/WebSphere directory.

List What's Installed NOW

/opt/IBM/WAS/wasadmin1/app/InstallationManager/im/eclipse/tools/imcl listInstalledPackages

returns: -

com.ibm.cic.agent_1.6.2000.20130301_2248
com.ibm.websphere.ND.v70_7.0.25.20120831_0427
com.ibm.websphere.XML.v10_1.0.13.20120814_1806
com.ibm.ws.WBPMSTD_7.5.1001.20120915_1227
7.5.1.1-WS-BPM-IFJR42774_0.0.0.20121016_1300
7.5.1.1-WS-BPM-IFJR43774_0.0.0.20121113_1959
7.5.1.1-WS-BPM-IFJR44032_0.0.0.20130308_1342
7.5.1.1-WS-BPM-IFJR44086_0.0.0.20121206_2324
7.5.1.1-WS-BPM-IFJR44199_0.0.0.20130104_2055
7.5.1.1-WS-BPM-IFJR44357_0.0.0.20130719_1130
7.5.1.1-WS-BPM-IFJR44397_0.0.0.20121106_1740
7.5.1.1-WS-BPM-IFJR44413_0.0.0.20121217_1639
7.5.1.1-WS-BPM-IFJR44428_0.0.0.20121024_1447
7.5.1.1-WS-BPM-IFJR44463_0.0.0.20121221_1452
7.5.1.1-WS-BPM-IFJR44474_0.0.0.20121203_2247
7.5.1.1-WS-BPM-IFJR44503_0.0.0.20121026_1403
7.5.1.1-WS-BPM-IFJR44606_0.0.0.20121108_1605
7.5.1.1-WS-BPM-IFJR44617_0.0.0.20121101_1346
7.5.1.1-WS-BPM-IFJR44690_0.0.0.20121108_1616
7.5.1.1-WS-BPM-IFJR44729_0.0.0.20121116_1736
7.5.1.1-WS-BPM-IFJR45124_0.0.0.20130121_1508
7.5.1.1-WS-BPM-IFJR45222_0.0.0.20130123_0131
7.5.1.1-WS-BPM-IFJR45344_0.0.0.20130116_2314
7.5.1.1-WS-BPM-IFJR45523_0.0.0.20130128_1539
7.5.1.1-WS-BPM-IFJR45532_0.0.0.20130126_0434
7.5.1.1-WS-BPM-IFJR45553_0.0.0.20130131_1507
7.5.1.1-WS-BPM-IFJR45755_0.0.0.20130304_1154
7.5.1.1-WS-BPM-IFJR45931_0.0.0.20130523_1037
7.5.1.1-WS-BPM-IFJR46822_0.0.0.20130704_1033
7.5.1.1-WS-BPMPC-IFPC42774_0.0.0.20121126_1259
7.5.1.1-WS-BPMPC-IFPD42774_0.0.0.20121126_1517
7.5.1.1-WS-BPMPC-IFPD44032_0.0.0.20130308_1349
7.5.1.1-WS-BPMPC-IFPD44357_0.0.0.20130104_1533
7.5.1.1-WS-BPMPC-IFPD44413_0.0.0.20130719_1420
7.5.1.1-WS-BPMPC-IFPD45755_0.0.0.20130220_1405
 
Start Clusters, Node Agents and Deployment Manager

Job done :-)

Saturday, 2 November 2013

Sametime Unified Telephony - Broken, Now Fixed

Having recently upgraded to IBM Notes 9.0.1 and embedded IBM Sametime 9.0, I was somewhat annoyed to find that I was unable to use the Sametime Computer Phone to make calls any longer.

This is, of course, on a  MacBook Pro, running OS X Mountain Lion.

This had previously worked using Notes 9.0.0 and Sametime 8.5.2.

I kept seeing "Unable to call Dave Hay because the phone number is missing or invalid.".

Thanks to an internal IBM blogger, I found the solution.

I needed to add: -

com.ibm.collaboration.realtime/enableTelephonyStatus=true

to /Applications/IBM Notes.app/Contents/MacOS/rcp/plugin_customization.ini before restarting Notes.

Now I can make calls via the Sametime Computer Phone without problems, including internal numbers, IBM mobile extensions, and UK mobile and landline numbers.




Thursday, 31 October 2013

DB2 - Performance - Optimization profiles and guidelines

From the DB2 9.7 Information Center: -

Optimization profiles and guidelines

An optimization profile is an XML document that can contain optimization guidelines for one or more SQL statements. The correspondence between each SQL statement and its associated optimization guidelines is established using the SQL text and other information that is needed to unambiguously identify an SQL statement.

The DB2® optimizer is one of the most sophisticated cost-based optimizers in the industry. However, in rare cases the optimizer might select a less than optimal execution plan. As a DBA familiar with the database, you can use utilities such as db2advis, runstats, and db2expln, as well as the optimization class setting to help you tune the optimizer for better database performance. If you do not receive expected results after all tuning options have been exhausted, you can provide explicit optimization guidelines to the DB2 optimiser.

We're looking at this to help optimise the way that IBM BPM internal queries are performed against our DB2 9.7 database infrastructure

Still not RESTing on my laurels

I can keep this pun going forever: -

Using the REST APIs in IBM Business Process Manager V7.5


This useful reminder came from my IBM BPM jedi colleague, Dawn, who kindly pointed out that we have a sweet REST UI testing tool built right into the product.

This is the link from the BPM 8.0.1 Information Centre: -


<snip>
Start the REST API test tool. Direct your web browser to the URL for the REST API test tool. The value of the URL depends on how the virtual host and context root were configured for your installation. The URL takes the following form:

http://host_name:port_number/bpmrest-ui

</snip>


*BUT* the same also works for me on my current project using BPM Standard 7.5.1.1, both for Process Center AND Process Server.

Which is nice ….

IBM Education Assistant - a much underused asset - and it's free !!!




Note to self - Firefox and local connections

 Whilst trying to hit my NAS from Firefox on my Mac, I kept seeing errors such as:- Unable to connect Firefox can’t establish a connection t...