Db2 Web Query is the analytics family of products integrated with IBM i. In this session Doug Mack will cover options and considerations for deploying DASHBOARDS to the business or even for systems monitoring purposes that an IBM i Administrator might like! See the new DESIGNER, part of Version 2.3.0, and “Automated Insights” using AI/ML models in the cloud!
Navigator Re Imagined | Tim Rowe | Business Architect Application Development at IBM | IBM USA
IBM i has delivered a web based interface for managing the IBM i for many years. Sadly, this interface was built back in the infancy of Web technologies and struggled when it came to usability and performance. Today we have a brand new Navigator! This interface is built on Angular and SQL Services. This session will show you how it can be used to manage multiple systems in a simple to use web infrastructure. Much of this session will be live demo showing the speed and simplicity of managing many aspects of your IBM i.
Quick Wins on Improving SQL Performance | Kent Milligan | Senior DB2 for i Consultant | IBM USA
This session will provide an overview of the Db2 SQL performance tools and methods included in IBM i. The presentation will provide particular focus on obtaining value from Visual Explain, the Index Advisor and the SQL Plan Cache. These options leverage ‘always available’ information to make powerful tools readily available to the database engineer.
IBM i Next Gen Apps – Ready for the future | Steve Will Chief Architect | IBM USA
How to create a Minecraft server on IBM i 7.3
(By Tobias Haupt)
Step 1: install Java 11
Download B_GROUP1_04_IBM_i_RS_730-00 from ESS and burn it on DVD.
Start a new Terminal Session with ACS or HMC.
First ENDSBS *ALL *IMMED
Next GO LICPGM and then 11. Search for 5770-JV1 *BASE – install it.
Now we have installed the base enviroment for java. Next we have to install the Java11 package. For that follow the instructions on:
https://www.ibm.com/support/pages/download-installation-and-usage-java-11-ibm-i-os
Next you have to install the PTF SF99725.
Now start a new SSH Session (when the connections will be refused, go into your terminal ans type STRTCPSVR *SSHD).
Create a new folder with mkdir /minecraft. Download the Server from https://getbukkit.org/ and copy it to the directory.
Change the current directory with chdir (F4) /minecraft <- This is really important, otherwise java is going to unzip the files in the root directory)
Test if the Minecraft server starting with RUNJVA CLASS(‘/minecraft/spigot-1.11.2.jar’) JOB(MINESERVER) (you must change the numbers to your version).
You shoud see this Window now:
Additionally you can create your own command to start Minecraft.
CRTLIB MINECRAFT
CRTSRCPF FILE(MINECRAFT/MINESRC)
WRKMBRPDM FILE(MINECRAFT/MINESRC)
F6 Source Member: STRMINSVR Source Type: CLP
| CHDIR DIR(‘/MINECRAFT’) RUNJVA CLASS(‘/MINECRAFT/SPIGOT-1.11.2.JAR’) JOB(MINESERVER) ENDPGM |
CRTSRCPF FILE(MINECRAFT/MINECMD)
WRKMBRPDM FILE(MINECRAFT/MINECMD)
F6 Source Member: MINECMDM Source Type: CMD
| CMD PROMPT(‘COMMAND FOR MINECRAFT SERVER’) |
Next CRTCMD
