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