One of the new features in Domino V10 is DQL which allows you to access Domino data using SQL. Darren Cacy presented this new feature with some examples and also the prereq’s.
But Darren also showed when NOT to use DQL:
For using DQL in your environment you should follow the following tips:
Usage of terms and booleans
Usage of the language to access data from a Domino database
- Fulltext Indexing of a Domino database is not necessary for better performance !
- No sort functions available with DQL – therefore you have to use other tools ( Node.JS for example )
- Design Catalog GQFdsgn.cat has to exist on the Domino Server which is currently not automatically created !!!
- Currently there’s no security available in DQL – this is a feature for the future and is coming with IAM
Here’s an example how to use DQL:
So DQL is a great feature when you have to access Domino databases for displaying a small result set in any frontend via Node.JS. Get additional information about this new feature in the “Getting started-lab” using the following link: http://ibm.biz/dql-lab
Today began – beside heavy rain – with tremendous announcements of HCL in person of Richard Jefts, Barry Rosen and Chris Davis in their session
“The Beat goes on – and it goes to 11”.
A great and updated roadmap for Domino V10+ has been presented:
A lot ( I’m sure there will be more ) of the new features coming soon and what we can expect in V11 have been presented. As far I understood “Coming soon” is Q1/2019 and we’ll get the following in the next weeks:
- Re-Release of the missing Group1 languages ( german )
- Group 1 support for the Notes Basic and the ICAA client
- Fixes for the regressions in Xpages V10
- Domino App Dev Pack for Windows
- A preview of the browser-based “Verse on mobile” app
- Verse on Premises 1.0.7
We’ll also get Sametime V10 in the first half of 2019. For Sametime Limited Use ( license bundled in your Notes license ) we’ll get the following new and great features:
- Sametime Chat everywhere ( persistent chat across multiple devices )
- Simplified deployment of Sametime using Docker containers
- Chat client will be compatible with the current version 9.0.1 FP1
There have been additional announcements and I can’t remember to hear this lot of news during a 50 minute session !!
So what else can be expected in Notes/Domino V11 ? Just take a look at the following images:
Further informations regarding V11 can be seen and heard during the webcast on March 14th where you can register here: https://bit.ly/2TGIXDM
Another great news has been the announcement that you can use MarvelClient Update to upgrade any existing IBM Notes Client to V10.0.1 for free !! Thanks to panagenda for giving anyone the possibility.
So in a sum-up great features will be delivered in V11 and HCL will also increase marketing activity for pushing Domino V10+ stronger to the market via the new HCL partners.
Today was not sooo busy like yesterday but also had great informations prepared.
For the first session I attended the “The Anatomy of a Privileged Account Hack” and I was impressed about the way this can be executed. Joseph Carson explained in a very easy way how an account hack runs. It always runs in multiple phases with very different ways of getting informations and access to systems.
In this session Joseph showed a real scenario he was working on – and he also showed what was the problem of the customer in the end:
We all received a free book “Privileged Account Management” which gives very good informations how to protect yourself. There’s also a free download available here.
Afterwards a great session of Christoph Adler and Ben Menesi took place where the great new features of IBM Domino V10 have been presented like
- Extension of some limits like database size from 64gb to 256gb
- Advantages of the new ODS53
- Deletion Logging for databases
- Cluster Symmetry
- Great improvements for the regular replication
- Automatically synchronization and monitoring of the ID vault
The next session was performed by Thomas Hampel and Barry Rosen where the new Domino Mobile Apps ( DMA ) has been presented. With DMAyou are able to access all of your Domino applications on the iPad. We already got the information that an additional announcement about DMA will be delivered tomorrow – I’m very excited about it…
After some meetings the last updates for Verse on Premises and also a look to 1.0.7 were delivered by Drew Birnbaum and Barry Rosen. Take a look what’s coming in the new version:
As last session Bill Malchisky shared his tremendous knowledge about “Prepping for Domino V10” where a lot of useful informations about running Domino on Docker was shared. Bill shared very helpful hints about Linux for running either Domino within or out of a Docker container.
Another great day is finished and the tiredness is increasing due the lot of informations gathering all day long. Tomorrow will be a very interesting session right in the morning where – hopefully – all planned features and extensions of Notes/Domino V11 will be announced.
So stay tuned and follow the blog if you’re interested.
Today the “IBM Collaboration Solutions” was held at the Hilton Union Square and first of all: It was amazing !!
We received great informations of Alan Hamilton, Dawn Herndon, Bob Schultz and some other. The most interesting themes have been presented by Richard Jefts and Andrew Manby with a great review of ‘The Road to Domino V10’ where some very impressive numbers have been presented:
Those numbers indicate that Domino is the cheapest and best Application Development Platform ever. The next session belonged to Richard Jefts. Richard’s statement “HCL will deliver what´s committed” is a very great announcement in the future of Notes, Domino, Connections and the other Collaboration Solutions. Also the announcement to bring together Domino and Connections brought smiles to the faces of all attendees.
The demonstration about the possibilities of Domino V10 regarding integrating a Domino application in very different platforms like SalesForce, Twitter, Slack, Microsoft Teams, … was impressive. Also administrative tasks can be handled via voice control with Alexa like Luis Guirigay showed.
During the week we also will get updates about Domino V11 like announced:
Afterwards interesting informations about IBM Connections have been told by Danielle Baptiste – e.g. that the next update to IBM Connections – 6.0 CR5 – soon will be announced. And like the Domino Jams there also will be Jams for IBM Connections. The following information shows the interest of customers and also Community members: there are about 4500 ideas in the IBM Connections Ideas Lab which can be accessed under https://connections.ideas.aha.io/.
The last session showed the possibilities with the new feature of “Domino Query Language” coming with Domino V10. And during the session Luis showed the “DQL Explorer” – a very great application which delivers the option to build SQL searches for Non-Developers without any Development know-how and also shows the query in different languages like LotusScript, DQL, Java and so on. This tool ( a single Domino database ) will be available in the next days.
It was a very interesting day with huge announcements, great informations and also some fun with the othet members of the “Yellow Community” which ended with the “Chairman’s address” – the Keynote of Ginni Rometty.
Hopefully you enjoyed this personal recap of day 2…
The first day of my IBM Think 2019 in San Francisco passed and it was great to see all the fellows of different IBM brands, especially all the friends of the Collaboration Community ( I will not mention all of you not to forget anyone ). But especially the hugs with Sandra and Mat have to be mentioned.
Now to the content specific part: we heard a lot of news inside the IBM Champion sessions like Success Stories, new perspectives, and so on… Libby Ingrassia and her team managed the content of this very comprehensive day >> Thanks a lot to you and your team for the preparation and leading through the day.
Also the new Lifetime Champions have been announced and there are two new members of the ICS Brand in this selected group: Daniel Nashed and Richard Moy. But of course all announced deserve this award – congratulations to all of you !!
I also attended a session about IBM StoredIQ and to be honest: I’m very impressed about the possibilities of this solution. Especially IBM StoredIQ InstaScan is very interesting !! With this solution you are able to analyze your unstructured data ( on premises AND also in cloud like AWS, Box, Sharepoint, OneDrive, … ) and get a very helpful overview about possible data breaches and so on. I’ll take a closer look at this – be sure.
So I can look back on a very interesting day and I’m awaiting the Collaboration Solutions Community Day tomorrow. Stay tuned about the informations coming soon…
Yesterday I moved a Domino infrastructure to a new OS with a combined migration of the Domino environment to IBM Domino 10.0.1 including Notes Traveler 10.0.1.1, iQ.Suite and Language Pack German.
No problems occured – everything ran fine.
Today I implemented a Team Calendar and found out that there´s a bug in the PUBNAMES.NTF in the form “Mail-In-Database”. In the button “Open database” the following formula is included:
@Command([FileOpenDatabase]; MailServer; MailFile )
with a semicolon between MailServer and MailFile
Therefore the hotspot button is not working, because the correct syntax should be:
@Command([FileOpenDatabase]; MailServer:MailFile )
with a colon between MailServer and Mailfile
After this little correction and a “lo design -f names.nsf” the hotspot button also worked fine.
Due to investigation of some users ( Uli Krause delivered a very good summary ) there are some issues with the “STRG” functions in the Notes V10.0.1 client German. Some of the functions are either not working or working very slow.
The download of the this client has been withdrawn from Partnerworld at the moment but I assume that HCL is working on this issues with high pressure !!
I don´t think that there are issues in the Language Pack for Domino V10.0.1 but there´s a recommendation not to install the V10.0.1 client German at the moment.